Joomla2Wordpress Import Wizard v.3

Posted on January 16th, 2008 by Azeem

Tags:, , , ,

I recently switched from Joomla over to Wordpress. One major step which was preventing me from making the move for so long was the export process. Then I found a post on rangit.com which had a script which would allow you to move the content over. But there was a problem. Wordpress had changed its database schema in its latest version (2.3.2) thus breaking the script (linked above). So I decided to take this on as a side project and fix it. I also made some changes which will make it even easier to use this script; such as allowing the user to set table prefixes in the config file.

This version of the script has been tested on Joomla 1.0.12 and Wordpress 2.3.2 and works pretty smoothly.

Step by Step Instruction (with Screenshots):

1. Unzip Joomla2WordPress.zip
2. Edit config.php and enter all missing values
Screen01
3. Upload files to /export on your server
Screen02
4. Add Categories in wordpress which you want to import into
5. Open www.yoursite.com/export/index.php on a browser
Screen03
6. Select either a Joomla Section, Category or Links Category
Screen04
7. Select a Wordpress Category to import into
Screen05
8. Repeat Steps 5-7 till all of your articles have been imported
Screen06
9. Enjoy and Spread the word!

Download: Joomla2WordPress Import Wizard

Notes:-minor glitch: If you create a WP category which is empty (has no posts), the articles will import just fine, but the category may not appear in the categories widget until you open at least one post in that category in /wp-admin and just hit save. If anyone knows how to fix this minor bug

Credits
v1: Mambo2Wordpress Import Wizard by Mission:Tech, technology blog.
v2:Joomla To Wordpress by Chris Chee of Rangit.com
v3: Joomla2WordPress Import Wizard by Azeem Khan of Azeemkhan.info

Filed under: Technology


