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.

We can extract the default content information for e-Marketing Spot objects with the Data Extract utility to create a MarketingSpotDefaultContent.csv input file. We can then load this file with the Data Load utility. For example, if we 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

• Extracting marketing data with the Data Extract utility

• Loading marketing objects with the Data Load utility

When you load default content 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, we must first load the data to create the e-Marketing Spots. Then, we can load the default content 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 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.

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.

contentType

(Required, String) The type of content that can display in the e-Marketing Spot. We 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: 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.