Customer experience | Sales, Customer Insights,...

Loading data into contact point consent table with excel for "Tracking" purpose

(1) Share

Report

Posted on by CU03091316-0

170

We have some emails we need to disable "Tracking" consent on and are trying to load them using excel into the consent center screen. This works fine for all purposes and topics, except for "Tracking" purpose. The reason is probably that we have two consent models, one for email, and a simplfied one for sms/custom with less purposes and topics. The error we get is "Duplicate reference found for transformation output parameter....". We had the same initially for other purposes as well, but got rid of it by making sure we dont have same names on any purposes or topics in the two models. However, the Tracking purpose is system named and can not be changed, so we are stuck. And we can not make the reference unique, as the msdynmkt_contactpointconsent4 table does not contain a column for the consent model, only purpose and topic.

Any suggestions on how to solve this import problem?

Categories:

Dynamics 365 Customer Insights - Journeys

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Tom_Gioielli 2,762 Super User 2025 Season 2 on at

Like (1)

Report

Every record or option set has a unique value assigned to it that you should be able to use for an import.

In the case of a record such as this, this is the GUID or Primary Key. If you are running into duplicate references, I recommend using this primary key as your reference on the import file. You should be able to find this value in the table to use.

Was this reply helpful? Yes No
CU03091316-0 170 on at

Like (0)

Report

Purpose is a lookup field with the value from the msdynmkt_purpose table. The challenge is that the ecxel import tool does not expose the GUID for the lookup field, only the value. Is there anyway around this, while still sticking with the excel import?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Loading data into contact point consent table with excel for "Tracking" purpose

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Loading data into contact point consent table with excel for "Tracking" purpose

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates