[Ultimate Member] How do I pull the information users enter in registration

  • I need to know how to pull or even FIND the information users enter into their registration fields. I need to be able to see reports. I have read something about user_meta but it never said how to pull these fields. I’m really confused and don’t know howyou can create a plugin that allows you to ask for information from a user and then makes it so hard to ACCESS the information they’ve entered!?

    I’ve literally been waiting almost 5 days for this answer in a different post and I just feel that Ultimate Member should do a better job at responding to support. I’ve never seen anything like this.

    Please….help.

Viewing 13 replies - 1 through 13 (of 13 total)

  • The easiest way to download basic information is via phpMyAdmin > Database wordpress > Table wp_users > Export (as a csv file).

    This suggests that you have something like cPanel already running with your host.

    Then, you’ll need Microsoft Excel to open the csv exported file, but that is not going to give you the information your users entered in their profile page forms because that is what the “wp_usermeta” table contains.

    If you decide to download and convert that export to excel, you will not find your users details associated with their names but with their user ids instead.

    The reason is UM considers those details similar to custom posts and they do not get added to the WordPress wp_users table as new data columns.

    I hope this helps,

    • This reply was modified 8 years, 1 month ago by borisv.
    Thread Starter kjordan83

    (@kjordan83)

    1) What is PHPmyadmin? Is it a plugin? If not Where do I access this?

    2) “Then, you’ll need Microsoft Excel to open the csv exported file, but that is not going to give you the information your users entered in their profile page forms because that is what the “wp_usermeta” table contains.” what does that mean?? Then where do I find the wp_usermeta that contains this info?

    I just really need clear instructions on where and how to download and convert this file. I am so disappointed in how difficult this is. :/

    Ultimate Member (“UM”) is a great plugin, and most importantly is FREE!

    If you don’t know what phpMyAdmin is, then call your hosting service provider and ask them if they can download and send you those 2 tables as CSV exports directly to your computer. This way you’ll be able to open them with Excel and you can see for yourself what I was talking about.

    But once again, the answer is there is no way that you can “pull” out all your user details including what they filled out in their profile pages in one big file swoop…

    Thread Starter kjordan83

    (@kjordan83)

    So what is the purpose of having fields available where visitors can enter information if once they enter it you never see it again and most of it can’t even be accessed through these reports from “myPHPAdmin”?

    How does that make any sense? If there is a way to pull the information at ALL someone should be able to explain it in a way that everyone can understand not just developers because this plugin was created for people who don’t know or necessarily want to be coding from scratch right?

    Maybe someone else can help. This doesn’t make any sense…

    Thread Starter kjordan83

    (@kjordan83)

    You just gave me these instructions “download basic information is via phpMyAdmin > Database wordpress > Table wp_users > Export (as a csv file)” and you aren’t able to tell me HOW to execute your own instructions??

    How is anyone going to give you instructions about working with data bases if you don’t even know what SQL tables are? You never even heard of phpMyAdmin and you demand instructions?

    I should have told you that what you want is not possible on UM and end of story. Please go to the WordPress main forum to ask users how to extract registration details from a SQL database, or do it manually via your WordPress Admin menu > Users > Username > click on the ‘info’ link.

    Good luck,

    • This reply was modified 8 years, 1 month ago by borisv.
    Thread Starter kjordan83

    (@kjordan83)

    Ultimate Member should definitely have a different support person representing their product. It is absolutely a reflection on the service and while you may think one person won’t make a difference, it is exactly the opposite.

    • This reply was modified 8 years, 1 month ago by kjordan83.

    For the record I don’t represent Ultimate Member and never have I ever stated that. I am just the only person who has bothered to answer your demands for an answer, It’s not my problem or the community’s that you are not knowledgeable enough to understand my replies.

    @kjordan83, @borisv gave you a straight forward answer really, but since you don’t know how to go about phpmyadmin, here is a solution i think might help. There are some plugins in the WordPress repository that does what you want to do some of these are “Cimy User Manager” and “amr users”. They can help you to export you members details with few clicks.

    Cheers!

    @phlexy, @borisv
    I’ve the same problem as @kjordan83, I found this post useful, so now I know how to extract the data I need (I do know how to use myPHP).
    Notwhitstanding, it’s simply absurd this data are not accessible via wp backoffice, @kjordan83 is absolutely right: these are very important data and they have to be accessed in a simple way (even via myPHP I’d like to see theme referenced by nome or email not ids).
    More oddly, if you select manual admin approval for new registration, before the new user is approved by admin, THOSE DATA ARE EASILY ACCESSIBLE: in user list, a “info” link is shown (beside “view profile”) that opens a popup with the exact user information kjordan83 was talking about. BUT (and here comes the weird stuff) from the moment you accept the user, this “info” link will disappear and the data are not accessible anymore. So instead of rely on myphpadmin it would be very very much easier if the “info” link would be left in place even after user approval.

    • This reply was modified 7 years, 5 months ago by mik. Reason: add email notification

    And by the way, the users registration info kjordan83 was looking at are NOT in wp_users table but in wp_usermeta table

    Hi All, there is a plugin named Database browser which quickly show you all fields contained in a specific table. In this case @kjordan83 you have to select wp_usermeta and just click “select”. The bad is you must see all the fields, even if not used by you. I hope this helps.

    • This reply was modified 7 years, 5 months ago by fabiob76.

    @borisv thanks for answering because your reply solved my problem.
    @kjordan83 thanks for asking this as I had same issue

    I could solve my problem because of you guys

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘[Ultimate Member] How do I pull the information users enter in registration’ is closed to new replies.