PDA

View Full Version : Minimum Fields To Create New User Account?



StuartW
Tue 1st Feb '05, 9:22am
I am currently launching a new vB 3.0.x message forum. There are no existing threads to import but I do have 3-4 dozen user accounts that I would like to pre-populate in order to get the forum moving quickly. These user accounts will include a number of custom profile fields created via the admin cp. Unfortunately I find ImpEx to be overkill for a task of this size - the learning curve for the tool would take longer than simply keying the accounts into the system by hand.

I am very comfortable dealing with MySQL and the manual importation of records in message forum environments. I've done this for several other systems and it's the only way to fly. The bottom line is that I need to know the minimum database tables/fields that need to be populated in order to create a user account in vB ... if you want to take this off-line via PM or e-mail that's fine with me.

Please advise / thanks,

Stuart

Jerry
Wed 2nd Feb '05, 1:49pm
An email address, though username and email address makes more sense.

I would use the CSV importer, its not really over kill, just download it ftp it up, set up the impexconfig and you are ready to go.

The thing that impex does is protects you from the dependancies that you will have to set up in the database.

Belive me, I've done both and wrote the system, you don't want to directly mod the tables of the database for something this simple.

Have a look at the CSV importer you could do something like :



jerry, jerry@vbulletin.com, mypassword
StuartW, StuartW@StuartW.com, yourpassword
...
...


in a text file and impex will do the rest.

StuartW
Thu 3rd Feb '05, 10:25am
OK, I'll give it a try. But now for the big question - can ImpEx handle custom profile fields? If it can't then I might as well do it all by hand ...

Please advise / thanks,

Stuart

Jerry
Thu 3rd Feb '05, 2:06pm
It can, though not in the CSV importer.

How about importing the basic user details with the CSV importer then adding the custom fields and using the admincp to update them afterwards with the extra info.