Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Mass User-import for vB 2.x Details »
Mass User-import for vB 2.x
Mod Version: 1.00, by Bernd Glasstett (Contributor) Bernd Glasstett is offline
Developer Last Online: Nov 2019 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 1
Released: 17 Mar 2004 Last Update: Never Downloads: 11
Not Supported Is in Beta Stage  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 19 Mar 2004, 15:21
VeoMorphine VeoMorphine is offline
 
Join Date: Nov 2002
anyway you can convert this to VB3? Vb2 allready have a whole forum importer for vb2.
Reply With Quote
  #3  
Old 19 Mar 2004, 15:43
Bernd Glasstett's Avatar
Bernd Glasstett Bernd Glasstett is offline
 
Join Date: Sep 2002
Real name: Bernd Glasstetter
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
__________________
Comicforum.de - The largest comicboard in Germany
Reply With Quote
  #4  
Old 05 Apr 2004, 15:51
glo's Avatar
glo glo is offline
 
Join Date: Aug 2002
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
Reply With Quote
  #5  
Old 05 Apr 2004, 16:50
Bernd Glasstett's Avatar
Bernd Glasstett Bernd Glasstett is offline
 
Join Date: Sep 2002
Real name: Bernd Glasstetter
You can place it whereever you want - it's just important that you enter the database-data in the top-part of the file
__________________
Comicforum.de - The largest comicboard in Germany
Reply With Quote
  #6  
Old 09 Apr 2004, 13:04
glo's Avatar
glo glo is offline
 
Join Date: Aug 2002
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

Last edited by glo; 09 Apr 2004 at 13:17.
Reply With Quote
  #7  
Old 09 Apr 2004, 17:09
glo's Avatar
glo glo is offline
 
Join Date: Aug 2002
What is the english translation for
" Import abgeschlossen. Es wurden $totalnewusers neue Benutzer in die Datenbank importiert."

Thanks
Reply With Quote
  #8  
Old 09 Apr 2004, 17:37
glo's Avatar
glo glo is offline
 
Join Date: Aug 2002
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!
Reply With Quote
  #9  
Old 10 Apr 2004, 10:57
glo's Avatar
glo glo is offline
 
Join Date: Aug 2002
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
Reply With Quote
  #10  
Old 11 Apr 2004, 17:03
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
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
Reply With Quote
  #11  
Old 09 Jul 2004, 00:10
glo's Avatar
glo glo is offline
 
Join Date: Aug 2002
Hi Bernd,

Can you please assist with my problem?

Thanks
Reply With Quote
  #12  
Old 09 Jul 2004, 11:36
Bernd Glasstett's Avatar
Bernd Glasstett Bernd Glasstett is offline
 
Join Date: Sep 2002
Real name: Bernd Glasstetter
Sorry, for not getting back on you - but 3 months ago our little son was born and since then our live has changed quite a bit

Originally Posted by glo
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(,)."?
No ; is right.

Originally Posted by glo
"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.
Your have lines of users in your table. It just means the lines in your CSV-table. Afaik it is not possible to let users change their usernames in vB - and I wouldn't recommend to use their mailadresses as usernames - just because of the addressgrabbers of the spammers out there.

Originally Posted by glo
What is the english translation for
" Import abgeschlossen. Es wurden $totalnewusers neue Benutzer in die Datenbank importiert."
"Import succeeded. There were $totalnewusers new users imported." Translated it now in the new version.

Originally Posted by 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!
I can only assume, that you didn't use semicolons ( as seperators, as the script looks for them. This is the part of the code, which makes the seperation:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

so you really need to use ; as seperators.

Originally Posted by Xenon
als 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
Thanks for moving the thread and for the help. I updated the script now to reflect this. And it should work. However I am not sure what happens, if custom userfields are added before the import.
__________________
Comicforum.de - The largest comicboard in Germany
Reply With Quote
  #13  
Old 20 Nov 2004, 15:49
Gio~Logist's Avatar
Gio~Logist Gio~Logist is offline
 
Join Date: Jun 2004
Location: San Francisco
Real name: Giovanni Martinez
does this transfer the user's posts and stuff as well? i mean, like all of the users info or w/e?


and say that you have 2 names on both sites that are the same, will it have an effect in the process?
__________________

ModernvB.com - vBulletin Mods & Services - ModernvB.com vBulletin 3 Mods - ModernvB.com vBulletin 4 Mods - Hire ModernvB
Full-Time vB Development - If you can think it, we can build it.
Reply With Quote
  #14  
Old 20 Nov 2004, 18:00
Bernd Glasstett's Avatar
Bernd Glasstett Bernd Glasstett is offline
 
Join Date: Sep 2002
Real name: Bernd Glasstetter
No, this simply adds the users!
__________________
Comicforum.de - The largest comicboard in Germany
Reply With Quote
  #15  
Old 20 Nov 2004, 18:57
Gio~Logist's Avatar
Gio~Logist Gio~Logist is offline
 
Join Date: Jun 2004
Location: San Francisco
Real name: Giovanni Martinez
would it mess it up if u have 2 users the same?
__________________

ModernvB.com - vBulletin Mods & Services - ModernvB.com vBulletin 3 Mods - ModernvB.com vBulletin 4 Mods - Hire ModernvB
Full-Time vB Development - If you can think it, we can build it.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:49.

Layout Options | Width: Wide Color: