Populate vBulletin user database with existing user data?

[mollila]

We have a database of a few thousand old customers (name, email), and would need to create an account to vBulletin for them on their behalf.

Is it somehow possible to populate vBulletin user database by using their email address and a generated username (for example first part of email address) and generated password?

Would this have to be custom coded, or is there already a feature or modification that allows this? By searching I did not find any info.

If possible, when the user logs in the first time to vBulletin he/she would be asked to agree to our terms of use and change the generated passwords. Could this be easily implemented?

[Zachariah]

Just shooting ideas here.

I bet something could be made that will import the list of user names, e-mail.
- On creation random password.

Set them up in a usergroup that will need them to change their password on next login.

Once this is done a Cron job could be made to send out a mass emails "Remind user of their password"

I have not looked, but there may be something like that.

What program, or format is your user base in ?

[nevetS]

Using the vBulletin data manager, it's pretty easy to add users via a script. Search around in the forums and I'm sure you'll find the eight lines of code necessary. Throw in some php to parse a CSV and call the add_user function for each line and you are home free.

I expect that if you can't do it yourself, you can find someone to put it together for less than $100.

[mollila]

Originally Posted by Zachariah

What program, or format is your user base in ?

They are in Excel.

Originally Posted by Zachariah

Set them up in a usergroup that will need them to change their password on next login.

How could we set a usergroup to change their password on the next login? Is this possible from vBulletin admin interface?

[Marco van Herwaarden]

You can export the Excel as CSV (Comma Seperated Values) file, and use ImpEx to import the users.