Ron, I found this wiki pages regarding industry classifications and sic codes
- https://en.wikipedia.org/wiki/Industry_classification - https://en.wikipedia.org/wiki/Standard_Industrial_Classification Would you say that the sic codes (as per the second link) are correct? 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 Sat, Jan 24, 2015 at 8:49 PM, Pierre Smits <[email protected]> wrote: > Yes, the sic codes should be real. > > Pierre Smits > > *ORRTIZ.COM <http://www.orrtiz.com>* > Services & Solutions for Cloud- > Based Manufacturing, Professional > Services and Retail & Trade > http://www.orrtiz.com > > On Sat, Jan 24, 2015 at 7:07 PM, Ron Wheeler < > [email protected]> wrote: > >> On 24/01/2015 5:14 AM, Pierre Smits wrote: >> >>> 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. >>> >> I am not sure what the risk is. >> If they wander down to Main Street and don't see all these companies >> lined up next to each other or call a bunch of 555 telephone numbers they >> will figure it out pretty quickly. >> >> The SIC codes should be real since that is a useful entity and is real >> data >> I would be less happy with dummy SIC codes since that just creates more >> work for everyone. >> >> Dummy data thath makes no sense, just makes it harder to understand how >> the system works. >> >> Ron >> >> Best regards, >>> >>> Pierre >>> >>> Verstuurd vanaf mijn iPad >>> >>> Op 24 jan. 2015 om 02:53 heeft Ron Wheeler <rwheeler@artifact-software. >>>> com> 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 >>>> >>>> >> >> -- >> Ron Wheeler >> President >> Artifact Software Inc >> email: [email protected] >> skype: ronaldmwheeler >> phone: 866-970-2435, ext 102 >> >> >
