Add Mapping Function Information to a List Mapping Template

Once you have created a new list mapping template, the Mapping tab defines how data will be mapped into the Personify tables. In general, the mapping process transfers a set of objects or data from one location to another. In this case, from the source file to the MKT_Prospect table. The mapping involves the transfer of the field sequence in a source file to a specific column in the Prospect table. You can also map a specific source field value to another specific value.

 

Mapping functions include two types:

·            Range – allows you to translate a value (e.g., revenue) into a coded field that represents ranges of values. For example, if the source file quotes revenue in dollars, then you can map this to a coded field that represents a range of revenue.

·            Value – allows a mapping of a specific value into another specific value. For example, the source data file may use the code “H” for home address type whereas the system uses “HOME.”

The value mapping provides the following options:

·            For delimited source files, you can map the field sequence in the source file to a specific column in the Marketing Prospect database table.

·            For a fixed length record format, you can map the start and end position in the source record to a specific column in the Prospect table.

·            For a specific source field value, you can map this value to another specific value.

·            For any column in the Prospect table, you map it to a fixed value.

To add mapping information:

1.    From the External Prospect List Mapping screen, on the Mapping tab (shown below), click Add.
Alternatively, click Populate Table to automatically add all Target Names to the grid. Then, you can click Delete to remove the records that do not apply to your mapping.
image1.jpg

2.    Click in the Target Name cell and select the target name.
The Data Type displays automatically.

3.    Enter the Field Order in the table cell.

Note.pngEnter a Field Order of "0" if the field does not exist in the mapping file but you want it to be included.

4.    Enter the Fixed Value in the table cell.

5.    Click in the Mapping Function cell and search for the appropriate mapping function.
If no Mapping Functions exist, you need to create one by completing the following:

a.    From the Mapping tab, click Mapping Function.
The Mapping Function Maintenance search screen displays, as shown below.
Mapping_Function_search.bmp

b.    Click Create New List Map.
The Mapping Function Maintenance screen displays, as shown below.
create_new_mapping_function.bmp

c.    Enter the Map Function ID.

d.    Enter the Map Function code in the first text box and the long name in the second text box.

e.    Select the Function Type from the drop-down.
The table options differ depending on the Function Type selected here.

f.      If necessary, uncheck the Active checkbox.

g.    Select the Subsystem and Type of codes that will be mapped.

h.    Click Add.

i.      If you selected “Range” for the Function Type, then enter values in the Source Low Value and Source High Value table cells.

j.      If you selected “Value” for the Function Type, then enter the specific value in the Source Data Value table cell.

k.    Click the button in the Mapped to this Value table cell and select the appropriate value.

l.      Click Save.

m.  Navigate back to the External Prospect List Mapping.
The Mapping Function you just created appears in the Mapping Function chooser.

6.    Select the Mapping Function from the chooser.

7.    Repeat steps 1-6 for any additional mapping functions.

8.    Click Save.

Screen Element Description

Mapping Tab
Add Button. When clicked, a row is added to the table.
Delete Button. When clicked, the highlighted row is deleted from the table.
Populate Table Button. When clicked, the table populates with marketing prospect columns and other related information.
Mapping Function Button. When clicked, the Mapping Function Maintenance screen displays. See Add the Mapping Function Information for more information.
Target Name

Table cell. The following are the minimum columns that must be included in the mapping detail definition:

·            First Name, Last Name, Middle Name, or Company Name

·            Address 1 - if this field is not included in your mapping file, assign a Field Order of "0" and a Fixed Value of "[space]".

·            Address Type Code - if this field is not included in your mapping file, assign a Field Order of "0" and a Fixed Value of "BLANK".

·            Address Status Code - if this field is not included in your mapping file, assign a Field Order of "0" and a Fixed Value of "BAD".
Data Type Table cell. This populates based on the Target Name selected and cannot be changed here.
Field Order Table cell. The order in which the target will display in relation to the other targets.
Fixed Value Table cell. The optional fixed value for the target. If the field must be fixed, then enter the value here.
Mapping Function Table cell. When clicked, the Generic Chooser displays where you can search for an existing marketing mapping function. If the mapping function does not display in the chooser, then you can add a mapping function using the Mapping Function Maintenance screen. See Add the Mapping Function Information for more information.

Mapping Function Maintenance screen
Map Function ID Text box. Mapping Function ID is user-defined and can be reused across multiple lists. Enter the Map Function code in the first text box and the long name in the second text box. Mapping helps determine what should be done with a specific field in the source file when it is mapped to target column.
Active Checkbox. When checked, indicates this mapping function is active.
Function Type

Drop-down. This controls the behavior of the mapping function. The table options differ depending on the Function Type selected. Mapping functions include two types:

·            Range – allows you to translate a value (e.g., revenue) into a coded field that represents ranges of values.

·            Value – allows a mapping of a specific value into another specific value. For example, the source data file may use the code “H” for home address type whereas the system uses “HOME.”
Subsystem Drop-down. The subsystem of the code being mapped.
Type Drop-down. The code type defined under the subsystem for a mapping function.
Add Button. When clicked, a row is added to the table.
Delete Button. When clicked, the highlighted row is deleted from the table.
Source Low Value Table cell. Only displays when “Range” is selected as the Function Type. The data value in the source data file is evaluated against this low value and a code is substituted.
Source High Value Table cell. Only displays when “Range” is selected as the Function Type. The data value in the source data file is evaluated against this high value and a code is substituted.
Source Data Value Table cell. The specific source value.
Mapped to this Value Table cell. When clicked, the Generic Chooser displays. Search for the appropriate field value to which the source should be linked.