Joomla2WordPress import wizard with UTF-8 support


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 azeemkhan.info which had a wizard which would allow you to move the content over. But there was a problem. It did not support UTF-8 sites like Joomla! 1.5 So I decided to take this script and change it to a working script with UTF-8 support.

First things first ! Make backups of your old site !!!!!

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

If you have any problems with this tool, just drop me a mail.

Joomla2Wordpress Wizard (hits: 1092)

This application is created for a wordpress installation not in the root but in /root/wordpress on your server. If your wordpress installation is in the root or in another directory (eg: /root/blog, /root/posts) you have to adjust the following lines to this :
Line 11: if (!file_exists(‘../wordpress/wp-config.php’))
Line 17: require_once(‘../wordpress/wp-config.php’);
Line 21: $guessurl = str_replace(‘/wordpress/wp-admin/install.php?step=2′, ”, ‘
http://’ . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) );
Line 312:     require_once (“../wordpress/wp-includes/functions.php”);
Line 441:     require_once (“../wordpress/wp-includes/functions.php”);

Theo van der Sluijs

Theo van der Sluijs (1975) is Software Development Manager at Bax-shop.nl. You can read more in dutch on his “Dutch Blog“, he also created Gebruikmaar.nl. He is a member of the Board of the Dutch Flex Usergroup and Goesweb.net.

Google+ Twitter LinkedIn 



VN:F [1.9.13_1145]
Rating: 7.3/10 (7 votes cast)
VN:F [1.9.13_1145]
Rating: +5 (from 5 votes)
Joomla2Wordpress import wizard with UTF-8 support, 7.3 out of 10 based on 7 ratings

Related Posts

12 comments

  1. Chien HOang

    I have a same problem when migrate Joomla to WordPress with Vietnamese. It have ???? in word. I don't know why.
    Here is sample:
    Trong các n??c ? châu Á

    And expected words:
    Trong các nước châu Á

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  2. Hoi Theo,

    Ik kwam op jouw site toen het script van Zeem Khan niet werkte. Jouw script heb ik aangepast voor de locatie van de WordPress installatie (geen /wordpress, maar in de root folder). Connectie naar de database gaat prima, maar de export breekt af bij elke willekeurige sectie/categorie. Foutmeldingen als Step Three Query failed getting content from section ontstaan. Heb je een oplossing, want dit soort ongein houdt de overstap van Joomla naar WordPress inderdaad tegen.

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  3. Hi, i have imported my website but it seems some articles haven;t completely transfered and the part after read more is missing can you please explain how they can be retrieved

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  4. Please look into my problem if you intend to give paid support thats fine with me i have given my email id here

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  5. Dear its showing error –

    ', '2009-07-02 13:20:30', '0000-00-00 00:00:00', 'sources-of-pregnancy-information', '7')

    Query failed inserting into categories

    Whats solution for this?

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
    • This can be a ton of reasons.

      Need more info.

      VN:F [1.9.13_1145]
      Rating: 0.0/5 (0 votes cast)
      VN:F [1.9.13_1145]
      Rating: 0 (from 0 votes)
      • Theo,

        I got the same error message as above:

        ', '2009-07-07 05:00:00', '0000-00-00 00:00:00', 'core-connection-lifestyle-is-now-on-facebook-and-twitter', '3')

        Query failed inserting into categories

        ——————————————-

        It appears as though the content is being moved, but then when I read further down past the content, I get the error above. Everything else seemed to check out (DB connection, etc.), so any assistance you could give would be appreciated.

        And thank you for creating this application! I was a Joomla! head for years, but now that I'm on WordPress, life is just a whole lot easier to deal with! LOL!

        VA:F [1.9.13_1145]
        Rating: 0.0/5 (0 votes cast)
        VA:F [1.9.13_1145]
        Rating: 0 (from 0 votes)
  6. Hi,

    Re "Query failed inserting into categories" – I've just had the same error and I believe it's due to changes in WordPress.

    According to http://codex.wordpress.org/Database_Description#C… in v2.8 they removed a column from the _posts table, and when I call mysql_error() I get this:

    Unknown column 'post_category' in 'field list'

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  7. Hi Theo,

    First of all, thank you for this great plugin and for the step by step guide.

    I managed to transfer all my articles with your wizard but with a crucial problem which I do not know how to fix.

    My articles are in greek and now all the greek text is ???? . Do you know what I should change to your code to do the transfer right?

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  8. I also tried something but it didn't work…

    I added after every mysql_connect() the following 2 lines

    mysql_query("SET NAMES 'utf8'", $link);

    mysql_query("SET CHARACTER SET utf8", $link);

    It changed the text but know shows this kind of symbols με πάχος μόÎ

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  9. Wow! Thank you! I always wanted to write in my site something like that. Can I take part of your

    post to my blog?

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  10. Ummmmm … english please. No Hablo russian.

    VN:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.13_1145]
    Rating: +1 (from 1 vote)

Trackbacks/Pingbacks

  1. Joomla! migration to Wordpress | I am Bored So I Blog - [...] You can read more about this Joomla2Wordpress migration tool in another post. [...]
  2. Martin-zone » Blog Archive » Joomla -> Wordpress - [...] sem našel rešitev za UTF-8 kodiranje, a žal ni delovala. Iskal sem še naprej in našel skripto Joomla2Wordpress import wizard ...

Leave a Reply

Get Adobe Flash playerPlugin by wpburn.com wordpress themes