User List Import

[rikkuotaku]

Hi,

I'd like to import users with text passwords into vBulletin along with a forum structure that's stored in an ascii text file.

With all the different scripts to import tons of different boards into vBulletin, someone must know how to import a simple text file with that info???

I have searched the board and found lots of threads about this subject, but no clear answers. Some say 'just import it'. Some say' md5() it and import it'. But none of this helps me with the specifics.

If someone would even give me sample sql code to import a user, and a sample sql code to import a category/forum/subforum structure, I could modify my text file to just have one sql command after another for each user and forum - no problem!!

I just need somewhere to start!

Thanks!!!

[selzlerb]

Hello Team,

I have been looking for a solution to this problem as well. I'm assuming that users could be created from a userlist using basic information. Group, Username, Password, and other VB defaults. Then the user could log in and flesh out the profile themselves.

It seems like there are some with ideas as to how to do this. I took a look at the WebMin MySQL controls to see if there was a method there, but it doesn't look that way.

If anyone has some thoughts or a hint as to where to start I would really appreciate it.

Thanks.

- Sez

[selzlerb]

Originally Posted by jacobi

Well, I imported to both the "user" and "userfield" tables, and it worked like a charm. In fact, I probably should have just done that in the first place because I did have the profile data for the userfield table; I was simply looking for instant gratification.

So, how did you do this? Can you post the script/method you used?

Thanks.

- Sez

[StewardManscat]

I imported my custom user table ok, but the number of members (stats) is not correct. Can anyone tell me how this gets updated, or can I just zap the number in the table (I see it buried in some gobbledegook in a settings table row of some sort...)

None of the repair/integrity functions updated the user count. Curious.

I just paid $500 CDN for this software. I have the insane 20 digit number after digging it out, but then lost the place in this system where I am suppoed to put it in. Argh.

Again: conversion of members appears to be completed normally, but no clue how to get the count updated.

Please and thank you.

[Xenon]

you should update to vb3 and then run the repair user profiles function in the maintenance section.

it's not only, that the users are not counting on the memberslist, but you also cannot edit them in the acp as long as you don't do that.

[Visibility]

I don't think selzlerb ever got a reply - is there a script or easy way to import the users? Any comments or pitfalls to avoid?

[Xenon]

<a href="https://vborg.vbsupport.ru/showpost.php?p=339566&postcount=4" target="_blank">https://vborg.vbsupport.ru/showp...66&postcount=4</a>

It always depends on how you have your users currently.
i know i did write such a script once as a custom job....

[Visibility]

I've got about 25K users, though I may use some selection criteria to whittle that down in preparing the text file. The key fields would be username and e-mail address; the users can repopulate the profile info as needed. I'm not sure I'll be able to decode the existing passwords, but I suppose returning users could utilize the password recovery feature in order to log in.