Importing articles from WordPress fails

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
derulf
Regular
Posts: 7
Joined: Tue Dec 26, 2006 4:51 am

Importing articles from WordPress fails

Post by derulf »

Hi there,

as the search function doesn't seem to be online at the moment I'm gonna post my problem right away:

Yesterday I installed S9Y 1.0.4 successfully. Afterwards I tried to import my articles from my old WordPress installation. The import process succeeded but all the umlauts (like ä, ö, ü, ß) are not displayed the right way. I tried to import with UTF-8 and ISO-8859-1. I even tried the general RSS import. They all failed because of the mentioned characters. First I thought that this was caused by Safari, the browser I'm using, but Firefox and Camino do have the same problems.

What do I do wrong? Is there any patch available for that problem? Is that problem already known? I'm running WordPress 2.0.5 DE (German edition).


Thanks for your answers, merry christmas
Ulf
Davy
Regular
Posts: 109
Joined: Fri Oct 13, 2006 2:06 pm
Location: The Netherlands

Post by Davy »

Are that special characters correctly displayed in the RSS-feeds? Maybe WP is the problem (I hope so, because s9y is much better :P ).
derulf
Regular
Posts: 7
Joined: Tue Dec 26, 2006 4:51 am

Post by derulf »

Davy wrote:Are that special characters correctly displayed in the RSS-feeds? Maybe WP is the problem (I hope so, because s9y is much better :P ).
Unfortunately they're not. In my WP-Feeds they're displayed correctly, in the S9Y-Feeds they are not.

Any further ideas?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Did you maybe try to use the 1.1 serendipity version? It has a fix in the proper import for special characters that should help/Work in your case...?

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
derulf
Regular
Posts: 7
Joined: Tue Dec 26, 2006 4:51 am

Post by derulf »

garvinhicking wrote:Hi!

Did you maybe try to use the 1.1 serendipity version? It has a fix in the proper import for special characters that should help/Work in your case...?

HTH,
Garvin
No, won't get any better :( With 1.1 I tried both codepages again, same result... Here a little extract:

Wow... dafür hab ich sogar meine Sendepause unterbrochen

Original version looks like this:

Wow… dafür hab ich sogar meine Sendepause unterbrochen
Davy
Regular
Posts: 109
Joined: Fri Oct 13, 2006 2:06 pm
Location: The Netherlands

Post by Davy »

I think you should parse that special characters, so they're valid.

E.G.: " is " or a code like Ł
If you can do so, a browser will display it correctly.
derulf
Regular
Posts: 7
Joined: Tue Dec 26, 2006 4:51 am

Post by derulf »

Davy wrote:I think you should parse that special characters, so they're valid.

E.G.: " is " or a code like ?
If you can do so, a browser will display it correctly.
Any idea how to do that?
Davy
Regular
Posts: 109
Joined: Fri Oct 13, 2006 2:06 pm
Location: The Netherlands

Post by Davy »

derulf wrote:
Davy wrote:I think you should parse that special characters, so they're valid.

E.G.: " is " or a code like ?
If you can do so, a browser will display it correctly.
Any idea how to do that?
With the "Search and Replace"-function of Microsoft Word. :)

But maybe there's another solution. If your blog's charset is UTF-8, change it to Native, and try again. (So not the RSS-charset, but that one in the Blog Configuration.)
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Are you only importing the WP-data frmo the RSS feed, or are you trying the direct DB import?

Which PHP version is your server using where you have installed s9y?

I have heard of many WP users that converted properly, so I'm sure we can find the problem in your case somehow. Generally, it does work :)

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
derulf
Regular
Posts: 7
Joined: Tue Dec 26, 2006 4:51 am

Post by derulf »

garvinhicking wrote:Hi!

Are you only importing the WP-data frmo the RSS feed, or are you trying the direct DB import?

Which PHP version is your server using where you have installed s9y?

I have heard of many WP users that converted properly, so I'm sure we can find the problem in your case somehow. Generally, it does work :)

Best regards,
Garvin
I tried both. Both failed by the mentioned effects.

I'm using PHP/4.3.10-18 on my server.

Do you need any further information? Ask me ;) And thanks for your help.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Are you maybe able to provide me a DB SQL dump of your WP installation? Strip all passwords or sensitive information, of course. I could then use that to test what's going on.

Is your s9y blog using "native" (ISO-8859-1) charset or UTF-8? (Can be changed in the configuration).

And which MySQL version are you using on the WP server and on the s9y server (maybe they're the same, of course).

And maybe you could check your phpinfo() output to see if either iconv or recode is enabled/available? Either one is required to do the necessary string conversion from/to UTF-8/ISO.

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
derulf
Regular
Posts: 7
Joined: Tue Dec 26, 2006 4:51 am

Post by derulf »

garvinhicking wrote:Hi!

Are you maybe able to provide me a DB SQL dump of your WP installation? Strip all passwords or sensitive information, of course. I could then use that to test what's going on.

Is your s9y blog using "native" (ISO-8859-1) charset or UTF-8? (Can be changed in the configuration).

And which MySQL version are you using on the WP server and on the s9y server (maybe they're the same, of course).

And maybe you could check your phpinfo() output to see if either iconv or recode is enabled/available? Either one is required to do the necessary string conversion from/to UTF-8/ISO.

Best regards,
Garvin
Hi,

you will get all the information tomorrow. Unfortunately I do not have any time today as I have to write a test in analysis tomorrow morning. Anyway, thanks for your help, I really appreciate it.


Ulf

PS: How can I send you the URL where to download the dump?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Just send me the data/URL via a PM in this board. :-)

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
derulf
Regular
Posts: 7
Joined: Tue Dec 26, 2006 4:51 am

Post by derulf »

garvinhicking wrote:Hi!

Just send me the data/URL via a PM in this board. :-)

Best regards,
Garvin
Oh my g... hit me, if you like. That was it. What? The character settings in S9Y. I just switched from UTF-8 to National Character Settings and now it work's. My fault, sorry... :/
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

No problem at all. Sorry that I wasn't specific enough to solve it earlier for you. :-(

Have fun using s9y and best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply