Matthew A PriceUPDATE July 24, 2012
So I have created a dev V2 of the plugin. Completely rewritten from the ground up.
You can download and test it at: https://github.com/matthewaprice/WP-Export-Users
It now makes a download file automatically. No longer just displays the results in a textarea. I also removed the field encapsulators and separators as I modified how the file is made. The resulting file is openable directly with Excel or Pages ( it is a CSV file ).
I am working on the import feature and will have that up in the next couple of days as well as other features
Matt
—
This is a nifty little plugin that allows you to customize CSV output of your users. It will export their username, display name, and email address. You can select which columns you need and then review the output from the admin area. You can regenerate the output as many times as you like then copy and paste the data either into a text file or directly into the system that it needs to go.
For example, you have your newsletter hosted by Constant Contact, Moible Storm, iContact, etc. They have very easy import options for CSV files or some have a “Copy and Paste” your data directly into the system. Some of these API’s even cost money. So you can use this plugin to craft the data how you want/the other systems, want.
You can download the plugin at: http://wordpress.org/extend/plugins/wp-export-users/
Tweets that mention WP Export Users | Counting Rows -- Topsy.com
[...] This post was mentioned on Twitter by drfots, Counting Rows. Counting Rows said: New WordPress Plugin. WP EXPORT USERS. Allows for custom csv output with preview before you make the file http://bit.ly/92uNzc [...]
Ben
GREAT !!
I use it on my WP 3.0.1 without problems……. maybe, some more fields to get out of the database ? like website ?
It is very simple en useful for me like it is now !
Thanks !
Used on http://hierlive.com
Matt Price
Thanks for the kind words. I will definitely add more fields from the usermeta table in the future.
Matt
Dylan van der Heij
Hi Guys,
Is there any chance to export the ‘role’ of a user with this plugin?
Many thanks!
With regards,
Dylan
Matt Price
Hi Dylan
My next version will include the following:
Usermeta Data (url, aim, etc)
User Roles
and anything else that is suggested in the next week or so. My initial version was specific for a client and needed to get out quick so i kept it to basic info.
Thanks for all of the feedback
Matt
Matt Price
Hello Everyone!
I have updated the plugin to include User Role and User Url.
Thanks for the suggestions.
Matt
gary
when i go to generate the list, after choosing a few fields, the output is nothing? when i first go to the plugin i have a list of the emails but i would also like : password, username, name, email – any reason why i may not be getting the data?
Matt Price
Hi Gary,
Can you please let me know the version of wordpress you are using? and if you are also using buddypress? Hopefully we can figure out what is going on.
Thanks
Matt
Matt Price
Hello Everyone
I am currently working on the bug that returns a blank screen when some of the export options are checked. I will be releasing a fix in the next couple of days.
Matt
Matt Price
Hello Everyone
so i have released the new version of the plugin.
it addresses the blank screen issues as well as refines how the separators and encapsulators are handled
http://www.countingrows.com/wp-export-users-updated-to-version-1-2/
Debbie
Hi Matt,
Do you know if there is a plugin to transport user information from the wordpress site to say an excel sheet or something.
Thanks,
Debbie
Matt Price
Hi Debbie
So you can use my plugin to generate a CSV file that you can then import into excel. You can use the field delineators and separators to create the CSV file. You can copy and paste the output of the plugin into a blank text file. Then you can save that file as users.csv. Then import that into excel and you should be jammin!
Feel free to follow up with any questions
Matt
Julia
Does this plugin allow you to include passwords as part of the user data? We’re in the process of upgrading our WordPress site and part of that upgrade includes the migration of the account management portion of the site over to our main corporate (non-WordPress) site.
I’ve been told by IT that while we can pull the user names and email addresses, we can’t get to the passwords and as a result everyone with an account on our current WP site will need to reset their passwords when we make the transition. This seems like a big inconvenience to our members so I’d like to see if there’s a way transfer the username and password to the new site for them.
Thanks for any help you can provide.
Matt Price
Hi Julia
Providing that the new system that you use uses the same password encryption, I could grab the passwords out of the database and include it in the plugin. What is your time frame for migration?
Regards
Matt
Julia
Hi Matt,
Unfortunately the password encryption won’t be the same on the new site. That would have been too easy. Thanks for getting back to me so quickly tho!
Matt Price
hi Julia
so it is still possible to do what you like. just means a bit more work. if you want, you can email me at matt@countingrows.com and we could figure out a way
Matt
Ben Tupper
Hi Matt,
Will a future version of this plugin allow the export of a user’s name (ie: Matt Price)? I too would be interested in exporting out passwords. Please contact me to discuss. I’m happy to donate $ for assistance. Thanks
Matt Price
Hi Ben
I can definitely hook up the First and Last Names. I just recently made a custom version of the plugin that grabbed custom profile data from the users_meta table. So i can work on that upgrade for a next version. I can get it to it this weekend. As far as passwords go, i could only pull the encrypted versions. I would not want to have passwords exposed in one of my plugins.
Thanks
Matt
Matt Price
Hello Everyone,
I have released a new version of this plugin that allows for first and last name as exportable options.
I have updated the plugin to include First and Last Name as exportable options.
You can download the plugin at: http://wordpress.org/extend/plugins/wp-export-users/
sebastien
Hello, thanks for your plugin. I am looking since at least 2 hours how I can authorize “Editor” to use it, instead of “Administrator”, and I do not find. In an Association of mine, the Editor is in charge of a newsletter …
Thanks if you can help !
Matt Price
Hi
So by default it is only the admin that can use the plugin. i can write a bit of modified code for you so that you can have an editor use it too. I can get it to you in a couple of days
Bob
Matt, does the updated version now support exporting of the encrypted passwords? That’d be very helpful for cases of an export-and-import where the same keys/SALTs are being used in wp-config.php between the old and new site.
Matt Price
Hi Bob
It currently does not export passwords. I can add that to the list and get that out this week. Thanks for the suggestion
Matt
Matt Price
Hi
I will definitely be getting a version of the plugin out that has the encrypted passwords by saturday. I apologize for the delay.
Thanks for all the support
Matt
Matt Price
Hello
I have updated the plugin to now included encrypted passwords as part of the output
You can download the plugin at: http://wordpress.org/extend/plugins/wp-export-users/
Travis
Hello Matt.
Thank you for your WP Export Users plug-in that will export to .csv the user data (username, first, last, email, etc), but if you look at our site and click Sign Up:
http://www.vetworkingla.org
You’ll see we have additional profile fields that are required in order to register.
What is an easy way to get all those fields to export in a similar fashion? Once I get it into Excel, I can link them to the userdata, I just want to save the trouble of having to click each profile and copy-n-paste the data into a spreadsheet.
Any ideas? Thanks in advance.
-Travis
Matt Price
Hi Travis
I have written custom implementations like this already. what are the field names from your User Meta table? feel free to email me directly at matt@countingrows.com
Matt
Pieter Hartsook
I’m trying to move a WP blog from one hosting service to another. I would like to use your export users then be able to import the file with all the fields into the Users at the new host. Any idea of a plugin that is compatible with your output format that would import the user data? Thanks.
Matt Price
Hi Pieter
You can use the wp-admin area to do this. you can go to Tools -> Export – > Then follow the instructions. for your purpose this will bring forward all posts, users and other information
If you need any help feel free to let me know
Matt
Jesse
Any chance of having the physical address export too?
Matthew Price Post author
Hi Jesse
Do you have the physical address of the users stored as a usermeta? this is not a standard profile field for WordPress
Thanks
Matt
Thom Hoff
I am working with the Plugin and it works very well in the admin space however I need a general user to be able to use it also. Is there an easy way to do this with the ADD_ACTION function or does this require something custom?
I also noticed that when using the encapsulating option it appears that do the encapsulating after the data is pulled. I have a user that as a comma in their name (first last, middle). The output shows “first”,”last”,”middle” instead of “first”,”last, middle”.
Any help would very helpful.
Thanks
Thom Hoff
1) From what I am reading it appears to be the add_user_page (its 3rd parameter) that would needs to be changed however I am not sure what to change it to (or if I am even correct). The Role that I want to see this plugin is “Author” and above.
2) The following line appears to be causing an issue when the user has a comma in their name: “$getArrayData = explode(‘, ‘, $getArrayData);”. This line splits the data using the comma as a delimiter. Shouldn’t this be using a different character for splitting data since the user can use the comma in their input?
Matthew Price Post author
hi thom
i guess i made a bad assumption about splitting the names using a comma. the user meta fields that i am using are first_name and last_name. i am not including a middle name. the plugin doesn’t account for a middle name. it could in the future, but right now, just uses those two meta fields. i could potentially use a “pipe” or something to separate to allow for the functionality that you are seeking
Matt
James
I am trying to make my mailing list as customer friendly as possible and give people the option to opt in/opt out of the mailing list. I see that there is a field that can be ticked or unticked in the users information section of WordPress.
Is it possible to include a “True/False” or “In/Out” value for this in the export based on the selection in that field in your next revision please?
Also, I currently use Wishlist Member to manage the membership side of my site. It currently transfers the registration information to the user’s section of my WordPress install. Sadly it does not have the address fields automatically set up so I have created these as custom fields – is there any way that you could potentially build in the ability to add more of my own fields to the plug in?
If not, please would you contact me to discuss the cost of a custom plug in.
Many thanks.
Matthew Price Post author
Hi James
I have made custom versions as “one offs” until i can generisize all the customizations into a public release. I have made versions that include custom user meta fields. If you could send me the names of the fields i can see what i can do. And is the opt-in/out a custom user meta as well?
Thanks
Matt
Matt
Hello,
I’m trying to transfer all my users from one wordpress site to another – after exporting it with your plugin, how can I import these users into another wordpress site?
Daniel D'Laine
I”ve just used this on v. 3.3.1 with no problems and it works an absolute treat — saved loads of time!!
I couldn’t find a way of getting just the first name followed by email, so I did two separate lists, one for each column, dropped each into a spreadsheet — and they matched up perfectly!
Is there a proper way to do this?
Regards
Daniel D’Laine
warren grantham
I am interested in getting the info from more fields to be exported into the csv file. I can actually get the fields to be printed but the data in those fields do not show up. Is there any documentation anywhere that I can use to help me with this? I am using buddypress and the fields that I need were created there. Thanks.
Matthew Price Post author
Hi Warren
I will be fairly busy the next 6-7 days. I have made a couple of custom versions of the plugin that use custom fields, user meta, etc…so i am sure that i would be able to hook it up to add xprofile data
Matt
Kristen
I’ve been unable to activate v1.2. Installed from within WP, but when I try to activate I see: Fatal error: Call to undefined function get_called_class() in /home/mnla/public_html/wp-content/plugins/wp-users-exporter/A_UserExporter.class.php on line 112
Can you help?
Matthew Price Post author
Hello
So my plugin is called ‘/wp-export-users/’
The plugin that you have installed is not mine. Your plugin is called ‘/wp-users-exporter/’
I know that can be confusing : >
Matt
Chris_Christoff
Hi Matthew,
Is it possible for:
A. To import exported users into a new site?
B. Automate the importing and exporting?
Matthew Price Post author
Hi
I am in the works of a completely remade upgrade to this plugin. When i made it the first time it was basically hacked together to get something working for me. Your additions are definitely part of my new version. It will be a lot cleaner and simpler. I looked at it recently and was like “what was i thinking when i wrote this?” : >
Matt
Matthew Price Post author
Hi
So i have created a dev V2 of the plugin. Completely rewritten from the ground up. You can download and test it at: https://github.com/matthewaprice/WP-Export-Users
It now makes a download file automatically. No longer just displays the results in a textarea. I also removed the field encapsulators and separators as i modified how the file is made. The resulting file is openable directly with Excel or Pages
I am working on the import feature and will have that up in the next couple of days
Matt
Ronier Lopez
Matthew Price Post author
As this is an export feature, i really didn’t actually find it necessary to create an import function. i also forgot that i had said that i would try to figure that out. It is not gonna happen anytime soon