Creating custom Contact extended details (Microsoft SQL Server)
You can specify custom Contact extended detail fields by adding or removing columns in the CONTACTS_EXTENDED_DETAILS table in the tridion_cm_email and tridion_submgmt databases.
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_DETAILSIMPORT_CONTACTS
- On your Presentation Server, change the following table in the Outbound E-mail subscription management (
tridion_submgmt) database:CONTACTS_EXTENDED_DETAILS
Procedure
Results
What to do next
After you have changed extended details in the database, you need to configure the Content Manager server: Configuring Contact details