By zwhalen on

Hi.

I'm converting a site to Drupal from a flat file db blog (Blosxom) and I'm trying to figure out the best way to import the comments from the old system. I was using the Pollxn plug in for Blosxom, which basically creates parallel blog entries as comments, so I'm not expecting any kind of scripted mass import to work.

What I'd like ideally is a way that I could create comments with the same options as I do node entries (as admin). Like when you create a story as admin, you have the option of specifying any other user's name as the author and changing the "created on" date for the node. Is there any way to do that with comments? Alternatively, is there a better way to add on comments that were originally posted by multiple users?

Thanks.

⋅ Categories: Drupal 4.6.x

Comments

zwhalen’s picture

zwhalen commented

Since I'm getting no response, let me try again: more generally, what's the best way to import comments into Drupal? I've already got a blot that's run for a couple of years, and I want to import all of that content including comments into the new Drupal site. What's the best way to accomplish that?

Thanks in advance,
zach

zwhalen’s picture

zwhalen commented

Well, my server's out at the moment, so while it comes back, let me try and flesh out an idea. What about compiling all my comments into a big ol' INSERT query and ramming them in to the db that way? To create a comment, I already have all the information I need except for the nid to attach it to, so as I create each node, I could just note the NID and then add the comments' information to my big insert query and then just insert them all at once when I'm done.

zwhalen’s picture

zwhalen commented

So let's say this is what I wanted to do (a big insert), would I just need to worry about putting information into the 'comments' table, or should I also update the 'node_comment_statistics' table as well?