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.

[VeoMorphine]

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

[Bernd Glasstett]

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

[glo]

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

[Bernd Glasstett]

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

[glo]

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

[glo]

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

Thanks

[glo]

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!

[glo]

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

[Xenon]

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