• My Widget




Joomla2Wordpress Import Wizard v.3

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.

UPDATE: This version of the script has been tested and works on all versions of Joomla between  1.0.12 - 1.5 and Wordpress 2.3.2 -2.7 and works pretty smoothly. So it should work with the latest versions of both CMS platforms! Make sure to post your success or failure and which version you were using in the comments.

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


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?
  • 116 Responses to “Joomla2Wordpress Import Wizard v.3”

    1. welcome to wordpress!

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

    3. 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. 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. Will this delete the joomla database completely? Or will it simply just copy the files and leave the original joomla db intact? Thanks!

    6. 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. 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. 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. Any ideas how this could be made to import from joomla 1.5?

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

    10. 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. Well, if you have the time to look at it I could really use it :)

    12. 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. 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. Sounds like a good work around. I will definitely give it a go. Thanks for looking into it!

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

    16. De Fries:

      let us know if it works out for you

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

    18. 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. 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. [...] 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. 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. 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. @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. 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. 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. When I proceed to step 2, I get “Query Failed”. How can I solve that?

    27. @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. [...] » Joomla2Wordpress Import Wizard v.3 [...]

    29. Thank you.. I will try it.

      Nice tutorial

    30. This sooooo needs to be updated for wordpress 2.5 (2.5.1)

    31. I just migrated from Joomla into WordPress Version 2.5.1 and it worked flawlessly.
      Thanks a ton!

    32. As long as the db schema (structure) of WP isn’t changed this script will work on current versions of WP. As Sage above just said he was able to import directly into 2.5.1.

      I am assuming the script will not work with Joomla 1.5, but will work with any 1.0.x version

    33. Thanks a million for the script!

      I had some problems in the beginning because my Joomla 1.0 site was in Finnish and the script didn’t work proberly when the articles I tried to import had special characters like ä or ö in the title. Changing these characters solved the problem. Migration to Wordpress 2.5.1 workes fine.

    34. [...] Geliştirici: Azeem Khan | Joomla2WordPress Anasayfası [...]

    35. I just exported more than 300 posts (it only took a couple of minutes) to Wordpress 2.5.1 and it worked fine. Thank you Azeem, you did a great job with this script!

    36. Will this work with direct convertion of Joomla into Wordpress MU ? Or will I need to covert first to wordpress 2.5.x and then convert the WP to WP MU ?

    37. @ohad

      I haven’t seen the db schema for MU, if its the same then it will work without a prob. Try it, tell us how it goes

    38. Just tried this on one of my sites and worked great :D. (after i downloaded the correct file anyway)

      Now to move wordpress to the root instead of a subfolder :) And then do it on my other site :P

    39. Any suggestions on importing from Joomla 1.5x?

    40. Can i move my user registrations from Joomla to Wordpress with this script?

    41. @Joomler

      No the script does not import users, but you can specify in the configuration file which user should be the author of the articles when importing. admin is default. In WP create the users first before using the username in the configuration file.

    42. Hi,

      First at all its a great thing to make this happen.In spite of the fact that I have more interess in joomla I have seen that its much more easy to get results on the internet by using wordpress.Anyway, I have a running joomla 1.5 site and wanted to change it into wordpress.

      I folow the instructions above:

      İnstall a 2.2.2 Wordpress , make the necessary changes on the config.php file and run it.

      It has worked!

      Step 1 and step 2 appeares but there is a major problem!

      The characters gets lost!

      http://v2.geyve.org/wordpress-to-joomla.jpg

      ş,ç,ı,ğ,ö,ü characters are used in the turkish language ( Usally needs ISO-8859-9)

      I cld not understand why because both of the databases uses utf-8 as defaut character set.

      I wonder if there were anything possible to show them corrctly.

    43. Hi !

      Wordpress to Joomla ?

      Varmı kardeş ?

    44. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pliktech/public_html/export/index.php on line 534

      what wrong ?

    45. Hey guys
      I’m getting a Query Failed at step 3 - no idea what is going wrong.
      Trying to move Joomla 1.5 to Wordpress 2.5 or 2.6 - both of them fail on step 3.
      Please heeeeeeelp

    46. I tried using this to import the Joomla articles. It must be connecting to the database for step one because it successfully pulled all the categories. Great. But once you select it to move to step two, I got the following error:

      “Query Failed”

      I’m using wordpress MU but I don’t think that is the problem as the general article structure I believe is the same, but I’ll try it again with a different version.

    47. Upon further review, this script only works for up to Wordpress 2.3. Use that and then upgrade the database to the current 2.6. It works like a charm.

    48. This script only works for wordpress 2.3, so I have imported to an temporary blog and after import I have upgraded it.
      I worked without any problem. Thanks buddy.

    49. [...] here’s the article about "Moving from Joomla to Wordpress" :http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/ [...]

    50. Can this util export authors to WP as well. I have a multi author site that have many articles contributed by different authors

      Thanks

      Bill

    51. [...] and easy to use and has a lot of plug-ins and features. I migrated all my joomla content with a script and it worked pretty well. Had to upload and fix all the images manually, and all the comments are [...]

    52. [...] Geliştirici: Azeem Khan | Joomla2Wordpress Anasayfası [...]

    53. query failed Fixed! :P jos_ replaced by mos_ in config.php :) $joomlatblprefix = ‘mos_

    54. Hi, I’m looking for some scripts to perform an import of joomla’s 1.5.6 blog entries to a clean wordpress installation.
      I don’t care about joomla users or whatever.
      I just care about posts and related comments.

      Anyone?
      Thanks,
      A.

    55. Awesome! Worked without any problems!

    56. great stuff. thanks a lot

    57. Joomla2WordPress Import Wizard v3 by Azeem Khan
      Step One

      Okay, we’re connected to the Joomla database.

      Now, we need to select the method you want to use to import your articles or links. (You should automatically advance to the next step, but if it doesn’t you can click the button.)
      Query failed

      What can i do to avoid this matter?

      Many thx

    58. Hello,

      It’s working but the wizzard has imported only 17 elements on 176 existings ….
      do you know why?

    59. Hi,
      Import fine but I am getting [...] characters in my posts. Same as post above:

      [...] Geliştirici: Azeem Khan | Joomla2Wordpress Anasayfası [...]

      I cannot see them/get rid of them in the editor or database tables. Any idea on how to remove them?

    60. Hi

      Any tips on importing site not on UTF code page but on win 1250 code page. Characters get messed up. Thank u in advance.

    61. I’m thinking of migrating to either Wordpress or Drupal FROM Joomla 1.0.15. The main reasons:
      1. is the lack of consistency for users using Internet Explorer, Firefox and Netscape. Everytime I make a change, it takes hours to check each type of browser and tweak the templates to make it all look OK..and OK is not really good enough!
      2. search engines seem to prefer WP or Drupal (even with SEF on in Joomla
      3. Joomla just seems less flexible unless I want to use modules and mambots which all seem to conflict one way or another
      3. There is no decent integrated FORUM for Joomla (tried FB and currently using Agora which has it’s own issues.

      Does any have any advice on which is better. WP or Drupal. I don’t really care about importing the data, I’ll do it manually if I have to and this will give me a chance to rejig a lot of the problems I have with Joomla anyway.
      Thanks

    62. Awesome! Joomla 1.0.12 to Wordpress 2.6.5 no snags!

    63. Great work!
      Have you find a solution to import comment from joomla?
      Thanks

    64. Great work, can anyone import static content?

    65. [...] comments dan data-data lain memerlukan langkah penanganan lanjutan lain lagi. Saya menemukan link Azeemkhan. Import content ini dicoba pada Joomla 1.0.12 dan Wordpress [...]

    66. Is there updated version of script from Joomla 1.0.15 to WP 2.7? I have close to 2,000 contents in Joomla and I really could use some help. Thanks!

    67. [...] joomla-wordpress-import [...]

    68. Hi,
      this script is ok also to migrate
      joomla 1.5.x. to wordpress 2.7! :)
      I’ve tested in a local site… ;)

    69. The script worked perfectly with WP 2.7
      Thanks!

    70. [...] I used Azeem Khan´s  Joomla2Wordpress Import Wizard v.3 [...]

    71. [...] oude Joomla database heb ik met een gevonden Query overgezet in Wordpress (query is hier te vinden). Deze hikte helaas op een aantal vreemde tekens (nou ja, vreemd, maar het ging niet goed). Denk [...]

    72. How do I copy images from posts over?? Thoughts?

      Dave

    73. What a amazing script. Thanks a lot !!

      My joomla website had texts in portuguese with tons of accents (ç,é,á,ó,ü, ê,…). I had problems with that migrating these texts.

      To solve this problem without much work, I replaced all ocorrences of “$row[" by "utf8_encode($row[", in the index.html file.
      Exemple:
      before: $row["id"];
      after: utf8_encode($row["id"]);

      Hope this information was useful.

    74. [...] Geliştirici: Azeem Khan | Joomla2Wordpress Anasayfası [...]

    75. Hey People, I’m getting this error:

      Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘ODBC’@'localhost’ (using password: NO) in I:\FerozoWebHosting\cepriuca.com.ar\public_html\blog\export\index.php on line 124
      Could not connect

      Why is this happening?

    76. Hey People, I’m getting this error:

      Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘ODBC’@’localhost’ (using password: NO) in I:\FerozoWebHosting\cepriuca.com.ar\public_html\blog\export\index.php on line 124
      Could not connect

      Why is this happening?

    77. @Mati

      check your username/pw/db credentials.

    78. Yes Azeem, after I left the message I continued checking and it was an error made by me writing the DB name. My bad!, thanks! Great tool!

    79. Hey,

      i have one problem. If i use this script i get this error message after step 3:

      INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES (’66′, ‘4′)
      Query failed

      Have anyone an idea what i can do?

    80. [...] Daí, tempos depois resolvi começar um blog pra valer. Por conta disso montei meu primeiro blog no wordpress e de lá prá cá virou uma bagunça. Cheguei a ter as coisas em três lugares diferentes e tava difícil controlar. Finalmente, depois de muita paciência, terminei de mover tudo pro Wordpress com a ajuda de um artigo que encontrei no site do Wordpress: http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/ [...]

    81. Converting from Joomla to WordPress (up to 2.7x)…

      Quite a few people use the popular Open Source CMS software Joomla for just about everything they do. And in fairness, Joomla is a pretty flexible piece of code (from 1.5 and onwards anyway). One area where Joomla isn’t all that hot, however, is when …

    82. [...] finding the amazing Joomla2Wordpress script, I was able to successfully move Emergent Future from a Joomla 1.0 install to the latest [...]

    83. Hi Azeem,

      The migration worked fantastic!

      Thanks!

    84. hello,
      greate way how to moving Joomla >> Wordpress .

      can you help me moving Wordpress >> Joomla .

      thanks

    85. Hi Azeem,
      the tool worked fine, many many thanks.

      Just for further improvements, I had to rename all post title with special chars (otherwise the script failed with “query failed” message) and images into joomla post weresn’t imported at all.

      Big big thanks, you helped me a lot.

      Take care,
      A.

    86. @benjamin
      special chars into post title? ;)

    87. Hey Mate,

      You’ve made my day, my week and my year!
      Amazing Script!

      Thanks so much!

    88. Awesome script. you have just made me look very clever!

      the only real problem was a few special chars in post titles, once I read though these comments I figured that out.

      thanks for the script and thanks to those that have reported issues and solutions.

    89. I would like to use, however I have a lot of content with images, will this do the trick for it as well or do you have any suggestions

    90. Hi Jimmy,

      It worked for me. I just had problems with portuguese accents.

    91. Great script, but I think the lack of support for authors is a fatal flaw. Is there any chance that you might implement that functionality in the future?

    92. [...] 91 Responses on my Joomla to Wordpress Migration Tool - http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/ [...]

    93. Help!

      Need to migrate a BLANK joomla template into a Wordpress Theme - No content, nothing - just need assistance in deploying the joomla theme into a wordpress 2.7.1 theme.

      Any ideas or help on this??

    94. it’s wonderful!
      THANKS !!

    95. This came in very handy. Thanks.

    96. [...] I found a post on azeemkhan.info which had a wizard which would allow you to move the content over. But there was [...]

    97. The script is failing on Step Two after I select a category to import. Here is what I get:

      Second Step

      Importing 645 items
      SELECT ID from wp_users WHERE wp_users.user_login = ‘admin’

      INSERT INTO wp_posts (id, post_author, post_title, post_content, post_date, post_modified, post_name, post_category) VALUES (”, ‘1′, ‘Welcome to PlanetX64!’, ‘
      {mosimage} Welcome to PlanetX64.com, a hardware/software review site for the 64-bit world.

      From the folks that brought you PlanetAMD64 comes PlanetX64!
      \r\n
      \r\nCutting edge technology reviews for the 64-bit community! As the world\r\nmigrates to 64-bits, count on the staff at PlanetX64 to keep you\r\ninformed of the latest news and information regarding this exciting\r\nevolution in our computing experience.
      ‘, ‘2005-10-13 22:53:52′, ‘2005-11-24 20:09:40′, ‘welcome-to-planetx64′, ‘9′)
      Query failed inserting into categories

    98. I tried your script, but it doesn’t support the Greek language. All I get is question marks (???????????????).

      Any idea why this happens and what I can do to fix it?

      Thanks for taking the time.

      Phoat

    99. With WP 2.7.1, I had to modify the query and the database to allow some null values to be uploaded. Also, the ID cannot be loaded as null because it is an auto-incrementing value. However, the script only partially uploads my data. Also, trying to do an entire section at a time causes the few posts that are loaded to all have the same category - the section name - instead of the actual category. This script is very close but not quite there. You seem to be loading up all the data as a huge query. Wouldn’t it be more effective to loop through the joomla database and build a query for each post and then submit it? Your script may be running into memory limits with large sites like mine.

    100. [...] via Joomla2Wordpress Import Wizard. [...]

    101. I’m getting this when I try to open /export/index.php
      “There doesn’t seem to be a wp-config.php file. I need this before we can get started. Need more help? We got it. You can create a wp-config.php file through a web interface, but this doesn’t work for all server setups. The safest way is to manually create the file.”

      I’m sure I’m doing something dumb. Suggestions on what I should do?

    102. I am gettig the same problem like steve whit.
      I am using joomla 1.5.x and WP 2.7.1

    103. Hi Steve and Mohamed,

      probably you only installed Wordpress without opening it at least once. Just go to your WP-Installation and follow the instructions then you should have a wp-config.php.

      Greetings from Germany
      Andy

    104. *edit*

      I read somewhere something… where is your “export” folder? Is it in the WP root? It has to there. Maybe thtá the solution.

    105. *edit*

      I read somewhere something… where is your “export” folder? Is it in the WP root? It has to there. Maybe that is the solution.

    106. Hi,

      when i convert from Joomla2Wordpress all Article with German Umlauts will strip when a Umlaut (öäü) is in the article…

    107. To Andreas Mohamed, and Steve

      YES that is the solution, I has the same problem and I fix it that way. moving the export folder to the WP root

    108. anyone find out if this works with wordpress mu? I’m using Joomla 1.5.10 and Wordpress 2.7

      Just curious before I screw something up.
      Bob

    109. Hi, I’m having the same problem as Benjamin. When I exported from joomla to worpdress, the script only gets the first 3 posts of each section/category. At the end of the step 3 I got the next message:

      INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES (’4′, ‘3′)
      Query failed

      Anyone knows a solution to fix it?.

      Thanks in advance.

      ps: sorry for my bad english.

    110. @Matias - This is due to special characters (curly quotes, etc.) in the post title.

      I’m having the same problem, only I noticed the script also truncates posts if there’s any special characters in there as well.

      This is incredibly problematic, seeing as how I’m converting 800 posts and having this problem with also every story.

    111. Thank you so much.
      Worked like a charm on j1.013 to wp2.7 !!!

      —> BUT, is there any way I can bring over users as well ? Doing this by hand is out of the question since I have a lot.

      Again, thank you so much for your work, it’s majorly appreciated :D

    112. [...] posts from Joomla was very fast and easy thanks to the Joomla2Wordpress Import Wizard. Static content were not imported and I had to copy-and-paste the content into Wordpress manually, [...]

    113. perfectly worked with wp 2.7, but not working with wp 2.8 :(

    114. I had to change the query at line 379 of index.php to be this:

      $query = “INSERT INTO “.$wptblprefix.”posts ( post_author, post_title, post_content, post_date, post_modified, post_name, post_category, post_excerpt, to_ping, pinged, post_content_filtered) VALUES ( ‘$ID5′, ‘{$import[1][$j]}’, ‘{$import[2][$j]}’, ‘{$import[3][$j]}’, ‘{$import[4][$j]}’, ‘$post_name’, ‘$wpsection’,”,”,”,”)”;

      and then it worked without error messages for me. I am running Joomla 1.5.11 and wordpress 2.7 and I had been getting the “Query failed inserting Section” error. This suggestion is as-is; back up your db first and use this mod at your own risk. thx

    115. anyone have luck getting this to work with wordpress 2.8? i’m a total hack at this stuff but looking at the index.php file, still can’t figure out why it isn’t working.

    116. Not working with Wordpress 2.8.

      I get a:

      Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘xxxx’@'xxxxx’ (using password: YES) in /home/xxxx/public_html/site3/export/index.php on line 233

      It seems like Wordpress is not accepting connections, but I know username and password are ok.

      Thank you for the great work, I’m considering installing Wordpress 2.7 and then upgrade.

      Regards,

      MG

    Leave a Reply