Importing from Squarespace

Hi all,

I am currently a squarespace user but would like to move over to wordpress. I have set up a test copy at http://www.experiencingtheoyster.com/acblog and got it set up and running without any problems.

I have exported the contents of one of my pages on squarespace in what squarespace calls an MT compatible format. I then imported this into wordpress using the MT import tool in the admin section.

All appeared to go well. The import finished. Now the fun begins.

The posts are all imported in DRAFT format. I had hoped that I could do some sort of select all and publish them on mass but there is no option for that. I then thought I’d be clever and use a SQL command to change the DB table setting from DRAFT to Published, I used the following command

update wp_posts set post_status = ‘publish’ where post_status = ‘draft’

This did indeed publish all the posts, but there were more problems. Although each post showed it’s proper category name. This name did not appear in the category list unless I edited the post and saved it again. The same goes for the comments. The post shows that there are comment but when you click on the post, they do not appear, unless I edit the post and save it again.

All this means that I’ll need to spend hours editied all my posts in order to bring them all across, not a fun prospect.

So, can anyone suggest an easier way to acomplish this?

Thanks in advance for any help, it will all be gratefully received.

I have reset my wordpress install so it is now clean.

Best regards,

Alasdair.