Advanced Field Options
When building a Data Map, the system provides a set of optional, advanced features that control how this data in this field is handled when imported into the system.
Data Type Options
Depending on the Data Type of the selected field, you may see one of the following options:
Country Code (for "Phone" fields) -- Select a Country Code; this country code will be prepended to the phone number value.
Date Time Locale (for "Date" fields) -- This option allows you to select the date / time locale formatting you want to use for this field. Using this field-level setting, you can import date / time data from more than one locale, within the same import file. From the drop-down menu, select the desired locale for this field. Please note that this option impacts only the import process. Post-import, all date / time values will be displayed according to the locale selected in your User Profile.
Number Locale (for "Money / Decimal," "Integer," "Big Integer," and "Preference" fields) -- This option allows you to select the number locale formatting you want to use for this field. Using this field-level setting, you can import numeric data from more than one locale, within the same import file. From the drop-down menu, select the desired locale for this field. Please note that this option impacts only the import process. Post-import, all numeric values will be displayed according to the locale selected in your User Profile.
Form Field Name
The "Form Field Name" is intended for use with Web Forms. When a consumer fills out and submits a Web Form, the Form sends that data to Messaging by means of an API request message. If you want to use a different name for a field within the API message, you must enter that name in the "Form Field Name," so that the platform knows where to store that data within the database.
For example, let's say you have a field in your database named "home_email," but when you collect the email address value on the Web Form, the API message uses the name "email_addr." You would need to instruct the system to look for the name "email_addr" within the Form submission, and translate that to the "home_email" column in the database.
Processing
Optionally, select one of the following special processes from the "Processing" drop-down menu:
Set Default Value: Allows you to set the value in this field as the default value.
Resolve camp_id from msg_id: Given a "msg_id" on the import file, will attempt to identify the associated Campaign ID (typically used for custom responses).
Resolve pk_id from msg_id: Given a "msg_id" on the import file, will attempt to identify the associated Primary Key ID (typically used for custom responses).
Set to mixed case: Transforms a text string into mixed case (capitalize the first letter of each word).
Set to mixed case (Specific acronyms excluded): Transforms a text string into mixed case (capitalize the first letter of each word), except for a global list of acronyms; if the text string is one of these specific acronyms, the platform won't change the value to mixed case. For example: "CEO" instead of "Ceo."
Get Name Prefix: Identifies and stores only the Name Prefix value from a "Full Name" field.
Get First Name: Identifies and stores only the First Name value from a "Full Name" field.
Get Last Name: Identifies and stores only the Last Name value from a "Full Name" field.
Get Name Suffix: Identifies and stores only the Name Suffix value from a "Full Name" field.
Make positive: Changes all numeric values to positive values.
Make negative: Changes all numeric values to negative values.
Set to lower case: Transforms a text string into all lower case.
Set to upper case: Transforms a text string into all upper case.
Date Format: For a field with a data type of "Date / Time," allows you to select from a wide range of date formats, such as "MM/dd/yyyy" or "MMM dd, yyyy" for example.
Entity Table Options
Optionally, select one or more of the following entity table options:
Note: These options are not available for a Load and Send Data Map.
Don't Re-Opt-in: (For "Preference" Data Types only) Don't use the value in this field to opt-in a customer who had previously opted-out.
Don’t Overwrite: If data already exists in the database for this column, the imported file will not overwrite any of those existing values.
Insert Null: If the column on the import file is empty, overwrite the data in the database as NULL.
Case-Sensitive: Use case-sensitive comparisons between any existing data in the database and the data on the file being imported.
Append Values: Append values from the import file onto any existing values in the database, rather than overwrite.
Ignore Ban List: (For "Email" Data Types only) Do not run this email field through any Email Ban lists.
Blast Flag: Delete all existing data in the database for this column, and add any new data from this file (note: use with caution!).