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.