Customer experience | Sales, Customer Insights,...

Importing Consent via Excel imports

(1) Share

Report

Posted on by jnicophene

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)

All responses (3)

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jnicophene 63 on at

Like (0)

Report
Copy link

Link copied!

Thanks! I see I can't use "Commercial," I must use the guide of the value. Let me give that a try.

Was this reply helpful? Yes No
jnicophene 63 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No