开云体育

+ AA6YQ comments below

I'm starting to get serious about confirming grids within North America that I have worked, but who never confirmed (usually because they're not on LoTW). I'm especially anxious to confirm any that are needed for "Fish points."

Is there a filter syntax that could select band=6m, grid worked/not-confirmed, LoTW User=No, and DXCC country in W, VE? And for good measure, age <= 5 years? I've tried a few different filters but I get stuck with grid worked but not confirmed. And even the relatively simple filter of "((BAND='6M') AND (App_DXKeeper_LotW_Member='N') AND (QSO_BEGIN > #2015-01-01#))" only turns up one result out of over 2800 QSOs on 6m.

+ As a first step, try

((BAND='6M') AND (App_DXKeeper_LotW_Member<>'Y') AND (QSO_BEGIN > #2015-01-01#))

<> means "not equal"

+ You might also take a look at the FFMA.txt script in DXKeeper's Scripts folder.

73,

Dave, AA6YQ

On Wed, Jun 17, 2020 at 07:48 PM, Dave AA6YQ wrote:

((BAND='6M') AND (App_DXKeeper_LotW_Member<>'Y') AND (QSO_BEGIN > #2015-01-01#))

OK, that syntax worked with 353 results. Now to narrow it down to do what I need.?

Good to see the Fishy Script--took me a moment to figure out what it did. But can I use this in conjunction with and SQL filter to display only?QSOs with stations who will definitely?not?be able to confirm via LoTW? Display the grids and populate the log page so I can print off labels and start sending out cards?

+ AA6YQ comments below

+ AA6YQ comments below

The FFMA report is a good starting point, but I would respectfully suggest going further with this concept for needs in general.

If someone who uses LoTW goes in to that report it's almost certainly not to see what's confirmed/verified (he can do that via LoTW after all), but rather, to try and figure out what's still outstanding; to determine who will need to be sent a physical card.

Using "add needed" doesn't work properly either since it's selecting LoTW users as well as non-LoTW users (and multiple non-6m QSOs with those who I also need to confirm on 6). I'm willing to give LoTW users a couple of years before I mark those Qs as needed for paper card (or, more likely, not in their log or otherwise unconfirmable).

The FFMA report is a good starting point, but I would respectfully
suggest going further with this concept for needs in general.

The FFMA script was written before DXKeeper provided a built-in
FFMA report. Notice that the script calls the VUCC Report.

Using "add needed" doesn't work properly either since it's selecting
LoTW users as well as non-LoTW users (and multiple non-6m QSOs with
those who I also need to confirm on 6).

If one uses the same SQL as the "Filter" statement in the FFMA script
to filter the DXKeeper log display then does an "Add Needed" for CARDS/LABELS without removing the filter it will certainly add any
QSOs that are not confirmed via LotW.

it's selecting LoTW users as well as non-LoTW users

If you don't want LotW users add "and App_DXKeeper_LotW_User <> 'Y'"
to the SQL used in the FFMA Script.

(and multiple non-6m QSOs with those who I also need to confirm on
6)

Well then don't tell DXKeeper you want the extra QSOs ... *CLEAR* the
"Add Needed requests" boxes in the QSL Config dialog.

I'm current with my FFMA grids so I can't check *but* one should
actually be able to accomplish what you want by:

1) Filter the DXKeeper Log display with:
App_DXKeeper_LotW_User <> 'Y'
2) Clear the "Add Needed requests" boxes
3) Clear the Awards boxes in Add Needed
4) Select *only* FFMA

73,

... Joe, W4TV


On 2020-06-18 9:18 AM, Peter Dougherty wrote:

The FFMA report is a good starting point, but I would respectfully suggest going further with this concept for needs in general.
If someone who uses LoTW goes in to that report it's almost certainly not to see what's confirmed/verified (he can do that via LoTW after all), but rather, to try and figure out what's still outstanding; to determine who will need to be sent a physical card.
Using "add needed" doesn't work properly either since it's selecting LoTW users as well as non-LoTW users (and multiple non-6m QSOs with those who I also need to confirm on 6). I'm willing to give LoTW users a couple of years before I mark those Qs as needed for paper card (or, more likely, not in their log or otherwise unconfirmable).

On Thu, Jun 18, 2020 at 06:44 AM, Joe Subich, W4TV wrote:

actually be able to accomplish what you want by:

1) Filter the DXKeeper Log display with:
App_DXKeeper_LotW_User <> 'Y'
2) Clear the "Add Needed requests" boxes
3) Clear the Awards boxes in Add Needed
4) Select *only* FFMA

