A duplicate column heading exists...

(2) Share

Report

Posted on by Community Member

Hi All,

I get this error for a couple of entities when I try to download the templates for data import.

Is there an easy way of identifying which fields are duplicates? I'm assuming that it is duplicate field names in the schema, and I've tried visually comparing the schema names on the fields, but can't see any duplicates.

Any ideas?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (27)

Answers (1)

Rajkumar Rajaraman on at

Like (0)

Report

Hello,

Refer to following article. It provides the steps to remove duplicate column in Excel.

blogs.msdn.com/.../importing-data-into-microsoft-dynamics-crm-online-accounts-contacts.aspx

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, sorry, I should have been clearer. It's when you go to Data Management >>Templates For Data Import, select the entity and click "Download".

It is supposed to download a blank spreadsheet I can put values in, but it gives me the error.

It happens for a couple of different entities, both where the schema has been modified at some point.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

For clarity, it isn't when I am trying to upload a spreadsheet with values, I can't get that far.

It's when you go to Data Management >>Templates For Data Import, select the entity and click "Download".

It is supposed to download a blank spreadsheet I can put values in, but it gives me the error.

It happens for a couple of different entities, both where the schema has been modified at some point.

Was this reply helpful? Yes No
Abhishek Gupta 2,003 on at

Like (0)

Report

Hi MBwd

Are you taking the latest Data map from CRM and populating values and then import into CRM. This what are you trying to do and it is showing duplicate column heading?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, the error appears when I try to download the template. So, when I click on the "Download" button where you download templates for data imports. It does not let me download the template, it gives me the error.

I think this is because there are duplicate fields in the schema for the entity, so I would like to know if there is a way of seeing which columns are duplicates. I am running CRM Online, so cannot view trace logs etc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, I have a client experiencing the same issue on both the online production and the Sandbox orgs. Spring update was applied two weeks ago.

Seems to be happening on the main entities in the sales area (Accounts, Contacts, and Leads). In the service area the Cases import template did not cause an error.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

"Seems to be happening on the main entities in the sales area (Accounts, Contacts, and Leads). In the service area the Cases import template did not cause an error."

I can confirm, this behaviuor is still persists. Double checked the presence of duplicate column headings... No duplicate column headings in the system!

Was this reply helpful? Yes No
Suggested answer

Lucas Blackburn on at

Like (1)

Report

Instead of comparing schema names have you tried looking at the display names on the form (and field) to see if the main forms have any duplicates? (It exports the columns based on what is visible on the forms). Maybe the column header is based on display name.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm having the same problem, except that when I go to Leads, it is stuck with that error message.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Copy the header of the Excel file and paste it into the notepad. Then you can find what column is causing the problem. Go back to the view and delete the column worked for me.

Was this reply helpful? Yes No