开云体育

I am trying to come up with the following report:

I want to see Grid Squares that I have worked but not confirmed in my VUCC.

Specifically I sort my log for say only 6 meter contacts. Then go to the progress tab and hit the Progress Key for VUCC. It gives me all the grids I have on 6 meters, both worked and confirmed.

How do I get to a report that ONLY gives me those grids (and the contact info) that I have worked but NOT confirmed?

I am trying to come up with the following report:

I want to see Grid Squares that I have worked but not confirmed in my VUCC.

Specifically I sort my log for say only 6 meter contacts. Then go to the progress tab and hit the Progress Key for VUCC. It gives me all the grids I have on 6 meters, both worked and confirmed.

How do I get to a report that ONLY gives me those grids (and the contact info) that I have worked but NOT confirmed?

+ AA6YQ comments below

On Thu, Apr 16, 2020 at 3:07 PM Udo A. Heinze <uaheinze@...> wrote:

I am trying to come up with the following report:

I want to see Grid Squares that I have worked but not confirmed in my VUCC.

Specifically I sort my log for say only 6 meter contacts. Then go to the progress tab and hit the Progress Key for VUCC. It gives me all the grids I have on 6 meters, both worked and confirmed.

How do I get to a report that ONLY gives me those grids (and the contact info) that I have worked but NOT confirmed?

Fun! Not sure if there's an easier way, but the following filter should match any 6m QSO where any of the 4 grids is (W)orked. You could then generate a report (keeping the filter in place), or make a script.

Band = '6m' and EXISTS (SELECT VUCCProgress.M6 FROM VUCCProgress WHERE
(VUCCProgress.M6 = 'W' and VUCCProgress.Grid in (Left(Gridsquare, 4), Left(App_DXKeeper_Grid2, 4), Left(App_DXKeeper_Grid3, 4), Left(App_DXKeeper_Grid4, 4))))

Not thoroughly tested, but the result seems reasonable for my log.


+ Alternatively,,

1. On the Main window's "Check Progress" tab, click the VUCC panel's Realtime button to display the VUCC tab of DXKeeper's "Realtime Award Tracking" window

2. In the "VUCC Award Progress Filter" panel on the VUCC tab of DXKeeper's "Realtime Award Tracking" window,

2a. set the Band selector to 6m

2b. check Worked and Requested boxes

2c. uncheck the Confirmed and Verified boxes

2d. click the Report button

+ In the table of grid squares shown above the "VUCC Award Progress Filter" panel, double-clicking the W or R in a grid square's row and the 6m column will filter the Log Page Display to show all 6m QSOs with that grid square.

~iain N6ML

I followed your instructions and did get a list of ONLY outstanding Grids. And clicking on the "grid" of Worked or Requested Grids I get to the actual contacts in the log. Although this is very helpful, I was trying to create a report which not only lists the outstanding grids but also the call (s) for that grid which I have worked and perhaps the date and time of the QSO. I guess what I am really asking is, does DXLab incorporate some sort of report writer which lets you slice and dice the data (the log) any way you would like and then create a subsequent report?

73
Udo NI0G

-----Original Message-----
From: [email protected] <[email protected]> On Behalf Of iain macdonnell - N6ML
Sent: Thursday, April 16, 2020 9:54 PM
To: [email protected]
Subject: Re: [DXLab] Custom Reports in DXLab

On Thu, Apr 16, 2020 at 6:26 PM Dave AA6YQ <aa6yq@...> wrote:

+ AA6YQ comments below

On Thu, Apr 16, 2020 at 3:07 PM Udo A. Heinze <uaheinze@...> wrote:

I am trying to come up with the following report:

I want to see Grid Squares that I have worked but not confirmed in my VUCC.

Specifically I sort my log for say only 6 meter contacts. Then go to the progress tab and hit the Progress Key for VUCC. It gives me all the grids I have on 6 meters, both worked and confirmed.

How do I get to a report that ONLY gives me those grids (and the contact info) that I have worked but NOT confirmed?

Fun! Not sure if there's an easier way, but the following filter should match any 6m QSO where any of the 4 grids is (W)orked. You could then generate a report (keeping the filter in place), or make a script.

Band = '6m' and EXISTS (SELECT VUCCProgress.M6 FROM VUCCProgress WHERE
(VUCCProgress.M6 = 'W' and VUCCProgress.Grid in (Left(Gridsquare, 4),
Left(App_DXKeeper_Grid2, 4), Left(App_DXKeeper_Grid3, 4),
Left(App_DXKeeper_Grid4, 4))))

Not thoroughly tested, but the result seems reasonable for my log.


+ Alternatively,,

1. On the Main window's "Check Progress" tab, click the VUCC panel's
Realtime button to display the VUCC tab of DXKeeper's "Realtime Award
Tracking" window

2. In the "VUCC Award Progress Filter" panel on the VUCC tab of
DXKeeper's "Realtime Award Tracking" window,

2a. set the Band selector to 6m

2b. check Worked and Requested boxes

