E-Marketing Spot input file definitions

Use a MarketingSpot.csv input file to load information to create e-Marketing Spots in a store. After you load the data, business users can manage the new e-Marketing Spots with the Marketing tool.

You can extract e-Marketing Spot objects with the Data Extract utility to generate the MarketingSpot.csv input file that you can then load with the Data Load utility. For example, if you want to copy or move the e-Marketing Spots 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 e-Marketing Spot data from the EMSPOT database table. The SQL that the Data Extract utility uses to extract e-Marketing Spots 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 e-Marketing Spot data. When you load the MarketingSpot.csv file, the Data Load utility populates the EMSPOT database table.

For more information about extracting and loading marketing data, see

Depending on how your e-Marketing Spots are configured, you might need to load additional information. For example, you might need to load default content or a default title information for one or more e-Marketing Spots. For more information about the e-Marketing Spot-related data that you can load, see:

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.

description

(String) The description for the e-Marketing Spot.

Maps to EMSPOT.DESCRIPTION.

supportedTypes

(String) The type of business objects that the e-Marketing Spot can display. You can set the following values for this column or element:

A: Awareness ad
P: Product
C: Category
S: Cross-sell or Up-sell for a product
G: General content, which corresponds to a content spot.

Maps to EMSPOT.SUPPORTEDTYPES.

usageType

(String) The usage type of the e-Marketing Spot. You 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.

uiDisplayable

(Integer) Indicates whether the e-Marketing Spot displays in Management Center. You can set one of the following values for this column or element:

1 or null: The e-Marketing Spot displays in Management Center.
0: The e-Marketing Spot does not display in Management Center.

Maps to EMSPOT.UIDISPLAYABLE.

managingTool

(Integer) Indicates the Management Center tool that is used to manage the e-Marketing Spot. You can set one of the following values for this column or element:

0 or null: The e-Marketing Spot is managed with the Marketing tool.
1: The e-Marketing Spot is managed with the Commerce Composer tool.

Maps to EMSPOT.MANAGINGTOOL.

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.