I had decided to transfer my old blogs (from late 2009 and 2010) from Drupal to this WP-powered site during Christmas, and now it’s done. I started off with a sql dump (password lost so I couldn’t access it in Phpmyadmin) and the first step was to get a program which was able to read it. After some research, I tried Word and Excel, and to my surprise both worked, even if the result was not perfect in any way.
Then I needed to get the date for the blogs, there was just one long 11 digit number which I guessed was some sort of a code for the date and time. I found the Unix time converter which was able to convert the time code into a date and time, one date at a time. I’m sure there is an algorithm out there that could be used in Excel for converting several dates at the same time, or?
Finally there was the cutting and pasting of blog posts from the Word document, one by one. Word retained the formatting and HTML code but Drupal had put some extra characters there which needed to be erased. The date and time I also had to enter manually.
All this took me almost ten hours, but what are holidays for? Now I’ll use WordPress in the foreseeable future, together vid the Canvas theme from Woothemes.


