Example: Organization

Use the Data Load utility to load organization data into the HCL Commerce database.

This example uses a CSV file to demonstrate how to insert, replace, or delete your data. You can also create and use an XML formatted file to insert, replace, or delete your data. If you choose to create and use an XML formatted file, ensure that your XML elements use the same names as are used for CSV column names.

CSV column and XML element definitions

orgEntityName
(String) The name of the organization or organization unit. For example, Retail Department. This field cannot be null.
parentDN
(String) The distinguished name of the parent organization. For example, o=sample organization,o=seller organization,o=root organization.
orgEntityType
(String) The type of organization entity. Valid values are:
  • Organization
  • OrganizationUnit
This field cannot be null.
status
(String) Specifies whether the organization is locked. Valid values are:
  • Locked
  • Unlocked
administratorLastName
(String) The last name of the administrator. For example, Hall.
administratorFirstName
(String) The first name of the administrator. For example, Mary.
administratorMiddleName
(String) The middle name of the administrator. For example, Patricia.
address1
(String) The address line 1. For example, 42 Sample Way.
address2
(String) The address line 2.
address3
(String) The address line 3.
city
(String) The city for the administrator. For example, Toronto.
state
(String) The state for the administrator. For example, Ontario.
country
(String) The country for the administrator. For example, Canada.
zipCode
(String) The postal code for the administrator. For example, M1M 1W1.

CSV file with sample organization data

In this example, the CSV file contains sample organization data.

CSV file with sample organization data.

Due to the large number of fields in this CSV file, the following table is split into two sections:
Formatted CSV file with column headings
orgEntityName parentDN orgEntityType status administratorLastName administratorFirstName administratorMiddleName
Sample Organization o=seller organization,o=root organization Organization Unlocked Redmond Sam Arnold
HR Department o=sample organization,o=seller organization,o=root organization OrganizationUnit Locked Personnel Susan Amy
Retail Department o=sample organization,o=seller organization,o=root organization OrganizationUnit Hall Mary Patricia
Formatted CSV file with column headings
address1 address2 address3 city state country zip code
1 Sample Way Toronto ON CA M1M 1W1
42 Sample Way Toronto ON CA M1M 1W1
42 Sample Way Toronto ON CA M1M 1W1

Mapping data

