Example: Person
Use the Data Load utility to load user data into the WebSphere Commerce database.This example uses a CSV file to demonstrate how to insert, replace, or delete your data. We 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
- logonId
- (String) The logon ID for the user. For example, olivialee. This field cannot be null.
- personTitle
- (String) The title for the user. For example, Ms.
- lastName
- (String) The surname of the user. For example, Lee.
- firstName
- (String) The given name of the user. For example, Olivia.
- middleName
- (String) The middle name of the user.
- displayName
- (String) The name that displays for the user in the storefront. For example, Olivia Lee.
- address1
- (String) The address line 1. For example, 40 Lee Avenue.
- address2
- (String) The address line 2.
- address3
- (String) The address line 3.
- city
- (String) The city for the user. For example, Seattle.
- state
- (String) The state for the user. For example, Washington.
- country
- (String) The country for the user. For example, USA.
- zipCode
- (String) The zip code for the user. For example, 12345.
- phone1
- (String) The primary phone number for the user. For example, 315-520-1314.
- bestCallingTime
- (String) The best time to call. Valid values are:
- D (daytime)
- E (evening)
- email1
- (String) The primary email address for the user. For example, olivia.lee@gmail.com.
- gender
- (String) The gender of the user. For example, Female.
- maritalStatus
- (String) The marital status of the user. Valid values are:
- M (Married)
- S (Single)
- W (Widowed)
- D (Divorced)
- P (Separated)
- C (CommonLaw)
- O (Other)
- children
- (Integer) The number of children the user has. For example, 2.
- hobbies
- (String) The hobbies of the user. For example, singing.
CSV file with sample member data
In this example, the CSV file contains sample member data.CSV file with sample member data. Due to the large number of fields in this CSV file, the following table is split into three sections:
Formatted CSV file with column headings
logonId personTitle lastName firstName middleName displayName description jacobsmith Mr. Smith Jacob Jacob Smith Insurance agent ryanjohnson Mr. Johnson Ryan Ryan Johnson School teacher olivialee Ms. Lee Olivia C Olivia Lee American idol
Formatted CSV file with column headings
address1 address2 address3 city state country zip code 7 Bond Street London Wales UK 7007 1 Sky Lane Toronto Ontario Canada M1M 1W1 40 Lee Avenue Seattle Washington USA 12345
Formatted CSV file with column headings
phone1 bestCallingTime email1 gender maritalStatus children hobbies 7000007 E jacobsmith@uk.com S hockey 416-470-9394 D ryanjohnson@yahoo.com.cn Male M 2 basketball 315-520-1314 D olivia.lee@gmail.com Female M 2 singing
Mapping data
The following code snippet from the wc-loader-person.xml configuration file demonstrates how to map each value to a business object logical schema path.<_config:DataMapping> <!-- The unique reference number of the person --> <_config:mapping xpath="PersonIdentifier/UniqueID" value="userId" /> <!-- The distinguished name of the person --> <_config:mapping xpath="PersonIdentifier/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="parentMemberDN" /> <!-- The logon id --> <_config:mapping xpath="Credential/LogonID" value="logonId" /> <!-- The logon password is not loaded by PersonMediator <_config:mapping xpath="Credential/Password" value="logonPassword" /> --> <!-- The challenge question --> <_config:mapping xpath="Credential/SecurityHint/Question" value="challengeQuestion" /> <!-- The challenge answer --> <_config:mapping xpath="Credential/SecurityHint/Answer" value="challengeAnswer" /> <!-- The credential user data field X <_config:mapping xpath="Credential/UserData/UserDataField/X" value="credentialUserDataFieldX" /> --> <!-- The preferred currency --> <_config:mapping xpath="PersonalProfile/PreferredCurrency" value="preferredCurrency" /> <!-- The preferred language id --> <_config:mapping xpath="PersonalProfile/PreferredLanguage" value="preferredLanguage" /> <!-- The display name --> <_config:mapping xpath="PersonalProfile/DisplayName" value="displayName" /> <!-- The description --> <_config:mapping xpath="PersonalProfile/Description" value="description" /> <!-- The photo URL --> <_config:mapping xpath="PersonalProfile/PhotoURI" value="photo" /> <!-- The preferred communication --> <_config:mapping xpath="PersonalProfile/PreferredCommunication" value="preferredCommunication" /> <!-- The preferred delivery --> <_config:mapping xpath="PersonalProfile/PreferredDelivery" value="preferredDelivery" /> <!-- The receive SMS notification --> <_config:mapping xpath="PersonalProfile/ReceiveSMSNotification" value="receiveSMSNotification" /> <!-- The receive SMS store id <_config:mapping xpath="PersonalProfile/ReceiveSMSPreference/StoreID" value="storeId" valueFrom="BusinessContext" /> --> <!-- The receive SMS preference --> <_config:mapping xpath="PersonalProfile/ReceiveSMSPreference/Value" value="receiveSMS" /> <!-- The receive Email store id <_config:mapping xpath="PersonalProfile/ReceiveEmailPreference/StoreID" value="storeId" valueFrom="BusinessContext" /> --> <!-- The receive Email preference --> <_config:mapping xpath="PersonalProfile/ReceiveEmailPreference/Value" value="receiveEmail" /> <!-- The gender --> <_config:mapping xpath="PersonalProfile/Gender" value="gender" /> <!-- The annual income --> <_config:mapping xpath="PersonalProfile/Income/value" value="income" /> <!-- The income currency --> <_config:mapping xpath="PersonalProfile/Income/currency" value="incomeCurrency" /> <!-- The marital status --> <_config:mapping xpath="PersonalProfile/MaritalStatus" value="maritalStatus" /> <!-- The number of children --> <_config:mapping xpath="PersonalProfile/NumberOfChildren" value="children" /> <!-- The household size --> <_config:mapping xpath="PersonalProfile/HouseholdSize" value="household" /> <!-- The company name --> <_config:mapping xpath="PersonalProfile/CompanyName" value="companyName" /> <!-- The hobbies --> <_config:mapping xpath="PersonalProfile/Hobbies" value="hobbies" /> <!-- The date of birth --> <_config:mapping xpath="PersonalProfile/DateOfBirth" value="dateOfBirth" /> <!-- The age --> <_config:mapping xpath="PersonalProfile/Attributes/age" value="age" /> <!-- The time zone --> <_config:mapping xpath="PersonalProfile/Attributes/timeZone" value="timeZone" /> <!-- The preferred unit of measurement --> <_config:mapping xpath="PersonalProfile/Attributes/preferredMeasure" value="preferredMeasure" /> <!-- The tax payer id --> <_config:mapping xpath="PersonalProfile/Attributes/taxPayerId" value="taxPayerId" /> <!-- The user profile Field1 --> <_config:mapping xpath="PersonalProfile/Attributes/userProfileField1" value="userProfileField1" /> <!-- The user profile Field2 --> <_config:mapping xpath="PersonalProfile/Attributes/userProfileField2" value="userProfileField2" /> <!-- The demographic Field1 --> <_config:mapping xpath="PersonalProfile/Attributes/demographicField1" value="demographicField1" /> <!-- The demographic Field2 --> <_config:mapping xpath="PersonalProfile/Attributes/demographicField2" value="demographicField2" /> <!-- The demographic Field3 --> <_config:mapping xpath="PersonalProfile/Attributes/demographicField3" value="demographicField3" /> <!-- The demographic Field4 --> <_config:mapping xpath="PersonalProfile/Attributes/demographicField4" value="demographicField4" /> <!-- The demographic Field5 --> <_config:mapping xpath="PersonalProfile/Attributes/demographicField5" value="demographicField5" /> <!-- The demographic Field6 --> <_config:mapping xpath="PersonalProfile/Attributes/demographicField6" value="demographicField6" /> <!-- The demographic Field7 --> <_config:mapping xpath="PersonalProfile/Attributes/demographicField7" value="demographicField7" /> <!-- The PersonalProfile user data field X <_config:mapping xpath="PersonalProfile/UserData/UserDataField/X" value="personalProfileUserDataFieldX" /> --> <!-- The employee id --> <_config:mapping xpath="BusinessProfile/EmployeeID" value="employeeId" /> <!-- The employee type --> <_config:mapping xpath="BusinessProfile/EmployeeType" value="employeeType" /> <!-- The department number --> <_config:mapping xpath="BusinessProfile/DepartmentNumber" value="departmentNumber" /> <!-- The manager --> <_config:mapping xpath="BusinessProfile/Manager" value="manager" /> <!-- The secretary --> <_config:mapping xpath="BusinessProfile/Secretary" value="secretary" /> <!-- The organization id --> <_config:mapping xpath="BusinessProfile/Attributes/organizationId" value="organizationId" /> <!-- The organization unit id --> <_config:mapping xpath="BusinessProfile/Attributes/organizationUnitId" value="organizationUnitId" /> <!-- The requisitioner id --> <_config:mapping xpath="BusinessProfile/Attributes/requisitionerId" value="requisitionerId" /> <!-- The alternate id --> <_config:mapping xpath="BusinessProfile/Attributes/alternateId" value="alternateId" /> <!-- The BusinessProfile user data field X <_config:mapping xpath="BusinessProfile/UserData/UserDataField/X" value="businessProfileUserDataFieldX" /> --> <!-- self address --> <!-- 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 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="1" valueFrom="Fixed" /> <!-- 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 code 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 user Field1 --> <_config:mapping xpath="Attributes/userField1" value="userField1" /> <!-- The user Field2 --> <_config:mapping xpath="Attributes/userField2" value="userField2" /> <!-- The user Field3 --> <_config:mapping xpath="Attributes/userField3" value="userField3" /> <!-- quick checkout profile billing address --> <!-- The billing address language <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/language" value="billToLanguage" /> --> <!-- ORDERS data not mapped --> <!-- The billing address id <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/ContactInfoIdentifier/UniqueID" value="billToAddressId" /> --> <!-- The billing address nickname --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/ContactInfoIdentifier/ExternalIdentifier/ContactInfoNickName" value="billToNickName" /> <!-- The billing address title --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/ContactName/PersonTitle" value="billToPersonTitle" /> <!-- The billing address business title --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/ContactName/BusinessTitle" value="billToBusinessTitle" /> <!-- The billing address last name --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/ContactName/LastName" value="billToLastName" /> <!-- The billing address first name --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/ContactName/FirstName" value="billToFirstName" /> <!-- The billing address middle name --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/ContactName/MiddleName" value="billToMiddleName" /> <!-- The billing address type --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/type" value="B" valueFrom="Fixed" /> <!-- The billing address primary address flag --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/primary" value="billToPrimary" /> <!-- The billing address line 1 --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/AddressLine[0]" value="billToAddress1" /> <!-- The billing address line 2 --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/AddressLine[1]" value="billToAddress2" /> <!-- The billing address line 3 --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/AddressLine[2]" value="billToAddress3" /> <!-- The billing address internal office address line --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/InternalOfficeAddress" value="billToInternalOfficeAddress" /> <!-- The billing address city --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/City" value="billToCity" /> <!-- The billing address state or province name --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/StateOrProvinceName" value="billToState" /> <!-- The billing address country --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/Country" value="billToCountry" /> <!-- The billing address postal code --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/PostalCode" value="billToZipCode" /> <!-- The billing address user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Address/UserData/UserDataField/X" value="billToUserDataFieldX" /> --> <!-- The billing address primary phone number --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone1/Value" value="billToPhone1" /> <!-- The billing address primary phone number type --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone1/type" value="billToPhone1Type" /> <!-- The billing address primary phone number listed indicator --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone1/publish" value="billToPublishPhone1" /> <!-- The billing address primary phone number user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone1/UserData/UserDataField/X" value="billToPhone1UserDataFieldX" /> --> <!-- The billing address secondary phone number --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone2/Value" value="billToPhone2" /> <!-- The billing address secondary phone number type --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone2/type" value="billToPhone2Type" /> <!-- The billing address secondary phone number listed indicator --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone2/publish" value="billToPublishPhone2" /> <!-- The billing address secondary phone number user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Telephone2/UserData/UserDataField/X" value="billToPhone2UserDataFieldX" /> --> <!-- The billing address best calling time --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/BestCallingTime" value="billToBestCallingTime" /> <!-- The billing primary email address --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/EmailAddress1/Value" value="billToEmail1" /> <!-- The billing primary email address user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/EmailAddress1/UserData/UserDataField/X" value="billToEmail1UserDataFieldX" /> --> <!-- The billing secondary email address --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/EmailAddress2/Value" value="billToEmail2" /> <!-- The billing secondary email address user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/EmailAddress2/UserData/UserDataField/X" value="billToEmail2UserDataFieldX" /> --> <!-- The billing address primary fax number --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Fax1/Value" value="billToFax1" /> <!-- The billing address primary fax number user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Fax1/UserData/UserDataField/X" value="billToFax1UserDataFieldX" /> --> <!-- The billing address secondary fax number --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Fax2/Value" value="billToFax2" /> <!-- The billing address secondary fax number user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Fax2/UserData/UserDataField/X" value="billToFax2UserDataFieldX" /> --> <!-- The billing address primary mobile phone number --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/MobilePhone1/Value" value="billToMobilePhone1" /> <!-- The country code of the billing address primary mobile phone number --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/MobilePhone1/Country" value="billToMobilePhone1Country" /> <!-- The billing address primary mobile phone number user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/MobilePhone1/UserData/UserDataField/X" value="billToMobilePhone1UserDataFieldX" /> --> <!-- The billing address organization name --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/OrganizationName" value="billToOrganizationName" /> <!-- The billing address organization unit name --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/OrganizationUnitName" value="billToOrganizationUnitName" /> <!-- The billing address geographical shipping code --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/GeographicalShippingCode" value="billToShippingGeoCode" /> <!-- The billing address geographical tax code --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/GeographicalTaxCode" value="billToTaxGeoCode" /> <!-- The billing address Field1 --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Attributes/addressField1" value="billToAddressField1" /> <!-- The billing address Field2 --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Attributes/addressField2" value="billToAddressField2" /> <!-- The billing address Field3 --> <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/Attributes/addressField3" value="billToAddressField3" /> <!-- The billing address user data field X <_config:mapping xpath="CheckoutProfile/PaymentInfo/BillingAddress/UserData/UserDataField/X" value="billToUserDataFieldX" /> --> <!-- quick checkout profile shipping address --> <!-- The shipping address language <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/language" value="shipToLanguage" /> --> <!-- ORDERITEMS data not mapped --> <!-- The shipping address id <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/ContactInfoIdentifier/UniqueID" value="shipToAddressId" /> --> <!-- The shipping address nickname --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/ContactInfoIdentifier/ExternalIdentifier/ContactInfoNickName" value="shipToNickName" /> <!-- The shipping address title --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/ContactName/PersonTitle" value="shipToPersonTitle" /> <!-- The shipping address business title --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/ContactName/BusinessTitle" value="shipToBusinessTitle" /> <!-- The shipping address last name --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/ContactName/LastName" value="shipToLastName" /> <!-- The shipping address first name --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/ContactName/FirstName" value="shipToFirstName" /> <!-- The shipping address middle name --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/ContactName/MiddleName" value="shipToMiddleName" /> <!-- The shipping address type --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/type" value="S" valueFrom="Fixed" /> <!-- The shipping address primary address flag --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/primary" value="shipToPrimary" /> <!-- The shipping address line 1 --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/AddressLine[0]" value="shipToAddress1" /> <!-- The shipping address line 2 --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/AddressLine[1]" value="shipToAddress2" /> <!-- The shipping address line 3 --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/AddressLine[2]" value="shipToAddress3" /> <!-- The shipping address internal office address line --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/InternalOfficeAddress" value="shipToInternalOfficeAddress" /> <!-- The shipping address city --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/City" value="shipToCity" /> <!-- The shipping address state or province name --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/StateOrProvinceName" value="shipToState" /> <!-- The shipping address country --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/Country" value="shipToCountry" /> <!-- The shipping address postal code --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/PostalCode" value="shipToZipCode" /> <!-- The shipping address user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Address/UserData/UserDataField/X" value="shipToUserDataFieldX" /> --> <!-- The shipping address primary phone number --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone1/Value" value="shipToPhone1" /> <!-- The shipping address primary phone number type --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone1/type" value="shipToPhone1Type" /> <!-- The shipping address primary phone number listed indicator --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone1/publish" value="shipToPublishPhone1" /> <!-- The shipping address primary phone number user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone1/UserData/UserDataField/X" value="shipToPhone1UserDataFieldX" /> --> <!-- The shipping address secondary phone number --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone2/Value" value="shipToPhone2" /> <!-- The shipping address secondary phone number type --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone2/type" value="shipToPhone2Type" /> <!-- The shipping address secondary phone number listed indicator --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone2/publish" value="shipToPublishPhone2" /> <!-- The shipping address secondary phone number user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Telephone2/UserData/UserDataField/X" value="shipToPhone2UserDataFieldX" /> --> <!-- The shipping address best calling time --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/BestCallingTime" value="shipToBestCallingTime" /> <!-- The shipping primary email address --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/EmailAddress1/Value" value="shipToEmail1" /> <!-- The shipping primary email address user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/EmailAddress1/UserData/UserDataField/X" value="shipToEmail1UserDataFieldX" /> --> <!-- The shipping secondary email address --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/EmailAddress2/Value" value="shipToEmail2" /> <!-- The shipping secondary email address user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/EmailAddress2/UserData/UserDataField/X" value="shipToEmail2UserDataFieldX" /> --> <!-- The shipping address primary fax number --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Fax1/Value" value="shipToFax1" /> <!-- The shipping address primary fax number user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Fax1/UserData/UserDataField/X" value="shipToFax1UserDataFieldX" /> --> <!-- The shipping address secondary fax number --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Fax2/Value" value="shipToFax2" /> <!-- The shipping address secondary fax number user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Fax2/UserData/UserDataField/X" value="shipToFax2UserDataFieldX" /> --> <!-- The shipping address primary mobile phone number --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/MobilePhone1/Value" value="shipToMobilePhone1" /> <!-- The country code of the shipping address primary mobile phone number --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/MobilePhone1/Country" value="shipToMobilePhone1Country" /> <!-- The shipping address primary mobile phone number user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/MobilePhone1/UserData/UserDataField/X" value="shipToMobilePhone1UserDataFieldX" /> --> <!-- The shipping address organization name --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/OrganizationName" value="shipToOrganizationName" /> <!-- The shipping address organization unit name --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/OrganizationUnitName" value="shipToOrganizationUnitName" /> <!-- The shipping address geographical shipping code --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/GeographicalShippingCode" value="shipToShippingGeoCode" /> <!-- The shipping address geographical tax code --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/GeographicalTaxCode" value="shipToTaxGeoCode" /> <!-- The shipping address Field1 --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Attributes/addressField1" value="shipToAddressField1" /> <!-- The shipping address Field2 --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Attributes/addressField2" value="shipToAddressField2" /> <!-- The shipping address Field3 --> <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/Attributes/addressField3" value="shipToAddressField3" /> <!-- The shipping address user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/ShippingAddress/UserData/UserDataField/X" value="shipToUserDataFieldX" /> --> <!-- The shipping info user data field X <_config:mapping xpath="CheckoutProfile/ShippingInfo/UserData/UserDataField/X" value="shippingInfoUserDataFieldX" /> --> <!-- The CheckoutProfile user data field X <_config:mapping xpath="CheckoutProfile/UserData/UserDataField/X" value="checkoutProfileUserDataFieldX" /> --> <!-- The user data field X <_config:mapping xpath="UserData/UserDataField/X" value="userDataFieldX" /> --> <!-- The registration status --> <_config:mapping xpath="registrationStatus" value="RegisteredPerson" valueFrom="Fixed" /> <!-- The registration approval status --> <_config:mapping xpath="registrationApprovalStatus" value="registrationApprovalStatus" /> <!-- The profile type --> <_config:mapping xpath="profileType" value="profileType" /> <!-- The password expired --> <_config:mapping xpath="passwordExpired" value="passwordExpired" /> <!-- The user status --> <_config:mapping xpath="accountStatus" value="userStatus" /> </_config:DataMapping>
Business object mediator
The mediator class name is PersonMediator.Note: When we use a mediator that is provided with WebSphere Commerce with the Data Load utility, the utility assumes that we are loading data for all columns for a business object. 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. See Configure a column exclusion list.