Related Posts:
  • Joomla Study Shows Its level of adoption
  • Joomla Vs. Drupal
  • zemanta makes blogging a breeze!
  • How to get off of Akismet Blacklist
  • Is this the Future?
    • « Navreet Official FOB Status Dave Chappelle says Eid Mubarak in not so Halal Stand Up »

    29 Responses to “Joomla2Wordpress Import Wizard v.3”

    1. H. Ahmed, on January 16th, 2008 at 5:34 pm Said:

      welcome to wordpress!

    2. Mad About Anything » Blog Archive » Bye Joomla, Hi Wordpress, on January 23rd, 2008 at 6:01 am Said:

      […] http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/  […]

    3. Deependra Solanky, on January 23rd, 2008 at 8:28 am Said:

      Hi Azeem,
      Thanks a lot for your nice work. I have successfully migrated my website http://www.madaboutanything.com/blog/ from Joomla to Wordpress today with your tool.
      Thanks once again.

    4. Laurent, on January 24th, 2008 at 12:52 pm Said:

      Thank you so much for this. I’ve just tested it and it works fine, I cant thank you enough as you just saved me an incredible amount of work!!
      The bug with the category is really minimal. I had a similar bug from the one you describe.
      I imported one set of posts from Joomla into a virgin category using the script. The category showed 0 posts. I then created a post and the category showed the right amount. I then deleted some posts from the category via mysql and in WP the number didnt update. It only did once i created another new post in the category.

      Thanks again!

    5. Jon, on January 27th, 2008 at 9:00 pm Said:

      Will this delete the joomla database completely? Or will it simply just copy the files and leave the original joomla db intact? Thanks!

    6. Azeem, on January 27th, 2008 at 11:37 pm Said:

      It does not delete the joomla db it simply copies the files from the db. If you like you can manually delete the db once the files have been copied. Always remember to back up the db before messing with it.

      To do a backup, I suggest using phpmyadmin (click on the db name) click on export, check the box to save as a file, check off gzip compression hit ok and save on your hd.

    7. Lori, on January 28th, 2008 at 11:46 am Said:

      Is there a way to transfer the comments with each posts as well? I would really REALLY appreciate it if you could let me know a solution…. thanks!

    8. Azeem, on January 28th, 2008 at 2:41 pm Said:

      Joomla does not have a bult-in commenting system. What Third party plugin were you using for comments?

      I was using JoomlaBoard which I am currently working on another script to transfer my own comments.

    9. De Fries, on January 31st, 2008 at 6:48 am Said:

      Any ideas how this could be made to import from joomla 1.5?

      And does this script also import pages/childpages and such?

    10. Azeem, on January 31st, 2008 at 8:02 am Said:

      I have not checked out the database schema for Joomla 1.5 yet. Even if it is a little different it will not be hard to make changes in the script to make it work. It would just affect 1 query, well maybe 2 at most.

    11. De Fries, on January 31st, 2008 at 9:27 am Said:

      Well, if you have the time to look at it I could really use it :)

    12. Azeem, on January 31st, 2008 at 9:39 am Said:

      Okay, I will check it out. I added a feature to subscribe to comments. You might want to do that. I will try to get it soon. Once I do, I’ll just comment here.

    13. Azeem, on February 1st, 2008 at 7:11 pm Said:

      De fries:

      Ok try out this extension:

      it should allow you to move your content from 1.5 installation back to 1.0.13 (just do a clean install of 1.0.13 in a different folder with a different db)

      and then you can use my script. This might be the quickest way to make this work. (I did start looking at the 1.5 db schema, but didn’t have enough time to do any coding)

    14. De Fries, on February 6th, 2008 at 3:53 am Said:

      Sounds like a good work around. I will definitely give it a go. Thanks for looking into it!

    15. Como migrar de Joomla a Wordpress | Ayuda Wordpress, on February 6th, 2008 at 6:42 pm Said:

      […] uso del Script Joomla2Wordpress te facilitará enormemente el cambio siguiendo los siguientes […]

    16. Azeem, on February 7th, 2008 at 10:44 am Said:

      De Fries:

      let us know if it works out for you

    17. De Fries, on February 8th, 2008 at 2:12 pm Said:

      I will.. for now I have installed the suggested joomla component and am getting a lot of errors. Will keep you posted.. :)

    18. Eddie, on February 17th, 2008 at 11:20 am Said:

      hey, im at the step where i have wordpress installed on same db and host as joomla. and i have to silly questions.

      1. do i need to create a seperate database?

      2. does this only copy the posts i.e not the whole web site (design)

      i only have 3 posts so far so it wouldnt be a big deal to re create them i really just need to get my site running off wordpress.

      am i barking up the wrong tree? ok thats a third stupid question.

    19. Azeem, on February 18th, 2008 at 10:02 am Said:

      Eddie:

      What you need to use this script is:
      1. An existing joomla installation
      2. A wordpress installation

      in the config file you enter the db connections for each db and also specify the table prefixes

      I have not tested this script with bot installs on the same database, I imagine that would work, but if they are on separate dbs that would be better.

      No this script will not move your template over, this is only to move your actual content.

    20. Panic1 » Blog Archive » New blog site, on March 14th, 2008 at 3:33 am Said:

      […] work with the 2.3 version of Wordpress, so that explains the delay.  This new package can be found here (I have also attached the script, README file is […]

    21. DeFries, on March 14th, 2008 at 4:37 am Said:

      I tried but I could not get it to work properly with Joomla 1.5. So I ended up copying the posts one by one :S

      Anyway.. thanks for the help

    22. Tarod, on April 9th, 2008 at 12:03 pm Said:

      Thanks for the tool. This worked perfectly. One more question though: Do you know of a tool that can convert joomla templates to Wordpress easily? I haven’t found one and didn’t want to get back into the CSS.

      Thanks

    23. Azeem, on May 1st, 2008 at 2:47 pm Said:

      @Tarod

      I haven’t come across any template converters yet. I am actually thinking of making an app in .NET or Adobe AIR which does just that. Seems like a time consuming project though which would require hours of effort. The biggest hurdles will be completely understanding the respective template structures, and ongoing dilemma will be dealing with changes made in those templating schemes (keeping it up to date).

    24. Jason Frovich, on May 1st, 2008 at 3:37 pm Said:

      Thanks this worked AMAZING…
      Now all i need a a plug in for Categories that handle 2 or more levels deep.
      I have 1000 pages to move over but i need a deep categories structure..
      Ill keep looking or have to stick to joomla..

    25. Matt, on May 1st, 2008 at 4:03 pm Said:

      Worked great the first time. Installed WP 2.3.2, ran the tool, then upgraded to WP 2.5.1. Flawless for me. Thanks!

    26. rizky, on May 1st, 2008 at 6:47 pm Said:

      When I proceed to step 2, I get “Query Failed”. How can I solve that?

    27. Azeem, on May 2nd, 2008 at 2:55 pm Said:

      @rizky check the config file make sure your table prefixes are correct. You would only get this error if the query formed by the script is bad. If you can share the query that failed (its printed out) then I might be able to tell whats up with it.

    28. Links for 2008-04-30 [del.icio.us] | RedMallorca LAB, on May 3rd, 2008 at 7:21 pm Said:

      […] » Joomla2Wordpress Import Wizard v.3 […]

    29. Sundi, on May 11th, 2008 at 6:00 am Said:

      Thank you.. I will try it.

      Nice tutorial

    Leave a Reply

    AJAXed with AWP