Creating Wordpress Users (with passwords) from Civi Members

[Ground Glass]

Similar problem to this post: http://forum.civicrm.org/index.php?topic=33194.0

Also, this is probably a good resource: http://ask.metafilter.com/218507/Can-I-create-Wordpress-users-from-existing-CiviCRM-contacts

I've got civicrm installed on our wordpress site with 1200+ members in the database. One of the main functionalities of the site is a members-only area that requires you be logged in as a wordpress user.

My hope is to create a Wordpress user for every existing Civi member in the database, but I can't quite figure out how to do this. I've got some ideas from the two links I posted above, but I wouldn't really know what to do.

(When launching the site, I thought the "Synchronize Users to Contacts" function would do the trick, but it turns out it does the opposite of what I need.. This is a pretty big mistake on my part, because the site is meant to be live and fully functional tomorrow, but if members can't access anything, the site is half useless. AH!)

Has anybody dealt with this type of thing and wouldn't mind giving me a hand?

[JonGold]

Are you comfortable using the command line?  If so, you can probably solve this problem with wp-cli (http://wp-cli.org/).  I wrote the section of this wiki page that describes using this same technique with Drupal and drush (http://wiki.civicrm.org/confluence/display/CRMDOC/Creating+a+Drupal+user+for+every+CiviCRM+contact).

In short, you can run "wp user create", which can also specify role, password, etc.:

Code: [Select]

wp user create <user-login> <user-email> [--role=<role>] [--user_pass=<password>] [--user_registered=<yyyy-mm-dd>] [--display_name=<name>] [--first_name=<first_name>] [--last_name=<last_name>] [--send-email] [--porcelain]

So the trick is to export your list of users from CiviCRM and open it in Excel.  Then you create a formula which takes your users and generates the appropriate "wp user create" command to create that user.  Paste that formula down, then take that column and save it to a text file.  You now have a script that will create 1200 Wordpress users!  The technique is described in detail on the wiki page above.  Hope that helps!

Jon

The exact technique is laid out well