Marketing content attachment input file definitions

Use a MarketingContentAttachment.csv input file to load data to create attachment information for the marketing content that belongs to a store. After you load the data, business users can manage the new content attachment information with the Marketing tool.

Note: You must apply the interim fixes for APAR JR53438.fep and APAR JR53438.fp to add support to the Data Extract utility and Data Load utility for extracting and loading marketing data.

You can extract the content attachment objects with the Data Extract utility to create a MarketingContentAttachment.csv input file that you can then load with the Data Load utility. For example, if you want to copy or move marketing content and related data between stores or instances, such as for creating one or more test environments. Sample configuration files are provided for you to use with the Data Extract utility to extract content attachment data from the following database tables:

Sample configuration files are also provided for you to use with the Data Load utility to load the content attachment data. When you load the MarketingContentAttachment.csv file, the Data Load utility populates the following database tables:

For more information about extracting and loading marketing data, see

When you load attachments for marketing content, you might need to load additional information. For example, if the marketing content does not exist in your target store, you must first load the data to create the content. Then, you can load descriptive information in multiple languages for the content or the content attachments. For more information about the marketing content-related data that you can extract or load, see:

Definitions

contentName

(Mandatory, String) The name of the marketing content.

When you use the Data Extract utility to generate the MarketingContentAttachment.csv file, the utility uses the ResolveValueBasedOnSQLHandler to extract the value for contentName. The utility extracts the value for the COLLATERAL.NAME database column based on the COLLATERAL ID value that is in the ATCHREL.BIGINTOBJECT_ID database column.

This column or element maps to COLLATERAL.NAME.

attachmentIdentifier

(Mandatory, String) The identifier for the attachment target.

This column or element maps to ATCHTGT.IDENTIFIER.

usageName

(Mandatory, String) The identifier for the usage relationship for the attachment.

This column or element maps to ATCHRLUS.IDENTIFIER.

sequence

(Double) The sequence that the attachment displays for the marketing content.

This column or element maps to ATCHREL.SEQUENCE.

relationName

(String) The language-dependent name for the attachment relationship.

This column or element maps to ATCHRELDSC.NAME.

relationShortDescription

(String) The short description for the attachment relationship.

This column or element maps to ATCHRELDSC.SHORTDESCRIPTION.

relationLongDescription

(String) The long description for the attachment relationship.

This column or element maps to ATCHRELDSC.LONGDESCRIPTION.

delete

(String) Indicates whether to delete the record. Specify 1 to delete the record.

Note: If you want to delete all of the database records that match the records in a file, you can run the Data Load utility in delete mode. For more information, see Configuring the data load order.