DMM Import Error - Source data is not in the required format

While importing data recently, I recieved the above error message. With the application of my brains I understood that Dynamics CRM and Office Excel Date formatting did not match.

I changed the Date format to mm/dd/yyyy in Excel and CRM (Tools > Options > Format) to maintain consistency and I had a favorable outcome.

CRM 4.0 Data Migration Manager in Multi-tenant Environment

You have installed CRM 4.0 and you want to migrate data using the data migration manager into the Organization.

OK, You know what to do!

Install Data Migration Manager on one of the workstations > Configure it for the Organization and continue your migration using DMM (Data Migration Manager)

Now, you created another Organization in CRM (Multi-Tenant) and you want to migrate data into the new Organization. The good news is you can do it, the how is what you have to live with. Install DMM on another workstation > This time configure it with the new Organization you just created and proceed with the migration

or

Completely uninstall DMM and reinstall it. This time configure it for the other Organization. Before reinstalling the application, you need to manually delete the database or rename it. The setup will create a new database for the new installation of DMM, and will fail if the database already exists. The database that needs to be deleted is MSCRM_MIGRATION.

"The path is not of a legal form" Error - While installing Data Migration Manager

While installing Data Migration Manager for Microsoft Dynamics CRM 4.0 on the Server, I received the error message "The path is not of a legal form"


Here is how you make the path legal to install Data Migration Manager.

• Start > Run
• Type "regedit.exe" (without quotes)
• Navigate to key - [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\59DD8CB00184F24E99A62CF4D6109FA\InstallProperties]
• Right-click InstallLocation and select Modify
• In the Value Data text field type "C:\Program Files\Microsoft Dynamics CRM"

The Value Data field had no value, until I did the above needful. Now your installation must be smooth. You can also follow this thread on Microsoft Forums for further information.

Happy Installing..

Please Note: The value 59DD8C...... after the \Products\ folder in regedit.exe might differ in some cases. I have learnt this as it has come up on forums. You might have values like:

• 43689CC1EAEE14C458FDAD0580BC0C97
• 059DD8CB00184F24E99A62CF4D6109FA

Go ahead with them. After all you want a successful installation, don't you?

Importing data in CRM

Heylo! Used a tool to import data into CRM.
Pretty good tool to use.

1.You'll need the view of the entity you want to import data on.

2.Export the view as .csv

3.Enter data into it

4.Import it back into CRM using the CRM import tool

Simple tool at use and performs the task promptly. The screenshots and in depth explaination of the tool is here and the tool can be downloaded from MS CRM Data Import Tool.

Enjoy your weekend.