E-Marketing Spot default content input file definitions

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

You can extract the default content information for e-Marketing Spot objects with the Data Extract utility to create a MarketingSpotDefaultContent.csv input file. You can then load this file with the Data Load utility. For example, if you want 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 content data from the DMEMSPOTDEF database table. The SQL that the Data Extract utility uses to extract e-Marketing Spot default content 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 content e-Marketing Spot data. When you load the MarketingSpotDefaultContent.csv file, the Data Load utility populates the DMEMSPOTDEF database table.

For more information about extracting and loading marketing data, see

When you load default content data for e-Marketing Spots, you 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, you can load the default content for the 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.

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.

contentType

(Required, String) The type of content that can display in the e-Marketing Spot. You can set the following values for this column:

CatalogGroup: Indicates that the e-Marketing Spot displays categories.
CatalogEntry: Indicates that the e-Marketing Spot displays catalog entries.
MarketingContent: Indicates that the e-Marketing Spot displays marketing content.

Maps to DMEMSPOTDEF.CONTENTTYPE.

content

(Required, String) The external identifier for the content. When you load this value, the utility first maps the value to DefaultContent/ContentUniqueID. The utility then converts the value based on the content type value and then stores the converted value in the database:

For marketing content, the utility assumes that the value is the COLLATERAL.NAME. The mediator then converts the value to the COLLATERAL_ID and saves the value in the DMEMSPOTDEF.CONTENT column.
For catalog entry content, the utility assumes that the value is the CATENTRY.PARTNUMBER. The mediator then converts the value to the CATENTRY_ID and saves the value in the DMEMSPOTDEF.CONTENT column.
For category content, the utility assumes that the value is the CATGROUP.IDENTIFIER. The mediator then converts the value to the CATGROUP_ID and saves the value in the DMEMSPOTDEF.CONTENT column.
For any other content type, the value is stored in the DMEMSPOTDEF.CONTENT column as-is.

Maps to DMEMSPOTDEF.CONTENT.

sequence

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

Maps to DMEMSPOTDEF.SEQUENCE.

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.