4

Web8 comes with a nice new UI to add Audience Manager contact extended detail fields. This is great, however how can I delete a field created by mistake or obsolete?

I do not see a delete option, newly created fields cannot be changed either. For instance I chose the wrong data type (text instead of int) and would like to change it.

When removing the field from both tridion_cm_email and tridion_submgmt databases manually, it still appears in the new AM Settings UI. I guess it is stored somewhere in AppData, but is there a proper way to delete such field entry?

AM settings

7

Operations that might result in data loss are not yet in the UI, due to the challenges and risks involved. That includes changing the type of a field.

So for that, you need to do what you did in the previous versions: edit the databases manually. There's a couple of new tables that you might not be aware of, so I'll try to outline all of the steps for deleting a field here:

  1. Stop the Synchronization service.

Then, in the Audience Manager database (Tridion_cm_email):

  1. Delete the relevant entries in EXTENDED_DETAILS_SYNC (only needed if the field was added recently and hasn't been synchronized to all targets yet). Matched by the "EXTENDED_DETAIL_NAME" column.
  2. Look up the ID of the field in EXTENDED_DETAILS.
  3. Delete the rows in EXTENDED_DETAILS_TRANSLATIONS that have said ID in the EXTENDED_DETAIL_ID column (should be 6 rows).
  4. Delete the row for the field in EXTENDED_DETAILS.
  5. Alter CONTACTS_EXTENDED_DETAILS and delete the column there.
  6. Alter IMPORT_CONTACTS and delete the column there.

In the subscription database (if the field has been synchronized):

  1. Delete the row for the field in EXTENDED_DETAILS.
  2. Alter CONTACTS_EXTENDED_DETAILS and delete the column for the field.

Finally:

  1. Recycle the application pool for the CME website, or restart IIS (CM-side)
  2. Restart the Synchronization Endpoint service (CD-side).
  3. Start the Synchronization service again (CM-side)

That should do it for deletion. If you just want to change the type of a field, you only need to alter the CONTACTS_EXTENDED_DETAILS tables and IMPORT_CONTACTS.

  • Good info - but quite a pain as OOB Audience Manager comes with 16 'example' fields. It would be great if there was at least a script to remove these, or an install option to start with no extended details. – Will Price Sep 28 '16 at 7:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.