Jun 19 2008

Joomla / Mambo to Wordpress 2.5 migration wizard

Category: code, projectsJeremiah @ 12:00 pm

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)

Tags: , , , , ,

10 Responses to “Joomla / Mambo to Wordpress 2.5 migration wizard”

  1. Joomla / Mambo to Wordpress 2.5 migration wizard says:

    [...] Go to the author’s original blog: Joomla / Mambo to Wordpress 2.5 migration wizard [...]

  2. laztrix says:

    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

  3. Jeremiah says:

    Hey Yavuz,

    What are your MySQL charset & connection collations set each the joomla and wordpress tables? Do they match?

    Jeremiah

  4. Yavuz says:

    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

  5. James says:

    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.

  6. Jeremiah says:

    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

  7. Yavuz says:

    Jeremiah,
    Solved or not,I really appreciate your help anyway.
    I noticed your e-mail I’ll be in touch.
    Thanks a lot,
    yavuz

  8. Minor Updates to the Joomla -> Wordpress Conversion tool | Jeremiah Hester says:

    [...] some minor adjustments to the Joomla -> Wordpress Conversion tool and tested against Wordpress [...]

  9. Jeremiah says:

    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

  10. Jason says:

    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.

Leave a Reply