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. We can extract the content attachment objects with the Data Extract utility to create a MarketingContentAttachment.csv input file that we can then load with the Data Load utility. For example, 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:

• ATCHREL

• ATCHRELDSC

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:

• ATCHTGT

• ATCHTGTDSC

For more information about extracting and loading marketing data, see

• Extracting marketing data with the Data Extract utility

• Loading marketing objects with the Data Load utility

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

• Marketing content input file definitions

• Marketing content description input file definitions

• Marketing content attachment description input file definitions

• Marketing content image map input file definitions

Definitions

contentName

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

When we 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

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

This column or element maps to
ATCHTGT.IDENTIFIER.

usageName

(Required, 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: To delete all of the database records that match the records in a file, we can run the Data Load utility in delete mode. See Configure the data load order.