» Joomla2Wordpress Import Wizard v.3

242 Responses to “Joomla2WordPress Import Wizard v.3”

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

welcome to wordpress!
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/ [...]
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.
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!
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!
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.
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!
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.
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?
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.
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
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.
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)
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!
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 [...]
Azeem, on February 7th, 2008 at 10:44 am Said:

De Fries:

let us know if it works out for you
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..
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.
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.
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 [...]
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
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
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).
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..
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!
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?
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.
Links for 2008-04-30 [del.icio.us] | RedMallorca LAB, on May 3rd, 2008 at 7:21 pm Said:

[...] » Joomla2Wordpress Import Wizard v.3 [...]
Sundi, on May 11th, 2008 at 6:00 am Said:

Thank you.. I will try it.

Nice tutorial
Bla1ze, on May 20th, 2008 at 3:02 am Said:

This sooooo needs to be updated for wordpress 2.5 (2.5.1)
Sage, on May 21st, 2008 at 10:13 am Said:

I just migrated from Joomla into WordPress Version 2.5.1 and it worked flawlessly.
Thanks a ton!
Azeem, on May 21st, 2008 at 11:30 am Said:

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
Henrik, on June 2nd, 2008 at 2:18 am Said:

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.
Joomla’yı Wordpress’e Aktarmak « Sinerjik Günlük, on June 23rd, 2008 at 9:21 am Said:

[...] Geliştirici: Azeem Khan | Joomla2WordPress Anasayfası [...]
Wil, on June 25th, 2008 at 4:37 am Said:

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!
ohad, on July 3rd, 2008 at 9:37 am Said:

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 ?
Azeem, on July 4th, 2008 at 12:15 am Said:

@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
Bex, on July 9th, 2008 at 5:16 am Said:

