30 day trial
John O'Donnell, Microsoft Dynamics ISV Architect Evangelist, is on Channel 9. He demonstrates the new Data Migration Manager tool in Microsoft Dynamics 4.0 showing how it can be used to import and link multiple entities from CSV files.
John O-Donnell blogs at http://blogs.msdn.com/usisvde.
PingBack from http://crm.discoveryjournal.info/2008/01/04/microsoft-dynamics-crm-40-data-migration-manager-with-john-odonnell/
Hi John. I have been watching your videos and was wondering if you were going to create any videos for upgrading from 3.0 to 4.0?
Also can anyone further explain below (we host CRM)
1) In 4.0, it appears that CRM can be configured so that no email router is needed at all – everything can be done in Outlook. Please see page 23 and following of the attached ExchangeRouterExamples document.
a. Does this really work?
b. In 4.0, it is possible to turn off the CRM tag in the email subject and have CRM intelligently figure out which account an email is for. Does this work when Outlook is used as the email router?
2) If we wanted (or the client wanted) to continue using an email router, here is my assessment that I would like to have verified:
a. Email tags (aka tokens) would still have to be used in the subject of emails
b. The customer would still need to set up email forwarding to us as outlined in the Exchange section of the attached user guide. What are the actual steps a customer would take to set up forwarding rules in their Exchange system – is it just what is written on page 20 and following in the attached ExchangeRouterExamples document?
c. We could receive that email either with Exchange or with some other SMTP email, then have the router associate the email with CRM. Would we prefer to use something other than Exchange to receive these emails? Does that really work?
Thanks for the feedback. I will look at making a video of the upgrade process from 3 to 4.
As for email
CRM 4.0 no longer needs the tags on the subject line. CRM 4.0 can intelligently work out the record to attach these emails to.
Also CRM 4.0 has a pluggable email architecture. This means CRM could work with other email systems beyond Microsoft Exchange.
Thanks for answering the questions. I really enjoy the video's. It was a good idea to put yourself up in the corner because we can read the screen better.
Another question: Do you know if the hosted bits are the same as the other bits?
Do you know if CRM 4 only supports forms authentication in a hosted environment?
Hi, John. We are considering using Dynamics CRM 4.0 for some classes we teach at the business school. I was wondering if you know how large the sample database is (e.g., rough # of orders or customers, etc). Since Dynamics is a new app for us, we want to make sure we know the sample db has enough database before we put into a huge amount of effort learning the application. Your help is GREATLY appreciated.
Hi, John O'Donnell
I made it to work with user mapping and Status ,Status Reason.
Its really kool product .
My migration manager doesn't work?
Even a repair of an new installation doesn't work.
Crm40 workks normally, on http://crmdemo.
When i log in trough the data migration manager the application says that
The configuration manager cannot connect to the Microsoft CRM server. This might indicate that the server is down?
But everything is working very good.
What is the problem?
Thanks for the video. Showing the relationship mapping was very helpful. I'm able to import contacts related to accounts, but am having a hard time also setting a primary contact for the account. Is it possible to set the primay contact using the Data Migration Manager?
A quick question...How do I migrate from CRM 3 to CRM 4? Do you know of some tool that might help with this process?
BTW: Fantastic blog
Very helpful video and good blog. I am having a bit of trouble in importing accounts that I don't wish assigned to me. I have owners for the accounts but need to know how to link MS CRM Users to the Accounts in my file. I have a column that contains the account owners and those owners are setup in MS CRM, however, it does not permit me to choose a user mapping. It insists upon importing the Accounts to me.
Any help you can provide is much appreciated.
The following information acts as a continuation to the brief introduction and demo of Data Migration
I don't really get this about look-up fields.
If I import contacts and accounts, I want to set a contact as primary contact in account, and add it to the account's contacts. It can get the contacts to appear in the account's contacts, but I cannot set a contact as primary contact (in the same import). Is this not possible.
At approx 7.18, you claim that in order to get a lookup to work, you need to use a business required field? Is this really true? I mean, last name is probably not unique, nor is full name (if I could use that).
I would probably like to use a combination of several fields. But this is not possible? Or can it be done by using "custom" data maps?
Hi John - I am working with DMM on a server with 2 orgs (Multi-Tenancy). I set up the DMM to be configured to Org1, then in CRM, I created another Org called Org2. How do I use the DMM to import data into Org2? I've noticed that there is no Org selection dialog box during the DMM import process wizard?
WENDY --> "Very helpful video and good blog. I am having a bit of trouble in importing accounts that I don't wish assigned to me. I have owners for the accounts but need to know how to link MS CRM Users to the Accounts in my file. I have a column that contains the account owners and those owners are setup in MS CRM, however, it does not permit me to choose a user mapping. It insists upon importing the Accounts to me."
If you open a USER in the administration you see a GUID in de Title of the screen. To get the GUID press F11 and insert it in a table you want to import under the USER column.
MS CRM will recognize the GUID and connect the Account etc. to the USER.
ADRIAN --> "If I import contacts and accounts, I want to set a contact as primary contact in account, and add it to the account's contacts. It can get the contacts to appear in the account's contacts, but I cannot set a contact as primary contact (in the same import). Is this not possible."
To get a primary contact in a Account create a Column in the table with Contacts and Accounts that contains a unique number or letters for ex. NL1000001 (Dutch Contact). So now the Account and Contact in the table have the same Primary Contact ID. If you use the Data Migration Manager this ID is the Primary Contact in the Account which looks for the Contact (Primary Key) in the Contact table. When importing the Contacts this ID is the Contact (Primary Key). The Data Migration Manager will do the rest, cause its a lookup field in the Account.
Hopefully I helped you both,
Sjoerd de Clippelaar
To get the primary contacts in the accounts add a primary key in the table and map it to Contact (Primary Key) and Primary Contact in Account when using Data Migration Manager.
To get a User at a account, contact or other table row. Open the User in the Administration and press F11. Copy the GUID and paste that in the User column of the table you want to import. Than map that column to the User in the Data Migration Manager, it will put the dataa under the assigned user.
Hopefully this advice helped you all out.