Customer experience | Sales, Customer Insights,...

Export to xlsx from crm2013 SP1 UR4 issue

(0) Share

Report

Posted on by David_Mar

Hi all,

when exporting from CRM 2013 (SP1 UR4) view to excel (xlsx), for related entity columns, they appear twice on excel headers. Please look at this example:

View in advanced find:

View in excel

Does anyone know how to avoid the second entity name between brackets?

Thanks in advance!

All responses (2)

Answers (0)

Suggested answer

Ken Hubbard on at

Like (0)

Report

RE: Export to xlsx from crm2013 SP1 UR4 issue

Hello DM,

Looking into this, I could see that this is intended behavior that is still present today in the current Online and On Premise client (Ver 9.x).

To add a little more context to what is going on here, the naming convention is "FIELD Name (entity context) (entity)" For example below I added two columns to a User view. The first was the Calendar Type from the Calendar entity, and the other was the Address from the Created By context of the User entity.

This was implemented at some time in the past to avoid a duplicate column error that would occur within our process to create this sheet if you used multiple values with the same name from different or even the same entity. At the time the only workaround was to either rename or not use the column. For instance, in the example above, without the extra context, if you had 'Address' from User and Address from Created By user, you would have two same named Collumns of "Address (User)". Eventually, this is the solution our product group came to in order to prevent that issue.

To answer your original question, there is no means to change this behavior.

Thank you,
Ken Hubbard
Dynamics Support
Ken Hubbard on at

Like (0)

Report

RE: Export to xlsx from crm2013 SP1 UR4 issue

Hi David,

This certainly looks familiar, but I was not able to determine if this was a registered issue with CRM 2013. Allow me some time to research and I will let you know what I find out.

Thank you,

Ken Hubbard