I am only having one problem that i can't figure out. The user part of this import is only importing two users. It gives me all ok's and complete but only two users are imported. Does anyone have any ideas as to how to fix this?

Hello, I have a very small phpbb forum under 50 users and not very many topics posted. Be happy to pay someone that knows what they're doing to convert it to fireboard for me.

I have questions too. How does it convert the users to fireboard? I thought that since fireboard is integrated with joomla, that it uses your joomla login and password as your forum username and password. Or am I completely lost?

No, I'm waiting a new way or fix to import all phpBB users (I could do myself but I have examns now), I have the same problem and think it's relationated with the import of phpBB users table (have imported one user only in my fb table).


freakshowtm wrote:
[quote]jaleo wrote:
[quote]Other errors:

[code:1]Warning: Division by zero in /home/caminoes/public_html/motclub/components/com_fireboard/sources/fb_statsbar.php on line 884[/code:1]

[img size=184]http://www.bestofjoomla.com/components/com_fireboard/uploaded/images/error1.GIF[/img][/quote]

i have the same problem..

i notice that if you have no post yet, this error message pops up..

i'm using a clean install of fb 1.0.1 build 1..

Post edited by: freakshowtm, at: 2007/05/16 04:47[/quote]

Thanks for that script, Asli. I have moved my phpBB tables into my Joomla DB and am ready to run the script, but three questions first:

1.
Some of the user fields in phpBB (such as interests, website, location, etc.) do not have counterparts yet in Community Builder. Will this info be lost when the script is run? Should I add CB fields first? Or does the script add them?

2.
I have not yet installed a PM system on Joomla, but some users of phpBB have sent private messages to each other. Will the PM's be lost? Should I install a PM in Joomla before running the script? Does it matter which one?

3.
Some of the phpBB users who were also registered in Joomla have different IDs in the two programs, but same email address in the two programs. I think that, ordinarily, Joomla won't allow two users to register with the same e-mail. Will the script fail to import that phpBB user because of this? Will the script map them so that their posts are correctly ascribed to them? (Should I manually hunt for such users first, and change their e-mails with phpMyAdmin, so that one person ends up with two IDs in Joomla, one of which has the correct e-mail and Joomla article authorship, and the other has all the forum posts? Not good.)

I'm a bit scared to run this without thinking about this stuff first.

Thanks for your attention.

Post edited by: JLW, at: 2007/05/21 14:48

Post edited by: JLW, at: 2007/05/21 14:53

sublevel4 wrote:
I am only having one problem that i can't figure out. The user part of this import is only importing two users. It gives me all ok's and complete but only two users are imported. Does anyone have any ideas as to how to fix this?
It might have been caused by any or some of your users using weird names with apostrophes and such. If that's the case, make sure to use my script earlier in the thread (it should solve that problem...)

Post edited by: michiel, at: 2007/05/21 16:46

JLW wrote:
Thanks for that script, Asli. I have moved my phpBB tables into my Joomla DB and am ready to run the script, but three questions first:

1.
Some of the user fields in phpBB (such as interests, website, location, etc.) do not have counterparts yet in Community Builder. Will this info be lost when the script is run? Should I add CB fields first? Or does the script add them?

2.
I have not yet installed a PM system on Joomla, but some users of phpBB have sent private messages to each other. Will the PM's be lost? Should I install a PM in Joomla before running the script? Does it matter which one?

3.
Some of the phpBB users who were also registered in Joomla have different IDs in the two programs, but same email address in the two programs. I think that, ordinarily, Joomla won't allow two users to register with the same e-mail. Will the script fail to import that phpBB user because of this? Will the script map them so that their posts are correctly ascribed to them? (Should I manually hunt for such users first, and change their e-mails with phpMyAdmin, so that one person ends up with two IDs in Joomla, one of which has the correct e-mail and Joomla article authorship, and the other has all the forum posts? Not good.)

I'm a bit scared to run this without thinking about this stuff first.

Thanks for your attention.



1. The information won't be lost, it remains in the phpbb database. The script isn't build to transfer these information so you would have to edit the script manually to make that happen. You should create the appropriate fields in CB before importing and add a (couple of) query(ies) to the script to transfer the information.

