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

2015-11-08 Latest QSOs on my hamradio site
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: , ,

IPv6 check

Running test...
, 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

RSS
Meningen zijn die van mezelf, wat ik schrijf is beschermd door auteursrecht. Sommige publicaties bevatten een expliciete vermelding dat ze ongevraagd gedeeld mogen worden.
My opinions are my own, what I write is protected by copyrights. Some publications contain an explicit license statement which allows sharing without asking permission.
Other webprojects: Camp Wireless, wireless Internet access at campsites, The Virtual Bookcase, book reviews
This page generated by $Id: newsitem.cgi,v 1.57 2022/02/15 21:48:18 koos Exp $ in 0.006785 seconds.