Answers.Body: <p>We are just at the end of migrating an organisation who were using MS Dynamics. In this case, they were providing us with spreadsheets and we were then sorting out the data clean up and manipulation in order to get the results required in CiviCRM. </p>
  
  <p>We didn't use our more complex tools such as the Drupal Migrate approach that we developed for a number of reasons, but even without that we have for example managed to take the old 'one row for every year of membership' and import it so we have a single row for continuous memberships etc.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-23T19:57:51.663Z
Answers.LastActivityDate: 2017-02-23T19:57:51.663Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>I have not done this with MS Dynamics. But I did it from QuickBooks. We exported Excel reports out for Contacts and Donation history. Then we imported them into Civi. I'm sure you can do it that way without to much trouble.</p>
  
  <p>We found the API csv Import Extension very useful for getting our information imported.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-24T03:26:09.303Z
Answers.LastActivityDate: 2017-02-23T17:03:38.393Z
Answers.LastEditDate: 2017-02-23T17:03:38.393Z
Answers.UserDisplayName: Iowa Boy
Body: <p>We are in touch with an organization that is planning a move to CiviCRM. They currently use Microsoft Dynamics and they will want to migrate the data into CiviCRM (I suspect 4.6). Anyone done that before, hints, pitfalls, approaches, experiences they would like to share?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-01-13T20:58:10.823Z
Comments.Text: Did you get any help?
Comments.UserDisplayName: nielo
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-01-16T19:21:25.347Z
Comments.Text: No answer yet :-)
Comments.UserDisplayName: ErikH - CiviCooP
Tags: <migration>
Title: Does anyone have experience with migrating a MS Dynamics database to CiviCRM
ThreadText: # Does anyone have experience with migrating a MS Dynamics database to CiviCRM
  
  (Asked by: username_0 on 2016-06-17)
  
  We are in touch with an organization that is planning a move to CiviCRM. They currently use Microsoft Dynamics and they will want to migrate the data into CiviCRM (I suspect 4.6). Anyone done that before, hints, pitfalls, approaches, experiences they would like to share?
  
  **Tags:** migration
  
  > **Comments:**
  > **username_1**: Did you get any help?  
  > **username_0**: No answer yet :-)  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2017-02-23. Score: 1
  
  We are just at the end of migrating an organisation who were using MS Dynamics. In this case, they were providing us with spreadsheets and we were then sorting out the data clean up and manipulation in order to get the results required in CiviCRM.
  
  We didn't use our more complex tools such as the Drupal Migrate approach that we developed for a number of reasons, but even without that we have for example managed to take the old 'one row for every year of membership' and import it so we have a single row for continuous memberships etc.
  
  
  ---
  
  ### Answer by username_3 on 2017-01-24. Score: 0
  
  I have not done this with MS Dynamics. But I did it from QuickBooks. We exported Excel reports out for Contacts and Donation history. Then we imported them into Civi. I'm sure you can do it that way without to much trouble.
  
  We found the API csv Import Extension very useful for getting our information imported.
  
  
  ---
  
  