Siebel Marketing Guide > List Management > Importing and Managing External Lists >

Mapping Fields

After you import a list, you must map the fields in the imported list to the fields in the Prospect Business Component. When you do this, the values in the list fields are transferred accurately into the correct fields in the prospect records.

When there is a dedicated column in the prospect table, you should map fields in the imported list to existing fields in the prospects record. Try to avoid mapping fields to additional attribute columns in the database extension table.

To map fields when importing a list

  1. Determine if an Additional Attribute exists for each special column in the import file that does not map to a Prospect field.
  2. Create additional attributes, if required.
  3. Associate the attributes with the list using the List Additional Attributes tab.
  4. Navigate to the List Import tab. At the top of each column in the external list, select the appropriate field or attribute to which the column should be mapped.
  5. Click Save as New to save the List Import Format.
  6. At the top of each column in the external list, select the appropriate prospects record attribute to which the column should be mapped.
  7. Create additional attributes for columns in your list which have no corresponding prospect field.

 Siebel Marketing Guide, Version 7.5, Rev. A 
 Published: 18 April 2003