QSO/QSL Logging (LotW, eQSL, etc)
Posted: 02 Feb 2018, 15:49
Firstly, just to get this out there - I have started using Log4OM about a month ago..... I tried it a few years ago, but at that time, probably due to my lack of attention and knowledge, along with what I wanted, then, from a logging program, I never really started using Log4OM. But NOW!!! Oh boy!! This program is great! I absolutely love it - it really seems to fit just about every need I want.....
But..... A few things I have noticed and I am wondering if I just overlooked a configuration or setting that I could make.
1 - Frequency - I am mostly a digital user, which means that I like to log a freq like "7.074.123". Log4Om logs that for me as "7074.123" - not a huge issue at all, and something I can certainly live with if I have to.
2 - Time - The logged time is in the format or "010000" (two extra zeros - seconds would be my guess, but they are always 00). With FT8, that would be cool to be 15, 30, 45, or 00, but it is not. I would prefer to log only 4 places if I could (hours:minutes -- seconds not needed).
3 - Received or Sent - The log will record as "Y" or "N", or "V", whichever is appropriate. I would like to log the whole word, if possible.
I use a MySql backend for everything, and I have fiddled with some queries to change these items in the log. Using PHP and some web coding, everything displays as I like it in my log (www.w7mgb.com), but if I ever access the data using Log4OM, any data that was modified will not work. I.e., if I use the QSL management to check for, or up/download LotW status, a QSO where I changed "N" to "No", etc, will not be discovered. If I changed the Freq from "7074.123" to what I like ("7.074.123"), accessing that record with Log4OM will change the freq to zeros.
Also, a slight oversight maybe? A field name of "Call" is not a good idea. "Call" is a protected word in MySql. While it is workable to escape the protected word with a combination of quotes, it is not a recommended method.
And just a caveat on all this -- no I am not a SQL programmer or a programmer of any type. Just a guy that likes to fiddle about a bit.....
THANKS!!!
But..... A few things I have noticed and I am wondering if I just overlooked a configuration or setting that I could make.
1 - Frequency - I am mostly a digital user, which means that I like to log a freq like "7.074.123". Log4Om logs that for me as "7074.123" - not a huge issue at all, and something I can certainly live with if I have to.
2 - Time - The logged time is in the format or "010000" (two extra zeros - seconds would be my guess, but they are always 00). With FT8, that would be cool to be 15, 30, 45, or 00, but it is not. I would prefer to log only 4 places if I could (hours:minutes -- seconds not needed).
3 - Received or Sent - The log will record as "Y" or "N", or "V", whichever is appropriate. I would like to log the whole word, if possible.
I use a MySql backend for everything, and I have fiddled with some queries to change these items in the log. Using PHP and some web coding, everything displays as I like it in my log (www.w7mgb.com), but if I ever access the data using Log4OM, any data that was modified will not work. I.e., if I use the QSL management to check for, or up/download LotW status, a QSO where I changed "N" to "No", etc, will not be discovered. If I changed the Freq from "7074.123" to what I like ("7.074.123"), accessing that record with Log4OM will change the freq to zeros.
Also, a slight oversight maybe? A field name of "Call" is not a good idea. "Call" is a protected word in MySql. While it is workable to escape the protected word with a combination of quotes, it is not a recommended method.
And just a caveat on all this -- no I am not a SQL programmer or a programmer of any type. Just a guy that likes to fiddle about a bit.....
THANKS!!!