3 ways to import data
Published: April 12, 2008
Every organization has data stored online about customers, products, leads, contacts, contracts, sales literature, competitors, and more. Perhaps you want to transfer this data to Microsoft Dynamics CRM as part of your initial implementation, or have purchased data after everyone was already using Microsoft Dynamics CRM. Wherever the data comes from, you can automate the process of importing it into Microsoft Dynamics CRM so that no one has to manually enter the data.
Microsoft Dynamics CRM includes three tools for importing data, each of which is useful in different circumstances:
-
Import Data Wizard: Used by any user for importing one type of record at a time.
-
Data Migration Manager: Used by the system administrator to migrate data from another customer relationship system.
Note
Data Migration Manager is not used in the following scenarios:
-
Upgrading from Microsoft Dynamics CRM version 3.0 to version 4.0. This task is done by running Microsoft Dynamics CRM version 4.0 Setup.
-
Moving deployments from one Microsoft Dynamics CRM server to another computer. This task is done by using the Import Organization Wizard, part of Deployment Manager. Deployment Manager is a tool that is installed on the server as part of installing Microsoft Dynamics CRM 4.0.
-
-
Microsoft Dynamics CRM SDK: Used by a programmer to develop a custom import solution.
Import data using the Import Data Wizard
The Import Data Wizard is built in to Microsoft Dynamics CRM, and can be used by anyone who needs to import data.
Common reasons for using this tool include:
-
Import leads that you have collected at a trade show or have purchased
-
Update your price lists or product lists from a spreadsheet
-
Import the following types of records:
When you import data, you must specify where each column in your source data belongs in the Microsoft Dynamics CRM record. The Import Data Wizard makes it easy to do this mapping. If you need to do frequent imports from a specific type of file, such as a spreadsheet generated by a business-card reader, you can create and reuse your data map each time you need to import new data.
System administrators and managers can control the permissions for those who can import which types of data. For example, people with sales-related or marketing-related security roles might be allowed to import leads, but not products or price lists.
Migrate data from another customer relationship management system
The Data Migration Manager is a separate tool that is typically used when you first implement Microsoft Dynamics CRM to bring data from your legacy databases and systems into Microsoft Dynamics CRM. It can only be used by someone with the Microsoft Dynamics CRM System Administrator security role.
Common reasons for using Data Migration Manager include:
-
Records need to be assigned to different Microsoft Dynamics CRM users.
-
The data includes many related records. This is typically the case if you are using an existing system, such as a contact-management system that tracks accounts, contacts, and history of interactions. Another example is a service-scheduling program that tracks service resources and appointments, and you need to import existing service resources and appointments.
-
The data is in multiple files.
-
You want to transform the data as it is migrated. For example, if you need to split one field into two, combine several fields into one, or modify a date field as it is migrated.
-
You want to set the Created-On date to a date in the past as part of importing the data.
The Data Migration Manager includes data maps for commonly used customer-relationship management (CRM) systems, and additional data maps may be available for download.
Build your own custom migration tools
If you want to automate the migration process, you can use the Microsoft Dynamics CRM SDK tools to create a custom program to migrate your data.
