Imported DISQUS Comments Not Showing Up On Drupal Nodes

DISQUS is a popular "social commenting" platform. It is integrated with many hosted blog platforms and open source CMSes, including Drupal. A client of ours exported the comments from their old Wordpress blog and then imported them into DISQUS. The problem was that the comments were showing up in the DISQUS dashboard, however, when you clicked their corresponding URLs, these imported comments did not appear in Drupal. While the Drupal module looks for comments on the node/X URLs, DISQUS was storing them at the old Wordpress URL which were implemented as path aliases in this case.

Fixing this was relatively easy as DISQUS has a mapping tool available. You can download the URLs it knows about and then upload a very simple CSV file to change the URLs. To generate the CSV file after you have saved the Disqus URLs into disqus-urls.csv, just run the following script with drush php-script disqusmap.php > map:

<?php

$base = 'http://www.example.com/';

$n = strlen($base);

foreach (file('disqus-urls.csv') as $url) {

  $path = substr(trim($url), $n);

  $source = drupal_get_normal_path($path);

  if ($source != $path) {

    echo "$base$path, $base$source\n";

  }

}

After you have uploaded the file there is nothing to do but wait. As far as I can see, there are no logs, progress reports, or anything that provides status. In this client's case re-mapping worked to solve their missing comments and so hopefully it will work for you as well.