CODEWITHSUNDEEP
dynamics-crmexport-to-excelmicrosoft-dynamicsdynamics-crm-2013
Brian Fleishman
Brian Fleishman

Reputation: 1257

Exporting MS Dynamics CRM Accounts Entity with Notes

We are running an On-Premise version of Microsoft Dynamics CRM. Our extact version is:

Microsoft Dynamics® CRM 2013 Service Pack 1 (SP1) (6.1.4.145) (DB 6.1.4.145)

I would like to export the Accounts and Contacts entities with the associated NOTES fields. But under the advanced find tool, I do not see that field as an available option when trying to export.

How can I accomplish this?

My goal is to export the required entities to an Excel Spreadsheet for import into another database system.

Upvotes: 1

Views: 1690

Answers (1)

Arun Vinoth PrecogTechnologies
Arun Vinoth PrecogTechnologies

Reputation: 22836

Notes can be exported from Adv.Find separately like Accounts & Contacts. (Associated records wont export from Parent entity export). You have to filter the regarding entity only for Account/Contact to filter out other entity Notes.

At the end you will have 3 datasets (excel) with Accounts, Contacts, Notes which you can use it for import in destination. If you want the GUIDs of CRM records, make sure to check the checkbox for re-import - this will give hidden Id columns in exported excel - you can map for relationship.

Upvotes: 2

Related Questions