Extract user points

Thank you for your help with using this plugin – it’s great! May I ask whether it’s possible to extract user points and save them in .csv or any other way so that it can be saved or even printed accordingly? Thank you and good day! There isn’t a feature like this available, but if you have access to phpMyAdmin or another database interface through your hosting control panel, you could export the user points that way. If that might be an option for you, I could help you craft the database query that you would need to run. Thank you! Will let you know if need be! Best Regards, Leonard Callus I have access now. What do I need to do please? Thank you so much!! As in I have access to the hosting control panel and I’m using hostgator You would run a query on the wp_usermeta table using phpMyAdmin or another similar program. The table names may be slightly different if the prefix is different than wp_ . You will also need to change the wordpoints_points-points to replace points with the slug of your points type (e.g., wordpoitns_points-credits ). SELECT users.display_name AS user, meta.meta_value AS points FROM wp_users AS users LEFT JOIN wp_usermeta AS meta ON users.ID = meta.user_ID AND meta.meta_key = 'wordpoints_points-points' ORDER BY COALESCE(CONVERT(meta.meta_value, SIGNED INTEGER), 0) DESC, ID ASC phpMyAdmin should give you the option to export the results as CSV. This reply was modified 7 years, 3 months ago by J.D. Grimes . Reason: code formatting Hmmm for some reason I can’t find wp_usermeta under the list of databases :/ . They all start with wp_ however there’s isn’t one with that name. Oh wait I managed!! Thank you so so much. Not sure if it made the whole difference but I used the wp_social-users table and ran the query from there and it worked. Thank you once again!