Marketing element NVP input file definitions

Use a MarketingElementNVP.csv input file to load information to create name-value pair (NVP) information for the marketing elements that belong to marketing activities in a store. After you load the data, business users can manage the new name-value pair information for marketing activity elements with the Marketing tool.

We can extract element NVP data for marketing activities with the Data Extract utility to create a MarketingElementNVP.csv input file that we can then load with the Data Load utility. For example, to copy or move activities and related information 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 activity data from the DMELEMENTNVP database table. The SQL that the Data Extract utility uses to extract element NVP data extracts data for only the elements associated with activities that have the type 'WEB', 'DIALOG', 'EMAIL', and 'SEARCH'.

Sample configuration files are also provided for you to use with the Data Load utility to load the element data. When you load the MarketingElementNVP.csv file, the Data Load utility populates the DMELEMENTNVP 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 element NVP information for marketing activity elements, we might need to load additional information. For example, if the marketing activities or elements do not exist in your target store, we must first load the data to create the activities and element. Then, we can load the element NVP information. For more information about the marketing activity-related data that we can load, see:

• Marketing activity input file definitions

• Marketing campaign input file definitions

• Marketing element input file definitions

Definitions

activityName

(Required, String) The activity name.

This column or element maps to DMACTIVITY.NAME.

elementName

(Required, String) The campaign element name.

This column or element maps to DMELEMENT.NAME.

name

(Required, String) The name for the name-value pair.

This column or element maps to DMELEMENTNVP.NAME.

value

(Required, String) The value for the name-value pair.If you use the Data Extract utility to generate the MarketingElementNVP.csv file, the utility can convert the value for this column or element when the value includes a unique ID. Depending on the name column or element value, the Data Extract utility converts the unique ID value for the value column or element to be the corresponding external identifier value. When you load the data, the Data Load utility converts the values to the appropriate unique ID value in the target database. The utilities convert the unique ID values for the following name column or element values:

• For a list of catalog entry ID values, the Data Extract utility converts the ID values to the catalog entry part numbers. When you load the data, the Data Load utility converts each part number to the appropriate CATENTRY_ID value in the target database.

• For a list of category ID values, the Data Extract utility converts the ID values to the category identifier. When you load the data, the Data Load utility converts the identifier to the appropriate CATGROUP_ID values.

• For a list of attribute dictionary attribute ID values, the Data Extract utility converts the ID values to the external attribute identifier. When you load the data, the Data Load utility converts the identifier to the appropriate ATTR_ID values.

• For a list of attribute value IDs for attribute dictionary attributes, the Data Extract utility converts the ID values to the external attribute value identifier. When you load the data, the Data Load utility converts the identifier to the appropriate ATTRVAL_ID values.

• For a list of content ID values, the Data Extract utility converts the ID values to the marketing content name. When you load the data, the Data Load utility converts the content name to the appropriate COLLATERAL_ID values.

• For e-Marketing Spot ID values, the Data Extract utility converts the ID values to the e-Marketing Spot name and usage type. The name and usage type are separated by a line ('|') separator character, for example, "ShoppingCartRight_CatEntries|MARKETING". The default usage type is MARKETING. When you load the data, the Data Load utility converts the part number to the appropriate EMSPOT_ID value.

• For promotion ID values, the Data Extract utility converts the ID values to the promotion administrative name. When you load the data, the Data Load utility converts the name to the appropriate PX_PROMOTION_ID value.

• For a list of customer segment ID values, the Data Extract utility converts the ID values to the customer segment member group name. When you load the data, the Data Load utility converts the name to the appropriate MBRGRP_ID value.

• For email message ID values, the Data Extract utility converts the ID values to the email message name. When you load the data, the Data Load utility converts the message name to the appropriate EMLMSG_ID value.

• For any other name value, the Data Extract utility does not convert the value for the value column or element.

Maps to DMELEMENTNVP.VALUE.

sequence

(Double) The sequence in which the data should be returned in the campaign element.

This column or element maps to DMELEMENTNVP.SEQUENCE.

triggerMatch

(Integer) Indicates whether the parameter is required to match for the occurrence of the trigger.

This column or element maps to DMELEMENTNVP.TRIGGERMATCH.

properties

(String) The properties associated with the name-value pair.

This column or element maps to DMELEMENTNVP.PROPERTIES.

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.