Assistance with a download of users

[hcma1]

Hello all,
I run a non-profit that assists those with a rare heart disease. I am moving my website - and migrating to the new Cloud version of VB. I need to import the names, screen names, emails and location to my new website but I can not figure out how to get this data to export from VB. I had some tech assistance but he has taken a new job and has little time to help.
Is there anyone willing to help me out with how to do this.... I admit i have NO idea how to access the back end of the site so if you can help... step by step directions would be very helpful!
Thanks!
Lisa

[Lynne]

You want to download that information from your current vbulletin database? What version of the software are you running? The username and email are just in the user table, but if you have a 'real' name and a location, then they are in the userfield table and you would need to go to admincp > User Profile Fields and look at the "name" column and let us know the names of the fields you need there.

[hcma1]

I am on version 4.2.2 patch level 4 - I can get the email list but not the complete dataset I need.

How do i access the field headings you mentioned?
Lisa

[Lynne]

If you go to admincp > User Profile Fields and look at the "name" column, then you can find that same column in the usertextfield table and it gives the filled in information for each user.

See this post about getting the information - https://vborg.vbsupport.ru/showpost....96&postcount=5

SELECT username, email, fieldX, fieldY 
FROM user LEFT JOIN userfield ON(user.userid=userfield.userid)

You would change fieldX to the field number for the Real Name and fieldY to the field for the location, etc.

[Lynne]

The field headings are in the admincp:

Attachment 153357