·
2 min read

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