Bulk Load Users

[mtnemetz]

Hello All! I have a request for help. I manage an maintain an existing MSSQL DB of users for a company. This DB has a nightly DTS package that removes and adds users based on the day's termination and hires.

In order to deploy vBulletin across the company, I would like to automatically have the users registered off of this nightly package.

I there a way (even manually at this point) that I could do a bulk import of UN, PW, Title, Location and Signature?

[Antivirus]

The only way you can really do it is if you do the import using IMPEX (available in the vbulletin members area for download). Unless the import is from another forum software for which jelsoft has written an importer module, your only alternative is to use the txt file importer.

Alas, this will only allow import of users userid, username, password, and email. In order to import the other fields you desire, you'll have to either modify the importer module for text files, or do another separate import of custom fields into the userfield table, which I wouldn't suggest unless extremely familiar with vbulletin API and db structure.

Lastly, I don't think this procedue is somethign you would want to do on a nightly basis either.

[Wayne Luke]

You would most likely want to use custom code through the datamanagers to handle this actually. There is an article on how to add new users automatically over at www.vbulletin.org. It has some sample code and classes in the article and comments to it. However you would need to know PHP programming to tailor it to your needs.