Siebel Marketing 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 Update Mode, 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.

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 Show drop-down list, 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.


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