Reimport users after migration to Wordpress

Question

We're in the process of migrating from Drupal to Wordpress. The initial migration went without a hitch and we're now setting up new contribution forms in the new site. The plan is to reimport the users once we are ready to go live with the Wordpress site as the tables will be out of sync by then. So, is there a way of migrating just the user data at a later date without overwriting the other work we will have done in the system?

Thanks

Chris

Answer 1

Assuming you have done something like that :

• install Wordpress
• install an empty CiviCRM on Wordpress
• create the users in Wordpress with the same email as the primary email of their contact in CiviCRM
• copy CiviCRM database and reset the path or update them as needed

You should be able to fix the users / contact link by updating the civicrm_uf_match table with a sql query like :

UPDATE civicrm_uf_match uf 
  INNER JOIN civicrm_email e ON uf.contact_id = e.contact_id AND e.is_primary = 1 
  INNER JOIN wp_users u ON u.user_email = e.email
SET uf.uf_id = u.id;