Import old entries from Serendipity

Here I am again.. last week I imported some old entries from my old Serendipity based blog, using the Technosailor Serendipity (s9y) to WordPress Importer. Although it took the server about a minute per four posts, it worked out quite ok! All i found were some issues with the categories, but I was impressed by the ease of importing anyway.

Turns out that all my inserted posts have gotten some category, but not everything went fine. For instance, one of my first posts was posted in the category Todo. That shows a nice 404 now :) So, some tweaking had to be done.

First, I need to figure out the table structures and the original categories. I figured the best would be using the timestamps. Due to my older MySQL config, I am forced to use a script. While messing with this, i might as well update my imported categories with the category descriptions.

So, here we are:

  • Update the categories to preserve their descriptions
  • Update the posts to their right category

There is also a TODO list:

  • Update the counter for the categories
  • Add support for posts with multiple categories

But, well, I’ll probably won’t be importing my posts again, so…. drop a note if the scipt has to be altered. Oh, and bye the way: download it here, upload it in your plugins directory (wp-content/plugins) as a .php file and set it to go. Enjoy.

Add to your favorites:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Reddit
  • StumbleUpon

This entry was posted on Thursday, July 12th, 2007 at 00:14 and is filed under Blog, Tech, Testing. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply