Saturday, January 29, 2005

Shifting to WordPress...maybe

I got tired of seeing this post sitting in Drafts, so here it is.

Yesterday [I've had this post sitting in Drafts for a very long time, so I'm not actually sure when "yesterday" was. -Ed.], I decided to test WordPress and see how it works on my server. I was under the impression (due to this) that I wouldn't be able to run it. However, I went through the setup process and messed around with settings for awhile without ever seeing the "Database Error: Too Many Connections" message that I got when testing Mambo. I'm not sure if that means it'll be okay, or if I just put Mambo through more rigorous changes (although I'm thinking it's the second one).

The other problem is porting my Blogger stuff over into WordPress. They have a utility for importing Blogger posts, but they haven't updated it to include Blogger comments. All we see on the support forum are people asking whether or not there's a way to do it; one guy suggests exporting to Moveable Type format and then importing that to WordPress, but I hate that idea. It's too messy.

Looking at their tutorial and then examining the file in question, I got it into my head that maybe I could import the comments by modifying the file so that it would parse the comments and put them into the proper database fields. However, I was rather daunted by this task, and so I put it off for weeks.

Today [The real today. -Ed.], I started actually messing with it, just to see what would happen. At first I worked under the assumption that I would have to grab each comment while I was still within the "for" loop of the corresponding post. However, this didn't work. Finally, I remembered how to telnet into the database, so I took a look at how WordPress does its comments table. It contains the following columns:

comment_ID
comment_post_ID
comment_author
comment_author_email
comment_author_url
comment_author_IP
comment_date
comment_date_gmt
comment_content
comment_karma
comment_approved
user_id
I assume that comment_post_ID tells the software which post the comment goes with. This makes things easier and harder at the same time. I think that to get the raw comments data, all I need to do is create a separate dump from Blogger that contains the comments only...but I'm not sure how to indicate which posts the comments go with, nor what value comment_post_ID should then be assigned.

Kind of stumped, but at least I have an idea of the direction I need to go.

No comments: