Idea phpBB 3 to Kunena 3 Migration Script

We have migrated our forum from phpBB to Kunena and would like to share the migration script with the Joomla community:


mixerp.org/erp/14-open-source-projects/1...igration-script.html

Edit : March 7, 2015

This topic has become too big to read. I am now offering assistance in my own forum instead of here:

mixerp.org/forum

Happy migration folks.

I tested the script and finally it worked for me,
so: Thanks for sharing it with us

I ran into some major issues with your script:
(describing it here for others to be warned)
(tested with phpBB 3.0.11 ==> Kunena 3.0.6)

1.)
category names with "/" or german umlauts in it,
will be converted to invalid* category-aliases in joomla/kunena
*(not working with SEF/SEO and so on ...)

2.)
in phpBB you can have category and its subcategory with the same name.
The script then tries to generate the same category-alias in joomla/kunena twice and stops with errors.

3.)
If you have guest-posts in phpBB, then it would be better to convert the user-ID into a '0' within all the kunena-tables that contains the 'user-id'.
(it is not needed to import the "guest" (user-id=0) into the joomla usertable nor into the kunena-usertable at all ...)

4.)
all the attachments-filenames* of phpBB (without extension) are converted into filenames with a *.jpg -extension,
no matter if they are of another mime-type (e.g. *.png) ..
*(regarding the table "kunena_attachments" / column "filenames")


5.)
several bbcodes are not converted properly.
for example: should be converted into
6.)
phpBB sometimes uses some kind of "hashes" behind the bbcodes,
I don't know why and what it is, but when you look into the database of the phpbb you can see for example: and so on ...
The script doesn't handle this issue correctly.

Hello Dirk,

Thank you for trying this out. This script worked in our case but not for you properly because we had a limited scope to test onto. Moreover, I am glad that this could of some assistance to you.

1. Right.
2. Right, but can be fixed easily.
3. Right since we did not have guest posts enabled in our phpBB forum.
4. Right because phpBB does not say which extension an attachment has.
5. Right, can be fixed.
6. Right and wrong.

If you inspect the script properly, you will find something like this:

As of now, for this to work, you have to manually:

• Add any new tags you find
• Re-run the query several times
• Test and re-run

This script worked superfine on our "limited scenario", but there certainly are some issues. Still, I think there are more opportunities than the issues.

I would therefore request the community to improve quality the script by contributing to it.

Cheers!

Hello from me this error:

Your MySQL user does not have sufficient privilege to perform deletes. Sorry, I cannot help.

...

I will be more than happy to merge pull requests if someone comes with some revisions and improvements. That's the reason why this script is open source on the first place.

I believe the migration script would do pretty well, had it had more test cases and enhancements. Need more contributors on this.

Get an issue with this:



Any idea ?

Are you using Kunena 3?

Since this script was used to migrate phpBB 3 forum to Kunena 3 (Joomla! 3.x), I'm afraid your environment could be different.

Meanwhile, you could remove the column "requireReset" from the insert list and check to see if there are any further errors.

I'm on a PhPBB3, and want to migrate to K3.06.

To be sure:
phpbb_database_name = the database name from my "old" PhPBB board.
joomla_database_name = my new joomla database name
jos_ = the prefixe in my news joomla database name


Btw, i try with leaving "RequireReset"