Migrate from Drupal comment.module to Disqus comments

The module should be called disqus_migrate.module (or something), which should allow two things:

1. Import: Allows you to download the Disqus comments and import them into Drupal's comment module. This would require syncing, making sure no duplicates are added. You also have the ability to schedule this with the cron.
2. Export: Allows you to upload comments from Drupal's comment module to Disqus. It would track which comments were sent, making sure no duplicates on Disqus are made. You also have the ability to schedule this with the cron.

Also subscribing.

subscribing

Any plans or ETA on when the Export from Drupal to Disqus could be implemented?

+1 for the export - subscribing

Me too. Would love to be able to import old Drupal comments into the Disqus system.

More meaningful title.

Beginnings.

Attached is a *working* export patch. It adds the ability to export Drupal comments to any of your Disqus forums (including or excluding unapproved Drupal comments). It stores the export results in a table {disqus_migrate_export} to prevent duplicate comments from being exported; it also allows the API to fail but pick back up where it last was in the export.

Apply the patch inside the migrate_disqus folder. There is also a pre-patched version of the migrate module attached. Enjoy!

NOTE: I would randomly get unmarked API errors during certain test runs (only occurred on 1 or 2 tests), however this appears just to be an API problem because the export picks back up the next run. No threads or comments were missed when these errors occurred (tested on a site with about 40 threads and 200 comments). For sites with large amount of comments PHP will *probably* time out before it gets done, for now you can simply reload the page after the time out and click export again to pick up at the last comment. Eventually it would be nice to have a more graceful batch style export to avoid PHP time outs all together (maybe it's not a big deal though since it's a one-time operation usually).

P.S: To the module maintainer, ImageX Media would love to be credited for this work on the project page. Our company page is http://drupal.org/profile/companies/ImageX%20Media (http://imagexmedia.com). Thanks!!

subscribing

I'm getting this error when I try to export comments-
user warning: Table 'database.disqus_migrate_export' doesn't exist query: SELECT c.*, u.mail as user_mail, n.title as node_title FROM comments c INNER JOIN users u ON u.uid = c.uid INNER JOIN node n ON n.nid = c.nid LEFT JOIN disqus_migrate_export d ON d.cid = c.cid AND d.fid = 320046 WHERE d.did IS NULL AND c.status IN (0) ORDER BY c.timestamp ASC in /home/public_html/sites/all/modules/disqus/disqus_migrate.admin.inc on line 138.

I'm committing this one... http://drupal.org/cvs?commit=348370

We can worry about Batch API later on if anyone wants to help out with that.

I recently installed the disqus module and applied the patch from post #17 located here http://drupal.org/node/269010#comment-2756308 after having uninstalled and re-installing the module. After clicking on the export tab all I receive is a blank page. Has anyone run in to this issue? What can I do to trouble shoot this?

LEt's move people over to #777842: Uncaught DisqusException on export instead.