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

Editing the List Import Format Settings

You can administer the precise settings associated with your list import format. If the Import Format is to be used in Overwrite Existing Record match resolution, you can specify which columns are allowed to be overwritten in the database. You can see which columns are set to be overwritten by looking at the Allow Field Updates column in the lower list. If the column is checked, that field will be overwritten in any existing prospect record that matches the incoming record. By default, all columns are unchecked, so that no existing information can be overwritten without the administrator's consent.

If you are using Exact Match or Exact and Intelligent Match as the matching approach, you need to specify the columns that should be used to perform the exact match query. In the List Import Mappings list, check the box in the Exact Match Column column for each list field that you want to use in the exact match query.

For files with a fixed width file type, the server will automatically detect the column width and display the width in the List Import Formats view. To see the column width settings, from the visibility filter, select List Import Formats and in the List Import Formats list, select the list that relates to your list. If the List Import Format was originally created from a comma separated or tab delimited file, the value will default to 20, although the width will not have any effect during the import task.

NOTE:  Columns mapped to Additional Attributes cannot be updated in Update Mode. If you check Allow Field Updates for this column in the List Import Formats view, the system will ignore the setting.

List Import can load a text file in one of three types: comma separated, tab delimited, or fixed width. For files with a fixed-width data type, you can specify the width of each column. The default width is 20. In the bottom list, you can see the column sequence that you have defined in the List Import list. Type the width in the Width field.