We have to take into consideration that the naming of parties and addresses shouldn't resemble real life to much. People might otherwise get the perception that it is real data.
Best regards, Pierre Verstuurd vanaf mijn iPad > Op 24 jan. 2015 om 02:53 heeft Ron Wheeler <[email protected]> > het volgende geschreven: > > 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 >
