Configuring import Contacts

Before you begin

The procedure described in this task must only be executed by a Database Administrator (DBA).

About this task

Outbound E-mail comes with a default set of extended detail fields. You change your Contact extended details by adding or removing columns in the CONTACTS_EXTENDED_DETAILS table (in the tridion_cm_email and tridion_submgmt databases. For more information, see Creating custom Contact extended details (Microsoft SQL Server). When you update the extended details, you must also update the IMPORT_CONTACTS database table.

Procedure

  1. Using an appropriate database manager for your Outbound E-mail database.
  2. Access the Outbound E-mail database server, open the tridion_cm_email database and navigate to the IMPORT_CONTACTS table.
  3. Add or remove exactly the same columns, using the exact same name (including uppercase and lowercase) and properties as the columns in the tridion_cm_email database, with the following exceptions:

    The CONTACTS_EXTENDED_DETAILS database contains the following field which the IMPORT_CONTACTS table should not:

    • CONTACT_ID

    The IMPORT_CONTACTS database contains the following field which the CONTACTS_EXTENDED_DETAILS table should not:

    • GROUP_KEYVALUE
    • BOUNCE_STATUS_ID
    • SUBSCRIPTION_STATUS_ID
    • EMAIL_TYPE
    • ENABLED
    • LOCALE
  4. Make sure columns are set to optional (NULL).
  5. Save your changes and close the database manager.

Results

You have updated the IMPORT_CONTACTS table to be in sync with the CONTACTS_EXTENDED_DETAILS table.

What to do next

For more information on importing Contacts, see the help topics in Content Manager Explorer.