Import of old blog

[henning]

Version 1 is great - It just WORKS!

Now I'm trying to put my old home-made blog into version 1.

First I tried to import my rss-feed, but nothing shows up in the body-field (or what the message-area is called).
Only if I just put the "description" part in the rss-feed, but then the linebreaks an images are gone.
rss2 is here: http://www.brittoghenning.dk/weblog/xml/index.xml

Then I looked at the MySQL-table "entries".
But I use a date formatted as yyyy-mm-dd in my MySQL and s9y uses a timestamp. I don't know how to translate, so just sending data from one MySQL to another seems difficult for me.

Do you have any suggests?

[garvinhicking]

You should try to alter your RSS feed so that only either 'Description' or 'Content:Encoded' is set. Preferably you should preserve 'Content:Encoded' and drop 'Description', because 'Description' contains no HTML markup.

If you use both, the portion of "Content:Encoded" should be put into the 'Extended Entry' section of Serendipity. Did you look there if your original text is imported?

Converting MySQL Timestamps is not so hard, just look at UNIX_TIMESTAMP() and DATE_FORMAT() options from MySQL.

Best regards,
Garvin

[henning]

Only <description> gives the non-html-output in s9y.
Only <content:encoded> gives nothing but the date.
Both <description> and <content:encoded>gives nothing but the date. Ie no data in the extended part.

I'll try to look up the timestamp- / date-funktions. Should I use php to convert?

[garvinhicking]

Hm, did you play with the import settings? Try setting/changing the charset of the RSS feed and playing with the 'body only' option?

It doesn't matter if you use PHP or SQL directly to convert. Whatever you know better will be fine.

Best regards,
Garvin