[Solved] Wordpress 2.3.3 convert to drupal 5.x inverted comma error
I use WpDrupal-Win-1-02 and WpDrupal-Win-1-03 program for test to converting my wordpress 2.3.3 to drupal 5.x,but convertion stopped probably for the inverted comma in article.Even i upgrade wordpress 2.3.3 to 2.5.1 ,it's the same error! The error images as the following:(If you login prime357.org,you can see in accathment,Thanks)
inverted comma error image

the drupal index page article is empty

Why, i hope for admin's help.Thanks.
By doexcel
Another option, if you wish, is upload your Wordpress sql file, but in a zipped format or you could email it privately to me (remember login first).
Thanks Steve.The Wordpress 2.3.3 test sql is uploaded.
I've got the file and now getting things set up.
Do you have Version 2.5 as well. I believe you mentioned you upgraded to 2.5. Might as well work with the latest version.
If you check your user id column in the wp_posts table, most entries are by user id 2. If you check wp_users table you will note that there is only one user, admin, the user_id being 1. There is no user_id 2. That is the main reason why "N/A appears on your Drupal front page.
When I added myself as a user in your Wordpress file (me being user_id 2) then converted, the Drupal front page was correctly filled with your articles/posts.
As for the conversion breaking or not finishing because of a suspect character (inverted comma), I couldn't reproduce that error. Admittedly, I used my latest version (1.04 - about to be released).
Let me know if the above solved the problem regarding the "N/A" part.
Thanks for your quickly reply.
Yes,solved the problem regarding the "N/A" part according to your guidance.
Under wordpress2.3.3 background,I first add a user named"vlieh2" for id2,then i delete id2,and wordpress give you the choice,i select assign the id2's article to id1,and then use 1.03 convert to drupal5.1,it convert 126 articles success!
You see,now i'm probably trouble in wordpress article inverted comma.For a rookie,i can believe when i delete the 127th articel's inverted comma,it maybe go on converting until fall across next inverted comma:) I hope to see 1.04 can solve the little problem.
Another two little is:
1.you see,at the end of some articles,there is the same "Doexcel,做卓越的自己。本文来自:Doexcel-Do,excel!",and convertion cut off the sentence some words,only left "Doexcel,做卓越的自己。本文" .
2.Convertion probably does not differentiate wordpress's categoriesn and tags,ant all treated as tags.You see ,many tags,redundant,insignificant tags does not have the profit to seothe seo Can you change in the future vertion?
Thanks for your quickly reply again.
You have to appreciate how the taxonomy (categories & tags) works within Drupal. If I follow you correctly, you are indicating that in Wordpress you had a category named "something" and also you had a tag named "something", the same name but one is in a category and the other is a tag.
The conversion process copied all Wordpress tags to a separate vocabulary and all the categories to another vocabulary. If your posts in Wordpress were also linked to a tag "something" and also you categorised the post to "something", all the converter has done is copy that linking. How it's presented in Drupal, yes, I agree, it appears to have doubled up, but that's how it was in Wordpress, though presently slightly differently.
In order to clean that up simply delete the category term you don't need. If you want to keep that category name then you would have to navigate to each individual post and remove the category that way, which I'm sure you wouldn't want to do, too time consuming.
Could you upload or paste the offending text in a comment that you think is causing the converter not to work. I can then create a Wordpress post containing that text and check things out.
Thank you.
I posted the offending text in two formats(ZIPPed is here),one for pure text,directly copy from wordpress 2.3.3 proscenium,another is copy from wordpress 2.3.3 background in html source code.And you can creat 2 articles to test.One is pure text ,another in html code format,then post in WYSWYG module.
Just as the following:
************1.The article in text ************
传微软Office在线版近期正式上线 阻击Google Docs
红帽公司全球产品管理总监Nick Carr透露,据他得到的消息称,包括Office在内的微软关键应用软件都即将在近期实现在线服务.消息称,按照微软的计划,企业应用软件做为一种服务上线后,将仿效Salesforce采取收费模式,而常用的PC应用软件,上线后将以广告做为收入来源.此外,微软还计划进一步扩大其网络数据中心,为所有的后续产品提供存储.
简单的说,微软实际上是在对谷歌的Google Apps和Google Docs的挑战作出回应.据分析师估算,现在Google Apps和Google Docs带来的收入已经占到Google总收入的2%-3%,大约为每年4亿美元,而一年前这一数字还是4000万美元.虽然这一数字与微软Office 一年160亿美元的收入相比,仍显得微不足道,但透过它可以看到一个明显的趋势,即用户喜欢免费的软件,以及不同文档之间可以协作的功能.
现在Google为用户提供的在线服务在很多方面都超越了Office,而且还不向用户收取费用.这就直接导致微软陷入了畅销书“the Innovator’s Dilemma”所描述的“创新者的窘境”之中.
当然聪明的微软人不可能坐以待毙.消息来源认为,他们的反击应该就会在本周迟些时候举行的一次Mix会议上进行.届时微软将展示其用来与Adobe Air竞争的离线版Silverlight,还有可能借此机会推出其以Silverlight为平台的在线版Office.
另外,在这场应用软件在线化盛宴中,还有著名的网络软件和商业服务提供商 Salesforce高居上座.业界现在普遍猜测,微软和Google很可能会为收购Salesforce发起一场恶战.这也可以部分解释市场为何如此看好Salesforce,致使其市盈率达到恐怖的600.
不过现在微软正在与雅虎就收购事宜进行艰难的博弈,看起来它很难再同时发起对Salesforce的攻势.分析人士甚至认为,微软或许应该放弃雅虎,转而认真考虑收购Salesforce.
Doexcel,做卓越的自己。本文链接:Doexcel-Do,excel!
************2.The article in wordpress html code format**************