2. Same as above. Most Joomla PM-systems are build upon eachother or use at least similar database tables. It shouldn't be too hard to modify the script to transfer the PM's from phpbb to the correct tables in the Joomla PM system.

3. iirc the script maps the users with similar usernames and converges the data of joomla and phpbb (i.e. the joomla user will be conencted to the phpbb posts...) It checks only the username, so make sure they are the same.

4. Backup both db's so you can quickly revert in case of a failure or incomplete transfer (this helped me save loads of time)

Thanks, Michiel.

I just thought of one more possible improvement to the script:

If a CB user has no image yet, but his/her phpBB identity has an avatar, then perhaps the script could install that phpBB avatar as that user's CB image! Ah well, I am dreaming....

I just had another nightmare:

Some very common names (like 'David' and 'Alex' are taken by users in phpBB but are also taken already by other users in Joomla. Will this script not import the phpBB user's data and yet give that user's posts to the wrong user in Joomla?

Oy! I think I have some data-table housecleaning to do before running this.

Post edited by: JLW, at: 2007/05/21 17:22

michiel wrote:

...The script isn't build to transfer these information so you would have to edit the script manually to make that happen. You should create the appropriate fields in CB before importing and add a (couple of) query(ies) to the script to transfer the information...


OK, I have found the several users with identical e-mails in phpbb and Joomla but with different userIDs in each, and have changed their userID's in the `phpbb_users` table to match their Joomla userIDs. This is particularly important, because the reason they had unmatched IDs was that their first-choice userID (their phpbb ID) was already taken when they registered in Joomla, so the migration script would have given their posts to the wrong Joomla user.

And I found several phpBB users who were not in Joomla at all, but with such common names that someone else already has those IDs in Joomla. So I have unilaterally changed the phpBB user's ID, and I will have to communicate with those users about this after the migration.

Also, I now have `cb_wherefrom` , `cb_interests`, `cb_occupation`, and `cb_website` fields in CB's `content_profiler` table.

They are intended to capture the `user_from`, `user_interests`, `user_occ`, and `user_website` fields of the `phpbb_users` table.

Can someone tell me what the SQL statement(s) are to pass the data across them, and also where in the migration script to stick them? Thanks.

Also, I installed iddeIM for a PMS in Joomla, and it is beautiful!!! Looks and works great! Works in both JoomlaBoard and FireBoard, and integrates in the CB login module to report incoming messages; but I haven't found a way to plug it into the CB profiles to send a PM from theere. Anybody know where-to-find/how-to-do? Thanks.

Would also love the SQL to migrate the phpBB PM's to the iddeIM tables. There are about 100 Private Messages in the phpbb table. But to get this migration completed soon, I'm willing to lose the phpBB PM's if necessary.

Post edited by: JLW, at: 2007/05/21 18:06

Post edited by: JLW, at: 2007/05/21 18:10

Post edited by: JLW, at: 2007/05/21 18:13

JLW wrote:

OK, I have found the several users with identical e-mails in phpbb and Joomla but with different userIDs in each, and have changed their userID's in the `phpbb_users` table to match their Joomla userIDs. This is particularly important, because the reason they had unmatched IDs was that their first-choice userID (their phpbb ID) was already taken when they registered in Joomla, so the migration script would have given their posts to the wrong Joomla user.

And I found several phpBB users who were not in Joomla at all, but with such common names that someone else already has those IDs in Joomla. So I have unilaterally changed the phpBB user's ID, and I will have to communicate with those users about this after the migration.

Also, I now have `cb_wherefrom` , `cb_interests`, `cb_occupation`, and `cb_website` fields in CB's `content_profiler` table.

They are intended to capture the `user_from`, `user_interests`, `user_occ`, and `user_website` fields of the `phpbb_users` table.

Hi JWL,

I've modded the script to mke it custom-built for your needs. The added section is just under the user-queries. You should double-check if I didn't make any mistakes.. I can't test the script so I hope it works. Anyway, this should do the job...

Post edited by: michiel, at: 2007/05/21 21:12