Skip to main content

Notifications

Customer Insights - Journeys forum
Suggested answer

Importing Consent via Excel imports

editSubscribe (0) ShareShare
ReportReport
Posted on by 62
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
  • jnicophene Profile Picture
    jnicophene 62 on at
    Importing Consent via Excel imports
    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? 
  • jnicophene Profile Picture
    jnicophene 62 on at
    Importing Consent via Excel imports
    Thanks! I see I can't use "Commercial," I must use the guide of the value. Let me give that a try. 
  • Suggested answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Importing Consent via Excel imports
    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
     

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,373 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,212 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans