Creating custom Contact extended details (Oracle)
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 Detail fields 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
This task also describes how to create database indexes on extended detail fields. Depending on the size and set up of the CONTACTS_EXTENDED_DETAIL table, it may be useful to create indexes on extended details that are heavily used for searching. Note however that indexes decrease performance when saving and importing. Since search is implemented case in-sensitive, on Oracle you need to create function-based indexes using the Upper(fieldname) function.
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