I’m involved in a lot of Dynamics CRM data migration/integration projects. I know how much time it takes to analyse, clean up and import the data into a Dynamics CRM system. If you’ve done this in the past, then you know it can get complicated very quickly. Definitely if you have a lot of relationships.
With this version of Dynamics CRM I was pleased to see that you get some extra help in preparing your data fore the import. With CRM 2011 you can generate templates via the system that will help you with the preparation of your data. These import templates are in an XML format which you can open with Excel.
Generating the templates is done via the CRM 2011 system and it’s very easy. You can generate it per entity or from a more central location. Let’s say I want to retrieve the template for the account entity. I just navigate to the accounts view and click on “Import Data” from the ribbon. In the dropdown list, select “Download Template for Import”.
If you want, you can also retrieve the templates via the settings area. To do this click on “Data Management” in the left hand navigation. From this view select “Templates for Data Import”.
This will open a window with a dropdown where you can select an entity from. Once you have made your selection, click on the download button to download the template.
Once this is downloaded, you will notice that it’s an XML file. But no worries, you can open it in Microsoft Excel. At least when you have unblocked the file. This is just a security measure to prevent you from opening unwanted dangerous files. If you don’t unblock the file, you will be get the error message “The file is corrupt and cannot be opened”.
To unblock the file, right click on the XML file and open the properties. Here you will see a button to unblock the file.
Now you should be able to open the template without a problem and you should see something like this:
This is an extremely handy Excel file to have and it will help you a lot when you are preparing the data. Here is a list of features about the Import template:
All that is left to do is to fill in the Import template and import it using CRM 2011.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13