Thursday, 31 December 2009

Importing Haloscan comments to Wordpress

As I previously mentioned, I have imported my Haloscan comments to a WordPress blog. I have no intention of switching from Blogger to WordPress at this stage, but this is the best I can do currently to retain online access to my old comments.

As I have been asked how this was done I will provide a brief outline here with the links to the pages I referenced. It is not particularly straightforward and I did this with the assistance of stratman.

Haloscan has been purchased by JS-Kit. They initially offered to transfer comments to an upgradeable free account. I understand that this commenting system is integrated into Blogger which suggests comments would have been transferred back to Blogger's commenting system. This was not available until one was notified of the transfer, by which stage it was Echo commenting which was a paid system. Not too unreasonable I guess, but given they can possibly insert the comments into Blogger that would have been a nice option.

My steps

I downloaded comments from Haloscan. You should do this first, and probably do it anyway in case of future need. Comments download as an xml file which you can view in Notepad. Blogger does not recognise the comments in this particular xml format, though the comments are indexed by the blogpost code determined by Blogger.

I needed to set up WordPress blogging software. WordPress develop free blog software which is very versatile. The software needs to be uploaded to a webhoster which I don't have. They also have their software on their own webhoster conveniently (or confusingly) called Wordpress.com. This is less versatile and is insufficient for the import.

Not having a webhoster I needed to host the software on my computer by having it act as a server. I downloaded WampServer which is open source software located at SourceForge.

I installed WampServer following this guide. Although I did not create virtual hosts; the default is a single localhost. And be careful about creating a password. You probably do not need one. If you create a password the file you need to modify (config.inc.php) is not in the www\phpmyadmin\ directory that it must have been in the 2005 version of WampServer. It is currently located in the apps\phpmyadmin3.2.0.1\ directory.

WordPress downloads as a zip file. After unpacking, the files can be copied into the www/ directory. Alternatively you can follow these directions.

WordPress blogs can be viewed and modified from within a browser. It is reasonably straightforward but more details here. I went to Tools/Import and imported posts (and old, pre-Haloscan comments) directly from Blogger. You need to give WampServer/ Wordpress permission from Blogger to do this. Even with permission I got an error. Work around was to open the php.ini file and find the line
;extension=php_openssl.dll
The semicolon (;) indicates this is a comment. Decomment by removing the semicolon and save the file. Reboot WampServer and WordPress can import directly from Blogger. Alternatively you can export the file from Blogger then import to WordPress.

Next I installed a WordPress plugin to import Haloscan comments. Essentially Blogger uses unique numeric codes for blog authors and blog posts. Haloscan uses the same blogpost codes for comments. Blogger codes are lost on the import to WordPress. The plugins identify the blogpost codes and attach the Haloscan comments to the correct post. Here are the pluggins and instructions for importing the Haloscan comments. They worked fine other than adding > to the beginning of post titles and the first paragraph of the post body. Because of timeouts I set the thread identification pluggin to only grab 10 posts per time.

There is some development code to import WordPress to Blogger. It involves installing Python, and apparently does not keep the comment dates intact, so I have not used that. Thus I do not have my old comments in Blogger. I have a WordPress blog which I uploaded the posts and comments to, which will have to suffice. It is unlikely people other than me will use it. But perhaps this post may be helpful to those who use WordPress rather than Blogger.

3 comments:

  1. What version of Wordpress are you using? I'm on 2.9, and I keep getting "0 comments imported". I'll post a question on the justinsomnia.org site.

    ReplyDelete
  2. Justin gave me a couple of lines of code to change, and that did the trick. Thanks for the tip!

    ReplyDelete
  3. Glad it worked Jay. I downloaded WordPress version 2.9 for what it is worth.

    ReplyDelete

Labels

