The Arcive of Official vBulletin Modifications Site.

wedgey · #1 08-02-2006, 09:35 AM

I'm starting a closed forum and I have user tables from an Excel spreadsheet that I need to insert the MySQL database for vBulliten. The user list is about 6000 members (name and password).

Can anyone point me to a resource or offer advise on how best to accomplish this task?

Thanks & Best Regards - W

Paul M · #2 08-02-2006, 09:45 AM

Not that easy I'm afraid, there are a number of tables that data has to be inserted into for every user, plus the password as such is not stored, but rather a hash built from the password and another field known as the 'salt'.

Marco van Herwaarden · #3 08-02-2006, 01:57 PM

If you also have their email address stored (without that, it would be almost impossible to import the users), then you could export the Excel sheet to a CSV-file (Comma Seperated Values), and use ImpEx to import them into your board.

You can download ImpEx from the vBulletin members area.

wedgey · #4 08-02-2006, 06:50 PM

Thanks Marco,

I do have email addresses, etc.... Just about any field that vBulletin would need...I just lack the technical skill.

I guess I should be asking if anyone could help me with this project and what the rates are for a project like this.

All the best - W

wedgey · #5 08-05-2006, 08:59 AM

Quote:

Originally Posted by Marco van Herwaarden

If you also have their email address stored (without that, it would be almost impossible to import the users), then you could export the Excel sheet to a CSV-file (Comma Seperated Values), and use ImpEx to import them into your board.

You can download ImpEx from the vBulletin members area.

I can get the list into a .csv file although I can't find in ImpEx how to import a csv????

Is there a forum name that I should be looking for? All I have are the tables in csv.

Thanks!

wedgey · #6 08-08-2006, 08:02 PM

Sorry for the thread bump, I'm still needing a little help with importing users.

In ImpEx can I import ONLY user names and email addresses?

This is a brand new forum and I'm not importing an existing board. I DO have an Excel file with all the user data, specifically email addresses and names.

Is it possible to import new users as .csv (as mentioned above) and if so which import setting would I use?

Thanks for any insight!

-W

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08065 seconds Memory Usage 2,207KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (6)post_thanks_box (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (6)post_thanks_postbit_info (6)postbit (6)postbit_onlinestatus (6)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!