When trying to download template for data import

(0) Share

Report

Posted on by MarcusCrooke

A duplicate column heading exists A duplicate column heading exists.

	Timestamp: 10/12/2020 7:22:46 AM UTC Service Request Id: d6c021c8-bde1-41aa-b0de-460d3fff0ba4 Hide Technical Details Tenant Id: 69f487f6-e501-436c-9f4d-307f5c430375 Url: https:/*****.crm11.dynamics.com Organization Id: c515cc43-7c18-41b3-b0cb-0bc808d7c9e2 Type: Customer Unique name: ***** Created on: 5/20/2018 5:02:33 PM State: Enabled Security Group: 00000000-0000-0000-0000-000000000000

When trying to download the template for import I get the above error message.

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Mahendar Pal 45,095 on at

Like (2)

Report

Hi,

If you have used same display name for one or more field you will get this error when you will try to download import template for entity.

> Navigate to your solution if you have any custom solution otherwise open default solution (Settings->Customizations->Customize entity)

> Expend your entity and navigate to Fields

> Check display name for all the field (sort them based on the display name)

> If there is any duplicate display name change them

Save and publish your changes.

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (1)

Report

Hi Marcus,

As stated in the message, there is a duplicate column heading in Excel.

Since column heading is the display name of the field, we will look for fields with duplicate display names.

I will introduce a quick way.

Go to https://make.powerapps.com/, select the D365 environment.

Click Entities > the entity of the template, then click Edit data in Excel. As a demonstration, I created two fields with the same display name.

Open the download excel, find "2", then look for column heading that end with 2 and have no space before 2, this is the duplicate column heading.

Finally change this field's display name.

Was this reply helpful? Yes No
Suggested answer

MarcusCrooke 96 on at

Like (0)

Report

Thanks Mahen.

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (1)

Report

Hi Marcus,

If the problem has been resolved, please click Yes under "Did this answer your question?" of the verified answers to close this thread.

Was this reply helpful? Yes No
MarcusCrooke 96 on at

Like (0)

Report

Hi Hao,

Thanks for this suggestions.

After clicking through EDIT DATA IN EXCEL I come up against the below error when trying to download the data through DATA CONNECTOR.

Entity field(s) cannot be found

Details:

In source lead the following bound fields cannot be found or may be private: _relatedobjectid_display

Any ideas of how to fix this?

Thanks,

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (1)

Report

Hi Marcus,

Do not use DATA CONNECTOR, we are just looking for duplicate columns, which have nothing to do with data.

Please close the Data Connector sidebar and find the duplicate column in the way as in my last reply.

Was this reply helpful? Yes No