Bookshelf Home | Contents | Index | Search | PDF

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

Using List Import Formats

---

Before you import a file, you must save the List Import Format (the sequence of columns that correspond to your file). The list format name consists of the list name followed by the saved date/time stamp. For example, My Target List 09/1/2003 12:30:15pm. You can rename the list by navigating to the List Import Formats view and editing the record in the list. For more information, see Mapping External List Columns to Database Columns.

To apply an existing List Import Format to your list

From the application-level menu, choose View > Site Map > List Management > Lists.
In the Lists list, run a query for the list you created.
Select the list and click the List Import view tab.

NOTE:  Make sure the list is of type Imported and has a file attached. If no file is attached, you will receive an error message.

In the List Import Formats field, click the select button.
In the List Import Formats dialog box, select the format you wish to use. If necessary, perform a query to locate the format.

NOTE:  You may not be able to apply an existing format to a fixed width file if the data was originally created for comma separated or tab delimited file. For .csv or tab delimited files, the column width value defaults to 20, and this may not match the width of the fixed width file that is being used.

Bookshelf Home | Contents | Index | Search | PDF