Just tried this on one of my sites and worked great . (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
Plug One Boss, on July 13th, 2008 at 12:37 am Said:

Any suggestions on importing from Joomla 1.5x?
Joomler, on August 12th, 2008 at 4:16 am Said:

Can i move my user registrations from Joomla to WordPress with this script?
Azeem, on August 13th, 2008 at 6:11 am Said:

@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.
yavuz yayla, on August 13th, 2008 at 5:26 pm Said:

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.
Dolphin, on August 16th, 2008 at 7:57 am Said:

Hi !

Wordpress to Joomla ?

Varmı kardeş ?
Ahmandonk, on August 18th, 2008 at 12:30 pm Said:

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 ?
joe, on August 25th, 2008 at 7:11 am Said:

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
Mike, on August 27th, 2008 at 8:20 pm Said:

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.
Mr. Legal Advice, on August 27th, 2008 at 8:42 pm Said:

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.
Beijing, on August 31st, 2008 at 12:29 pm Said:

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.
Finally, Moved from Joomla to Wordpress | Mahmoud M. Abdel-Fattah, on September 1st, 2008 at 6:28 pm Said:

[...] here’s the article about "Moving from Joomla to WordPress" :http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/ [...]
Bill Nguyen, on September 12th, 2008 at 9:33 am Said:

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
Moving to WordPress | hamang.net, on September 18th, 2008 at 2:53 am Said:

[...] 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 [...]
Joomla’yı Wordpress’e Aktarmak | Sinerjik Günlük, on September 19th, 2008 at 9:26 pm Said:

[...] Geliştirici: Azeem Khan | Joomla2Wordpress Anasayfası [...]
Sebastian, on September 29th, 2008 at 12:57 pm Said:

query failed Fixed! jos_ replaced by mos_ in config.php $joomlatblprefix = ‘mos_
ArMyBoT, on September 30th, 2008 at 2:40 pm Said:

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.
Brow, on October 2nd, 2008 at 8:48 am Said:

Awesome! Worked without any problems!
psycho, on October 2nd, 2008 at 11:25 am Said:

great stuff. thanks a lot
Pfff, on October 4th, 2008 at 3:29 am Said:

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
Pfff, on October 5th, 2008 at 12:12 pm Said:

Hello,

It’s working but the wizzard has imported only 17 elements on 176 existings ….
do you know why?
gps, on October 10th, 2008 at 3:58 pm Said:

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?
kiki, on November 25th, 2008 at 4:21 am Said:

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.
DocMood, on November 26th, 2008 at 6:20 am Said:

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
Phil, on November 27th, 2008 at 9:41 pm Said:

Awesome! Joomla 1.0.12 to WordPress 2.6.5 no snags!
Heroow, on December 15th, 2008 at 2:22 am Said:

Great work!
Have you find a solution to import comment from joomla?
Thanks
Dan, on January 11th, 2009 at 5:31 pm Said:

Great work, can anyone import static content?
Artikel Langkah / Cara Migrasi Joomla ke WP : Import Content Artikel dari Joomla ke Wordpress. - Blogging - 315 | otong.net », on January 16th, 2009 at 8:38 am Said:

[...] 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 [...]
WPRookie, on January 24th, 2009 at 12:19 pm Said:

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!
Joomla to Wordpress import | Web Sheila, on January 25th, 2009 at 1:13 pm Said:

[...] joomla-wordpress-import [...]
iljester, on January 30th, 2009 at 4:51 am Said:

Hi,
this script is ok also to migrate
joomla 1.5.x. to wordpress 2.7!
I’ve tested in a local site…
Thor, on February 8th, 2009 at 7:19 am Said:

The script worked perfectly with WP 2.7
Thanks!
tf4m.com » Blog Archive » Goodbye Joomla, hello WordPress, on February 8th, 2009 at 7:24 am Said:

[...] I used Azeem Khan´s Joomla2Wordpress Import Wizard v.3 [...]
Nieuwe site bijna online | :: Creatov.nl ::, on February 13th, 2009 at 5:33 am Said:

[...] 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 [...]
Dave, on February 15th, 2009 at 1:34 pm Said:

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

Dave
Antoniazi, on February 17th, 2009 at 2:43 am Said:

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.
Joomla’yı Wordpress’e Aktarmak | Batuhan Bulak, on February 21st, 2009 at 2:41 pm Said:

[...] Geliştirici: Azeem Khan | Joomla2Wordpress Anasayfası [...]
Mati, on February 24th, 2009 at 7:19 pm Said:

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?
Mati, on February 24th, 2009 at 7:21 pm Said:

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?
Azeem, on February 25th, 2009 at 12:31 am Said:

@Mati

check your username/pw/db credentials.
Mati, on February 25th, 2009 at 6:59 am Said:

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!
Benjamin Büschenfeld, on March 1st, 2009 at 6:51 am Said:

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?
Joomla 2 Wordpress - Ócio também é cultura, on March 15th, 2009 at 11:28 pm Said:

[...] 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/ [...]
joho.se @ stockholm.sweden, on March 16th, 2009 at 5:28 am Said:

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 …
Successful Migration from Joomla to Wordpress | Emergent Future, on March 16th, 2009 at 4:16 pm Said:

[...] finding the amazing Joomla2Wordpress script, I was able to successfully move Emergent Future from a Joomla 1.0 install to the latest [...]
Lennart Koopmans, on March 20th, 2009 at 12:18 pm Said:

Hi Azeem,

The migration worked fantastic!

Thanks!
duy, on March 24th, 2009 at 7:40 pm Said:

hello,
greate way how to moving Joomla >> WordPress .

can you help me moving WordPress >> Joomla .

thanks
ArMyBoT, on March 25th, 2009 at 1:24 am Said:

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.
ArMyBoT, on March 25th, 2009 at 1:26 am Said:

@benjamin
special chars into post title?
Asaf, on March 26th, 2009 at 7:42 am Said:

Hey Mate,

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

Thanks so much!
Headstrong, on March 28th, 2009 at 3:32 pm Said:

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.
Jimmy, on April 1st, 2009 at 9:25 am Said:

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
Antoniazi, on April 1st, 2009 at 4:29 pm Said:

Hi Jimmy,

It worked for me. I just had problems with portuguese accents.
Adam, on April 1st, 2009 at 11:18 pm Said:

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?
» My Twitter Tweets for 2009-04-03, on April 3rd, 2009 at 1:54 am Said:

[...] 91 Responses on my Joomla to WordPress Migration Tool – http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/ [...]
Thomas, on April 8th, 2009 at 3:43 pm Said:

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??
zineworm, on April 10th, 2009 at 10:16 pm Said:

it’s wonderful!
THANKS !!
Arsenalist, on April 13th, 2009 at 11:56 pm Said:

This came in very handy. Thanks.
Joomla2Wordpress import wizard with UTF-8 support | I am Bored So I Blog, on April 20th, 2009 at 4:02 am Said:

[...] I found a post on azeemkhan.info which had a wizard which would allow you to move the content over. But there was [...]
Carlos Echenique, on April 27th, 2009 at 6:47 pm Said:

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
Phoat, on April 28th, 2009 at 8:17 am Said:

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
Carlos Echenique, on April 28th, 2009 at 2:02 pm Said:

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.
Moving from Joomla to WordPress | PAULMYATT.COM, on May 6th, 2009 at 5:57 am Said:

[...] via Joomla2Wordpress Import Wizard. [...]
steve whit, on May 6th, 2009 at 3:41 pm Said:

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?
mohamed, on May 8th, 2009 at 7:47 pm Said:

I am gettig the same problem like steve whit.
I am using joomla 1.5.x and WP 2.7.1
Andreas, on May 10th, 2009 at 2:28 am Said:

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
Andreas, on May 10th, 2009 at 5:12 am Said:

*edit*

I read somewhere something… where is your “export” folder? Is it in the WP root? It has to there. Maybe thtá the solution.
Andreas, on May 10th, 2009 at 5:13 am Said:

*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.
Devil, on May 19th, 2009 at 1:16 pm Said:

Hi,

when i convert from Joomla2Wordpress all Article with German Umlauts will strip when a Umlaut (öäü) is in the article…
Lardo, on May 24th, 2009 at 10:18 am Said:

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
Bob, on May 25th, 2009 at 11:35 pm Said:

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
Matías, on May 26th, 2009 at 10:27 am Said:

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.
Bryan, on June 4th, 2009 at 7:34 pm Said:

@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.
flav, on June 13th, 2009 at 9:22 am Said:

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
syamsul’s domain » Migrating a Joomla + Joomlaboard site to Wordpress + punBB, on June 14th, 2009 at 12:42 am Said:

[...] 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, [...]
TRecords, on June 21st, 2009 at 4:21 am Said:

perfectly worked with wp 2.7, but not working with wp 2.8
mj_massachusett, on June 24th, 2009 at 11:39 pm Said:

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
sp, on June 26th, 2009 at 4:50 pm Said:

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.
MG, on June 29th, 2009 at 11:53 am Said:

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
Saif, on July 4th, 2009 at 2:40 pm Said:

Salam.
I try this script, but get:
——————————–
Importing 29 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′, ‘Ilmu Ikhlas’, ‘
-CONTENT HERE-
‘, ’2007-01-20 15:29:56′, ’2007-01-23 15:54:10′, ‘ilmu-ikhlas’, ’11′)

Query failed inserting Section
——————————–

Can you give solutions?
Thanks, brother.
Saif, on July 4th, 2009 at 2:45 pm Said:

Salam.
I try this script, but get:
——————————
Importing 29 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′, ‘Ilmu Ikhlas’, ‘
-CONTENT HERE-
‘, ‘2007-01-20 15:29:56′, ‘2007-01-23 15:54:10′, ‘ilmu-ikhlas’, ‘11′)

Query failed inserting Section
——————————

Can you give solutions?
Thanks, brother.
Antoniazi, on July 6th, 2009 at 10:46 pm Said:

I got the message “Query failed inserting Section” too. To solve it I had to change line “$query = “INSERT INTO” in the index.php script because the field post_category doesn’t exist anymore.

Now the insert command should be:

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

in case the message persists, you can add the Sql Error message changing the “die command” to:

die(“Query failed inserting Section”. mysql_error());

hope it helps
foxtrot, on July 20th, 2009 at 10:58 am Said:

I’m a noob so forgive the obvious questions:

I have a website with Joomla 1.5 and would like to change it to WordPress.

1. Do I need to install WordPress on my Joomla site ahead of time, or does this script do that for you?

2. If I need to install WordPress ahead of time, is this the best approach:

a. Create a WordPress database and user (along side my Joomla database). (I can do this using the cPanel or myPhpAdmin, which are available when I log into my Joomla site.)

b. Install WordPress 2.7 manually by uploading the contents of the WordPress directory to the “root directory” of my website. (I assume the root directory of my website is …/public_html/) If I do this, I’ll end up with a mix of WordPress and Joomla folders and files, all under /public_html/. Is that problem? Do I just need to later go through and manually delete the Joomla folders and files?

