Uploading user data in bulk?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
TimChuma
Registered User
Posts: 2
Joined: Tue Jul 17, 2007 1:08 am

Uploading user data in bulk?

Post by TimChuma » Tue Jul 17, 2007 5:51 am

Hello,
I am working on a website with over 9,000 registered members and wanted to know if it was possible to upload user data via an excel spreadsheet to the phpBB database. Do I need a forum mod for this or I can I do it through the control panel.

I have a test file of 100 or so users and read in another forum that the password has to be md5 hashed also.

Thanks.

hc2995
Registered User
Posts: 229
Joined: Tue Jun 20, 2006 1:25 am
Contact:

Re: Uploading user data in bulk?

Post by hc2995 » Tue Jul 17, 2007 6:21 am

What kinda of information are you trying to upload? Dont think a spread sheet will help you much, since PHPbb uses MySQL. Im not the best MySQL person but i do know somethings, you make be able to make a PHP file to convert spreadsheets to MySQL files.

Inspector-Tyrant
Registered User
Posts: 66
Joined: Mon Jul 02, 2007 4:33 am

Re: Uploading user data in bulk?

Post by Inspector-Tyrant » Tue Jul 17, 2007 2:24 pm

You can have some fun with a program called Excel To MySQL.
Takes a little effort and you've got the users in your prefix_users table!

Then just run the fix.php script and your all set... ;)
---
Inspector Tyrant

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50895
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Uploading user data in bulk?

Post by stevemaury » Tue Jul 17, 2007 3:19 pm

Inspector-Tyrant wrote:You can have some fun with a program called Excel To MySQL.
Takes a little effort and you've got the users in your prefix_users table!

Then just run the fix.php script and your all set... ;)
You have a link to that?

OP, take a look at http://www.phpbb.com/community/viewtopi ... 5&t=285945
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Inspector-Tyrant
Registered User
Posts: 66
Joined: Mon Jul 02, 2007 4:33 am

Re: Uploading user data in bulk?

Post by Inspector-Tyrant » Tue Jul 17, 2007 3:33 pm

---
Inspector Tyrant

Locked

Return to “2.0.x Support Forum”