红帽公司全球产品管理总监Nick Carr透露,据他得到的消息称,包括Office在内的微软关键应用软件都即将在近期实现在线服务.消息称,按照微软的计划,企业应用软件做为一种服务 上线后,将仿效Salesforce采取收费模式,而常用的PC应用软件,上线后将以广告做为收入来源.此外,微软还计划进一步扩大其网络数据中心,为所 有的后续产品提供存储.
简单的说,微软实际上是在对谷歌的Google Apps和Google Docs的挑战作出回应.据分析师估算,现在Google Apps和Google Docs带来的收入已经占到Google总收入的2%-3%,大约为每年4亿美元,而一年前这一数字还是4000万美元.虽然这一数字与微软Office 一年160亿美元的收入相比,仍显得微不足道,但透过它可以看到一个明显的趋势,即用户喜欢免费的软件,以及不同文档之间可以协作的功能.
现在Google为用户提供的在线服务在很多方面都超越了Office,而且还不向用户收取费用.这就直接导致微软陷入了畅销书“the Innovator's Dilemma”所描述的“创新者的窘境”之中.
当然聪明的微软人不可能坐以待毙.消息来源认为,他们的反击应该就会在本周迟些时候举行的一次Mix会议上进行.届时微软将展示其用来与Adobe Air竞争的离线版Silverlight,还有可能借此机会推出其以Silverlight为平台的在线版Office.
另外,在这场应用软件在线化盛宴中,还有著名的网络软件和商业服务提供商 Salesforce高居上座.业界现在普遍猜测,微软和Google很可能会为收购Salesforce发起一场恶战.这也可以部分解释市场为何如此看好Salesforce,致使其市盈率达到恐怖的600.
不过现在微软正在与雅虎就收购事宜进行艰难的博弈,看起来它很难再同时发起对Salesforce的攻势.分析人士甚至认为,微软或许应该放弃雅虎,转而认真考虑收购Salesforce.
Doexcel,做卓越的自己。本文链接:Doexcel-Do,excel!
I've quickly tested the above two pieces of text by creating two posts in Wordpress and then converting. I used 1.04 to convert (now available for download) and all went through without a problem.
Here are two screen shots of Drupal pages with your entries. Unfortunately, I can't read it but I'm sure you will be able to determine whether I'm using the right pieces of text. It's just past midnight here, so I'll leave further testing until tomorrow.
Sorry, I can't reproduce the error from the text that you supplied. For this test, I used the two text snippets you included in the zip file. All went through normally and below are screen shots of the final Drupal entries.

You will note that the text exceeds the right border of the page, there must be some long strings in there. The effect was the same for Wordpress.
Thanks for your quickly and arduous work.
I used the latest 1.04 to test,unfortunately i fall across the same error,convertion stopped at the article's inverted comma.I search the article ,and then reconvert,convertion stopped at another article's inverted comma.
I insert the following test text:
'doexcel,the world'
in some articles it will stop at 'doexcel,the world' .In fact,it will stopped at inverted comma.
So the only way for me is:When i found the article ,i search the inverted comma and then deleted it ,then "Empty Drupal table"→Convertion.
I can not explain that,perhaps we are in the different entironment.Such as :windows vertion(i use simplified chinese Vertion windows),alphabetic character(i chinese ,and most foreign friends are english only),etc.The first time,when i upload the wordpress sql for you to test,i found that perhaps it's entironment problem.You can sucessful convert,while me not:)
Thanks.
I'm sorry I can't figure it out . If you want I could convert your Wordpress for you and forward to you the Drupal sql file. All you need to do then is create an empty database and import the sql file.
Thanks,Steve.
If possible,I need your help.In the future, probably i will send my "big" wordpress sql for you to help converting to drpal.
Remember me:)
Thanks again.



Hi Doexcel, sorry for the late reply. Anyway, can you upload as a text file but in zipped format the offending post entry that you think is causing the problem. Once uploaded I can then check it out at my end.
To upload and link to the file, hope this helps: You'll see that each user has their own sub-directory to store images and files.

Steve
My running website