3. For step 3 – “Upload files to /export on your server.” – Do I create the export directory in the “/public_html” directory? (Alongside all the existing folders for Joomla – administrator, components, includes, etc. – and WordPress – wp-admin, wp-content, etc.?

That’s it for now. Thanks for any pointers.
Martin-zone » Blog Archive » Joomla -> Wordpress, on July 22nd, 2009 at 4:08 am Said:

[...] skripto Joomla2Wordpress, ki naj bi poenostavila migracijo. Ker ni delovala, sem poskusil še Joomla2Wordpress Import Wizard v.3. Skripta je sicer uspešno prenesla članke, a brez šumnikov. Med komentarji sem našel rešitev [...]
theloupe » Joomla vs Wordpress, on July 22nd, 2009 at 9:21 am Said:

[...] coming. I finally made the transition to WordPress from my joomla site with a little help from this nifty script. My site is essentually a `blog´as they call it so I thought I would start using the best blogging [...]
Julien, on July 27th, 2009 at 10:45 am Said:

Great job.

wp-config.php not found : if your wordpress is in a subdirectory simply edit index.php et search et replace all “../” by “../yourdirectory”

connect error : many times a error in dbhost name
Jon, on July 30th, 2009 at 1:37 pm Said:

Query failed inserting into categories for every option I try on your script.
joomla exports a wordpress | zonamotorsport.com, on July 30th, 2009 at 6:19 pm Said:

[...] uso del Script Joomla2Wordpress te facilitará enormemente el cambio siguiendo los siguientes [...]
call center outsourcing, on August 1st, 2009 at 7:42 am Said:

Thanks you so much.
This is a great blog post,
i have learnt a lot.
stounemaster, on August 3rd, 2009 at 10:42 am Said:

Hello.

I’m tring to get working your script:

but still having problems whith articles that have special characters.

so… is there a query to execute .. so that I can change special characters form the “Title” of Joomla Articles:

é è ë ê -> e
ä â -> a

thank you very much ^^
troupe » Joomla vs Wordpress, on August 4th, 2009 at 6:52 am Said:

[...] coming. I finally made the transition to WordPress from my joomla site with a little help from this nifty script. My site is essentually a `blog´as they call it so I thought I would start using the best blogging [...]
Casper, on August 5th, 2009 at 9:01 am Said:

THANKS A MILLION TIMES!!!

- I just imported all categories from joomla 1.0 (Legacy!!) to WordPress 2.8.3.
Only “setback” was the ‘Query failed’, which is Antoniazi already addressed above.
In this regard, I’d just like to add that the

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

command has to be replaced in index.php TWICE – once for section importing and once for category importing.

Other than that, it went flawless!! For the record, I did this on the same DB, with wordpress in a sub-folder.
After this, I’ll be exporting normally from WP and into another DB, on another host.

Thx again!
sillybean » Another WordPress plugin: Dashboard Notepad (and some backstory), on August 6th, 2009 at 11:04 am Said:

[...] my teeth and tearing my hair out all summer, I finally said “screw it,” located a Joomla-to-WordPress importer (Joomla being our original sucktastic CMS, powering the current site), and had the new WP site more [...]
Fast4u, on August 12th, 2009 at 3:06 pm Said:

Hello I keep getting this error!

Can someone help please

I do everything as it says, and when I click and choose the category.

this is what I get:
=====
on top of the page
=====

Step Three
Importing 234 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′, ‘Closing reception new to OTC’, ‘

====
and the bottom!
====

Query failed inserting Section

——————————–

what should I do?
Casper, on August 13th, 2009 at 5:48 am Said:

@Fast4u;

See my previous reply (Aug 5th) and also Antoniazi’s reply.
- I’m fairly sure you get that error because the script is trying to execute SQL inserts into a table that no longer exists; ‘post_category’.

I’m assuming you’re importing into a recent version of WP?

Hope it helps!
Fast4u, on August 13th, 2009 at 12:02 pm Said:

Casper,

Thanks for the quick reply!

Yes Version 2.8, So I should just edit the code, and remove after post_name, “post_category”.

And that should solve the problem?
Casper, on August 13th, 2009 at 12:31 pm Said:

@Fast4u;
Copy/paste this;

Line 379;

$query = "INSERT INTO ".$wptblprefix."posts (id, post_author, post_title, post_content, post_date, post_modified, post_name) VALUES ('', '$ID5', '{$import[1][$j]}', '{$import[2][$j]}', '{$import[3][$j]}', '{$import[4][$j]}', '$post_name')";

Line 507;

$query = "INSERT INTO ".$wptblprefix."posts (id, post_author, post_title, post_content, post_date, post_modified, post_name) VALUES ('', '$ID5', '{$import[1][$j]}', '{$import[2][$j]}', '{$import[3][$j]}', '{$import[4][$j]}', '$post_name')";

NB: Make sure that the single quotes aren’t escaped/re-formatted to backticks! (I had that problem the first time, when i copy/pasted from here)

Good luck
Fast4u, on August 13th, 2009 at 12:50 pm Said:

Casper,

I did what you said! And this is what I get
++++++++++++++++++++++++++++++++
top
++++++++++++++++++++++++++++++++
Step Three
Importing 234 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) VALUES (”, ’1′, ‘Closing reception new to OTC’, ‘
++++++++++++++++++++++++++++++++++++
bottom
++++++++++++++++++++++++++++++++++++
‘, ’2008-05-02 10:07:40′, ’2008-05-02 10:08:10′, ‘closing-reception-new-to-otc’, ’6′)

Query failed inserting Section
++++++++++++++++++++++++++++++++++++

and this is what i changed in my index.php file

http://img198.imageshack.us/img198/4139/379line.gif

http://img22.imageshack.us/img22/1728/line507.gif

Please advice,

Thanks again!
hellllllllllllllllp, on August 15th, 2009 at 4:02 am Said:

What do I do wrong?

I’m so tiered that my eyes are shutting down. Can anybody help me?

http://www.stage-suriname.com/export

i tried to put the lines from the last post in there, but when I do that it just turn blank.

Wordpress 1.8.3 and Joomla 1.5x.

I hope sombody could help me!
Hades87, on August 18th, 2009 at 2:45 pm Said:

Hello i have an error with querys in category:

Importing 2 items
SELECT ID from bm_users WHERE bm_users.user_login = ‘Hades87′

