Log in

View Full Version : Loading User Data


MikeM79
10-20-2005, 01:31 PM
Newbie here.

I am trying to figure out how to migrate from my obsolete message board (UBB Classic 5.47e) to VBulletin 3.50.

I have over 16,000 member records to move to VB. I can create an Excel file that is 16,000 rows (records) by about 15 columns (various fields....username, password, etc.). I then thought I could upload / convert the Excel file to MySQL to populate the user file in VB.

Anyway, I went to mysqladmin and tried to insert a new user record manually. It appears to work until I try to log in as that user in VB. Each time I get a "bad password" error. If I go through the "I forgot my password" jive then I can get in. However, when I inspect the user record through the VB Admin CP it is missing all of the data (yet it shows up on the list of users). Weird.

So, (and thanks for hanging in there)..........which fields in which files need to be populated in order for VB to work with them smoothly? My best guess is that I am not populating enough data and / or failing to "hit" certain files in order to create a fully functional user.

Many thanks.

Andreas
10-20-2005, 01:37 PM
ImpEx, the vBulletin Importer supports importing from UBB.
Yo might want to contact Jerry if you got problems importing.

The value of field password in vBulletin table user is md5(md5('plaintextpassword'), salt).