Marketing attachment assets in multiple languages input file definitions

Use a AttachmentAssetLanguage.csv input file to load data to associate marketing attachment assets with multiple languages. After you load the data, business users can manage the new asset and language relationships with the Assets tool.

We can extract the relationship between assets and languages with the Data Extract utility to create a AttachmentAssetLanguage.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 description data in multiple languages from the ATCHASTLG database table.

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

• Marketing attachment input file definitions

• Marketing attachment description input file definitions

• Marketing attachment asset input file definitions

Note: A store must be configured to support a language before the asset relationship information for that language can display in Management Center.

Definitions

identifier

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

This column or element maps to
ATCHTGT.IDENTIFIER.

assetPath

(Required, 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.

languageId

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

This column or element maps to ATCHASTLG.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.