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”);
12 comments
Trackbacks/Pingbacks
- Joomla! migration to Wordpress | I am Bored So I Blog - [...] You can read more about this Joomla2Wordpress migration tool in another post. [...]
- 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 ...





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 Á
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.
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
Please look into my problem if you intend to give paid support thats fine with me i have given my email id here
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?
This can be a ton of reasons.
Need more info.
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!
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'
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?
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 με ÏάÏÎ¿Ï Î¼ÏÎ
Wow! Thank you! I always wanted to write in my site something like that. Can I take part of your
post to my blog?
Ummmmm … english please. No Hablo russian.