« I Don't Speak Muslim! | Main | X2 and T3 »
جمعہ 18 جولائی 2003Friday, July 18, 2003
Comments Imported
You might have noticed that the “Most Comments” on the sidebar have changed drastically since yesterday. That is because I was finally able to import all my Haloscan comments.
Gabriel Misura has written the Perl code required to import comments from Haloscan. It works like a charm except that the email addresses get a bit funky in the process.
Here is the link for the plug-in and here are some instructions I wrote for it.
After importing the comments, I needed to fix the email addresses of the imported comments since I use the CommentLeaders plugin for counting the number of comments my readers have made. For that purpose, I used phpMyAdmin and Kristine’s wonderful tips for mySQL.
Thank you very much, Gabe.
Posted by Zack at July 18, 2003 7:25 AM in Internet
Advertisements
Trackback Pings
TrackBack URL for this entry:
http://www.zackvision.com/mt/zv-trbk.cgi/372
Listed below are links to weblogs that reference Comments Imported:
» Import Comments Success from Blue Dragon
Well, I'm happy to report that at least one user has been able to use the Import Comments feature I added to Movable Type (no thanks to my sorry excuse for documentation/instructions and blindness to emails). Zack was able to... [Read More]
Tracked on July 19, 2003 12:05 AM
» Imported Comments! from stuff and whatever
Gabe Misura has written a script for importing Haloscan comments into Moveable Type. You can get it from MT Plugins or directly from Gabe. Zack Ajmal has written a blurb about his experience and an installation tutorial. Most importantly, don't... [Read More]
Tracked on July 21, 2003 7:15 PM
Comments
Posted by: Al-Muhajabah (262 comments) at July 18, 2003 2:39 PM
Great find, Zack! I think I’m looking at my weekend project.
Posted by: Bin Gregory (8 comments) at July 24, 2003 10:27 AM
Whoa! On second thought, after looking over the spec I think I’ll just leave those Haloscan comments right where they are thank you. But major geek props to you for getting it to work!
Posted by: Bin Gregory (8 comments) at July 24, 2003 11:15 AM
Bin Gregory: If you need any help with transferring your comments, let me know. I’ll be glad to do it for you.
Posted by: Zack (1803 comments) at July 25, 2003 2:33 AM
Well that’s a kind offer! I’d be foolish not to take you up on it. I’ll send you an email momentarily… Thanks again!
Posted by: Bin Gregory (8 comments) at July 26, 2003 7:21 AM
Zack, I’m guessing this doesn’t work for MT 3.14? I tried the steps and the Import Comments button never shows up. Thanks for your help if you can. If not, not a big deal…my blog is pretty new and I don’t have a lot of comments yet.
Posted by: Jeff Smith (1 comments) at February 2, 2005 3:37 AM
Jeff: It won’t work with MT 3.xx I think.
Posted by: Zack (1803 comments) at February 2, 2005 1:28 PM | PGP Sig
Hi,
I just got it working for MT 3.16. It was all based on Gabriel Misura’s code and your helpful comments. However, I only imported the text of the comment, author, and date of comment. There are no hyperlinks. I wanted it that way since I don’t like linking to people’s email addresses and I didn’t care for the links to people’s websites. The perl code wasn’t outputing it to the Database anyways. It did the job for me though. The files I modified were:
\lib\MT\App\CMS.pm
\tmpl\cms\header.tmpl
\tmpl\cms\import_comments.tmpl
\images\nav-import-comments.gif
\styles.css (you have to add the image to the “Import Comments” location here)
\extlib\HTML\TableExtract.pm
What is no longer used in MT3.xx is:
\tmpl\cms\mininav.tmpl (this is now been deprecated by header.tmpl)
Btw, I don’t know Perl, and I just started hacking at MT about 2 days ago.
As well, the import brought in some garbage HTML:
There were 2 types:
1. The actual HTML source of the Haloscan comments window
2. The copyright/powered by Haloscan stuff
I had to go into the MySQL database and run the following 2 commands:
DELETE FROM `mt`.`mt_comment` where comment_text like ‘%form method%’
DELETE FROM `mt`.`mt_comment` WHERE comment_text like ‘<p align=”center”>%’
After removing the rubbish, I was simply too lazy to publish the comments to I just did the following:
UPDATE `mt`.`mt_comment` SET comment_visible=’1’
Yes. This is defintely not for the average user :-( But it worked for me.
Posted by: roy (2 comments) at May 8, 2005 11:55 PM
Oh, I’ld also like to add that not all the comments made it :-( I think I know why. I posted a bit on on my blog post: http://www.beernut.ca/roy/archives/003308.html
Posted by: roy (2 comments) at May 9, 2005 9:49 AM
roy: Good that you got it working for MT 3.16.
Posted by: Zack (1803 comments) at May 9, 2005 9:00 PM | PGP Sig
Hi.
You don’t happen to know anyone who has successfully imported Haloscan comments into Wordpress do you?
Posted by: Hilary (1 comments) at June 12, 2005 6:49 PM
Hilary: Here you go.
Posted by: Zack (1803 comments) at June 12, 2005 10:23 PM | PGP Sig
Post a comment
Note: Disagreements are welcome, but please keep it civil. Any comments full of hatred, bigotry, trolling or spam will be deleted and the commenter banned. Do read the commenting policy.
Valid XHTML: You have to preview your comment to make sure that it is valid XHTML 1.1. You will see the "Post" button on the preview page.
Urdu: To comment in Urdu, include "p[ur](urdu). " (with a space at the end and without the quotes) at the start of every Urdu paragraph. If you want to write an Urdu word(s) in an English paragraph, do it like this: %[ur](urdu)اردو%. If you want to put an English word(s) in an Urdu paragraph, write it like this: %[en](en)English words%.
PGP Signing: PGP-signed comments are encouraged. However, clearsigning Urdu text with GPGshell produces garbage.
MathML: Select the Textile with itex to MathML text filter. What you'll use is itex, which is a superset of WebTeX and differs somewhat from standard LaTeX.
Text Filters: For regular comments, whether in English or Urdu, keep the text filter setting to its default of Textile 2. Change it to Textile with itex to MathML when writing MathML.
Cool! I decided awhile ago to try and import my old YACCS comments, but it turns out that nearly all of them had been deleted. I’m not sure why, but they had been sitting there for almost a year unused.