By AppleBag on
So I'm working on a client's D5 site (I know, don't ask), and she has a ton of comments for various forum topics/threads that she doesn't want to manually do one-by-one herself. What's the best way to add comments to a topic in bulk?
Comments
Format?
In what format are the source comments in currently? It might be possible to use Node Import (http://drupal.org/project/node_import) to do this. Note, that you will need to click on "View all releases" link to download the old unsupported D5 version. I've used Node Import on D5 to import users and other content and this should work also for comments. However, you will need to have the source content in a form that Node Import can work with: e.g. tab delimited fields.
It is better to use Node Import if you can, since it will update comment count tables and other dependent tables without any mess or fuss on your end. The only other option I can think of would be to use an ETL tool like Pentaho Kettle - but then you would have to manage updates across all the comment related tables.
Regards,