Import users from a CSV file into WordPress
Works really well - but make sure that you use LibreOffice to save your CSV rather than Excel. That'll save you a half hour of frustration...
Worked out of the box.
The only problem I had was that all first names and last names where terminated at special characters (german umlauts) without any warnings or errors (e.g. "Stöckl" - only "St" was loaded). But this is not the Plugins fault, this is WordPress. After converting the CSV File to UTF-8 this was solved.
Maybe showing a hint that the input file should be UTF-8 encoded would make sense.
The plugin works well, but I had to add the following line to the top of import-users-from-csv.php:
Until I did that, it just timed out. Also, I selected the "Update user when a username or email exists" field when importing. My input file had 164 entries but only 161 were added. When I checked the CSV files, there were indeed three duplicates.
BTW, I'm using WP 3.9.3, but the dropdown when writing this review didn't offer that as an option.
After following jcow's instructions on downloading LibreOffice I was able to also successfully import users. Excel is useless for this plugin.
It works great, but you have to save it a certain way that I couildn't find in the documentation. Exporting from Excel doesn't work by default. I had to use LibreOffice and use specific settings to make sure each frame is wrapped in quote marks. Then it worked REALLY well. It doesn't work AT ALL otherwise and gives no errors.
It is not working at all. Installed and activated twice but there is no import option in the user menu. Very, very frustrating. Deactivated all plugins didn't help either. Is this a known bug?
I was looking for a quick, easy-to-use and free solution to import a massive database of users and i found your plugin. I was a bit scared because of the latest update but its working fine even with WP4.0.
I just had an error message while importing, i changed the charset and delimiters and all worked fine, even with personal user meta (using WP-Types)
Thank you for the time i saved :)
Failed to import the CSV, and error was not written to plugin log, so there's no way to troubleshoot.
I used the Export Users plugin by the same author (which works great) and I then used this one to import the already exported users to another WP installation. Very easy and straightforward! Thanks for the plugins!
After spending several hours setting up my file and importing and troublehshooting, I discovered that when you import hashed passwords using this plugin, it stores those passwords into your database as simple text, not as MD5.
This plugin assumes when you create your CSV file to import, you are able to see all the passwords for your users, which isn't possible since passwords stored in wp_users table are hashed as MD5. Who would create a plugin with the assumption that you can see all of your users' real passwords.
I couldn't figure out what was happening when I wasn't able to login, until I tested login using the hashed password, not the 'real' password. Not good. Wasted several hours. Eventually I just imported in phpMyAdmin using an SQL import of the user table I exported, and that worked fine. I should have done that in the first place.
I also checked the forums and only found one other user who brought this up. That forum topic was closed, but never resolved by the developer. Someone just recommended importing the passwords using phpMyAdmin, which defeats the purpose of using this plugin.
You must log in to submit a review. You can also log in or register using the form near the top of this page.