E-Marketing Spot default title input file definitions

Use a MarketingSpotDefaultTitle.csv input file to load data to create default title information for e-Marketing Spots that belong to a store. After you load the data, business users can manage the default title information for e-Marketing Spots with the Marketing tool.

We can extract the default title information for e-Marketing Spot objects with the Data Extract utility to create a MarketingSpotDefaultTitle.csv input file. We can then load this file with the Data Load utility. For example, to copy or move the e-Marketing Spot 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 the default title data from the DMEMSPOTCOLLDEF database table. The SQL that the Data Extract utility uses to extract e-Marketing Spot default title data extracts data for only the e-Marketing Spots with the 'MARKETING', 'CONTENT', 'LAYOUTMARKETINGSPOT', or 'SEARCH'.

Sample configuration files are also provided for you to use with the Data Load utility to load the default title e-Marketing Spot data. When you load the MarketingSpotDefaultTitle.csv file, the Data Load utility populates the DMEMSPOTCOLLDEF 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 default title data for e-Marketing Spots, we might need to load additional information. For example, if the e-Marketing Spots do not exist in your target store, you must first load the data to create the e-Marketing Spots. Then, we can load the default title data for the e-Marketing Spots. For more information about the e-Marketing Spot-related data that we can load, see:

• E-Marketing Spot input file definitions

• E-Marketing Spot default content input file definitions

Definitions

spotName

(Required, String) The name of the e-Marketing Spot.

Note: This name must match exactly (including case) the value of the emsName parameter in the JSP file for this e-Marketing Spot.

Maps to EMSPOT.NAME.

usageType

(String) The usage type of the e-Marketing Spot. We can set one of the following values for this column:

MARKETING

Indicates that the e-Marketing Spot displays marketing messages. The default value is "MARKETING".

CONTENT

Indicates that the e-Marketing Spot displays store content.

LAYOUTMARKETINGSPOT

Indicates that the e-Marketing Spot displays Commerce Composer layouts.

SEARCH

Indicates that the e-Marketing Spot is used by search rules.

Maps to EMSPOT.USAGETYPE.

contentName

(Required, String) The external identifier for the content. When you load this value, the utility first maps the value to DefaultMarketingSpotTitle/ContentUniqueID. The business object mediator then converts the value from the COLLATERAL.NAME database column value to the COLLATERAL_ID value that is saved in the database.

Maps to DMEMSPOTCOLLDEF.COLLATERAL_ID.

sequence

(Double) The sequence number that determines the display order of the object.

Maps to DMEMSPOTCOLLDEF.SEQUENCE.

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.