Migrate Data from MS Dynamics | Online Help - Zoho CRM

Migrating from Microsoft Dynamics CRM to Zoho CRM


Converting the format of the MS Dynamics data files 

Zoho CRM supports only .CSV file format for migration of data. However, the export data from Microsoft Dynamics CRM is in .BAK format. You can get in touch with our team (migration@zohocrm.com) who can help in converting the files to .CSV format. 
The data should always be in the .CSV format. When you save the data backup to your local drive, it is a good idea to extract the files to check that the format matches and compress them again for import. This may sometimes create additional folders. If there are any additional folders in the zip file, uploading your file may fail. 
To raise a request with the support team:
  1. Go to Setup > Data Administration > Import.
  2. In the Data Migration page, do the following:
    1. Choose Microsoft Dynamics CRM.
    2. Click Contact our experts now, to submit your request for converting the file into .CSV.
    3. In the Submit your request popup do the following:
      1. Enter the Phone Number with country code.
      2. Select the Number of users from the drop-down list.
      3. Enter a Description and click Submit.
  3. Once you get the .CSV file, you can browse and upload the files.
    You can select multiple files or upload a zip file to migrate data into more than one module.

Mapping the modules

You can map the modules in MS Dynamics with the following modules of Zoho CRM. 
  1. Users
  2. Leads
  3. Accounts
  4. Contacts
  5. Deals
  6. Campaigns
  7. Notes
  8. Activities (Tasks, Meetings, Calls)
  9. Attachments 
  10. Competitor
  11. Cases
  12. Solutions
  13. Products
  14. Quotes
  15. Sales Orders
  16. Invoices
  17. Purchase Orders
  18. Vendors
  19. Price Books

To migrate data from MS Dynamics

  1. Log in to Zoho CRM with Administrator privileges.
  2. Go to Setup > Data Administration > Import.
  3. In the Data Migration page, choose MS Dynamics.
  4. In the pop-up, browse for and upload the files.
    You can select multiple files or upload a zip file to migrate data into more than one module.
  5. Click Next.
    Zoho CRM automatically reads the files and maps the data to the correct modules and fields.
  6. You can do the following in the  Module-File Mapping  section:
    • View the mapped and unmapped modules separately.
    • Click on a file and see which module it is mapped to.
    • View the mapped, unmapped and unsupported files separately.
    • Click the Discard Migration link to start again.
  7. Click on a module to view the files that have been mapped to it.
    You can also select from the  Unmapped files and map them. Multiple files can be mapped at the same time.
    You can also create a new module and map the appropriate file.
    At this step you can create a new module:
    1. Click Create New Module.

    2. Enter the module name and click Next.
    3. Select the file to be mapped with this module and click Save.
  8. Click Next.
    The mapped modules will be listed where you can map the fields for each module.
  9. In the Field Mapping tab, make sure that you map all the mandatory fields.
    The field names that you specified in the .CSV file will be available in the drop down lists.

  10. Click Create New Fields to add new fields and insert data for them during the migration.
    The number of fields that you can create depends on your Zoho CRM edition. (Skip to step 12 if you do not want to create fields.)

  11. In the  Create New Fields  pop-up, do the following:
    • Modify the field labels, if required.
      All the fields from the import file that were not mapped for migration because they are not available in Zoho CRM will be listed with their column numbers from the import file.

    • Select the Field Type from the drop-down list.
      Autonumber and Formula are not available. You cannot create these fields during migration.
    • Click Create.
      The field will be created and mapped to the columns in the import file.
    • Click Close to continue the migration process.
  12. Click Mapped Fields and Unmapped Fields to view the columns that are mapped and not mapped respectively with the fields in Zoho CRM. 
  13. Click the  Reset Mapping   link to start mapping from scratch. 
    Any mapping you have done so far will be removed and you can start over. 
  14. Click the  Auto Map  link to let CRM map the import columns with matching fields. 
    The system will identify columns that match the CRM fields and map them automatically. 


  15. Hover over the field and enter the field values in the Replace Empty Values text box.
    Sometimes the field in an import file doesn't have a value, in case that field is marked mandatory in CRM, the record will not be imported because of absence of value. To avoid such situations, you can mention an alternate value that will replace the empty field. 
    For example, you have mapped the 
    Last Name field from the file with the Last Name field in the Leads module, which is mandatory. So without the field value, the record will be skipped during the import process. To avoid that, you can specify the value that should replace the empty Last Name field. 
  16. Hover over the field and click the Add (+) icon next to the field name and map multiple fields in CRM with a single field from the file.
    For example, if the Billing Address and the Shipping Address are same you can map both these CRM fields to the appropriate fields from the file.
  17. Click the Assign Default Values tab and select the CRM Fields with the appropriate Default field values
    Once the values are specified, all the records will have the field value that you have specified by default. For example, you are importing a set of records to the Leads module and the Lead Source is common for all the records. The appropriate value for the lead source can be chosen here so that all the records will have the specified field value by default.

  18. Click Save and Next.
  19. In the Review page, check the Field Mapping Status and the Pre Migration Statusfor Each Module.
  20. Click Start Migration to initiate data migration.
    You can still click Edit Mapping and re-run Migration while the migration is running.
Note
  • Tags can be migrated from your file into CRM.
  1. If a record has more than 10 tags, only the first ten tags will be migrated.
  2. Each tag can have a maximum of 25 characters.
  • Then data migration will be paused if more than 5000 records in a module are skipped during the migration. You will have the option to discard the migration or continue. Zoho CRM will also inform you for each module if more than 5,000 records are skipped.
  • You can undo the data migration from Import HistorySee Also Viewing Import History

Check for Data Accuracy

After importing each file, check that the data is imported correctly. For example, after importing users to Zoho CRM, go to SetupUsers & Permissions > Users to check that all the users have been imported. Follow the same steps for Leads, Accounts, Contacts, etc. If the data is not imported properly or the fields were incorrectly mapped, you can delete the imported records and reimport. See Also Import History

If you have any issues with the above steps, please contact us at 
support@zohocrm.com or, if you would like us to migrate your data for you, fill in the form http://www.zoho.com/crm/zwitch.html  and one of our representatives will contact you shortly.

SEE ALSO

    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Data Migration: An Introduction

                                                                                                                The Data Migration wizard in Zoho CRM ensures that your data is migrated accurately and helps you reduce much of the manual work. It automatically maps import files to CRM modules and import file columns to Zoho CRM fields. In the case of modules ...
                                                                                                              • Migrating Data Between Zoho CRM Accounts

                                                                                                                Retrieve Data files from Zoho CRM If you are planning to use a backup of data from Zoho CRM to import, the file structure does not change. If you exported data from another CRM, use the following folder structure: The Data folder should contain all ...
                                                                                                              • FAQs: Data Migration

                                                                                                                What is Data Migration wizard in Zoho CRM? The data migration wizard in Zoho CRM ensures that your data is migrated correctly and helps you reduce much of the manual work. It automatically maps import files to CRM modules and matches data columns to ...
                                                                                                              • Microsoft Exchange - Administrator Guide

                                                                                                                Microsoft Exchange is email and calendar server software that comprises a collection of applications for digital messaging and collaboration. The applications include email services, scheduling events, contact management, task management, messaging, ...
                                                                                                              • Migrating from Sugar CRM to Zoho CRM

                                                                                                                Welcome to Zoho CRM! Migrating your data from Sugar CRM to Zoho CRM can be done seamlessly using our data migration feature. All you need is to have an export file from Sugar, ready to use. Click here to learn to export data from their CRM. Before ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources