E-Marketing Spot input file definitions
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.
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.