Indeed! Verstuurd vanaf mijn iPad
> Op 24 jan. 2015 om 06:18 heeft Ron Wheeler <[email protected]> > het volgende geschreven: > > There seems to be a lot of possible data missing from the samples and that is > one of the reasons that I suggested that documentation and demo data be > separated out into a separate sub-project so that this can be fixed. > > People who are not coders can contribute a lot in this area. > > 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 >
