Re: [Phpwebsite-developers] bulk adding of users

[Verdon V. <ve...@ve...>]

I've had to do this a few times... it's not so bad. Following is an=20
over-simplified explanation of my approach.

Password encryption is md5. What I would do is put together a simple=20
spreadsheet for the user records you will need, with the passwords in=20
clear text. Then export your spreadsheet to a .csv file. Using=20
something like phpMyAdmin, import this csv file into your users table=20
(don't forget to change the value in users_seq to something bigger than=20=

the id of your last user record when done). Then run a sql query to md5=20=

the new user's passwords.

best luck,
verdon

On 22-May-05, at 5:16 AM, Matt wrote:

> Hello,
>
> I need to be able to add users in bulk to phpWebsite, I've looked at
> doing by using a SQL script to insert records into the users table -
> this works fine apart from the passwords - each user has to go through
> the 'forgot password' process to login. How are the passwords
> encrypted to be stored in the db?
>
> Any help much appreciated!
>
> Matt
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_idt12&alloc_id=16344&op=3Dclick
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>