Siebel Marketing Installation and Administration Guide > Installing and Administering Siebel Marketing > Installing Marketing Contact List Import Using PL/SQL >

Importing a Contact List Using PL/SQL

1. Navigate to Administration Marketing, Import, and then Job Setup and create a new Import Job for Contact Import.
2. Set the following values to enable the Database Import button:

• Main Object: Contact
• Source Type: Text File
• Import Mode: Import new records
• File Selection: Use exact file name
• Data Type: Comma Separated OR Other Delimiter like (|)
• File Name: Click on the file browser and select the file that you uploaded to the database directory.

3. Navigate to Data Mapping, and specify the mapping, required fields, and exact match fields.
4. Click the Database Import button to import the contacts.
5. Navigate to Sitemap > Contacts > All Contacts, query for the imported contacts, and verify that they display.

Enabling the New List Import Functionality

Once you have created the package, you need to enable the contacts list functionality. Use the following procedure to enable the new contacts list import functionality.

To enable the contacts list import functionality

1. Within the Siebel application, navigate to Administration - Application, then System Preferences.
2. Navigate to the MktgIsDBOracle and MktgEnableDBImport system preferences, and set the value to Y for each preference. The default value for these preferences is N.