Microsoft Dynamics CRM Online Data Import tool


On Codeplex there is a tool for Microsoft Dynamics CRM On Premise  that allows you to modify records and then re-update the CRM system with them. There are two advantages to this tool. The first is that you can update the records in a grid view and the other is that you can export the records to a csv file, edit the data in Excel, and then re-import to update the records in CRM.

You can find the original source code and binaries at http://www.codeplex.com/MSCRMimport .

More information: CRM Data Import Tool.

I've made changes to the code so that it will work with CRM Online. You can download from here.

Make sure you create a folder on you local drive and unzip the contents. Some folks use their desktop but I suggest a folder off the root drive to avoid any potential problems. The application is in the bin\debug or bin\release folder.

I've taken a few screen shots to show the tool.

The first is the login:

Login screen

Enter in your Windows Live ID that you have used for your CRM authorization. Enter your password and organization name.

Next, the tool will load the Record view window:

Record View Window

You can edit records by clicking on the field and just typing in the grid. This is useful if you have lots of small changes to make. Just make a view containing the fields you would like to edit and load it in the tool. After you make your changes, click on the Update Records button.

Notice the drop down at the top. You can select which entity you would like to view as well as the CRM user view to display in the grid.

Select Entity

The next piece is the ability to export the record into a csv file. This is useful to edit records in bulk or you can just use the data in Excel. When you are ready, you can import the data back into CRM using the import tool.

More information: Using the Microsoft Dynamics CRM Online Import Wizard.

When you do the import of the file back to CRM make sure you saved the file as a CSV file. Notice the import wizard, recognizes the file has unique identifiers for the records and prompts you do an update rather than re-create. This happens only if the record GUID is the first column in the file.

Enrich Data checkbox

The other tool available to do essentially the same is the Bulk Export. You can export records and then re-import them with it also.

Cheers,

Jon White

Comments (5)

  1. Peter says:

    Your XML feed doesn’t seem to be working. Are you planning on getting it working soon?

  2. 365blog says:

    Just tested XML Feeds:

    http://blogs.msdn.com/crm/atom.xml

    http://blogs.msdn.com/crm/rss.xml

    and the XML Feed for comments to this post:

    http://blogs.msdn.com/crm/commentrss.aspx?PostID=9700230

    All seem to be working. Can you be more specific about what isn’t working for you?

  3. Jeremy says:

    Not following the Readme very well, using the online version, I have the zip file extracted and the sdk downloaded and installed, but not sure what to do with the .dll files as it just says copy the 2 dll files??

  4. Todd says:

    I’ve tried this re-import tool, specifically on the Account entity.  I export to CSV, manually modify CSV file and save appropriately.

    Text fields seem to update correctly however picklists and bit fields fail to locate a proper data mapping (bit fields seem to be handled in the same fashion picklists are handled).  

    I can force and configure a data mapping by altering the column headers, in particular the Account (i.e. GUID) column header.  When I do this, new records are always create – irrespective of the data map.  Records are never updated and I do not get option to select/activate the Data Enrichment checkbox.

    I should mention the only way only way I can get the Data Enrichment feature to be available is if the Account column (containing the Account GUID) exists with the column header named "Account" and all subsequent column headers exactly match the Account Attribte Display names.  I think this is by design (Automatic mapping is manditory for record updates).

Skip to main content