I have been trying to go from an XOOPS site that had WordPress running in it, as an XOOPS module.
Did all the backups, wiped the site, installed 3.1.3, and then used the CSV Importer to load the posts. Now, for only 30 posts, there are 154 loaded, and it's a complete mess. Fortunately, I also backed up WP 3.1.3 before the CSV importer.
I notice the dashboard has a WP importer, read up a bit, then used the 'export' to see what sort of file is produced. It's an XML file, ..so here is the big question ..
Is there an easy method, or a plugin, to convert the SQL of the posts table to an XML file that I can them use for the WP import function ?