Question phpbb3 to Kunena

I can, I suppose, but since I'm trying to keep 1 common look and feel to the site, its hard with phpbb.

Yes, I have been using the jFusion bridge.....

I believe that your users do not care about the looks -- they just want to have the forum online.

Perhaps

I on the other hand is migrating my whole site from my custom thing and phpbb3 to Joomla. I can't open the new site until I get a good migrator because users will register into Joomla and JomSocial and then they have two accounts when I finally get my hands on a migrator.

I have over 1100 users waiting for this so I need this pretty bad
Crossing my fingers that everything runs smoothly for you Matias!

Really appreciate your work! Good luck!

Linuus,

You can still try on a fresh install the step by step method with the solution I proposed in case of bad user sync. I would also love to have a stable component handling it all though my wish to use Kunena quickly was higher.

All,

In order to migrate from PHPBB3 to Kunena there are 2 solutions :

1- Be patient.
Matias shall, sooner or later, releases his component.

2- Get your hands in mud and DIY !
As I succeeded in with this method, I'm willing to provide it to whomever is impatient as I am. Moreover it would also help me reproducing it, as it is currently performed on an old DB version of mine.

In order to do so, you would need :

• Access to your DataBase (like PHPMyAdmin),
• Access to your FTP (like FireFtp),
• A bit of PHP Knowledge,
• A common sense of logic.

DIY : Here is the (complete) step by step method to migrate from PHPBB3 to Kunena 1.5.5

My case was on J! 1.5.14 with CB 1.2.1, UddeIM 1.8 and PHPBB 3.0.4 just for interactions purpose. Here we go.

A- like eAsy !
I first used the step by step method that you may find here .

Problem here: users are not synced with Joomla! ie. PHPBB3 user Smith's ID is unlikely the same as his J! ID, even if you used some bridge or Jfusion sync. Here comes the real DIY.


B- like Bring J! IDs
Point now is to modify your database, saying that for each forum post with Smith's PHPBB ID, it has to be replaced by Smith's J! ID. (Easy )

I exported the PHPBB3_users and jos_users tables from PHPMyAdmin to excel .csv file. I then mapped their IDs, meaning that I looked at Smith's PHPBB3 ID and his J! ID, put them aside in 2 columns (phpbb3_former_id and jos_final_id). I also removed all PHPBB bots... useless to have them in J!.

Tip: Thousands of users ? Try excel VLOOKUP function matching their usernames!

Once done, save your sheet with the 2 columns only in a .csv file.
Back to PHPMyAdmin, I created a new table, say test_mig_users_id, with 2 fields (phpbb3_former_id and jos_final_id) of INT (numbers). Then I imported the .csv file with the values we want to fill in the table.

We have now PHPBB IDs matching J! IDs in your database. Remains to tell PHPMyAdmin to update Kunena's posts with, by launching 2 SQL queries :

/* Update jos_fb_users table with new ids */ /* Update jos_fb_messages table with new ids */
Your users IDs are synced now ! If Smith log in J! he'll be able to post under his username. However he may be sad to see that its posts count doesn't match its real amount. But it can be corrected :


C- like Count posts !
First update your Kunena 1.0.8 (or previous) to 1.5.5, it is pretty simple : go to J! back-end > Extensions > Install/UnInstall and in the URL field, fill up the .zip package file URL you can find on Kunena's download page.

Note: As stated somewhere in this forum, you DO NOT need to uninstall Kunena 1.0.x before installing 1.5.x !

Once done, you are in the situation where you can edit Kunena's files to tell it recounting users' posts amount. Easy here again, everything's explained here ! Once done, in Kunena's back-end, click on 'Recount Categories' stats', it'll do the trick.


D- like Done !
Here you are with J! 1.5.4 and Kunena 1.5.5. Just get rid of PHPBB !!


If you don't understand (all of part of) the second method of migration, please refer to the first one involving patience on top of this post. ^^