How *not* to import your posts using Wordpress
Today I’ve been “fighting” with my computer and server to get all my posts over from my old MODx website over to the ‘new’ Wordpress powered version. To do so I figured it would be ‘easy’ to use phpMyAdmin to modify my SQL database to gain the format used by Wordpress.
After about an hour or two struggling with the SQL queries and horrible syntaxes, not to mention the extremely user friendly errors; ’syntax error’ without showing where the error came up, I finally managed to get the database in the right format. What I didn’t notice was that Wordpress also keeps track of the ‘human friendly’ version of the post title to use the nicer URL’s; my work became worthless.
After looking through the Wordpress documentation I noticed a tab ‘Posts -> Import’ in the administrator panel. And even though my previous system wasn’t officially supported, this nice page also allows you to import posts from an RSS feed, saving you all the trouble of converting, modifying and cleaning the database. Arg!
Popularity: 5% [?]