Importing Joomla! MxComments into Drupal comments

Submitted by Jochus on Mon, 01/03/2010 - 22:25 | Posted in: Website

Today, I finally finished my custom Drupal module which imports (existing) Joomla! MxComments into the Drupal database. I did it because CyCo didn't want to lose the old comments ;-) ! Unfortunately, nobody created a Drupal module for this operation before ... :-( ...

I was planning to share this module with the community, so I posted a suggestion/request to have my own developer space: http://groups.drupal.org/node/49188.
But I received only 1 reaction. I wasn't planning to integrate my component with other components, although I agree it would be better. But I didn't want to spend too much time on development. My module is used for a 1-time-operation, so I didn't want to go very fancy :-)

If people are interested in my module, feel free to drop a comment/mail. I can documentate the whole migration process on my wiki.

Briefly, I ...

  • ... selected all MxComments from Joomla! database
  • ... converted them into the $comment array of Drupal
  • ... used the http://api.drupal.org/api/function/comment_save/6 operation to insert the comment in the database using the Drupal API
  • ... finally, I ran a database query to update the node_comment_statistics table



Meanwhile, I closed my old website (http://www.jochus.be/www/). It will be removed in the near future ...

Comments

Submitted by CyCo on Tue, 02/03/2010 - 18:30
 

nice ;D
strange nobody wrote something like that before...

Add new comment

The content of this field is kept private and will not be shown publicly.

Full HTML

  • Lines and paragraphs break automatically.
  • You can caption images (data-caption="Text"), but also videos, blockquotes, and so on.
  • Web page addresses and email addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <bash>, <cpp>, <css>, <html5>, <java>, <javascript>, <php>, <sql>, <xml>. The supported tag styles are: <foo>, [foo].
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.