Latest QSOs on my hamradio site / 2015-11-08

2015-11-08 Latest QSOs on my hamradio site 2 years ago
It's possible to get your 'most recent QSOs' (radio contacts) on a website using iframes/scripts from sites like www.qrz.com or www.hrdlog.net.

I had to do my own thing and get the data from my logging application CQRLOG which has all my radio contacts logged. In a MySQL database. Which is not my preferred database, but it works with CQRLOG and I don't touch it otherwise.

A bit of searching found me Accessing the MySQL server spawned by CQRlog - N0NB which had the right incantations. I used this to build a perl script which does an SQL query to extract the latest QSOs, like:
        SELECT callsign,band,mode,loc,rst_s,rst_r,qsodate
        FROM cqrlog_main
        ORDER BY qsodate DESC LIMIT 10
Followed by some work to export the data to a format the webserver for my website can pick up even when the 'radio' desktop is not running. And the result is now visible at the top right of PD4KH Amateur radio - Koos van den Hout.

Having the script really shut up when MySQL isn't running was a bit of work, but in the end this works in my crontab:
./logtosite.pl 2>/dev/null

Tags: , ,

, reachable as koos+website@idefix.net. PGP encrypted e-mail preferred.

PGP key 5BA9 368B E6F3 34E4 local copy PGP key 5BA9 368B E6F3 34E4 via keyservers pgp key statistics for 0x5BA9368BE6F334E4 Koos van den Hout
RSS
Other webprojects: Camp Wireless, wireless Internet access at campsites, The Virtual Bookcase, book reviews, Weather maps
This page generated in 0.008900 seconds.