If my structure for Customers is correct, I will offer the test
customers in the spreadsheets and their associated data including
Classification as demo data.
The Party data is pretty sparse.
It should show every possible related entity so that it can be used for
testing and documentation examples.
Ron
On 23/01/2015 3:36 PM, Pierre Smits wrote:
Ron,
Having checked the DemoData set, I noticed that we don't have demo data
regarding PartyClassification and PartyClassifcationGroup.
Would you be willing to create an improvement JIRA and add a patch with
your example?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Fri, Jan 23, 2015 at 5:54 PM, Ron Wheeler <[email protected]
wrote:
Great answer!
When adding a customer (Party) it needs to have a Classification
associated with it to carry the SIC code of the Party.
My reverse engineering of the Party entities and the seed data led me to
the following fragment that will load a CUSTOMER and the SIC classification
of"13"
<Party partyId="FOUR SEASONS HOTEL" partyTypeId="CORPORATION"
preferredCurrencyUomId="USD" partyStatus="PARTY_ENABLED"
externalId="100012"/>
<PartyRole partyId="FOUR SEASONS HOTEL" roleTypeId="CUSTOMER"/>
<PartyClassification partyId="FOUR SEASONS HOTEL"
partyClassificationTypeId="SIC_CODE" partyClassificationGroupId="13"/>
<PartyClassificationGroup partyClassificationTypeId="SIC_CODE"
GroupId="13" description="Miscellaneous"/>
From your description I will have no trouble loading another CUSTOMER that
is also a hotel (SIC Code 13) again
<Party partyId="HILTON" partyTypeId="CORPORATION"
preferredCurrencyUomId="USD" partyStatus="PARTY_ENABLED"
externalId="100012"/>
<PartyRole partyId="HILTON" roleTypeId="CUSTOMER"/>
<PartyClassification partyId="HILTON" partyClassificationTypeId="SIC_CODE"
partyClassificationGroupId="13"/>
<PartyClassificationGroup partyClassificationTypeId="SIC_CODE"
GroupId="13" description="Miscellaneous"/>
The statement <PartyClassificationGroup partyClassificationTypeId="SIC_CODE"
GroupId="13" description="Miscellaneous"/> will be processed many times but
only result in a single PartyClassificationGroup entity with SIC_CODE 13
which is the desired result.
Ron
On 23/01/2015 11:37 AM, Ruth Hoffman wrote:
Hi Ron:
In general - and please feel free to add to the Wiki: If the utilities
that load seed data into the database encounter a record (to be loaded)
where the primary-key(s) for this record already exist within a record in
the database, only the non-primary-key data is loaded.
Specifically, you can never replace a primary-key(s) for an existing
record in the database. This is intentional and done to preserve data
integrity.
On the other hand, if a record with the identical primary-key(s) do not
exist (the entire combination of primary-key(s) is considered), then a new
record is written to the database.
Given that, what entity are you loading with SIC codes? You will first
need to determine which entity this is in order to answer your question
from below: "what happens if the entity engine detects multiple requests to
load the same classification id" ?
Hope this helps.
Best Regards,
Ruth Hoffman
http://www.aesolves.com
On 1/23/15 11:13 AM, Ron Wheeler wrote:
I notice that SIC Codes are listed as a "supported" classification in
the seed data.
http://www.ehso.com/siccodes.php
Are there any seed data files that load the actual SIC Codes.
In North America the old SIC is replaced by NAICS except for some US
gov't departments and agencies related to financial regulation
http://www23.statcan.gc.ca/imdb/p3VD.pl?Function=getVD&TVD=118464
http://en.wikipedia.org/wiki/Standard_Industrial_Classification has
links to a number of other industry code systems.
Is there a set of seed data floating about that could be added to the
seed data.
If not, what happens if the entity engine detects multiple requests to
load the same classification id ?
This would happen if the sic code classification was loaded with each
customer or supplier in a bulk load operation of customers or suppliers.
Ron
--
Ron Wheeler
President
Artifact Software Inc
email: [email protected]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
--
Ron Wheeler
President
Artifact Software Inc
email: [email protected]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
