Inserting new users in to DB, can it be done??

Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Locked
rusty105
Registered User
Posts: 18
Joined: Mon Aug 29, 2005 3:16 pm

Inserting new users in to DB, can it be done??

Post by rusty105 »

OK, here is an odd question, and I think I might be able to work thru this one, but want to check if there is a MOD already in place for this.

I have a list of users that I want to import into my existing DB. The purpose of this is that I have a few years worth of mailing list output that I want to import into the forum. I can/will set up a spreadsheet of the 'username' 'registration date' which will be the first day I have an e-mail from them. They all will be members of 1 group 'Archive group' so I can control the permissions. From there I need to know what other fields NEED info for the database not to self destruct. I want to be able to set the e-mail, and passwords to all be the same. (if this is a big security no-no let me know) The second part will be to import the e-mail messages, which I will work on later. SO.....

What are the bare minimum fields needed, and can I just do a SQL inq to insert the users into the table 'phpbb_users' ?

Thanks
Rusty

rusty105
Registered User
Posts: 18
Joined: Mon Aug 29, 2005 3:16 pm

Re: Inserting new users in to DB, can it be done??

Post by rusty105 »

Anyone?

Should I post this on the main site noew that it is back up :)

Rusty

Locked