Hi, we use User Role Pro (and are very pleased with it!). We have 400 users and I would like to export a list with all user names and emails to check them easily, preferrably I want to open that list in Excell. Can I export such a list with User role?
I can see an “Export” button in the admin. When I click I get a .dat-file? What is that and how can I open and read it? When opened in Notepad it is just one line of characters (file is 8 k). That can not be the user list?
If this can not be done thru User role, can you recommend a plugin that does this (read about some plugin that created a whole lot of mess that I realy don´t want).
Query sample with first and last name for every user:
SELECT users.user_login, users.user_email, users.user_registered, meta1.meta_value as first_name, meta2.meta_value as last_name
FROM wp_users users
INNER JOIN wp_usermeta as meta1 on meta1.user_id=users.ID and meta1.meta_key='first_name'
INNER JOIN wp_usermeta as meta2 on meta2.user_id=users.ID and meta2.meta_key='last_name'