Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Modified Online logbooks query
15-10-2023, 04:05 PM, (This post was last modified: 17-10-2023, 10:03 AM by JW6VDA.)
#1
Modified Online logbooks query
I manage the logs for two clubs, both with a number of different operators with different personal callsigns.

To keep their log entries apart, and just to know who worked what, I have created a number of different "My qth"s, in the "My Qth" tab of the "Add qso" window, each containg the name and callsign of the operator.

To keep track of them in the daily logging, I have added an extra column to the "Online Logbooks" query, with the My_Operator_call.
Also, since I do not use all online logbooks, I have hidden those who are not in use.

Attached is the modified logbook query .spq-file, and the .RPL-file associated wth it.


.zip   Online Logbooks.zip (Size: 2,61 KB / Downloads: 15)

73 de Tom
Happy Swisslog user since 1989.

JW6VDA permanently may 1983 - august 1989 and august 2001 - august 2014.
LA6VDA 1989-2001.

Now OH6VDA since september 2014.
Reply
15-10-2023, 09:24 PM,
#2
RE: Modiied Online logbooks query
Thank you sharing Tom!!

Best 73
Jordi, EA3GCV
Current developer of Swisslog
Reply
06-10-2026, 09:50 AM, (This post was last modified: 06-10-2026, 10:19 AM by JW6VDA.)
#3
RE: Modified Online logbooks query
Going through both of my radioclub's logs, both with more than 50k qsos, I discovered that some operators had forgotten to check their "Current event" field on the MY qth tab (contest, special event or simply nothing - like a blank). Errors also appeared when importing ADIF files from e.g. contest loggers, and forgetting to use the correct event, so there was quite a mess in our logs. I found that the easiest way of finding these errors and correcting them was adding the MY_EVENT field in the Online Logbook query and group the logbook by this column. 

So here's the extended query .spq file and the .RPL file corresponding to it.
 
 73 de Tom OH6VDA


Attached Files
.zip   Online Logbooks with MY_OPERATOR and MY_EVENT.zip (Size: 2,74 KB / Downloads: 1)
Happy Swisslog user since 1989.

JW6VDA permanently may 1983 - august 1989 and august 2001 - august 2014.
LA6VDA 1989-2001.

Now OH6VDA since september 2014.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)