INSERT INTO bm_posts (id, post_author, post_title, post_content, post_date, post_modified, post_name, post_category) VALUES (”, ’2′, ‘Concierto de Las Furias.’, ‘

‘, ’2009-02-11 13:08:57′, ’0000-00-00 00:00:00′, ‘concierto-de-las-furias’, ’3′)

Query failed inserting into categories

In the 3 step i recived this error, query failed into categories and i don’t know wjat to do! thanks for all
Eko Subagio, on August 21st, 2009 at 10:08 pm Said:

I just want to move from joomla to wordpress, i will give it try
Noi that moi, on September 5th, 2009 at 4:20 am Said:

Thanks, i need
Hiroshi, on September 21st, 2009 at 10:39 am Said:

I want to move from joomla 1.0.12 to WordPress 2.8.4.

I have to modify the two lines of the script as shown by Casper.

Before I run the script have I to create sections and categories in WP ?
If I do so the articoles will go in the right section / category ?

Thanks for your reply.
Hiroshi, on September 21st, 2009 at 12:59 pm Said:

I’ve uploaded the files in:
http://www.nonsolomac.com/wp/export/ but

When i digit:
http://www.nonsolomac.com/wp/export/index.php

I get:
Parse error: syntax error, unexpected ‘>’ in /web/htdocs/www.nonsolomac.com/home/wp/export/index.php on line 381

Samthings wrong ?
Casper, on September 21st, 2009 at 4:41 pm Said:

@hiroshi;

Look for a missing ? (question mark), probably at the end.
Either that, or compare the line from the original file.

And yes, you need to create categories in WordPress, before doing the import – which just happens to be great, if you wanted to merge categories

I confirm it works flawlessly on WP 2.8.4 install.
Casper, on September 21st, 2009 at 4:42 pm Said:

@hiroshi;

Look for a missing ? (question mark), probably at the end.
Either that, or compare the line from the original file.

And yes, you need to create categories in WordPress, before doing the import – which just happens to be great, if you wanted to merge categories

I can confirm it works flawlessly on WP 2.8.4 install.
Hiroshi, on September 21st, 2009 at 5:30 pm Said:

Thanks Casper for your reply.

A missing question mark ? Where ?
The line 379 and 507 of the original index.php file has no question mark.
Hiroshi, on September 22nd, 2009 at 2:20 am Said:

… and no question mark for the line 381, the line indicated in the message error.
Importeren valt niet mee | Bierlaagh.com, on September 23rd, 2009 at 3:57 pm Said:

[...] mooi werken, dus dan maar even zoeken hoe ik mijn artikeltjes kan importeren in WP. na ff zoeken gevonden config aangepast geupload en importeren [...]
Hiroshi, on September 28th, 2009 at 7:12 am Said:

I’ve checked again.
Everything seems to be OK.
I can’t go on.

Help, Help !

Casper, are you there ?

Thanks
Casper, on September 28th, 2009 at 7:28 am Said:

@Hiroshi and everyone else;

I just uploaded my modified version of the index.php file.
I can confirm this one works flawlessly, with the latest WP install (2.8.4).

http://www.mediafire.com/?sharekey=9836bf5b19d22007d6baebe61b361f7ce2e801bfdbf2d453b878de785cc0f59e

Everybody should grab this one, and REPLACE it with the default index.php, included in Azeem’s original script.

If this file does not work for you, the error is not with the script/file – you should check your config.php, general DB settings etc.

Best of luck!!

Casper
Azeem, on September 28th, 2009 at 3:51 pm Said:

Thank’s Casper. I think I will put out a new version of the attachment and give you all the credit for the latest updates Do you know which version this updated code will work with and which old versions it won’t work with due to schema changes in WP ?
Casper, on September 28th, 2009 at 4:52 pm Said:

@Azeem;

No problem – I’m the grateful one
Thanks so much for writing the script, it was literally the only way for me to successfully port a legacy 1.0 Joomla to a fresh, clean, WP!

BTW, you should really credit Antoniazi’s – I only did what he wrote

I don’t know which WP version the schema change applies to, but it can probably be found on the Codex somewhere in the changelogs..

Thx again!
Azeem, on September 28th, 2009 at 5:37 pm Said:

@Casper,

Right… Special thanks to Antoniazi and Casper on the assist
Hiroshi, on September 29th, 2009 at 5:32 pm Said:

Thank you very much Casper.
I’ve uploaded the new index.php file.
Now I get this message: “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.”

Changing config.php in wp-config.php or creating an empty file wp-config.php doesn’t fix the problem.
Azeem, on September 29th, 2009 at 5:42 pm Said:

@Hiroshi,

you have to do a clean installation of wordpress to use this script. that file is part of the wordpress installation.
Casper, on September 29th, 2009 at 6:02 pm Said:

@Hiroshi;

Actually, the fault is on my part.
I initially changed the default path to WordPress’ wp-config.php, simply because I had WP in a subdirectory.

I uploaded my modified index.php again, this time with the default file path, as originally set by Azeem.

Grab the file here; and once again, REPLACE it with the default index.php, included with the download.

Azeem; could you maybe change my previous link above to match this one?
Casper, on September 29th, 2009 at 6:02 pm Said:

@Hiroshi;

Actually, the fault is on my part.
I initially changed the default path to WordPress’ wp-config.php, simply because I had WP in a subdirectory.

I uploaded my modified index.php again, this time with the default file path, as originally set by Azeem.

Grab the file here; http://www.mediafire.com/?wkneqm23mjj and once again, REPLACE it with the default index.php, included with the download.

Azeem; could you maybe change my previous link above to match this one?
hdwarriors, on October 2nd, 2009 at 9:38 am Said:

Casper, your link is not working.

On another note:
I got some of the things converted but it seems my articles are cut off. The script only imports so much of each article.
Anyone have a work around for this issue?

Thanks!
Casper, on October 2nd, 2009 at 9:51 am Said:

Hmm… For some reason, my earlier comment wasn’t posted;

@Hiroshi;
Actually, the fault is on my part.

I initially changed the default path to WordPress’ wp-config.php, simply because I had WP in a subdirectory.

I uploaded my modified index.php again, this time with the default file path, as originally set by Azeem.

Grab the file here; http://www.mediafire.com/?wkneqm23mjj and once again, REPLACE it with the default index.php, included with the download.

Azeem; could you maybe change my previous link above to match this one?
Hiroshi, on October 3rd, 2009 at 12:24 pm Said:

Thank you very much Casper !
Now I’m one step ahead.

The new index.php and the file config.php are online.
I’ve correctly modified config.php with my data.
I get the first page from the script.

I click the “Step One” link and i Get:

Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /web/htdocs/www.nonsolomac.com/home/wp/export/index.php on line 124
Could not connect

Everything seems to be OK, but I get this error.

What have I to do ?
splat, on October 5th, 2009 at 11:09 pm Said:

i’m trying to migrate from joomla 1.0.15 to wordpress 2.8.4 but every time i get to step 5 i get “Query failed inserting in to category”, or “section” if i select section”. I even tried upgrading to joomla 1.5.14, but i still get “Query failed”. i tried the index file that Casper posted on the 2nd but it still doesn’t work. the code produced looks good so i don’t know what’s up. any ideas?
Alex, on October 13th, 2009 at 7:48 am Said:

Hi,

FINALLY WORKING. So for info I ran Joomla! 1.5.14 and WordPress 2.8.4.

I had “Query failed” on step 3 for any importations.

What I did in index.php:

Removed “post_category” AND ‘$wpsection’ in line 379, AND line 507.

My articles got imported perfectly in my categories.

What a relief !

Good luck!

Alex.
Alex, on October 13th, 2009 at 8:15 am Said:

Actually one last problem: Posts that have special caracter in title such as “é”, “è” ..etc don’t import and end up with a “Query failed”. If anyone knows how to solve this pleeease tell us.
splat, on October 13th, 2009 at 10:51 am Said:

confirmed; removing ‘post_category’ and $wpsection works, and you also need to do the same thing for ‘link_category’ if you want to import links.

so that worked for text, any idea how to import images? and change the links in the text?
Mark, on October 14th, 2009 at 5:34 pm Said:

I am moving to a new ISP, I would assume you can not use this importer to go across domains to another site?

What files should I copy to a directory on my new ISP?
saabi, on October 18th, 2009 at 11:52 pm Said:

@splat: unfortunatelly I can’t confirm this. I’d like to migrate from J 1.0.15 to WP 2.8.4.
In Step 3 after chosing WP category the script seems to fail; without any error message or any other message. I see a blank page in my browser only with the header: “Joomla2WordPress Import Wizard v3 by Azeem Khan”

I’ve made the modification you mentioned (in row 379 and 507) but the result is same…
MySQL ver: 5.0.32
Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.0-8+etch11 mod_perl/2.0.2 Perl/v5.8.8

Any other experience like this?
Rudy’s Krabbels » Blog Archive » Conversie: Joomla naar WordPress, on October 23rd, 2009 at 5:48 pm Said:

[...] Dus, .. een alternatief zoeken. En dat alternatief is er: de Joomla 1.x site converteren naar een WordPress website. WordPress heeft daar zelf geen tools voor, maar er zijn wel mensen die er actief mee bezig zijn geweest. Er bestaat een uitstekend script voor op dit moment. Inmiddels is er een 3e versie beschikbaar, zie deze link. [...]
redkathy, on October 30th, 2009 at 6:06 pm Said:

Ok all you gurus, I’m a 50 year old mom trying to move from mambo to word press. I would be so grateful if you guys would help me out.

My dbs are not on the same host. I use go daddy hosting (don’t laugh). They say I need to buy virtual server, so that all dbs will be on the same host???

So far, I tried all three versions. I get query failed. Version 3 wouldn’t work at all after I changed line 379 and 507.

So can I use this script or do I have to do what go daddy recommended?
AppleUser, on November 2nd, 2009 at 7:42 am Said:

Thanks for the great plugin!

I get \r\n when i import the content to wordpress and that give me a break like … How can i delete \r\n in the importscript?
vapidoz, on November 6th, 2009 at 4:54 am Said:

Azeem thanks for the information. I just want to try to change my joomla to wordpress. I bookmark this page. Thanks, nice to meet you.
Hiroshi, on November 8th, 2009 at 6:12 pm Said:

I’ve still the same problem:

I click the “Step One” link and i Get:
Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /web/htdocs/www.nonsolomac.com/home/wp/export/index.php on line 124
Could not connect

Everything seems to be OK, but I get this error.
What have I to do ? Help !
Natalie, on November 19th, 2009 at 4:42 am Said:

I just tried to run this for my Joomla 1.0.15 site to migrate to WordPress 2.8.6 and it failed.

Error I got was: Query failed inserting into categories

Is there any help for this?

Thanks!
Natalie, on November 19th, 2009 at 4:43 am Said:

I just tried to run this for my Joomla 1.0.15 site to migrate to WordPress 2.8.6 and it failed.

Error I got was: Query failed inserting into categories

Is there any help for this?

BTW I am trying to import into a subfolder.

My main site is in root and I installed WordPress in a folder called /wp/ so that I don’t have downtime for my site.

Thanks!
13mhz, on November 25th, 2009 at 9:19 am Said:

i tried with joomla 1.0.15 and wordpress 2.8.6 and wordpress 2.7 – Query failed…
Adam W. Warner, on December 1st, 2009 at 9:38 am Said:

Hi all,

I have imported many articles and categories successfully, but now I have a need to import more articles and categories. I am wondering if anyone knows how to edit this script to import only categories and articles that don’t already exist.

I know a little SQL and I’ve had a look at the script. It looks like lines 379 and 507 are the two INSERT statements that are doing the actual import into the WP database. I am guessing (with my limited knowledge) that it would be possible to add a WHERE statement to these to check for duplicate post and category titles. Is this possible?

Example: INSERT INTO the wp db WHERE joomla article title is not equal to wp post title.

If anyone can help with this I would be very grateful. Please contact me at awarner20 AT yahoo if you’re interested.
nil, on December 9th, 2009 at 1:56 pm Said:

Hi,

I had same import problem with WP 2.8 too.

I changed the insert query in index.php like that:

$query = “INSERT INTO “.$wptblprefix.”posts (id, post_author, post_title, post_content, post_date, post_modified, post_name, post_status) VALUES (”, ‘$ID5′, ‘{$import[1][$j]}’, ‘{$import[2][$j]}’, ‘{$import[3][$j]}’, ‘{$import[4][$j]}’, ‘$post_name’, ‘publish’)”;

It works with my site import.
Mat, on December 10th, 2009 at 10:10 am Said:

hi
I get the “Query failed” error aswell.
I changed all instances in the index.php of wp_ to wpeco_ as I have more than one wordpress installation in the same database.
Any idea why this is not working???
Running wp 2.8.5 and 1.5 on joomla..
cheers mat
Migrate Joomla site to Wordpress - Irish SEO, Marketing & Webmaster Discussion, on December 16th, 2009 at 4:45 pm Said:

[...] you can indeed. Have done this twice before with little fuss. Something to look into: Joomla2Wordpress Import Wizard v.3 __________________ Web Design [...]
Azeem, on December 16th, 2009 at 9:04 pm Said:

For everyone using 2.8.4 getting errors do this:

download the files

Then download this file and replace index.php
http://www.mediafire.com/?wkneqm23mjj

and also make this code change:
http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/#comment-21848

I will setup the download link for versions past 2.8.4 with a seperate set of files so its easier for people on the newer versions on WordPress.

You could always get an older version of WP, use this script to import and then upgrade to the latest WP version.
Wordpress Adventures | Data into Decisions, on December 17th, 2009 at 11:28 am Said:

[...] http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/ [...]
Joomla to Wordpress - Webmaster Forumu, on December 27th, 2009 at 4:14 pm Said:

[...] ben de hortlataca��m kusura bakmay�n Bu eklenti ile Bu eklenti ile Joomla 1.0.x versiyonundan ge�i� yap�labiliyor. Joomla 1.5.x versiyonunda sorun [...]
Pablo PARRADO, on January 1st, 2010 at 8:59 am Said:

ohhhhh I didn’t read the entire thread, specially Azzem on December 16th, 2009 at 9:04 pm :-/

I’m running 2.9, and joomla 1.5.15

As it didn’t work for me I did this;

-Installed wp 2.3 as a migration wp
-Ran the migration script
-I had a issue (only one post) with a special char in one title, I remove it and ran again with success
-Upgraded wp2.3 to 2.9 (db as well)
-Exported
-Imported in the target wp the generated eXtended RSS (WXR) file

that’s it, it worked out
I need just edit some entries images.
Ayman, on January 1st, 2010 at 9:06 pm Said:

Hi Azeem
Thank you for the fine script. All went well with migrating from Joomla 1.0.15 to WordPress 2.8.4. However, is there any way to get rid of Joomla’s ‘mosimage” which is in every article in my newspaper’s website?

Thanks and happy 2010
DJSADERS, on January 2nd, 2010 at 4:47 am Said:

I have an issue which no one else seems to have had… im running joomla 1.5.15 all database settins are correct, however in step 1 it wont populate the drop down forums with the categories / sections / links

Any help on this one?
Yael, on January 4th, 2010 at 10:07 am Said:

No go for me. I’ve downloaded the latest index.php file and I still get a Query Failed in step two. I’m trying to go from Joomla 1.0.8 to WordPress 2.9 and I just can’t get it to work.

I see Pablo’s comment above about installing wp2.3 as a migration wp. Where would I find that? Perhaps I can try it thath way.

Thanks.
Adam W. Warner, on January 4th, 2010 at 10:13 am Said:

You can find the previous releases here:

http://wordpress.org/download/release-archive/
Yael, on January 4th, 2010 at 10:13 am Said:

correction: I’m trying to go from Joomla 1.0.12 to WP 2.9
Arthur Caby, on January 7th, 2010 at 3:57 pm Said:

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.)

Import articles from a whole section:

Import articles from just one category:

Import links from just a category:

When I went to step 2 I get this screen:

Joomla2WordPress Import Wizard v3 by Azeem Khan
Step Two

Could not select database
Arthur Caby, on January 7th, 2010 at 4:01 pm Said:

I am trying to Import from Joomla 1.5.9
to
WP 2.8.6
Arthur Caby, on January 7th, 2010 at 4:05 pm Said:

When I first started to import th script told me it could not find the wp-config.php file so I copied it to the export folder. and then it went ok to step 1, and stopped at step 2 as per above

Step Two

Could not select database

WHERE do I put the Export Folder????

Thanks,
Arthur
Matthew Baya, on January 14th, 2010 at 10:57 am Said:

First off, thank you for providing and updating this script. Saved me tons of time. You should add a ‘Donate via Paypal’ button to this page.

I followed the instructions in Azeem’s last comment at http://azeemkhan.info/2008/joomla2wordpress-import-wizard-v3/#comment-25564 and replaced my index.php with that file that downloaded there but then I got a different error saying it couldn’t find “../wordpress/wp-includes/functions.php” on line 435.

I found that line and changed it to:

require_once (“../wp-includes/functions.php”);

since I had installed this under my wordpress directory and now it’s working great.

Thanks again.
Matthew Baya, on January 14th, 2010 at 11:33 am Said:

Followup – I imported each category separately and this seemed to work but I got a few categories which gave a query failed part way through. My guess is there was an illegal character somewhere that choked things. Not sure why this happened but in this case it wasn’t the end of the world, just meant I will need to manually import the posts in that category that it didn’t get.

I did notice that for some other posts it only imported part of the post. At first I thought it was just showing the short abbreviated version of the post but in several occasions I found that only part of the post imported (and these were posts from categories that supposedly imported correctly). Again not sure why this happened.

I also noticed something else pretty critical.. this doesn’t import comments.

Oh and having it import attached photos etc would be a great addition too.

In my case I guess i’m going to need to manually copy every post over to make sure it gets everything, or find another tool that will get the comments etc.

Thanks again for providing this, please keep up the good work.
Hiroshi, on January 15th, 2010 at 1:53 pm Said:

@ Casper & Azeem

I have this problem:

after the click on “Step One” i have this message:

Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /web/htdocs/www.nonsolomac.com/home/wp/export/index.php on line 124
Could not connect

What have I to do ?
What do you think about this message ?
Is the problem in the settings of the file ?

I have Joomla 1.0.12 and now WordPress 2.9.
Yes, in the meantime I have uploaded, just a day before you posted the last version of the file index.php.

Help, help, help !
joaquin, on February 12th, 2010 at 2:54 pm Said:

idem error Warning: mysql_connect() [function.mysql-connect]: Access denied for user

??? HELP!
neeshu, on February 19th, 2010 at 5:45 am Said:

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
budi journal, on February 20th, 2010 at 4:12 am Said:

Azzem ,
miggration joomla 1.5.7 to wordpress 2.9.1
i have a problem :

Warning: require_once(../wp-includes/functions.php) [function.require-once]: failed to open stream: No such file or directory in C:\Program Files\xampp\htdocs\eksport\index.php on line 434

