Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post Reply
DB9CR
Novice Class
Posts: 28
Joined: 05 Dec 2020, 12:57

Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by DB9CR »

Hello,
I have worked a lot of DXCCs DXCC Slots. Most of them are confirmed via LOTW. A lot of the unconfirmed result from the fact that the partner is not using LOTW. In the Award status/award view, i can easily see the grey "worked", but unconfirmed entities. Now, to get QSL for these entities, there are several ways:
  • Wait for some time because user is using LOTW, but has not yet uploaded his log yet.
  • Send paper qsl card via buero and hope for reply.
  • Send paper qsl card with SAE, cash or whatever directly.
  • Request paper QSL card via Clublog OQRS - Online QSL Requests
What is the most efficient way to deal with
  • Find out who is using LOTW, so it makes sense to wait?
  • Get a list of QSOs with unconfirmed DXCCs?
  • Find the best QSL method for the QSO partners from the list?
  • keep track of what has been done to get a QSL
A first idea: Filter the log for something like the following to at least get a list of affected QSOs:

select * from log where ( select count(all) from log as log1 where log.dxcc=log1.dxcc and log.band=log1.band and qsoconfirmations like '%"CT":"LOTW","S":"Yes","R":"Yes"%') = 0 ;

What do you think? Can someone with more knowledge about the database internals optimize this statement?

73 de Christian DB9CR
User avatar
G4POP
Log4OM Alpha Team
Posts: 10753
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by G4POP »

I feel this is worthy of being a feature suggestion so will move it there to gain more exposure
73 Terry G4POP
DB9CR
Novice Class
Posts: 28
Joined: 05 Dec 2020, 12:57

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by DB9CR »

Thanks, that would be great.
wb2bin
Advanced Class
Posts: 72
Joined: 20 Mar 2020, 17:48

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by wb2bin »

I really support this idea. This one of the features I have been asking for.

Greg
WB2BIN
User avatar
CT1BXX
Old Man
Posts: 459
Joined: 21 Jan 2013, 15:27

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by CT1BXX »

Hi,

A nice feature.
It would be very useful. :D
73 Manuel Fernando CT1BXX
User avatar
KI5IO
Log4OM Alpha Team
Posts: 1798
Joined: 16 Aug 2015, 16:30
Location: Plano, TX

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by KI5IO »

I've added to our feature request list on Mantis.
73 - Nolan Kienitz - KI5IO
Plano, TX
DB9CR
Novice Class
Posts: 28
Joined: 05 Dec 2020, 12:57

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by DB9CR »

Hello, any updates on this feature?
73 Christian DB9CR
DB9CR
Novice Class
Posts: 28
Joined: 05 Dec 2020, 12:57

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by DB9CR »

OK, just rechecked it myself. Most of the stuff mentioned in original post works when you just enter

( select count(all) from log as log1 where log.dxcc=log1.dxcc and log.band=log1.band and (( qsoconfirmations like '%"CT":"LOTW","S":"Yes","R":"Yes"%') or (qsoconfirmations like '%"CT":"QSL","S":"Yes","R":"Yes"%')) ) = 0

in the filter expression in the label print dialog, select all QSOs with ^A and confirm selection. The following dialogs will ask nicely for desired paper QSL method (direct, buero, etc..), they are even using data from qrz.com to propose the best method. Well done!

73 Christian DB9CR
WA2SQQ
Old Man
Posts: 326
Joined: 16 Feb 2015, 20:13
Location: New Jersey US

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by WA2SQQ »

You lost me, and likely many others. Where and how is this data string entered? Will this do a screen dump, or only to a printer?
User avatar
G4POP
Log4OM Alpha Team
Posts: 10753
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Efficient way to get QSLs for worked, but onconfirmed DXCCs and DCXX slots

Post by G4POP »

WA2SQQ wrote: 21 Jun 2022, 01:52 You lost me, and likely many others. Where and how is this data string entered? Will this do a screen dump, or only to a printer?
As Christian said, go to label print and select the 'Filters' icon at bottom

Copy and paste his Reg expression to the text box having first selected 'Use custom query' click the red cross to close the window and the filter will action

REGEX.jpg
REGEX.jpg (57.21 KiB) Viewed 1494 times

BE PATIENT because it will take some considerable time if you have a large log

You ca save the filter for future use in the filter dialog window for future use.

I have tested the expression and it works very well
73 Terry G4POP
Post Reply