2c. uncheck the Confirmed and Verified boxes

2d. click the Report button

+ In the table of grid squares shown above the "VUCC Award Progress Filter" panel, double-clicking the W or R in a grid square's row and the 6m column will filter the Log Page Display to show all 6m QSOs with that grid square.

Ah, so if the VUCCProgress value can be (R)equested, revise my filter to:

Band = '6m' and EXISTS (SELECT VUCCProgress.M6 FROM VUCCProgress WHERE
(VUCCProgress.M6 in ('W', 'R') and VUCCProgress.Grid in (Left(Gridsquare, 4), Left(App_DXKeeper_Grid2, 4), Left(App_DXKeeper_Grid3, 4), Left(App_DXKeeper_Grid4, 4))))

73,

~iain / N6ML

Hi Udo,

I suspect that you followed Dave's instructions?

If you apply the SQL filter that I provided to your log, you should
see all of the QSOs with unconfirmed grids. You could then use the
"Report" button on the "Log QSOs" tab to get a report containing all
of those QSOs, or you could generate a VUCC report (with the filter
still in place) to get a grid-based report.

73,

~iain / N6ML


On Fri, Apr 17, 2020 at 12:24 PM Udo A. Heinze
<uaheinze@...> wrote:

~iain N6ML

I followed your instructions and did get a list of ONLY outstanding Grids. And clicking on the "grid" of Worked or Requested Grids I get to the actual contacts in the log. Although this is very helpful, I was trying to create a report which not only lists the outstanding grids but also the call (s) for that grid which I have worked and perhaps the date and time of the QSO. I guess what I am really asking is, does DXLab incorporate some sort of report writer which lets you slice and dice the data (the log) any way you would like and then create a subsequent report?

73
Udo NI0G

-----Original Message-----
From: [email protected] <[email protected]> On Behalf Of iain macdonnell - N6ML
Sent: Thursday, April 16, 2020 9:54 PM
To: [email protected]
Subject: Re: [DXLab] Custom Reports in DXLab

On Thu, Apr 16, 2020 at 6:26 PM Dave AA6YQ <aa6yq@...> wrote:

+ AA6YQ comments below

On Thu, Apr 16, 2020 at 3:07 PM Udo A. Heinze <uaheinze@...> wrote:

I am trying to come up with the following report:

I want to see Grid Squares that I have worked but not confirmed in my VUCC.

Specifically I sort my log for say only 6 meter contacts. Then go to the progress tab and hit the Progress Key for VUCC. It gives me all the grids I have on 6 meters, both worked and confirmed.

How do I get to a report that ONLY gives me those grids (and the contact info) that I have worked but NOT confirmed?

Fun! Not sure if there's an easier way, but the following filter should match any 6m QSO where any of the 4 grids is (W)orked. You could then generate a report (keeping the filter in place), or make a script.

Band = '6m' and EXISTS (SELECT VUCCProgress.M6 FROM VUCCProgress WHERE
(VUCCProgress.M6 = 'W' and VUCCProgress.Grid in (Left(Gridsquare, 4),
Left(App_DXKeeper_Grid2, 4), Left(App_DXKeeper_Grid3, 4),
Left(App_DXKeeper_Grid4, 4))))

Not thoroughly tested, but the result seems reasonable for my log.


+ Alternatively,,

1. On the Main window's "Check Progress" tab, click the VUCC panel's
Realtime button to display the VUCC tab of DXKeeper's "Realtime Award
Tracking" window

2. In the "VUCC Award Progress Filter" panel on the VUCC tab of
DXKeeper's "Realtime Award Tracking" window,

2a. set the Band selector to 6m

2b. check Worked and Requested boxes

2c. uncheck the Confirmed and Verified boxes

2d. click the Report button

+ In the table of grid squares shown above the "VUCC Award Progress Filter" panel, double-clicking the W or R in a grid square's row and the 6m column will filter the Log Page Display to show all 6m QSOs with that grid square.

Ah, so if the VUCCProgress value can be (R)equested, revise my filter to:

Band = '6m' and EXISTS (SELECT VUCCProgress.M6 FROM VUCCProgress WHERE
(VUCCProgress.M6 in ('W', 'R') and VUCCProgress.Grid in (Left(Gridsquare, 4), Left(App_DXKeeper_Grid2, 4), Left(App_DXKeeper_Grid3, 4), Left(App_DXKeeper_Grid4, 4))))

73,

~iain / N6ML

+ AA6YQ comments below

If you apply the SQL filter that I provided to your log, you should see all of the QSOs with unconfirmed grids. You could then use the "Report" button on the "Log QSOs" tab to get a report containing all of those QSOs, or you could generate a VUCC report (with the filter still in place) to get a grid-based report.

+ DXKeeper does not include a report writer than supports arbitrary analyses. However, you can make a copy of your log file, and then direct Microsoft Excel to open that copy and perform whatever analyses you like using its tables; discard the copy when done, as you may have made changes that prevent DXKeeper from opening it.

* more AA6YQ comments below