Marketing attachment asset input file definitions

Use a AttachmentAsset.csv input file to load data to create assets for the marketing attachments that belong to a store. After you load the data, business users can manage the new assets for attachments with the Assets tool.

We can extract the asset information for marketing attachments with the Data Extract utility to create a AttachmentAsset.csv input file that you then can load with the Data Load utility. For example, to copy or move marketing attachments and assets 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 asset data from the
ATCHAST database table.

Sample configuration files are also provided for you to use with the Data Load utility to load the asset data. When you load the AttachmentAsset.csv file, the Data Load utility populates the ATCHAST database table. 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 the asset data, we might need to load additional information. For example, if the attachment does not exist in your target store, we must first load the data to create the attachment. Then, we can load the asset information. You might also need to load data to associate assets with specific languages. For more information about the marketing attachment and asset-related data that we can load, see:

• Marketing attachment input file definitions

• Marketing attachment description input file definitions

• Marketing attachment assets in multiple languages input file definitions

Definitions

attachmentIdentifier

(Required, String) The identifier of the attachment asset.

This column or element maps to
ATCHTGT.IDENTIFIER.

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, /image/a.gif.

This column or element maps to ATCHAST.ATCHASTPATH.

directoryPath

(String) The directory path of the attachment asset. This path is a substring of the attachment asset path when the attachment asset is a file. For example, if the attachment asset path is /image/a.gif, then its directory path is /image.

This column or element maps to ATCHAST.DIRECTORYPATH.

mimeType

(String) The MIME type of the attachment asset. If the attachment asset is an image file, such as a .gif, then the MIME type can be image/gif. If the attachment asset is an URL, then the MIME type is an empty string.

This column or element maps to
ATCHAST.MIMETYPE.

languageId

(Integer) The language ID for the language-specific fields in this input file.

This column or element maps to ATCHAST.LANGUAGE_ID.

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.