Bookshelf Home | Contents | Index | Search | PDF

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

Using List Import Formats

---

Whenever you import a file, you must first save the List Import Format—that is, the sequence of columns that correspond to your file. You can modify and reuse these List Import Formats to import similar files in the future.

To create a List Import Format, simply map the columns in the List Import list and click Save as New in the List Import list. For more information, This saves the List Format and gives it a name that consists of the List Name followed by the saved date/time stamp. For example, My Target List 09/1/2001 12:30:15pm. You can rename the list by navigating to the List Import Formats view and editing the record in the list.

To modify your List Import Format, change any of the columns mappings in the List Import list and click Save. This overwrites the previous format sequence. If you wish to save the column sequence as a new format instead, click Save as New. Both your new and old versions of the Import Format will be available to you in the List Import Formats list.

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