migrate | Fuzion

Migrate 2 + CiviCRM api 3 = CiviMigrate

A major challenge for CiviCRM implementers is migrating data from legacy systems into CiviCRM. For large datasets the front end import mechanisms time-out and don't allow for the complexity of the data.

Importing a CSV using Table Wizard

Table Wizard offers a quick & dirty way to get a csv into a Drupal mysql DB as a table. You need to start by downloading & enabling tablewizard and schema. Make sure you choose to enable the delimited import part.

You should then be able to navigate to admin/content/tw via the content menu and upload your csv file.

If you want the table available in views, However you need to access MySQL (e.g via PHPMyAdmin)

and add a primary key column e.g.

Importing Memberships & Related Contributions using Civimigrate

The joy of CiviMigrate is when you have a complicated destination for your data. In our example we have a simple csv with 6 fields but we want to create a Contact (see previous blog), a membership for that contact and an attached contribution record for the payment received. This blog will describe how to do a membership import and then a contribution import off the same data set.

This blog follows on very closely from the previous blog and continues the same example.

Importing data from a Drupal View into CiviCRM using CiviMigrate

The Migrate module is a powerful tool for importing data into Drupal and Drupal modules. It is also an approach we have been using for large, complicated or recurring imports into CiviCRM. Some advantages of using Migrate module for imports: