vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Mass User Import (https://vborg.vbsupport.ru/showthread.php?t=43374)

nulltone 09-10-2002 01:15 AM

Mass User Import
 
The head admin of my school is going to basically give me a comma seperated database, in text format. This database will have a list of users, and their desired password.
As of now, it is planned that we will only have their name and password, but other information (if nessicary) can be placed in this file.
I have full access to this server (Linux), so I can use mysql on the command line.

1. First of all, is it possbile (through vBulletin, mysql, php, whatever) to mass add users like this? Has anyone made a script? I have done many searches and have found nothing.
2. Of all, how has it been done, or how could it be done?
3. Are there any complications?

Idealy, I would like the user preferences (no to signatures, yes to mail from admin, etc) in that file, but those can be set manually through the mysql command line at a later date.

Keep in mind, the passwords will be in plain text.

Logician 09-10-2002 08:45 AM

You can (should) write a PHP script which will read from your file and update the user table in db accordingly. Since it's only user table there wont be any complications to worry about just dont forget to update your counters after you run the script. In your script you can (should) configure any other field's default value other than username and password.

Quote:

Keep in mind, the passwords will be in plain text.
They can be plain text in your source file but you have to MD5 them while your scripting is writing them into your db..

nulltone 09-10-2002 12:45 PM

So, I guess suprisingly no one has made this type of script before?
I dont know anything about php, so....I dont know if I'd be able to pull it off..

matthew tucker 12-18-2002 02:32 AM

So ... did you pull it off in the end??

If so, can you share it?

We have an external membership database (filemaker, but could be exported to csv etc) which has personal and membership information; I'd like to mass-import all our financial users and update their records on a monthly basis so that when they become unfinancial they lose certain privileges on the vbboard. (read: incentive to rejoin)

I can do this currently via an expiry date manually entered into admincp for each user, and cunningly interrogated when a user visits the board, dropping them to a lower privilege usergroup id they are not financial. They can also see when they log in how many days left they have on their membership.

But I'd like to do it for all users in an automatic sort of way. :ermm:


All times are GMT. The time now is 12:34 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01101 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete