Mass User-import for vB 2.x
 

Mass User-import for vB 2.x
This script takes a csv-file and imports the users in this csv-file into your database. This has been solely tested with vB 2.x and doesn't work with vB 3.x!

There are two files in this package:
userimport.php
userimport_mails.php

The first does an import with usernames and passwords only. All imported users will get one mail-address that you define in the config-part of the script.
The second one let's you make an import with mailaddresses defined for each user.

The csv-files are basically textfiles with a different ending. One user always gets one line in these files. The values are seperated by semicolons (;). For example:
PASSWD;USER - for the first script
PASSWD;USER;E-MAIL - for the second script

There is a config-part in the scripts, in which you need to set the values for the database:

• servername
• databasename
• databaseuser
• userpassword

Enjoy. And if you have any questions, please mail me or answer in the support-thread on vbulletin.org.

Credits go to Wolfgang Wahl aka QBorg, who originally wrote this script and gave me a kind permission to post it.

New in version 1.1: Bug fixed in order to add custom fields as well.

anyway you can convert this to VB3? Vb2 allready have a whole forum importer for vb2.

This is no forum-importer. This is just a user-importer. But I will see, if I have some spare-time to make it vB 3-compatible :)

Hello Bernd,

Thanks for releasing this mass user import!

Do i just place the "userimport_mails.php" file in the forum directory or the admin directory?

Thanks

You can place it whereever you want - it's just important that you enter the database-data in the top-part of the file :)

Hi Bernd,

In the userimport_emails.php file it says
" In the first column write the password, in the second one, write the username, the third one contains the mail-address.<br>
The columns are separated by semicolons (;)."

But shouldnt it be "The columns are separated by comma's(,)."?

And also
"Import Users from line <input type="text" name="start" size="4" maxlength="6"> to line <input type="text" name="stop" size="4" maxlength="6"><br><br>"

Are these variables that I manually change as I am using email addresses as usernames initially ?? I will allow them to change their username once they sign in for the first time.

Thanks

What is the english translation for
" Import abgeschlossen. Es wurden $totalnewusers neue Benutzer in die Datenbank importiert."

Thanks

Hi Bernd,

I have installed this, and all 4123 users have been imported and show on my total member numbers, but when i click the memberlist, it doesnt display any of the members that i just loaded?

Plus none of the uploaded members can sign in?

I look forward to your assistance!

I have since had a look at the Mysql database and can see that the usernames and email addresses were not correctly installed.

The username and email address is showing up blank!

Any suggestions?

Thanks

Hallo Bernd,

ich hab den thread mal in die Beta releases verschoben, da es doch noch einige probleme gibt wie man sieht.

fals ich dir ne kleine Hilfe geben darf: es reicht nicht neue user nur in die user tabelle einzuf?gen, sonder du musst sie auch in die userfield tabelle reinhaun, sonst gibts probleme :)