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.

Creating the Package Using the Batch File

The MKTG_List_Import package contains the PL/SQL procedures and functions required for the Contact List Import through PL/SQL feature.

The package code is in the following files in the dbsrvr\Oracle directory:

• Package Specification: mktg_listimp_pkg_spec.sql
• Package Body: mktg_listimp_pkg_body.sql

To create the package, you can execute the SQL files or you can use the batch files.

To create the package using the batch file

1. Extract the MktgListImportPkg.zip/MktgListImportPkg.tar file within the dbsrvr/Oracle directory on the machine where you have installed Siebel Server.
2. Do one of the following:
   1. On Windows, execute the CreateMktgListImportPkg.bat file.
   2. On Unix, execute the CreateMktgListImportPkg.sh file.
3. Enter the following information once you have invoked the batch file:
   1. Enter the table owner name, such as ORATT101.
   2. Enter the table owner password, such as ORATT101.
   3. Enter the database name as it is referred to in the tnsnames.ora file, such as ORATT101.
   4. Enter the Siebel Enterprise Server installation directory, such as C:\8.1.1.14\ses.

      The PL/SQL package is created.

4. Review the mktg_listimp_pkg_spec.log and mktg_listimp_pkg_body.log files for any errors.

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.