Prime 357

We'll learn something

Site Menu

  • Home
  • Recent Posts
  • Forum
    • Programming Languages
      • C++
    • Website Design & Content Management
      • Wordpress >> Drupal
  • Blogs
  • Topics
    • C++
    • Changing hosts - Dummies Guide
    • Wordpress >> Drupal
  • Download Centre
  • Contact us
Home Forums Website Design & Content Management Systems Wordpress to Drupal


Image - OpenID

User login

What is OpenID?
  • Log in using OpenID
  • Cancel OpenID login
  • Create new account
  • Request new password

Navigation

  • Recent posts

Topics

  • C++ (The Book)
  • Changing Hosts - a Dummies Guide
  • Wordpress to Drupal

Recent comments

  • Got it solved This page here
    2 hours 20 min ago
  • Links working
    1 day 2 hours ago
  • Thanks... I may be able to
    1 day 7 hours ago
  • 3306 by default
    1 day 18 hours ago
  • Is this the right place to
    1 day 18 hours ago
  • Figured
    3 weeks 6 days ago
  • I'm guessing at this stage
    3 weeks 6 days ago
  • WordPress MU?
    4 weeks 2 hours ago
  • Thanks
    10 weeks 1 day ago
  • I'm running the conversion
    11 weeks 4 days ago

New forum topics

  • What should the port number be
  • WordPress MU?
  • funny little bug in mac version
  • Error: Unable to Insert into Node_revisions table when converting from wordpress 2.6.0 to drupal 6.4
  • index.php?
more

Who's online

There are currently 0 users and 0 guests online.

Who's new

  • oODeathStormOo
  • leruffiant
  • Emtee
  • mnogodet
  • ZioMimmo

[Solved] Wordpress 2.3.3 convert to drupal 5.x inverted comma error

  • View
  • Revisions
14 replies
Tue, 10 Jun, 2008 - 21:06
doexcel
Joined: 27 May 2008
User offline. Last seen 5 weeks 9 hours ago.

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

4.png

the drupal index page article is empty
3.png

Why, i hope for admin's help.Thanks.
By doexcel

Top
  • 619 reads
Wed, 11 Jun, 2008 - 11:19
#1
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
Upload the offending article

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.
Image - Editor buttons

Steve
My running website

Top
Wed, 11 Jun, 2008 - 12:36
#2
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
Upload SQL file

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

Steve
My running website

Top
Thu, 12 Jun, 2008 - 14:19
#3
doexcel
Joined: 27 May 2008
User offline. Last seen 5 weeks 9 hours ago.
Thanks Steve.The Wordpress

Thanks Steve.The Wordpress 2.3.3 test sql is uploaded.

Top
Thu, 12 Jun, 2008 - 14:32
#4
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
I've got the file and now

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.

Steve
My running website

Top
Thu, 12 Jun, 2008 - 15:17
#5
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
Interim status report.

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.

Steve
My running website

Top
Thu, 12 Jun, 2008 - 17:05
#6
doexcel
Joined: 27 May 2008
User offline. Last seen 5 weeks 9 hours ago.
Yes,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.

Top
Thu, 12 Jun, 2008 - 18:17
#7
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
Categories & Tags

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.

Steve
My running website

Top
Thu, 12 Jun, 2008 - 18:24
#8
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
Inverted comma

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.

Steve
My running website

Top
Thu, 12 Jun, 2008 - 22:14
#9
doexcel
Joined: 27 May 2008
User offline. Last seen 5 weeks 9 hours ago.
I posted the offending text in two formats

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!

Top
Fri, 13 Jun, 2008 - 02:07
#10
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
It worked for me

image-0073_large.jpg

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.

image-0074_large.jpgHere 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.

n/a
Top
Fri, 13 Jun, 2008 - 13:27
#11
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
Text from zip file - worked as well

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.

image-0075.jpgimage-0076.jpgYou 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.

n/a
Top
Fri, 13 Jun, 2008 - 19:21
#12
doexcel
Joined: 27 May 2008
User offline. Last seen 5 weeks 9 hours ago.
I can not explain inverted comma in my convertion

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.

Top
Fri, 13 Jun, 2008 - 20:51
#13
Steve
Joined: 27 Mar 2008
User offline. Last seen 36 min 46 sec ago.
I'll convert for you

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.

Steve
My running website

Top
Mon, 16 Jun, 2008 - 22:08
#14
doexcel
Joined: 27 May 2008
User offline. Last seen 5 weeks 9 hours ago.
Thanks,Steve. If possible,I

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.

Top

 Subscribe in a reader

free hit counter


RoopleTheme