Data Import Template: "Duplicate Column Heading Exists"

(0) Share

Report

Posted on by MDS

1,788

We are just in the middle of a data import and getting the error "A Duplicate Column Heading Exists" when attempting to download the data import template..

I searched through the fields on the Contact entity and deleted the duplicate field. This was some time ago (several hours), but we still receive the error when trying to download the template. Is there anything that needs to be done to "flush" the deleted field, or is it just a case of waiting? I have deleted, saved and published already.....

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Abed Haniyah 4,287 on at

Like (0)

Report

Hi MDS,

You should open your file in Excel and either rename the duplicate column headers to something unique or delete those columns.

Hope this helps,

Abed.

Was this reply helpful? Yes No
MDS 1,788 on at

Like (0)

Report

Hi Abed,

I cannot open the file because I am unable to actually download it. The error is thrown as I try to download the Contact entity Data Import Template from Settings/Data Management....

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Are you sure you deleted all duplicate fields ?

Field is considered as duplicate if it has the same "Column name" as another. It means you can have for example two fields on a form with différent labels, but their real complete name is the same.

Once you're sure you've deleted/renamed duplicates, make sure you save and publish your changes.

Doing so should enable you to download your templates.

Hope it helps.

Alex

Was this reply helpful? Yes No
MDS 1,788 on at

Like (0)

Report

Not that I can see. Is it only the Display Name that you can have duplicates isn't it? The Schema Name and the Name will always be unique?

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Exactly.

Are you sure you published your changes ?

Alex

Was this reply helpful? Yes No
Verified answer

MDS 1,788 on at

Like (0)

Report

Strange. I've just tried again, and now it's working! I haven't changed anything, so it must be time related or maybe there's some issues with CRM Online this afternoon!

Thanks for your help.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Strange indeed!

I'm glad it works now.

Alex

Was this reply helpful? Yes No
Mr Ramzy GHRIBI 345 on at

Like (0)

Report

i export my metadata file and i find the duplicated field :))

Was this reply helpful? Yes No
Vijil Jones 40 on at

Like (0)

Report

I had the same issue. In Settings> Customizations, display the Entities that causes the error. Sort the fields by display name and scroll through the list until you find two identical display names. Rename one, save and publish your changes. You should now be able to download the Import template.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

this was very helpful, after changing display name i am also able to download the template.

Was this reply helpful? Yes No