Page 1 of 2

Search LOTW sent but not received

Posted: 07 Nov 2020, 10:19
by F6FLU
Hello,
I'm trying to displays the QSOs for which I have sent the LOTW QSL but I have not received LOTW Confirmtion.
I Probably have to make a mistake but I don't see wich one
I have my Log like this :
Log4OM QSOs 2020-11-07 102509.png
Log4OM QSOs 2020-11-07 102509.png (71.98 KiB) Viewed 3120 times
And I made these SQL Request :
Log4OM Search LOTW non reçus 2020-11-07 102725.png
Log4OM Search LOTW non reçus 2020-11-07 102725.png (13.98 KiB) Viewed 3120 times
and the result is :
Log4OM LOTW recherche résultats 2020-11-07 102827.png
Log4OM LOTW recherche résultats 2020-11-07 102827.png (16.37 KiB) Viewed 3120 times
Can you help me ?
Thanks and 73

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 10:45
by G4POP
Firstly you need to set a date range for the sent confirmations also, probably the same period

Additionally are there any other filters set as that would conflict?

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 13:05
by F6FLU
Hello many thanks for your help but
If I set the same date it's the same problem
NO I have no another filters
Capture d’écran 2020-11-07 140031.png
Capture d’écran 2020-11-07 140031.png (11.67 KiB) Viewed 3110 times
Capture d’écran 2020-11-07 140057.png
Capture d’écran 2020-11-07 140057.png (10.9 KiB) Viewed 3110 times
Capture d’écran 2020-11-07 140203.png
Capture d’écran 2020-11-07 140203.png (14.21 KiB) Viewed 3110 times

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 13:06
by F6FLU
Capture d’écran 2020-11-07 135950.png
Capture d’écran 2020-11-07 135950.png (23.16 KiB) Viewed 3110 times

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 13:08
by F6FLU
@Terry
If you want, you can connect to my PC with TeamVierwer or AnyDesk ...
73
Dan

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 13:28
by G4POP
Email me an ADIF file of you log and refer to this thread please

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 14:47
by F6FLU
Done Terry
I sent my adif
73

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 18:18
by G4POP
Try using the QSL Manager and use the range dates at the top, I was able to filter for date range fine, see results below 643 QSO's where you sent a confirmation but have not received one apparently? Have you done an LOTW download in the QSL manager yet?

Untitled.jpg
Untitled.jpg (230.18 KiB) Viewed 3092 times

Re: Search LOTW sent but not received

Posted: 07 Nov 2020, 18:47
by F6FLU
Hello Terry
Thanks
No I didn’t use the QSL manager
I only look for the filter system with SQL request
I am just looking for the qso for which I sent the qsl lotw and which I did not receive
Thanks again

Re: Search LOTW sent but not received

Posted: 08 Nov 2020, 08:16
by F6EXV
Hello Daniel
Using the QSL manager as indicated by POP works great.
I have done the same research here, and get the correct result.
73
Paul F6EXV