+ AA6YQ comments below
HI Joe.....I tried your SQL line on my log and somehow it is showing only 4 qsos (out of 14k qsos) with LOTW_QSL_RCVD = 'V'
How does this happen?
I thought I had never downloaded my credits as the download screen showed a last date downloaded of "never"???
What happens if I tried to download all my 200 dxcc credits again??
Will it screw up these 4 Qs somehow?? Is a download of credits from ARRL the only way that setting changes to a 'V' normally?
Any answers appreciated as it appears I never did download the credits even after applying for the awards.
+ If LoTW responds to the "Sync LoTW QSLs" function by reporting a QSO to which DXCC award credit has been granted to a QSO that is confirmed via LoTW, then that report will include this field:
<CREDIT_GRANTED:4>DXCC
+ DXKeeper responds to such a report by setting the QSO's "LoTW QSL Rcvd" item to 'V'.
+ However, "Sync LoTW QSLs" directs LotW to report all new confirmations after the date shown beneath the "Sync LoTW QSLs" button - so most of your DXCC award credits granted to LoTW confirmations could go unreported if you didn't use the DXCC submission mechanism that DXKeeper provides. That's probably why only 4 of your QSOs have their LOTW_QSL_RCVD items set to 'V'.
+ The DXCC submission mechanism is documented here:
+ After you review it, please describe the DXCC applications you've submitted, and the actions you've taken in DXKeeper in support of those applications.
73,
Dave, AA6YQ