Can you please elaborate on steps 2 and 3? Where are these located? It's been more than a year or more since I last did anything with DXKeeper except import contest ADIFs; I'm a bit rusty on where certain things are located.

I mentioned the FFMA initially since I'm?also looking to confirm all US grids, but I don't want to limit it to just FFMA counters.?

I have filtered the display with the 3 conditions I mentioned upthread (only 6m QSOs with a date after Jan.1 2015 and not an LoTW user). I could add the condition of the entity being K or VE, but I'm fine with worldwide since I can send the non-US cards out via the bureau...most non-US/Canada are Italy, England, Scotland, Spain and Portugal. But the trick becomes how to filter it further to only include grids that have not been otherwise confirmed via LoTW by other stations. This is the part I'm having difficulty with.

If DXKeeper's stats are correct, I should only have a maximum of 50-odd records of worked-not-confirmed grids on 6, and I'd wager about 20% of those are LoTW users who either have not yet uploaded, who've busted my call, or I'm NIL to them.

Can you please elaborate on steps 2 and 3? Where are these located?

On the QSL tab, in "QSL Config" -> "General" -> Add Needed panel.

You had to have set all those values at some point.

I mentioned the FFMA initially since I'm also looking to confirm all
US grids, but I don't want to limit it to *just* FFMA counters.

FFMA *IS* all Grids for the contiguous US. I doubt that "All US
Grids" even makes sense if one includes Alaska/Hawaii.

I have filtered the display with the 3 conditions I mentioned up thread (only 6m QSOs with a date after Jan.1 2015 and not an LoTW
user).

You should need to filter only by "not LotW User" if you select
FFMA in the Awards box of the QSL Config dialog.

But the trick becomes how to filter it further to *only* include grids that have not been otherwise confirmed via LoTW by other stations. This is the part I'm having difficulty with.

If you are looking at grids worldwide, again selecting (filtering
the log) for "not LotW User" and selecting VUCC in the Awards section
of the Add Needed dialog should identify any needed cards (a card
is *not needed* if one already has an LotW confirmation).

This information (describing QSL Config and the "Add Needed" panel)
*IS* in DXKeeper's help files.

73,

... Joe, W4TV


On 2020-06-18 10:23 AM, Peter Dougherty wrote:

On Thu, Jun 18, 2020 at 06:44 AM, Joe Subich, W4TV wrote:

actually be able to accomplish what you want by:

1) Filter the DXKeeper Log display with:
App_DXKeeper_LotW_User <> 'Y'
2) Clear the "Add Needed requests" boxes
3) Clear the Awards boxes in Add Needed
4) Select *only* FFMA

Can you please elaborate on steps 2 and 3? Where are these located? It's been more than a year or more since I last did anything with DXKeeper except import contest ADIFs; I'm a bit rusty on where certain things are located.
I mentioned the FFMA initially since I'm also looking to confirm all US grids, but I don't want to limit it to *just* FFMA counters.
I have filtered the display with the 3 conditions I mentioned up thread (only 6m QSOs with a date after Jan.1 2015 and not an LoTW user). I could add the condition of the entity being K or VE, but I'm fine with worldwide since I can send the non-US cards out via the bureau...most non-US/Canada are Italy, England, Scotland, Spain and Portugal. But the trick becomes how to filter it further to *only* include grids that have not been otherwise confirmed via LoTW by other stations. This is the part I'm having difficulty with.

What you're suggesting does not do what I am looking for. First off, it's just a report, not a way to filter the log for queuing QSL labels for print.?

Secondly, it includes grids that have already been confirmed via LoTW by other stations. If a grid has been confirmed via LoTW or paper card in the past then any log filter or report should not include that grid, even if there's a non-LoTW user in it that hasn't confirmed my QSO. I don't need that grid confirmed again.

The goal is to filter the log in such a way that the only QSOs displayed should be for 6m (only) grids not confirmed already via LoTW or paper card. That is the predominant search criteria.

If a grid has one or more unconfirmed QSOs, then I need to filter the display to show every station I've worked within that grid who does not use LoTW so I can create a label and send him/her a physical card. Do this for every unconfirmed zone. Eventually I will have sent physical cards to non-LOTW stations. Once I do that, I will need to filter the log again to include unconfirmed grids where I've worked LoTW-participating stations, so I can email them and see if maybe they busted my call or whatnot, or if I'm NIL, then mark those QSOs invalid in my log.

I use FFMA since it's a subset of all unconfirmed 6m grids, and it takes the band variable out of the equation. But in reality, I want to do this for?all unconfirmed 6m grids, US or international.

* more AA6YQ comments below

+ AA6YQ comments below