A while back I decided I wanted a solution, where I could access my logbook(s) anywhere regardless of where I was currently located. At first I managed to-do this by using MySQL on my web server to store the HRD Logbook and just used an SSH tunnel. This worked fine if I was using my desktop computer or laptop, but it’s not always possible specially when it friends shacks.
So the next step was obvious, I needed to create a web front-end to the database so after a few late nights coding things started to take shape and after a month’s development I’m happy to show everyone, although I have been putting the odd screenshot on Twitter.
When you first the Web Logbook you first see the “Dashboard” which gives you an overview of what you’ve worked that day by displaying the last 9 QSOs, and any QSOs you’ve made that day on a Google Map plus just for reference you can also quickly see a breakdown of QSO information too.
View log allows you to do exactly that view all your QSOs, just like you would in a desktop application only difference is if you click on a Callsign you’ve worked it pops up an information box displaying more information and a map. Its also possible to edit a QSO from this area and soon delete (Once I write that bit of code!)
Search provides a way of quickly looking up a QSO just start typing the callsign into the field and never JS goes off and starts matching it, currently can be a little slow depending on server speeds.
The Add QSO section is really the brains of the application, here you enter your QSO at the moment the times are set to work with UTC only but thats pretty standard in the Ham Radio world, fields provided are the most important ones required you can either log as band or frequency this is controlled within the configuration files.
The system find previously logged QRA and name and populate the fields and then figure out bearings, distance and DXCC info which is displayed below the QSO box, its also got a Partial Callsign Check system, options to save satellite information (I need that important :-)) and soon going to add IOTA, QSLing information.
Notes was more of an add-on which I wanted so I could store beacon frequencies, ATU settings and the like, but really if its text you can store it in a note.
Statistics is something I’ve only just started to develop using the Google Charts API to show a breakdown of logbook QSOs, these are currently by Mode and band. I’ve also quickly written some to show QSOs on satellites, as I personally wanted to see what sat I used most (AO-51) this will develop further in the coming months no doubt.
Now I’m not providing this as a hosted application if you want to run it you’ll need to have some knowledge of remote access MySQL, creating tables and editing bits of PHP if thats OK then you’ll enjoy messing about with it.
Once this is all done it should work out of the box, remember this is open source project and you use it at your own risk. at some point I will have an guide on the github project on how to set it up.
Code can be found at https://github.com/magicbug/HRD-Web-Frontend