Fatal error: require_once() [function.require]: Failed opening required ‘../wp-includes/functions.php’ (include_path=’.;C:\Program Files\xampp\php\pear\’) in C:\Program Files\xampp\htdocs\eksport\index.php on line 434

this on step 3

please help me
darrell, on February 22nd, 2010 at 9:06 pm Said:

Using WordPress 2.9.2. and importing post query failed. I added mysql_error() to the query line and it said “post_category” does not exist. post_category does not exist in WordPress anymore in the post table.
darrell, on February 22nd, 2010 at 9:29 pm Said:

Ok. I removed the post_category from the import query (by category) and things seem to be working fine! I did the same to “section” but I’m not running that.
darrell, on February 23rd, 2010 at 10:59 pm Said:

Currently working on some updates. Such as generating SEF URL redirect list to place in htaccess. And will work on replacing {mosimage} to carry over images for posts.
ric, on February 24th, 2010 at 11:29 am Said:

I try from Joomla 1.5.15 DB to WordPress 2.9.2 DB and give errors at the Step 2.

Say: Query Failed. I remove articles in the errors but nothing change.

How to fix?
Kirsten, on February 24th, 2010 at 10:50 pm Said:

Worked for me from Joomla 1.5x to WordPress 2.9. Thank you so much, you saved me DAYS of work!
ric, on February 25th, 2010 at 3:06 am Said:

How many articles do you export?
Azeem, on March 1st, 2010 at 7:44 pm Said:

Hi all,

I am officially providing commercial support to those who need help in migrating from Joomla to WordPress. Use the contact link on my site to get a quote from me. Just send me your total number of articles.
Min resa från Joomla till Wordpress | Peter Lindén, on March 2nd, 2010 at 10:57 am Said:

[...] det underbara Joomla2Wordpress-skriptet för att kopiera alla gamla inlägg från Joomla in i nya WP-databasen. Detta fungerade [...]
Ali, on March 14th, 2010 at 3:46 pm Said:

Hi thanks brother. I just used it to transfer 2 years of articles from a joomla website for our football team to wordpress. I had to downgrade to an older version of wordpress first but i will now upgrade inshallah.
Matthew Baya, on April 1st, 2010 at 2:37 pm Said:

I’m working more on this blog I converted earlier and realized all the comments did not get imported. I realize that may be beyond the scope of this utility but figured I’d mention it for the wish list for future releases.
John, on April 4th, 2010 at 3:25 am Said:

