Jun 19 2008
Joomla / Mambo to Wordpress 2.5 migration wizard
In working with a recent client project, I was tasked with porting a site from Joomla over to Wordpress 2.5.x. My first instinct is to look at the table structures, write the sql and be done with it but in the sake of saving time, I did a quick search to see what other people have done in this respect.
In my search, I found that Rodney Blevins (www.blevins.nl/missiontech) created a wizard to do the same thing for a Mambo to Wordpress conversion. The script works fine on older versions of Wordpress but with the release of Wordpress 2.5, the table structure changed. With some minor tweaking, I made the script work for the later releases of Wordpress and added a simple sprintf to do the table prefix renames for the Mambo/Joomla tables.
I don’t doubt that I’ll need it again and can only assume that someone else will as well so enjoy. It is not without room for improvement but it will get you own your way.
** I have tested this on a few different scenerios but you should use at your own risk (as low as it is) and backup everything in your wordpress install before doing this!
If you don’t know how to do this, have someone to help you.
The Code Already…
- joomla2wordpress-0.9.zip - 6.19.2008
- joomla2wordpress-0.9.1 - 9.22.2008 - Minor revisions and tested against Wordpress 2.6.x
- This is the first update to refect the changes in Wordpress 2.5.x & 2.6.x. I have also updated the sql to allow for a change in the Joomla / mambo table prefix to be adjusted in the config file instead of a manual find/replace.
- 3 files are included in the zip file” config.php, index.php & install.txt (instructions)
June 19th, 2008 at 12:25 pm
[...] Go to the author’s original blog: Joomla / Mambo to Wordpress 2.5 migration wizard [...]
September 16th, 2008 at 7:39 pm
Hi,
I have a joomla website which language is Turkish.I did all the settings according to the instructions.
When I get to the second step where we choose the section from the joomla website I receive chrachter errors e.g : ç,ğ,ö,ş,ı
But this did not stoped me to come to the other step (3).I choose the section where I want to put the joomla section content but it did not work !
I receive this error :
Query Fail
I really appreciate if you could help me out to solve this problem and import my data .
I better give you more specific information about the sistems volumes:
Joomla 1.5.6
Wordpress 2.6.2
Thanks,
yavuz
September 16th, 2008 at 8:06 pm
Hey Yavuz,
What are your MySQL charset & connection collations set each the joomla and wordpress tables? Do they match?
Jeremiah
September 18th, 2008 at 7:44 am
Hi Jeremiah again,
Both of them has the MySQL charset “utf8″ and connection collation set “utf8_general_ci”.However, I could’t find any lines where we have to customize the fileds due to our own charsets and connection collation.Maybe in the index.php file.I yould really appreciate if you could say me where the changes have yo be done.
Regards,
yavuz
September 18th, 2008 at 8:23 am
Hi, I found your blog on this new directory of WordPress Blogs at blackhatbootcamp.com/listofwordpressblogs. I dont know how your blog came up, must have been a typo, i duno. Anyways, I just clicked it and here I am. Your blog looks good. Have a nice day. James.
September 22nd, 2008 at 5:31 am
Hey Yavuz,
To be honest, I have never dealt with that particular issue but I’ll be more than happy to help you. Just send me an email ( jeremiahhester[at]googlemail.com ) and we will see what we can do.
Thanks & sorry you are having trouble,
Jeremiah
September 22nd, 2008 at 10:47 am
Jeremiah,
Solved or not,I really appreciate your help anyway.
I noticed your e-mail I’ll be in touch.
Thanks a lot,
yavuz
September 24th, 2008 at 11:40 am
[...] some minor adjustments to the Joomla -> Wordpress Conversion tool and tested against Wordpress [...]
September 24th, 2008 at 11:46 am
Hey Yavuz,
I was able to pull the data over without data loss or character conversion errors by simply setting both the MySQL charset to “utf8″ and connection collation set “utf8_bin”.
Give that a shot and see if it fixes your issue.
I have also update the script but it was just minor adjustments and testing against the latest version of wordpress.
Thanks and let me know how it goes!
Jeremiah
October 28th, 2008 at 11:57 am
I just used the tool but was disappointed that it doesn’t appear to translate categories correctly even when I had previously created categories to match in Wordpress. Also it doesn’t appear that it brings over user accounts at all.
Still, the content pretty much came over (no links would transfer over though!), so it’s still saved some work though I do still need to do a bunch of cleanup.