Feature Pack 8

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.

Note: You must apply the interim fixes for APAR JR53438.fep and APAR JR53438.fp to add support to the Data Extract utility and Data Load utility for extracting and loading marketing data.

You 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, if you want 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 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 database table.

For more information about extracting and loading marketing data, see
When you load descriptive information for marketing content, you might need to load additional information. For example, if the content does not exist in your target store, you must first load the data to create the content. Then, you can load descriptive information in multiple languages for the content or load content attachments. For more information about the marketing content-related data that you can load, see:
Note: A store must be configured to support a language before the descriptive information in that language can display in Management Center.

Definitions

contentName
(Mandatory, 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 you 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
(Mandatory, 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: 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.