This plug-in allows you to batch import of users/members taken from an uploaded CSV file.
I only gave this a 4 star rating because the instructions were very lacking I felt. Once I got it to work, it did the job very nicely. I did this working from my Mac but I'm sure the same will hold true no matter what you use. I'm sure someone will have a comment or two but this is what I did and it worked. I'm including this in my review so no one should have to waste much time figuring it out.
*** Members import fields ****
// User data fields list used to differentiate with user meta
$userdata_fields = array(
'user_email', 'user_url', 'user_nicename',
'display_name', 'user_registered', 'first_name',
'last_name', 'nickname', 'description',
'rich_editing', 'comment_shortcuts', 'admin_color',
'use_ssl', 'show_admin_bar_front', 'show_admin_bar_admin',
The above is exactly how the fields have to be laid out in Excel and the CSV file to import to WP. All of the fields with the exception of the date field will need double quotes i.e. "name". All delimited by a comma. To do this in Excel, all the fields need to be hi-lited. Then go to Format -> Cells -> Custom. In the Type field enter \"@\" then click OK. All the fields now appear to have double quotes. Next do a Save As and select for Windows CSV file. The others won't work!
For the next step open the saved CSV file in a text editor like Komodo Edit or Note Pad, etc… You'll see there are 3 sets of quote marks around each field("""name"""). Now go to Edit -> Replace or Find/Replace. Search for """ and replace with ". All fields should now be delimited with only one set of double quotes i.e. "name" not """name""". Save the file.
In WP select Import Member, the CSV file, your options and then Register. When it completes click on All Users and they should be there. If you go into cPanel and phpAdmin, then select wp_users and the Browse tab, there they are. Also select wp-usermeta and Browse to further verify data.
This issue is several months old without a resolution. I searched the forums and tried different versions of csv files as suggested. I get a successfully imported messages but the users are not imported.
This plugin streamlined a website migration. I especially appreciated the option to automatically set the username to the email address, which was a small detail with big payoff for this project.
For ease of use, I'd recommend having a cheat sheet of field names on the import screen.
Thanks for the lovely work.
You must log in to submit a review. You can also log in or register using the form near the top of this page.