vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Mass populate profile fields? (https://vborg.vbsupport.ru/showthread.php?t=296069)

momma_oz 03-13-2013 02:27 PM

Mass populate profile fields?
 
I may be stretching here, but is there a way or a mod that will allow you to import a spreadsheet or CSV or something to update the profile fields of the forum?

We switched from SMF to Vbulletin and while we are VERY pleased, we also managed to lose a bit of data in custom profile fields.

We have this info saved to a spreadsheet so I'm wondering how you would go about this (short of manually updating each and every profile as we have almost 700 members and ain't nobody got that kinda time)

any brilliance you'd care to share? Heck, brilliance not even required here...:o

kh99 03-13-2013 03:41 PM

I think I would create a new table in the database and inport the spreadsheet data to it (unfortunately, I can't give you details on that, it's the kind of thing I have to figure out every time I need to do it, which isn't often). When that's done, I think you can use an SQL query to move the data to the user table. Of course there has to be some field that matches between the two tables - I'd assume there's a username, which hopefully stayed exactly the same after the move.


All times are GMT. The time now is 07:43 AM.

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.01488 seconds
  • Memory Usage 1,703KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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