Marketing attachment input file definitions

Use a Attachment.csv input file to load information to create attachments for the marketing objects that belong to a store. After you load the data, business users can manage the new attachment information for the marketing objects with the Attachments tool.

You can extract the attachment information for marketing objects with the Data Extract utility to create a Attachment.csv input file that you then can load with the Data Load utility. For example, if you want to copy or move marketing attachments 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 the 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 marketing attachment data. When you load the Attachment.csv file, the Data Load utility populates the following database tables:

For more information about extracting and loading marketing data, see

When you load marketing attachment data, you might need to load additional information. For example, you might need to load descriptive information for the attachment in multiple languages. For more information about the marketing objects and marketing attachment-related data that you can load, see:

Note: The Data Extract utility and Data Load utility do not extract or load any actual managed files that are associated with the attachments. The utilities only extract and load the information that points to the managed files. You must manually create the managed files in the target store by using the Attachments tool. If you do not create the managed files before you load the attachment information, the load operation fails since the Data Load utility cannot resolve the unique ID values for the managed files.

Definitions

identifier: (Required, String) The identifier for the attachment target.
Maps to ATCHTGT.IDENTIFIER.
usage: (String) The attachment usage ID for the attachment.
Maps to ATCHTGT.USAGE.
name: (String) The language-dependent name of the attachment target.
Maps to ATCHTGTDSC.NAME.
shortDescription: (String) The short description of the attachment target.
Maps to ATCHTGTDSC.SHORTDESCRIPTION.
longDescription: (String) The long description of the attachment target.
Maps to ATCHTGTDSC.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.