Exporting Faculty/Staff Users to Gordon Forums

 Problem Description : 

Directions to export new faculty/staff accounts for creating new accounts in Gordon Forums (phpbb)

 Resolution : 

*******NOTE: THIS DOSENT APPLY ANY LONGER. UPGRADED VERSION AND NOW USING LDAP AUTHENTICATION ***************************

In SQLNavigator:

- Run script phpbb_export in CSD SQLs folder

- Save results in a comma delimted file to \\buzzard\d\inetpub\wwwroot\phpbb\admin\import\members.tmp

Open DOS prompt, 

- map drive (I usually use R:) to \\buzzard\d

- CD to inetpub\wwwroot\phpbb\admin\import

- del the existing members.csv file

- To create a new members.csv file with just new accounts, run the DOS command: for /f "tokens=1-3 delims=," %i in (members.tmp) do @make_members %i %j %k>>members.csv

In IE, login to the forum as admin and:

- At bottom of page, click on "Go to Administration Panel"

- Renter password when prompted

- On left pane, click on Members under the Import Tools heading

- Select "plain text" passwords.

- Leave Import Rate at 250

- Click Start Import

The new users should be imported. PHPBB doesn't give a count or anything, just a message saying its done.

 Revision Date : 4/19/2011

 Keywords : password, update, phpbb, export