Creating custom Contact extended details (Microsoft SQL Server)

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. In most cases you will want to remove some of these fields and add custom extended detail fields of your own. This task describes how to create custom Contact Extended Details or remove existing ones.

When you want to create or remove database columns for Contact Extended Details, you must do so in the following database tables as these tables need to be kept in sync:

  • On your Content Manager Server, change the following tables in the Outbound E-mail (tridion_cm_email) database:
    • CONTACTS_EXTENDED_DETAILS
    • IMPORT_CONTACTS
  • On your Presentation Server, change the following table in the Outbound E-mail subscription management (tridion_submgmt) database:
    • CONTACTS_EXTENDED_DETAILS

Procedure

  1. Using an appropriate database manager for your Outbound E-mail database, access the Outbound E-mail database server.
  2. Open the tridion_cm_email database and navigate to the CONTACTS_EXTENDED_DETAILS table.
  3. Add or remove columns to this table by changing the table design, but DO NOT change the CONTACT_ID field. The name of this Contact Detail (that is, of this database table column) must meet the following restrictions:
    • It cannot be the same as any other standard or extended Contact Detail.
    • It cannot begin with two underscore characters (’__’).
    • It must begin with an underscore or a lowercase or uppercase letter from the English alphabet (a-z and A-Z).
    • All characters that follow the first character must be an underscore, a lowercase or uppercase letter from the English alphabet (a-z and A-Z), or a digit (0-9).

    For Microsoft SQL Server, the maximum permitted length of the database field is 255 characters and the data type of the new column must be one of the following:

    • Text types—NVARCHAR
    • Numerical types—INT, DECIMAL
    • Date/time types—DATETIME
  4. Specify whether the fields are optional (NULL) or mandatory (NOT NULL) .
  5. Save your changes.
  6. Navigate to the IMPORT_CONTACTS table. 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.
  7. Save your changes and close the database manager.
  8. Access the Subscription Management (tridion_submgmt) database and navigate to the CONTACTS_EXTENDED_DETAILS table. 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.
  9. Save your changes and close the database manager.

Results

You have added or removed columns defining the extended details for Outbound E-mail Contacts.

What to do next

After you have changed extended details in the database, you need to configure the Content Manager server: Configuring Contact details