HCL Commerce Version 9.1.4.0 or later

Catalog, Attribute and Attachment Data Load Enhancement

For a React Store that is enabled for HCL Digital Experience, all the digital assets are located in HCL Digital Experience. The digital assets are not located in the store web server.

The image path that is stored in the database, such as FULLIMAGE, THUMBNAIL columns in the CATENTDESC, is the custom URL that is associated with the file in HCL Digital Experience.

Data load for category, product, and attribute is enhanced to change the image path in the database to match the custom URL in HCL Digital Experience. These data loads support additional optional properties similar to the properties used for the Asset File Upload tool.

The HCL Digital Experience enabled sample data load configuration files for category, product and attribute are located in the <commerce>/samples/DataLoad/Catalog/DX directory. The sample data load configuration files for attachments are located in the <commerce>/samples/DataLoad/Marketing/DX directory.

The data load first checks the STORECONF table for the following name-value pair:

Property Description
hcl.externalContent.enabled If set to true for the store, or its parent store or the store 0, the image path or file path is enhanced to match the custom URL.

The additional optional properties in the data load configuration files are used to configure the custom URL.

Table 1. Additional properties for digital assets
Property Description
customURLContextRoot The prefix that is to be added to the custom URL. It is optional.

If it is not specified, no prefix is added to the custom URL.

replaceInvalidCharacterWith The custom URL allows only the following characters: “. (dot), a-z, A-Z, 0-9, - (dash), _ (underscore), / (forward slash)”. If the relative path for the file contains any invalid characters, they are replaced by the character specified here.

If this property is not specified, any invalid characters in the image path are not replaced.

externalURLPrefix A list of prefixes separated by a comma. Any image path in the data load CSV files which starts with the specified prefix will be loaded to the database as is without changing it to match the custom URL in HCL Digital Experience.

For example, “http://, https://, ftp://”.