Marketing content description input file definitions

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

We can extract the descriptions for marketing content objects with the Data Extract utility to create a MarketingContentDescription.csv input file that you then can 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 description data in multiple languages from the COLLDESC database table.

Sample configuration files are also provided for you to use with the Data Load utility to load the content description data. When you load the MarketingContentDescription.csv file, the Data Load utility populates the COLLDESC 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 descriptive information for marketing content, we might need to load additional information. For example, if the 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 load content attachments. For more information about the marketing content-related data that we can load, see:

• Marketing content input file definitions

• Marketing content attachment input file definitions

• Marketing content attachment description input file definitions

• Marketing content image map input file definitions

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

Definitions

contentName

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

This column or element maps to COLLATERAL.NAME.

location

(String) The full image path to the content.

This column or element maps to COLLDESC.LOCATION.

marketingText

(String) The marketing text of the content. This text describes the marketing objective that is to be achieved by the marketing campaign.

When we are extracting marketing content data, the Data Extract utility uses a value handler to extract this data. By default, the value for this column or element is extracted from the LONGMKTGTEXT column. If the value in that column is null or empty, the value for this column or element is extracted from the MARKETINGTEXT column.

When you load marketing content data, the Data Load utility loads the data into the MARKETINGTEXT column by default. If the value is more than 4000 characters, the utility loads the value into the LONGMKTGTEXT column.

Maps to COLLDESC.MARKETINGTEXT or COLLDESC.LONGMKTGTEXT

langId

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

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