abortion (8) absurdity (1) abuse (1) accountability (2) accusation (1) adultery (1) advice (1) afterlife (6) aid (3) alcohol (1) alphabet (1) analogy (5) analysis (1) anatomy (1) angels (1) animals (10) apologetics (41) apostasy (4) archaeology (22) architecture (1) Ark (1) Assyriology (11) astronomy (5) atheism (14) audio (1) authority (4) authorship (10) aviation (1) Babel (1) beauty (1) behaviour (4) bias (6) Bible (38) biography (4) biology (5) bitterness (1) blasphemy (2) blogging (12) blood (3) books (2) brain (1) browser (1) bureaucracy (3) business (5) calendar (5) cannibalism (2) capitalism (3) carnivory (2) cartography (1) censorship (1) census (2) character (2) charities (1) children (14) Christmas (4) Christology (8) chronology (46) church (4) civility (2) clarity (5) Classics (2) climate change (39) coercion (1) community (2) conscience (1) contentment (1) context (2) conversion (3) copyright (5) covenant (1) coveting (1) creation (1) creationism (36) criminals (8) critique (2) crucifixion (12) Crusades (1) culture (4) currency (1) death (5) debate (2) deception (2) definition (16) deluge (9) demons (3) depravity (6) design (9) determinism (24) discernment (4) disciple (1) discipline (2) discrepancies (2) divinity (1) divorce (1) doctrine (4) duty (3) Easter (7) ecology (3) economics (28) education (10) efficiency (2) Egyptology (9) elect (2) emotion (2) enemy (1) energy (6) environment (4) epistles (2) eschatology (6) ethics (36) ethnicity (5) Eucharist (1) eulogy (1) evangelism (2) evil (8) evolution (13) examination (1) exegesis (21) Exodus (1) faith (22) faithfulness (1) fame (1) family (4) fatherhood (2) feminism (1) food (3) foreknowledge (4) forgiveness (4) formatting (2) fraud (1) freewill (29) fruitfulness (1) gematria (4) gender (5) genealogy (10) genetics (5) geography (3) geology (2) globalism (2) glory (6) goodness (3) gospel (3) government (18) grace (9) gratitude (2) Greek (4) happiness (2) healing (1) health (7) heaven (1) Hebrew (4) hell (2) hermeneutics (4) history (21) hoax (5) holiday (5) holiness (4) Holy Spirit (3) honour (1) housing (1) humour (34) hypocrisy (1) ice-age (2) idolatry (4) ignorance (1) image (1) inbox (2) inerrancy (16) information (10) infrastructure (2) insight (2) inspiration (1) integrity (1) intelligence (3) interests (1) internet (3) interpretation (75) interview (1) Islam (4) judgment (19) justice (23) karma (1) kingdom of God (12) knowledge (15) language (3) lapsology (6) law (17) leadership (2) libertarianism (12) life (3) linguistics (13) literacy (2) literature (17) logic (28) love (3) lyrics (9) manuscripts (11) marriage (17) martyrdom (2) mathematics (10) matter (4) measurement (1) media (2) medicine (11) memes (1) mercy (3) Messiah (5) miracles (4) mission (1) monotheism (2) moon (1) murder (5) nativity (7) natural disaster (1) naval (1) numeracy (1) oceanography (1) offence (1) orthodoxy (3) orthopraxy (4) paganism (2) palaeontology (4) paleography (1) parable (1) parenting (2) Passover (1) patience (1) peer review (1) peeves (1) perfectionism (2) persecution (2) perseverance (1) pharaohs (5) philanthropy (1) philosophy (32) photography (2) physics (18) physiology (1) plants (3) poetry (2) poison (1) policing (1) politics (30) poverty (9) prayer (2) pride (2) priest (3) priesthood (2) prison (2) privacy (1) productivity (2) progress (1) property (1) prophecy (6) proverb (1) providence (1) quiz (8) quotes (428) rebellion (1) redemption (1) reformation (1) religion (2) repentance (1) requests (1) research (1) resentment (1) resurrection (4) revelation (1) review (4) revival (1) revolution (1) rewards (2) rhetoric (2) sacrifice (4) salt (1) salvation (26) science (43) sermon (1) sexuality (16) sin (15) sincerity (1) slander (1) slavery (5) socialism (4) sodomy (1) software (4) solar (1) song (2) sovereignty (15) space (1) sport (1) standards (6) statistics (13) stewardship (5) sublime (1) submission (5) subsistence (1) suffering (5) sun (1) survey (1) symbolism (1) tax (3) technology (12) temple (1) testimony (5) theft (2) trade (3) traffic (1) tragedy (1) translation (15) transport (1) Trinity (2) truth (26) typing (1) typography (1) vegetarianism (2) vice (1) video (10) warfare (7) water (2) wealth (9) weird (6) willpower (4) wisdom (4) work (10) worldview (4)