Samples > Data load utility samples > Examples: Mapping data > Examples: Mapping catalog data > Examples: Mapping catalog entry data
Example: Catalog entry and attribute dictionary attribute values (multiple attributes per CSV line)
Use the data load utility to insert, replace, and delete relationship between catalog entry and attribute dictionary attribute values simultaneously. This example differs from the previous one in that multiple attributes are specified per CSV line
CSV file column definitions
- PartNumber
- (Mandatory, String) The catalog entry identifier (SKU). Either this field or the CatalogEntryUniqueId is mandatory.
- CatalogEntryUniqueId
- (Mandatory, BigInt) The internal unique reference number of the catalog entry (SKU). Either this field or the PartNumber is mandatory.
- Color
- (String) The value of the Color attribute. If the value is omitted, the relationship is removed.
- Size
- (String) The value of the Size attribute. If the value is omitted, the relationship is removed.
CSV file with sample attribute dictionary attribute and value data
In this example, the CSV file contains attribute dictionary data.
PartNumber Color Size Shirt-Red-Large Red Large Shirt-Green-Small Green Small
Map data
The following code snippet from the catalog entry and attribute relationship load configuration file demonstrates how to map each value to a business object logical schema path. The attribute identifier, type, display sequence, and usage are hard coded in the load configuration file. Hence it is only applicable to loading homogeneous catalog entries that share the same fixed set of attributes.
<_config:DataMapping> <_config:mapping xpath="CatalogEntryIdentifier/ExternalIdentifier/PartNumber" value="PartNumber" valueFrom="InputData"/> <_config:mapping xpath="CatalogEntryIdentifier/UniqueID" value="CatalogEntryUniqueId" valueFrom="InputData"/> <_config:mapping xpath="CatalogEntryAttributes/Attributes[0]/AttributeIdentifier/ExternalIdentifier/Identifier" value="Color" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[0]/AttributeDataType" value="STRING" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[0]/displaySequence" value="1" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[0]/usage" value="Defining" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[0]/Value/identifier" value="Color" valueFrom="InputData" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[0]/Value/value" value="Color" valueFrom="InputData" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[1]/AttributeIdentifier/ExternalIdentifier/Identifier" value="Size" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[1]/AttributeDataType" value="INTEGER" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[1]/displaySequence" value="2" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[1]/usage" value="Defining" valueFrom="Fixed" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[1]/Value/identifier" value="Size" valueFrom="InputData" /> <_config:mapping xpath="CatalogEntryAttributes/Attributes[1]/Value/value" value="Size" valueFrom="InputData" /> </_config:DataMapping>
Business object mediator
The data load framework provides a business object mediator for inserting, replacing, and deleting relationship between catalog entries and attribute dictionary attributes. The mediator class name is CatalogEntryAttributeDictionaryAttributeExtendedMediator.