The following code snippet from the wc-loader-organization.xml configuration file demonstrates how to map each value to a business object logical schema path.
<_config:DataMapping>
        <!-- The unique reference number of the organization -->
        <_config:mapping xpath="OrganizationIdentifier/UniqueID" value="orgEntityId" />
        <!-- The distinguished name of the organization -->
        <_config:mapping xpath="OrganizationIdentifier/DistinguishedName" value="distinguishedName" />
        
        <!-- The unique reference number of the parent organization -->
        <_config:mapping xpath="ParentOrganizationIdentifier/UniqueID" value="parentMemberId" />
        <!-- The distinguished name of the parent organization -->
        <_config:mapping xpath="ParentOrganizationIdentifier/DistinguishedName" value="parentDN" />
        
        <!-- The organization name -->
        <_config:mapping xpath="OrganizationName" value="orgEntityName" />
        <!-- The business category -->
        <_config:mapping xpath="BusinessCategory" value="businessCategory" />
        <!-- The description -->
        <_config:mapping xpath="Description/value" value="description" />
        <!-- The legal identifier -->
        <_config:mapping xpath="LegalIdentifier" value="legalId" />
        
        <!-- The language id
       	<_config:mapping xpath="ContactInfo/language" value="language" />
       	 -->
        <!-- The address id
       	<_config:mapping xpath="ContactInfo/ContactInfoIdentifier/UniqueID" value="addressId" />
       	 -->
        <!-- The nickname -->
       	<_config:mapping xpath="ContactInfo/ContactInfoIdentifier/ExternalIdentifier/ContactInfoNickName" value="nickName" />
        <!-- The orgentity id -->
       	<_config:mapping xpath="ContactInfo/ContactInfoIdentifier/ExternalIdentifier/OrganizationIdentifier/UniqueID" value="orgEntityId" />
        <!-- The distinguished name -->
       	<_config:mapping xpath="ContactInfo/ContactInfoIdentifier/ExternalIdentifier/OrganizationIdentifier/DistinguishedName" value="distinguishedName" />
        <!-- The title -->
        <_config:mapping xpath="ContactInfo/ContactName/PersonTitle" value="personTitle" />
        <!-- The business title -->
        <_config:mapping xpath="ContactInfo/ContactName/BusinessTitle" value="businessTitle" />
        <!-- The last name -->
        <_config:mapping xpath="ContactInfo/ContactName/LastName" value="lastName" />
        <!-- The first name -->
        <_config:mapping xpath="ContactInfo/ContactName/FirstName" value="firstName" />
        <!-- The middle name -->
        <_config:mapping xpath="ContactInfo/ContactName/MiddleName" value="middleName" />
        <!-- The address type -->
        <_config:mapping xpath="ContactInfo/Address/type" value="SB" valueFrom="Fixed" />
        <!-- The primary address flag -->
        <_config:mapping xpath="ContactInfo/Address/primary" value="primary" />
        <!-- The address line 1 -->
        <_config:mapping xpath="ContactInfo/Address/AddressLine[0]" value="address1" />
        <!-- The address line 2 -->
        <_config:mapping xpath="ContactInfo/Address/AddressLine[1]" value="address2" />
        <!-- The address line 3 -->
        <_config:mapping xpath="ContactInfo/Address/AddressLine[2]" value="address3" />
        <!-- The internal office address line -->
        <_config:mapping xpath="ContactInfo/Address/InternalOfficeAddress" value="internalOfficeAddress" />
        <!-- The city -->
        <_config:mapping xpath="ContactInfo/Address/City" value="city" />
        <!-- The state or province name -->
        <_config:mapping xpath="ContactInfo/Address/StateOrProvinceName" value="state" />
        <!-- The country -->
        <_config:mapping xpath="ContactInfo/Address/Country" value="country" />
        <!-- The postal code -->
        <_config:mapping xpath="ContactInfo/Address/PostalCode" value="zipCode" />
        <!-- The address user data field X
        <_config:mapping xpath="ContactInfo/Address/UserData/UserDataField/X" value="addressUserDataFieldX" />
         -->
        <!-- The primary phone number -->
        <_config:mapping xpath="ContactInfo/Telephone1/Value" value="phone1" />
        <!-- The primary phone number type -->
        <_config:mapping xpath="ContactInfo/Telephone1/type" value="phone1Type" />
        <!-- The primary phone number listed indicator -->
        <_config:mapping xpath="ContactInfo/Telephone1/publish" value="publishPhone1" />
        <!-- The primary phone number user data field X
        <_config:mapping xpath="ContactInfo/Telephone1/UserData/UserDataField/X" value="phone1UserDataFieldX" />
         -->
        <!-- The secondary phone number -->
        <_config:mapping xpath="ContactInfo/Telephone2/Value" value="phone2" />
        <!-- The secondary phone number type -->
        <_config:mapping xpath="ContactInfo/Telephone2/type" value="phone2Type" />
        <!-- The secondary phone number listed indicator -->
        <_config:mapping xpath="ContactInfo/Telephone2/publish" value="publishPhone2" />
        <!-- The secondary phone number user data field X
        <_config:mapping xpath="ContactInfo/Telephone2/UserData/UserDataField/X" value="phone2UserDataFieldX" />
         -->
        <!-- The best calling time -->
        <_config:mapping xpath="ContactInfo/BestCallingTime" value="bestCallingTime" />        
        <!-- The primary email address -->
        <_config:mapping xpath="ContactInfo/EmailAddress1/Value" value="email1" />
        <!-- The primary email address user data field X
        <_config:mapping xpath="ContactInfo/EmailAddress1/UserData/UserDataField/X" value="email1UserDataFieldX" />
         -->
        <!-- The secondary email address -->
        <_config:mapping xpath="ContactInfo/EmailAddress2/Value" value="email2" />
        <!-- The secondary email address user data field X
        <_config:mapping xpath="ContactInfo/EmailAddress2/UserData/UserDataField/X" value="email2UserDataFieldX" />
         -->
        <!-- The primary fax number -->
        <_config:mapping xpath="ContactInfo/Fax1/Value" value="fax1" />
        <!-- The primary fax number user data field X
        <_config:mapping xpath="ContactInfo/Fax1/UserData/UserDataField/X" value="fax1UserDataFieldX" />
         -->
        <!-- The secondary fax number -->
        <_config:mapping xpath="ContactInfo/Fax2/Value" value="fax2" />
        <!-- The secondary fax number user data field X
        <_config:mapping xpath="ContactInfo/Fax2/UserData/UserDataField/X" value="fax2UserDataFieldX" />
         -->
        <!-- The primary mobile phone number -->
        <_config:mapping xpath="ContactInfo/MobilePhone1/Value" value="mobilePhone1" />
        <!-- The country of the primary mobile phone number -->
        <_config:mapping xpath="ContactInfo/MobilePhone1/Country" value="mobilePhone1Country" />
        <!-- The primary mobile phone number user data field X
        <_config:mapping xpath="ContactInfo/MobilePhone1/UserData/UserDataField/X" value="mobilePhone1UserDataFieldX" />
         -->
        <!-- The organization name -->
        <_config:mapping xpath="ContactInfo/OrganizationName" value="organizationName" />
        <!-- The organization unit name -->
        <_config:mapping xpath="ContactInfo/OrganizationUnitName" value="organizationUnitName" />
        <!-- The geographical shipping code -->
        <_config:mapping xpath="ContactInfo/GeographicalShippingCode" value="shippingGeoCode" />
        <!-- The geographical tax code -->
        <_config:mapping xpath="ContactInfo/GeographicalTaxCode" value="taxGeoCode" />        
        <!-- The address Field1 -->
        <_config:mapping xpath="ContactInfo/Attributes/addressField1" value="addressField1" />
        <!-- The address Field2 -->
        <_config:mapping xpath="ContactInfo/Attributes/addressField2" value="addressField2" />
        <!-- The address Field3 -->
        <_config:mapping xpath="ContactInfo/Attributes/addressField3" value="addressField3" />
        <!-- The billing code -->
        <_config:mapping xpath="ContactInfo/Attributes/billingCode" value="billingCode" />
        <!-- The billing code type -->
        <_config:mapping xpath="ContactInfo/Attributes/billingCodeType" value="billingCodeType" />
        <!-- The package suppression -->
        <_config:mapping xpath="ContactInfo/Attributes/packageSuppression" value="packageSuppression" />
        <!-- The ContactInfo user data field X
        <_config:mapping xpath="ContactInfo/UserData/UserDataField/X" value="contactInfoUserDataFieldX" />
         -->
        
        <!-- The context attribute
        <_config:mapping xpath="ContextAttribute/Name" value="contextAttributeX" />
        <_config:mapping xpath="ContextAttribute/AttributeValue/Value" value="contextAttributeValueX" />
        <_config:mapping xpath="ContextAttribute/AttributeValue/StoreID" value="contextAttributeXStoreId" />
         -->
        
        <!-- The orgentity Field1 -->
        <_config:mapping xpath="Attributes/orgEntityField1" value="orgEntityField1" />
        <!-- The orgentity Field2 -->
        <_config:mapping xpath="Attributes/orgEntityField2" value="orgEntityField2" />
        <!-- The orgentity Field3 -->
        <_config:mapping xpath="Attributes/orgEntityField3" value="orgEntityField3" />
        <!-- The administrator first name -->
        <_config:mapping xpath="Attributes/administratorFirstName" value="administratorFirstName" />
        <!-- The administrator last name -->
        <_config:mapping xpath="Attributes/administratorLastName" value="administratorLastName" />
        <!-- The administrator middle name -->
        <_config:mapping xpath="Attributes/administratorMiddleName" value="administratorMiddleName" />
        <!-- The tax payer id -->
        <_config:mapping xpath="Attributes/taxPayerId" value="taxPayerId" />
        
        <!-- The user data field X
        <_config:mapping xpath="UserData/UserDataField/X" value="userDataFieldX" />
         -->
        
        <!-- The registration approval status -->
        <_config:mapping xpath="registrationApprovalStatus" value="registrationApprovalStatus" />
        <!-- The organization entity status -->
        <_config:mapping xpath="status" value="status" />
        <!-- The organization entity type -->
        <_config:mapping xpath="type" value="orgEntityType" />
       	
      </_config:DataMapping>

Business object mediator

The mediator class name is com.ibm.commerce.member.dataload.mediator.OrganizationMediator.
Note: When you use a mediator that is provided with HCL Commerce with the Data Load utility, the utility assumes that you are loading data for all columns for a business object. If you want to update the data in only specific columns, configure a column exclusion list for the load process. A column exclusion list causes the Data Load utility to ignore specific columns during the load operation. If you do not use a column exclusion list, the utility updates all columns in the row of a database table row when the utility updates the row. If no value is set in the input file, the utility can replace the existing column value with a default value or set the value to be null. For more information, see Configuring a column exclusion list.