Samples > Data load utility samples > Examples: Mapping data > Examples: Mapping inventory data
Example: Deleting expected inventory records (RA)
You can use the data load utility to delete data from the RA table.
CSV file with sample data
In this example the data source is a CSV file named ra_delete.csv. The file contains sample data with minimum columns that are necessary for "delete" dataLoadMode.
VendorName CreateTime J and J Company 2005-07-12 01:01:01.123456 AdvancedB2BDirect Vendor 2008-05-15 04:04:04.0 AdvancedB2BDirect Vendor 2009-05-21 00:00:00.0
Because the table RADETAIL has cascade constraint on the table RA, when deleting a record from table RA, the corresponding data in the table RADETAIL will also be deleted, unless "markForDelete" property is set as true in business object configuration file. If "markForDelete" property is set as true, the RA record and RADETAIL record are not deleted from database, MARKFORDELETE value of these records will be updated to "1" instead.
CSV file column definitions
- VendorName
- (Mandatory, string) The vendor that supplied the inventory. This field is mandatory and cannot be null.
- CreateTime
- (Mandatory, timestamp) The date and time this record is created. The format of the input is "yyyy-mm-dd hh:mm:ss.SSSSSS". the length of the fractional seconds should no more than 6. The format may be customized by setting timestampPattern property in wc-dataload.xml. This field is part of the unique index of RA table. This field is mandatory and cannot be null.
Other optional fields not included in the example are:
- StoreIdentifier
- (String) The identifier of the store which this item belongs to, such as ConsumerDirect. This column can be added into CSV if the item belongs to a store which is different from the store defined in BusinessContext elements of wc-dataload-env.xml. If this column is not provided in the CSV file, the StoreIdentifier in the business context will be used.
Business context data
The following code snippet from the wc-dataload.xml configuration file provides the business context data necessary for loading the data:
<_config:BusinessContext storeIdentifier="ConsumerDirect"> </_config:BusinessContext>
- storeIdentifier
- (String) The identifier of the store which this item belongs to, such as ConsumerDirect. It is used if CSV file does not provide this information. The StoreIdentifier is used to retrieve the storeID.
Map data
The following snippet from the sample configuration file demonstrates how to map each column of data in the source CSV file to a value. Each column in the CSV file must have such a definition. If the optional field specified above is present in the CSV file, the definition for them must be added.
<_config:DataReader className="com.ibm.commerce.foundation.dataload.datareader.CSVReader" firstLineIsHeader="true"> <_config:Data> <_config:column number="1" name="VendorName" /> <_config:column number="2" name="CreateTime" /> </_config:Data> </_config:DataReader >
The following snippet from the sample configuration file demonstrates how to map each column of the data in the CSV file to a business object logical schema path. The attribute 'value' represents the name of a column of the CSV file which is defined in the configuration snippet above. Each column in the CSV file must have a mapping to the logical schema path. If the optional field specified above is present in the CSV file, the mapping for them must be added.
<_config:DataMapping> <_config:mapping xpath="ExpectedInventoryRecordIdentifier/ExternalIdentifier/VendorName" value="VendorName" valueFrom="InputData" /> <_config:mapping xpath="ExpectedInventoryRecordIdentifier/ExternalIdentifier/CreateDate" value="CreateTime" valueFrom="InputData" /> </_config:DataMapping>
Business object mediator
The data load utility provides a business object mediator for deleting expected inventory record data. The mediator class name is com.ibm.commerce.inventory.dataload.mediator.ExpectedInventoryMediator.