CatalogEntryAsset

Use the CatalogEntryAsset keyword and a CatalogEntryAsset.csv input file to load catalog entry assets. With this input file, we can create and associate attachments, such as images, with catalog entries. After you load this data, business users can manage the attachment associations for the catalog entries with the Catalogs tool.

Note: Catalog entries must exist before we can associate assets with the catalog entries.

Previously, you could load this data only in CSV formatted files. We can now load information in a CSV or XML formatted input file. Your input file must contain CSV column or XML element names and definitions that specify the characteristics of the business object type we are loading into the database. Sample configuration files are provided for you to use with the Data Load utility to load the catalog entry attachment data. When you load a CatalogEntryAsset input file, the Data Load utility or Catalog Upload feature can populate or update the following database tables:

• ATCHREL

• ATCHRELDSC

• ATCHTGT

• ATCHTGTDSC

• ATCHAST

• ATCHASTLG

CSV column and XML element definitions

PartNumber

(Required, String) The unique part number of the catalog entry.

Maps to the CATENTRY.PARTNUMBER database column and is used to identify the CATENTRY_ID value to populate the ATCHREL.OBJECT_ID column. Displays as the Code value for the catalog entry in the Catalogs tool.

Sequence

(Decimal) An optional number used to control the order in which the associated asset displays for the catalog entry.

Maps to and populates the ATCHREL.SEQUENCE database column. Displays as the Sequence value in the Associated assets table of the Associated Assets tab for the catalog entry in the Catalogs tool.

Usage

(String, Required) The identifier for the attachment relation usage. For example, IMAGES.

Maps to the ATCHRLUS.IDENTIFIER database column. Displays as the Usage value in the Associated assets table of the Associated Assets tab for the catalog entry in the Catalogs tool.

AssetPath

(String) The attachment asset path is the relative path of the attachment asset. This path includes the directory path and the file name of the attachment asset. For example, Attachment/mens_pants_cords_sm.gif. Include a value for the AssetPath or the AssetUrl.Maps to and can populate the following database columns:

• ATCHTGT.IDENTIFIER

• ATCHAST.ATCHASTPATH

• ATCHAST.DIRECTORYPATH

This value is used to identify the ATCHTGT.ATCHTGT_ID value to populate the ATCHREL.ATCHTGT_ID database column. If the load operation must create the attachment, this value is also used to populate the attachment database tables.

Displays as the Path value in the Associated assets table of the Associated Assets tab for the catalog entry in the Catalogs tool. If the load operation must create the attachment, this value also displays as the Code value for the attachment and as the Path value for the file or URL for the attachment.

AssetUrl

(String) The identifier for the attachment target, such as the URL for the asset. Include a value for the AssetUrl or the AssetPath column.Maps to and can populate the following database columns:

• ATCHTGT.IDENTIFIER

• ATCHAST.ATCHASTPATH

This value is used to identify the ATCHTGT.ATCHTGT_ID value to populate the ATCHREL.ATCHTGT_ID database column. If the load operation must create the attachment, this value is also used to populate the attachment database tables.

Displays as the Path value in the Associated assets table of the Associated Assets tab for the catalog entry in the Catalogs tool. If the load operation must create the attachment, this value also displays as the Code value for the attachment and as the Path value for the file or URL for the attachment.

Name

(String) The language-specific display name of the catalog entry asset.Maps to and can populate the following database columns:

• ATCHRELDSC.NAME

• ATCHTGTDSC.NAME

Displays as the Display name value in the Associated assets table of the Associated Assets tab for the catalog entry in the Catalogs tool. If the load operation must create the attachment, this value is also used as the Administrative name for the attachment.

ShortDescription

(String) The language-specific short description of the catalog entry asset.Maps to and can populate the following database columns:

• ATCHRELDSC.SHORTDESCRIPTION

• ATCHTGTDSC.SHORTDESCRIPTION

Displays as the Short description value in the Associated assets table of the Associated Assets tab for the catalog entry in the Catalogs tool. If the load operation must create the attachment, this value is also used as the Short description for the attachment.

LongDescription

(String) The language-specific long description of the catalog entry asset.Maps to and can populate the following database columns:

• ATCHRELDSC.LONGDESCRIPTION

• ATCHTGTDSC.LONGDESCRIPTION

Displays as the Long description value in the Associated assets table of the Associated Assets tab for the catalog entry in the Catalogs tool. If the load operation must create the attachment, this value is also used as the Long description for the attachment.

LanguageId

(Integer) The language ID for language-specific fields (Name, ShortDescription, LongDescription). For example:

• -1 for English

• -2 for French

Maps to and can populate the following database columns:

• ATCHASTLG.LANGUAGE_ID

• ATCHRELDSC.LANGUAGE_ID

• ATCHTGTDSC.LANGUAGE_ID

If the load operation must create the attachment, this value is used to indicate the language for the language-specific fields of the attachment.

Delete

(String) A flag that indicates whether to delete. Specify 1 to delete the row.