Two of the attachments seem to have fallen of the original e-mail.
On 22/01/2015 5:38 PM, Ron Wheeler wrote:
I have spent some time working on preparing some sample data for
loading Customers.
If this makes sense, I will add it to the docs as an example of
preparing external data for loading using the entity-engine.
It might also be a helpful addition to the demo data.
I have attached an image of the original spreadsheet with 14 sample
customer.
I have also created a drawing with GraphViz that shows the
relationship between all of the entities involved in getting the data
loaded.
The entities in red boxes are provided by the seed data
The user data is found in boxes with an aliceblue background;
I have manually created the entity-engine-xml for the first 2 customers.
I would appreciate any feedback on accuracy or clarity of the example.
Ron
--
Ron Wheeler
President
Artifact Software Inc
email: [email protected]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
<entity-engine-xml>
<PartyGroup partyId="MYCompany" groupName="OFBIZ COMPANY NAME"/>
<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"/>
<ContactMech contactMechId="FOUR SEASONS HOTEL-POSTAL" contactMechTypeId="POSTAL_ADDRESS"/>
<PostalAddress contactMechId="FOUR SEASONS HOTEL-POSTAL" toName="FOUR SEASONS HOTEL" address1="123 Main Street" city="NewYork" countryGeoId="USA" stateProvinceGeoId="NY" postalCode="126785"/>
<PartyContactMech partyId="FOUR SEASONS HOTEL" contactMechId="FOUR SEASONS HOTEL-POSTAL" fromDate="2015-01-01 00:00:00.000" allowSolicitation="Y"/>
<PartyContactMechPurpose contactMechPurposeTypeId="GENERAL_LOCATION" partyId="FOUR SEASONS HOTEL" contactMechId="FOUR SEASONS HOTEL-POSTAL" fromDate="2015-01-01 00:00:00.000"/>
<ContactMech contactMechId="FOUR SEASONS HOTEL-EMAIL" contactMechTypeId="EMAIL_ADDRESS" infoString="[email protected]"/>
<PartyContactMech partyId="FOUR SEASONS HOTEL" contactMechId="FOUR SEASONS HOTEL_EMAIL" fromDate="2015-01-01 00:00:00.000" allowSolicitation="Y"/>
<PartyContactMechPurpose contactMechPurposeTypeId="PRIMARY_EMAIL" partyId="FOUR SEASONS HOTEL" contactMechId="FOUR SEASONS HOTEL-EMAIL" fromDate="2015-01-01 00:00:00.000"/>
<ContactMech contactMechId="FOUR SEASONS HOTEL-PHONE" contactMechTypeId="TELECOM_NUMBER"/>
<TelecomNumber contactMechId="FOUR SEASONS HOTEL-PHONE" countryCode="1" areaCode="254" contactNumber="555-4534"/>
<PartyContactMech partyId="FOUR SEASONS HOTEL" contactMechId="FOUR SEASONS HOTEL-PHONE" fromDate="2015-01-01 00:00:00.000" allowSolicitation="Y"/>
<PartyContactMechPurpose contactMechPurposeTypeId="PRIMARY_PHONE" partyId="FOUR SEASONS HOTEL" contactMechId="FOUR SEASONS HOTEL-PHONE" fromDate="2015-01-01 00:00:00.000"/>
<PartyRelationship partyIdFrom="FOUR SEASONS HOTEL" partyIdTo="LESLIE" partyRelationshipTypeId="ACCOUNT" roleTypeIdFrom="_NA_" roleTypeIdTo="_NA_" fromDate="2015-01-01 00:00:00.000"/>
<PartyGroup partyId="ABC ELECTRIC" groupName="OFBIZ COMPANY NAME"/>
<Party partyId="ABC ELECTRIC" partyTypeId="CORPORATION" preferredCurrencyUomId="USD" partyStatus="PARTY_ENABLED" externalId="100041"/>
<PartyRole partyId="ABC ELECTRIC" roleTypeId="CUSTOMER"/>
<PartyClassification partyId="ABC ELECTRIC" partyClassificationTypeId="SIC_CODE" partyClassificationGroupId="13"/>
<PartyClassificationGroup partyClassificationTypeId="SIC_CODE" GroupId="02D" description="Electrical Contractor"/>
<PartyContactMechPurpose contactMechPurposeTypeId="GENERAL_LOCATION" partyId="FOUR SEASONS HOTEL" contactMechId="FOUR SEASONS HOTEL-POSTAL" fromDate="2015-01-01 00:00:00.000"/>
<ContactMech contactMechId="ABC ELECTRIC-POSTAL" contactMechTypeId="POSTAL_ADDRESS"/>
<PostalAddress contactMechId="ABC ELECTRIC-POSTAL" toName="ABC ELECTRIC" address1="123 Main Street" city="Toronto" postalCode="N5N 5X5" countryGeoId="CANADA" stateProvinceGeoId="ON" />
<PartyContactMech partyId="ABC ELECTRIC" contactMechId="ABC ELECTRIC-POSTAL" fromDate="2015-01-01 00:00:00.000" allowSolicitation="Y"/>
<PartyContactMechPurpose contactMechPurposeTypeId="GENERAL_LOCATION" partyId="ABC ELECTRIC" contactMechId="ABC ELECTRIC-POSTAL" fromDate="2015-01-01 00:00:00.000"/>
<ContactMech contactMechId="ABC ELECTRIC-EMAIL" contactMechTypeId="EMAIL_ADDRESS" infoString="[email protected]"/>
<PartyContactMech partyId="ABC ELECTRIC" contactMechId="ABC ELECTRIC-EMAIL" fromDate="2015-01-01 00:00:00.000" allowSolicitation="Y"/>
<PartyContactMechPurpose contactMechPurposeTypeId="PRIMARY_EMAIL" partyId="ABC ELECTRIC" contactMechId="ABC ELECTRIC-EMAIL" fromDate="2015-01-01 00:00:00.000"/>
<ContactMech contactMechId="ABC ELECTRIC-PHONE" contactMechTypeId="TELECOM_NUMBER"/>
<TelecomNumber contactMechId="ABC ELECTRIC-PHONE" countryCode="1" areaCode="506" contactNumber="555-4433"/>
<PartyContactMech partyId="ABC ELECTRIC" contactMechId="ABC ELECTRIC-PHONE" fromDate="2015-01-01 00:00:00.000" allowSolicitation="Y"/>
<PartyContactMechPurpose contactMechPurposeTypeId="PRIMARY_PHONE" partyId="ABC ELECTRIC" contactMechId="ABC ELECTRIC-PHONE" fromDate="2015-01-01 00:00:00.000"/>
<PartyRelationship partyIdFrom="ABC ELECTRIC" partyIdTo="LESLIE" partyRelationshipTypeId="ACCOUNT" roleTypeIdFrom="_NA_" roleTypeIdTo="_NA_" fromDate="2015-01-01 00:00:00.000"/>
</entity-engine-xml>
