While looking for my lost posts I’ve found that you can get back the last fetched feed from Google Reader from the URL below:
http://www.google.com/reader/atom/feed/FEED_URL?n=MAX_ITEMS
Then I got back about 50 posts from my lost pixzone.com blog in atom format.
My next step is to create a small converter from Atom to WordPress Extended RSS (WXR) format that I can use to import back the posts in WordPress, I already found some Ruby code for reference.
Update: I’ve created a small perl script to convert the Atom generated by Google Reader to the WordPress Extended RSS (WXR) format, you’ll find the Perl source below. You’ll also need to patch the wp_create_post() function in wp-include/post.php to keep the post IDs unchanged if you have included the post ID in the permalink and you don’t want to have a lot of 404s in your logs!
<span><span class="S2">#!/home/y/bin/perl</span><br />
<br />
<span class="S5">use</span><span class="S0"> </span><span class="S11">Data</span><span class="S10">::</span><span class="S11">Dumper</span><span class="S10">;</span><br />
<span class="S5">use</span><span class="S0"> </span><span class="S11">XML</span><span class="S10">::</span><span class="S11">Smart</span><span class="S10">;</span><br />
<span class="S5">use</span><span class="S0"> </span><span class="S11">Date</span><span class="S10">::</span><span class="S11">Manip</span><span class="S0"> </span><span class="S30">qw(ParseDate UnixDate)</span><span class="S10">;</span><br />
<span class="S5">use</span><span class="S0"> </span><span class="S11">HTML</span><span class="S10">::</span><span class="S11">Entities</span><span class="S10">;</span><br />
<br />
<span class="S5">my</span><span class="S0"> </span><span class="S12">$xml</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S11">XML</span><span class="S10">::</span><span class="S11">Smart</span><span class="S10">-></span><span class="S11">new</span><span class="S10">(</span><span class="S7">'feed.xml'</span><span class="S10">);</span><br />
<br />
<span class="S5">print</span><span class="S0"> </span><span class="S22"><<HERE</span><span class="S10">;</span><br />
<span class="S24"><?xml version="1.0" encoding="ISO-8859-1"?></span><br />
<span class="S24"><rss version="2.0"</span><br />
<span class="S24"> xmlns:content="http://purl.org/rss/1.0/modules/content/"</span><br />
<span class="S24"> xmlns:wfw="http://wellformedweb.org/CommentAPI/"</span><br />
<span class="S24"> xmlns:dc="http://purl.org/dc/elements/1.1/"</span><br />
<span class="S24"> xmlns:wp="http://wordpress.org/export/1.0/"</span><br />
<span class="S24">></span><br />
<br />
<span class="S24"><channel></span><br />
<span class="S24"> <title>the pix zone</title></span><br />
<span class="S24"> <link>http://www.pixzone.com/blog</link></span><br />
<span class="S24"> <description>Federico 'pix' Feroldi weblog</description></span><br />
<span class="S24"> <pubDate>Mon, 19 Apr 2007 18:29:58 +0000</pubDate></span><br />
<span class="S24"> <generator>http://wordpress.org/?v=2.1.3</generator></span><br />
<span class="S24"> <language>en</language></span><br />
<span class="S24">HERE</span><br />
<br />
<span class="S5">foreach</span><span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$entry</span><span class="S0"> </span><span class="S10">(</span><span class="S13">@</span><span class="S10">{</span><span class="S12">$xml</span><span class="S10">->{</span><span class="S7">'feed'</span><span class="S10">}->{</span><span class="S7">'entry'</span><span class="S10">}})</span><span class="S0"> </span><span class="S10">{</span><br />
<span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$e_title</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S11">encode_entities</span><span class="S10">(</span><span class="S12">$entry</span><span class="S10">->{</span><span class="S7">'title'</span><span class="S10">},</span><span class="S0"> </span><span class="S7">'<>&"'</span><span class="S10">);</span><br />
<span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$e_link</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S12">$entry</span><span class="S10">->{</span><span class="S7">'link'</span><span class="S10">}->{</span><span class="S7">'href'</span><span class="S10">};</span><br />
<br />
<span class="S0"> </span><span class="S12">$e_link</span><span class="S0"> </span><span class="S10">=~</span><span class="S0"> </span><span class="S17">m#blog/(\d+)/([^/]+)#</span><span class="S10">;</span><br />
<span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$e_id</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S12">$1</span><span class="S10">;</span><br />
<span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$e_slut</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S12">$2</span><span class="S10">;</span><br />
<br />
<span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$e_content</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S11">decode_entities</span><span class="S10">(</span><span class="S12">$entry</span><span class="S10">->{</span><span class="S7">'content'</span><span class="S10">});</span><br />
<br />
<span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$e_updated</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S12">$entry</span><span class="S10">->{</span><span class="S7">'updated'</span><span class="S10">};</span><br />
<span class="S0"> </span><span class="S12">$e_updated</span><span class="S0"> </span><span class="S10">=~</span><span class="S0"> </span><span class="S18">s/T/ /</span><span class="S10">;</span><br />
<span class="S0"> </span><span class="S12">$e_updated</span><span class="S0"> </span><span class="S10">=~</span><span class="S0"> </span><span class="S18">s/Z//</span><span class="S10">;</span><br />
<br />
<span class="S0"> </span><span class="S5">my</span><span class="S0"> </span><span class="S12">$e_updated_rfc</span><span class="S0"> </span><span class="S10">=</span><span class="S0"> </span><span class="S12">$e_updated</span><span class="S10">;</span><span class="S0"> </span><span class="S2"># UnixDate($e_updated_date, "%d-%b-%Y %H:%M:00");</span><br />
<br />
<br />
<span class="S0"> </span><span class="S5">print</span><span class="S0"> </span><span class="S22"><<HERE</span><span class="S10">;</span><br />
<span class="S24"><item></span><br />
<span class="S24"><title>$e_title</title></span><br />
<span class="S24"><link>$e_link</link></span><br />
<span class="S24"><pubDate>$e_updated_rfc</pubDate></span><br />
<span class="S24"><dc:creator>admin</dc:creator></span><br />
<span class="S24"><category><![CDATA[pixzone]]></category></span><br />
<span class="S24"><guid isPermaLink="false">http://www.pixzone.com/blog/?p=$e_id</guid></span><br />
<span class="S24"><description></description></span><br />
<span class="S24"><content:encoded><![CDATA[$e_content]]></content:encoded></span><br />
<span class="S24"><wp:post_id>$e_id</wp:post_id></span><br />
<span class="S24"><wp:post_date>$e_updated_rfc</wp:post_date></span><br />
<span class="S24"><wp:post_date_gmt>$e_updated_rfc</wp:post_date_gmt></span><br />
<span class="S24"><wp:comment_status>open</wp:comment_status></span><br />
<span class="S24"><wp:ping_status>open</wp:ping_status></span><br />
<span class="S24"><wp:post_name>$e_slut</wp:post_name></span><br />
<span class="S24"><wp:status>publish</wp:status></span><br />
<span class="S24"><wp:post_parent>0</wp:post_parent></span><br />
<span class="S24"><wp:post_type>post</wp:post_type></span><br />
<span class="S24"></item></span><br />
<span class="S24">HERE</span><br />
<span class="S10">}</span><br />
<br />
<span class="S5">print</span><span class="S0"> </span><span class="S22"><<HERE</span><span class="S10">;</span><br />
<span class="S24"></channel></span><br />
<span class="S24"></rss></span><br />
<span class="S24">HERE</span><br />
<span class="S0"></span></span>