vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Assistance with a download of users (https://vborg.vbsupport.ru/showthread.php?t=320254)

hcma1 09-14-2015 11:29 AM

Assistance with a download of users
 
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 09-14-2015 03:14 PM

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 09-14-2015 07:17 PM

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 09-15-2015 04:47 PM

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

Code:

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 09-16-2015 03:09 PM

1 Attachment(s)
The field headings are in the admincp:

Attachment 153357


All times are GMT. The time now is 08:08 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00946 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete