web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Importing Consent via Excel imports

(1) ShareShare
ReportReport
Posted on by 63
Hi Partners!
 
A client of mine would like to import consent details from MailChimp into CI-J. I downloaded the template from /Templates for Data Import/
I followed the format perfectly 
 
I keep getting this error message below
The missing attribute is msdunmkt_contactpointconsenttype. I don't see this column anywhere on the Excel, or does that represent the channel? Where and how should I map it? It doesn't appear as a mapping option 
It doesn't appear as a mapping option 
 
 
Should I use a marketing list instead? If so, how?
 
Thanks
I have the same question (0)
  • Suggested answer
    Dengliang Li Profile Picture
    Microsoft Employee on at
    Hi,
     
    You can download the template directly from the Consent Center entity.
    First, add a required field Reason to the view.
     
    Then export this template.
     
    The Purpose field and Subject field are lookup fields that need to be populated with the GUID of the corresponding record.
     
    Then import.
     
    This record was successfully imported into the Consent Center.
     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me .
     
    Best Regards,
    Dengliang Li
     
  • jnicophene Profile Picture
    63 on at
    Thanks! I see I can't use "Commercial," I must use the guide of the value. Let me give that a try. 
  • jnicophene Profile Picture
    63 on at
    Hi! I got the same error back even after adding the No Reason Field and added in the guids for Purpose and Topic
     
     
     
    Would you be available to jump on a teams call? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 61

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 52 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans