How does one go about changing the lotw_qsls field? I edited a QSO and all I changed was the signal report and the lotw_qsls changed from Y to blank.
73
Stan
KM4HQE
Thu, 2018-07-05 06:24
#1
Edit QSO
HI !
With sql console. yo need to know qsodate and time_on (or something else to find just qso you want to change)
First check state with:
select lotw_qsls from cqrlog_main where qsodate='2017-11-23' and time_on='06:01'
Then change it with :
update cqrlog_main set lotw_qsls='S' where qsodate='2017-11-23' and time_on='06:01'
check change with:
select lotw_qsls from cqrlog_main where qsodate='2017-11-23' and time_on='06:01'
--
Saku
OH1KH
Hi Saku,
Ok.
Perhaps I should also have asked why does lotw_qsls change when only a minor change is made to the QSO record. LoTW doesn't care about signal reports. Seems like that shouldn't happen. I could see where changing the time/date would make the record different and it would be considered another QSO. As long as the callsign, date/time and band matches; it's considered a confirmed QSO.
73
Stan
KM4HQE
You have changed qso data. So it is not in it's original form. Maybe that's why the send information is reset. (I guess)
Actually a valid qso consist of 2 sent items that are confirmed to be received ok while in qso.
Items normally are callsign and report, but they may be also something else. Means report can be changed to, name, age, qth what ever.
CQ OH1KH UP
OH1KH KM4HQE (my call is confirmed to be received ok)
KM4HQE 599 (your call is confirmed to be received ok)
TU 599 (tu confirms you received report ok)
TU UP (tu confirms I received report ok)
Qso is complete as 2 items changed and confirmed.
If you change report afterwards we can discuss is the qso still complete?. It is if you have changed some other item and it is confirmed, but in case of locator in JT-modes it is not confirmed like rprt -> R-rprt.
http://hf.r-e-f.org/c4_iaru_r1/10vienne/VIE10_C4_11%20QSO%20definition.pdf
So, without knowing how LoTW handles qso data maybe change of qsls state is needed.
--
Saku
OH1KH
Hi Saku,
Yes, I too guess that changing something reset the lotw_qsls status. While it's customary to exchange some sort of report with your QSO partner; the signal report is not needed by LoTW. See below for what the LoTW site states is a QSO match.
What constitutes a QSO "match?"
Two submitted descriptions of a QSO match if
your QSO description specifies a callsign that matches the Callsign Certificate specified by the Station Location your QSO partner used to digitally sign the QSO
your QSO partner's QSO description specifies a callsign that matches the Callsign Certificate specified by the Station Location you used to digitally sign the QSO
both QSO descriptions specify start times within 30 minutes of each other
both QSO descriptions specify the same band
both QSO descriptions specify the same mode (an exact mode match), or must specify modes belonging to the same Mode Group
for satellite QSOs, both QSO descriptions must specify the same satellite, and a propagation mode of SAT
A confirmed QSO's DXCC entity, grid squares (up to 4), and US State are specified by the Station Location your QSO partner used to digitally sign the QSO. You can view this information via your LoTW Account, or your logging application may be able to obtain it for you.
All LoTW confirmations are valid for DXCC awards. Only LoTW confirmations with one or more grid squares are valid for VUCC awards, and only LoTW confirmations with a US State are valid for WAS awards. Some WAS, WAZ, and WPX awards require a confirmation with an exact mode match. You can ask your QSO partner to re-submit a confirmed QSO that is digitally signed with a Station Location that contains additional information so that the confirmation will become valid for VUCC and/or WAS awards.
73
Stan
KM4HQE