Hi Azeem great job!
I’m trying to convert the content of my Joomla site (http://sonimotors.net) to a new WordPress site. Plugging in database locations in config.php is not working for me. It is perhaps because I’m a novice with this. Can you please let me know if I can just import jos_content into WP database along with categories and section jos? THat will be easier to import into.

Thanks,
John
Gerhard M., on April 8th, 2010 at 10:51 am Said:

I have tested the script with Joomla 1.5.10 and WordPress 2.9.2, but it doesn’t worked out.

The script started quit good, but always stop with error’s at about the 2 post.

Quiet bad for me. Would be really happy, if anyone could help me.

Cheers.
Rain, on April 8th, 2010 at 4:12 pm Said:

I am trying to switch to wordpress 2.9 from joomla 1.5 but the query isn’t working! It gives error “Query failed inserting into categories” at step 2.

Please help, how to solve it?
Rain, on April 8th, 2010 at 4:13 pm Said:

Help needed please…I am trying to switch to wordpress 2.9 from joomla 1.5 but the query isn’t working! It gives error “Query failed inserting into categories” at step 2.

Please help, how to solve it?
ronnieg, on April 9th, 2010 at 11:58 am Said:

This worked for me Joomla 1.5.15 to WP 2.8.1, after one bug fix shown below. Would probably work with WP 2.9.2 also, and I will try that later.

DO: Download the replacement index.php file. I found that it now seems to have all the required code changes in the inserts, so I didn’t have to do anything about those.

However, there is still one bug:

On line 305 of the replacement index.php, change it to be:

require_once (“../wp-includes/functions.php”);

and it will work, no matter what your WP install directory may be.

If your conversion needs are basic, and your Joomla site was primarily a social / blog / article site to begin with, this tool is OK.

But for my needs, I need to import 370+ static content Joomla pages into WP as pages, not posts. That I could solve with a plug-in that is available and allows you to change posts to pages and vice-versa. But I will probably modify this tool to do that either hard-coded or as an option, which shouldn’t be too hard to do.

However, this tool also lacks the ability to bring over the custom Joomla content SEO tags: Title, Description and Keywords. Since WP doesn’t (yet) support these directly, I always install the All-in-one SEO Pack plugin, which places those tags into the wp_postmeta table. I will be working on an enhancement that will do that automatically, as well as the option to allow me to import directly as pages, not posts.

Also, if you have a very large and complex Joomla site, and used Joomla’s dynamic menus in selectable module positions, this tool does not handle that, and neither does WordPress, at least not without plug-ins.

There are now several WP plug-ins that allow you to implement similar dynamically placed menus in WP. Once I pick one of those, and if I judge the development effort to be less than re-building the menu structures manually, I may also look at building an enhancement to this utility that would allow me to convert these to WP as well, perhaps reading the Joomla menu table, and for menu items that are static page content, import those to WP as pages, with the same parent page links as defined in the Joomla menu structures. WP 3.0 is supposed to have some menu system improvements, but from what I have read, still nowhere near what Joomla can do, so plug-ins may still be the only alternative for some time.
Joomla'yı Wordpress'e Aktarmak | Webledik, on April 22nd, 2010 at 3:26 pm Said:

[...] Geliştirici: Azeem Khan | Joomla2Wordpress Anasayfası [...]
Joomla'yı Wordpress'e Aktarmak | Webledik, on April 22nd, 2010 at 3:26 pm Said:

[...] Geliştirici: Azeem Khan | Joomla2Wordpress Anasayfası [...]
Teh Dude, on April 24th, 2010 at 12:32 pm Said:

On line 305 of the replacement index.php, change it to be:
require_once (”../wp-includes/functions.php”);

AND

On line 435 of the replacement index.php, change it to be:
require_once (”../wp-includes/functions.php”);
Alejandro, on April 27th, 2010 at 9:06 am Said:

I did it with Joomla 1.5.9 and wordpress 2.9.2. Just download the modified index.php file (check the comments to get the link to the file) and, if your wordpress installation is on /wordpress, just change the lines:

if (!file_exists(‘../wordpress/wp-config.php’))

require_once(‘../wordpress/wp-config.php’);

I did that and it worked perfectly.
Thank you so much guys!
darrell, on April 29th, 2010 at 3:59 pm Said:

I have a new version 4 tested on latest Joomla 1.15.x and WordPress 2.9.2. Tested against 3000 articles and fixed various bugs along the way. I also have option to generate htaccess redirect file from old urls to new ones. Also implemented replacing {mosimage} with the actual image using wordpress alignments. Problem is I’m having trouble getting it posted online.
Jackson, on May 2nd, 2010 at 3:47 pm Said:

Thanks for all the work everyone has put into this. I just read through all the comments, made the various suggested changes and got everything “working” in Joomla 1.5.15 and WP 2.92. Unfortunately, even though the whole export process worked without error, the articles were being cut off part way through and/or garbled. They didn’t include any weird characters although the truncation did seem to happen at commas.

Either way, I gave up and am doing the migration manually (it wasn’t too many pages any way). Just figured I’d put my experience out there in case it would help anyone.

Thanks again!
Rain, on May 4th, 2010 at 7:34 pm Said:

Today I tried again…the databases are connecting but when I try to export articles from one category of joomla to one category of wordpress, I get blank screen (at step 3).

At step 3 – I get this: Joomla2WordPress Import Wizard v3 by Azeem Khan

I tried to make changes are mentioned ../wordpress/wp-config.php but I get error (wp-config.php could not be found).
Rain, on May 4th, 2010 at 7:36 pm Said:

Could anyone tell me what’s happening. Am using Joomla 1.5.15 & WP 2.9.2
yeo, on May 7th, 2010 at 10:54 am Said:

i finally got the script working. good stuff!

however, it doesn’t import comments. any idea how to do this?

thx!

yeo
Leo, on May 12th, 2010 at 8:55 am Said:

Hi all.
I’m in the same situation as Rain, but with no luck.
Yeo, how did you do? Please help us

Leo
jaxon, on May 12th, 2010 at 11:56 am Said:

Rain and Leo, I did all the hacks listed above with the same setup as Rain and didn’t have much luck. Only partial posts came over… I ended up migrating manually – didn’t take too long. Good luck!
Joomla to Wordpress Convertor » visiblecompany.com, on May 17th, 2010 at 8:50 am Said:

[...] 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 v3.1 JROAKES (added page support | cleaned up titles and [...]
Larry Quiambao, on May 27th, 2010 at 6:41 pm Said:

I like your post. Your blog is fantastic.
güncel blog, on June 3rd, 2010 at 11:07 am Said:

thanks admin very post
今天終於將我的joomla網站給轉到了WordPress！ « 老劉的嘮叨, on June 17th, 2010 at 8:32 am Said:

[...] 使用的轉換程序是Joomla2WordPress – A Joomla importer for WordPress。其中還有一個程序應該也是可以用，但是我沒有去使用！Joomla2Wordpress Import Wizard v.3。下面說說我的轉換方式！這裡我是在本機測試的，所以必須安裝php服務器（我使用的是XmiServer）一、將網站的程序備份下來，使用phpmyadmin導入。 [...]
Blog do Yuri » Joomla2WordPress (de ISO 8859-1 para UTF-8), on June 23rd, 2010 at 10:48 am Said:

[...] claro, me deu uma trabalheira dos diabos… Tentei várias sugestões e, por fim, fiquei com o Joomla2WordPress. O problema é que ele só exportava textos já codificados em UTF-8 — a codificação [...]
Seo Danışmanlığı, on June 24th, 2010 at 4:48 am Said:

Thank you very much for this information. Good post thanks for sharing.
esenyurt, on July 6th, 2010 at 2:45 pm Said:

coming. I finally made the transition to WordPress from my joomla site with a little help from this nifty script. My site is essentually a `blog´as they call it so I thought I would start using the best blogging
şampiyonlar ligi maç özetleri, on July 6th, 2010 at 5:43 pm Said:

Query failed inserting into categories for every option I try on your script.
football manager, on July 18th, 2010 at 12:38 pm Said:

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.
kralbiziz, on July 23rd, 2010 at 4:05 pm Said:

Thanks!

Very good..Thanks for post..
Bruno, on July 25th, 2010 at 10:18 am Said:

Hello and thank’s for this script !
I have a problem with this “Query failed inserting Section” . Maybe because this script doesn’t works between WP 3.0 and Joomla 1.5.9?
seo, on July 27th, 2010 at 10:42 am Said:

Thank you, very much.
Graham, on July 30th, 2010 at 3:34 am Said:

Has anyone used this script with WordPress 3.0 yet? I’m wondering if it will work to migrate from Joomla 1.5.20 to WordPress 3.0. Thanks, Graham
Graham, on July 30th, 2010 at 4:38 am Said:

I’m giving it a go with J1.5.20 and WP3.0.1, but I get this error:
“Query failed inserting into categories”. Any suggestions?
SEO, on July 30th, 2010 at 11:38 am Said:

Thanks for article
ibrahim, on August 1st, 2010 at 4:06 am Said:

thanks for article. it is very nice.
telecom expense management, on August 4th, 2010 at 12:20 pm Said:

Very interesting. I’ve always used WordPress but have been looking at using Joomla for creating telcom expense management company blogs and websites instead. Do you believe that WordPress is better now that you’ve switched?
amerikan kapı, on August 7th, 2010 at 7:23 pm Said:

Thank you,very much.
car photos, on August 13th, 2010 at 3:51 am Said:

Thanks for article
resul, on August 21st, 2010 at 9:16 pm Said:

Thank you, very much.
Yucetasarim, on August 30th, 2010 at 12:11 pm Said:

I found your blog posting useful, but it would be even more useful if the jQuery code were a little more nicely formatted. The comment lines and code lines pretty much look the same.
xat sohbet, on September 2nd, 2010 at 2:20 am Said:

Thank You All Good informations…

My Widget

Related Posts

Joomla2WordPress Import Wizard v.3

242 Responses to “Joomla2WordPress Import Wizard v.3”

Leave a Reply

Recent Comments

My Widget

Related Posts

Joomla2WordPress Import Wizard v.3

242 Responses to “Joomla2WordPress Import Wizard v.3”

Leave a Reply

Recent Comments

Tags