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.We can extract e-Marketing Spot objects with the Data Extract utility to generate the MarketingSpot.csv input file that we can then load with the Data Load utility. For example, 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
- Extracting marketing data with the Data Extract utility
- Loading marketing objects with the Data Load utility
Depending on how your e-Marketing Spots are configured, we might need to load additional information. For example, we 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 we can load, see:
- E-Marketing Spot default content input file definitions
- E-Marketing Spot default title 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.
- 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. We 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. We can set one of the following values for this column:
- MARKETING
- Indicates that the e-Marketing Spot displays marketing messages. Default 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. We 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 used to manage the e-Marketing Spot. We 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: 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.