Use the data load utility to load UserData into custom extension tables in your
HCL Commerce database. There are two ways to load data into custom extension
tables:
- Map the extension table data to the logic noun UserData fields. If you need to extend the logic
noun in your Management Center tool or you need to generate custom SDO extensions, use this
method.
- Use the TableObjectBuilder and TableObjectMediator to load
data directly into the custom extension table. If you did not customize your Management Center
tool or you did not generate custom SDO extensions, use this method.
The following procedure shows you how to load data into custom extension table using the
first method.
Procedure
-
Run the Data
Service Layer wizard in your development environment.
-
Package the generated physical SDOs into a JAR file and deploy it to the
utilities_root/ext/lib directory of your runtime
environment.
-
Deploy the extension configuration directory generated by the Data Service Layer wizard into
the utilities_root/instances/instance_name/xml/config directory
of your runtime environment. The generated extension configuration directory is located in the
workspace_dir/WC/xml/config directory.
-
In your runtime environment, open the business object configuration file for the associated
business objects you want to load.
-
Add the appropriate mappings inside the
<_config:DataMapping>
element. For
example, the following snippet shows the customization of the CatalogEntry noun to support warranty
information:
<_cat:CatalogEntry catalogEntryTypeCode="ProductBean">
<_cat:CatalogEntryIdentifier>
<_wcf:UniqueID>10251</_wcf:UniqueID>
<_wcf:ExternalIdentifier ownerID="7000000000000000101">
<_wcf:PartNumber>FULO-01</_wcf:PartNumber>
</_wcf:ExternalIdentifier>
</_cat:CatalogEntryIdentifier>
<_cat:Description language="-1">
<_cat:Attributes name="careinstruction">Warranty care instructions.</_cat:Attributes>
</_cat:Description>
<_wcf:UserData>
<_wcf:UserDataField name="warterm">30</_wcf:UserDataField>
<_wcf:UserDataField name="wartype">LIMITED</_wcf:UserDataField>
</_wcf:UserData>
</_cat:CatalogEntry>
The
catalog entry mediator supports loading custom catalog entry UserData using the catalog entry
mediator. You do not need to create a custom mediator to support UserData.
Add the following
code in the business object configuration file to map the warranty
user data:
<_config:mapping xpath="UserData/UserDataField/warterm" value="WarrantyTerm" />
<_config:mapping xpath="UserData/UserDataField/wartype" value="WarrantyType" />
<_config:mapping xpath="Description/Attributes/careinstruction" value="CareInstruction" />
-
Save and close the file.
-
Run the Data Load utility.