Specifying the unique index
Outbound E-mail comes with a default set of extended detail fields, of which IDENTIFICATION_KEY and IDENTIFICATION_SOURCE are used to uniquely identify Contacts. This task describes how to change the unique index (from IDENTIFICATION_KEY and IDENTIFICATION_SOURCE to MAIL).
Before you begin
The procedure described in this task must only be executed by a Database Administrator (DBA).
Procedure
- Access the database server on which you installed the Outbound E-mail database (the database for Outbound E-mail on the Content Manager Server).
- Open the
tridion_cm_emaildatabase. - Navigate to the
CONTACTS_EXTENDED_DETAILStable. - Change the unique index as follows:
- Navigate to the
IMPORT_CONTACTStable and repeat the steps to change the unique index. - Navigate to the
IMPORT_KEYWORDStable and repeat the steps to change the unique index. - Access the database server on which you installed the Subscription Management database on the Presentation Server.
- Open the
tridion_submgmtdatabase and navigate to theCONTACTS_EXTENDED_DETAILStable. - Repeat the steps to change the unique index in the Subscription Management database.
Results
What to do next
After you have changed the unique index, you need to configure the Content Manager server to indicate which Contact Details uniquely identify Contacts. You do this by setting the isIdentificationKey="true" attribute in the OutboundEmail.xml configuration file.