WordPress group sync - after migrating from Drupal

Question

I'm migrating my site from Drupal to WordPress, and could use some advice about how to handle syncing between CiviCRM groups (not members) and WordPress groups.

I guess the first question is: how do I deal with the leftover user IDs attached to contact records? There are a few hundred contacts that show a user ID, but those user IDs don't exist in WordPress (I'm currently the only actual user on the site):

Can I simply run a SQL query to delete all the user ID values? If so, where are they located? I haven't found them yet.

Once I've cleaned that up, I need to choose a method for syncing groups between WordPress and CCRM. It looks like CiviCRM Groups Sync is the right choice for that, am I correct?

I've been getting a little confused between CiviCRM WP Profile Sync, CiviCRM WP Member Sync, BP Groups CiviCRM Sync, and CiviCRM Groups Sync. I installed CiviCRM WP Profile Sync first, because it was easy to find and install, but I guess that only deals with Members in CiviCRM land?

Answer 1

how do I deal with the leftover user IDs attached to contact records?

Clear your civicrm_uf_match table except for your own record - i.e. the one that has your User ID and Contact ID. You'll then need to decide how and why you want to create Users from your Contacts...

1. Do they have memberships in CiviCRM?
2. Do they need to login for some reason?

Depending on the answer above, you have a couple of options:

• For membership-based Users, use CiviCRM Member Sync. You can then create your Users from the plugin's "Manual Sync" admin screen.
• For login-based Users, you can create Users one-by-one with CiviCRM's built-in "Create User Record" option in the Actions menu on the Contact View screen. Or you can use CiviCRM Profile Sync which has a "Create Users from Contacts" Bulk Action in CiviCRM that you can enable by adding define( 'CIVICRM_WP_PROFILE_SYNC_BULK', true ); to your wp-config.php file.

Wordpress groups

WordPress doesn't have groups out of the box, so you need to decide which plugin you want to use to provide them.

BuddyPress can provide them if you're after social media style discussion groups and that's what BP Groups CiviCRM Sync is for - it works in a similar fashion to the Drupal OG Groups Sync module.

The "Groups" plugin can also provide them and that's what CiviCRM Groups Sync is for - these groups are permissions-based groups and don't do anything in and of themselves but can be used to grant (or revoke) access to content.

Your choice of group type depends on your use case.

Hope that helps get you started.