Date
1 - 10 of 10
Report
|
Julio Peralta
I’m chasing down some problems in the DXCC award for 6M. Is there a report that will list the call of all my DXCC entities by prefix/country and whether they are card or LOTW confirmations or both?
Julio, W4HY |
|
|
|
Joe Subich, W4TV
There is no predefined report that does what you want.
toggle quoted message
Show quoted text
However, you can filter the log page display to display QSOs on 6M that have been verified either LotW or Card, define a log display that shows the data as you want and then use the REPORT button on the log page display to print the report. See the DXKeeper Help file for the Check Progress tab. 73, ... Joe, W4TV On 2021-06-21 8:34 AM, Julio Peralta via groups.io wrote:
I'm chasing down some problems in the DXCC award |
|
|
|
Julio Peralta
I've been trying to write the needed SQL filter today but I haven't had much luck. Could someone lend a hand.
toggle quoted message
Show quoted text
I need an SQL filter to produce a log with 6M QSOs that are not from the US, in other words DX only, and if possible if they are confirmed via card or LOTW or both. Thanks for any help. Julio, W4HY -----Original Message-----
From: DXLab@groups.io [mailto:DXLab@groups.io] On Behalf Of Joe Subich, W4TV Sent: Monday, June 21, 2021 8:52 AM To: DXLab@groups.io Subject: Re: [DXLab] Report There is no predefined report that does what you want. However, you can filter the log page display to display QSOs on 6M that have been verified either LotW or Card, define a log display that shows the data as you want and then use the REPORT button on the log page display to print the report. See the DXKeeper Help file for the Check Progress tab. 73, ... Joe, W4TV On 2021-06-21 8:34 AM, Julio Peralta via groups.io wrote: I'm chasing down some problems in the DXCC award |
|
|
|
Dave AA6YQ
I've been trying to write the needed SQL filter today but I haven't had much luck. Could someone lend a hand.
I need an SQL filter to produce a log with 6M QSOs that are not from the US, in other words DX only, and if possible if they are confirmed via card or LOTW or both. + "6m QSOs" => (Band = '6m') + "not from the US" => (DXCCPrefix <> 'K') + "confirmed via card or LOTW or both" => (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V')) + The use of QSL_RCVD in ('Y','V')) + is shorthand for (QSL_RCVD = 'Y') or (QSL_RCVD='V') + This is necessary for both QSL_RCVD and APP_DXKEEPER_LOTW_QSL_RCVD because a QSO can be "confirmed" ('Y') or "confirmed with DXCC award credit granted" ('V'). + You can test each of the above fragments individually. Then put them all together: (Band = '6m') and (DXCCPrefix <> 'K') and (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V')) + If you provide columns in the Log Page Display for QSL_RCVD and APP_DXKEEPER_LOTW_QSL_RCVD, you'll be able to see exactly how each QSO is confirmed. 73, Dave, AA6YQ |
|
|
|
Joe Subich, W4TV
I need an SQL filter to produce a log with 6M QSOs that are not from the US, in other words DX only, and if possible if they are confirmedDo you want confirmed only or *credit granted* (verified)? 73, ... Joe, W4TV On 2021-06-21 3:24 PM, Julio Peralta via groups.io wrote: I've been trying to write the needed SQL filter today but I haven't had much luck. Could someone lend a hand. |
|
|
|
Joe Subich, W4TV
The following works to show *exactly* those QSOs (except for the one
toggle quoted message
Show quoted text
from US) for which ARRL has given me credit: DXCCID <> "291" and Band='6M' and (QSL_RCVD = 'V' or APP_DXKeeper_LotW_QSL_RCVD = 'V') DXCCID <> "291" -- exclude QSOs with the USA mainland BAND = '6M' --- QSOs on 6 meters QSL_RCVD = 'V' --- credit for card submission APP_DXKeeper_LotW_QSL_RCVD = 'V' --- credit for LotW submission You can sort the DXKeeper Log Page Display by DXCC Prefix (double click on the Prefix heading) and display your Logbook DXCC Awards status for 6 Meters (Awards -> DXCC -> 6M ... select "All credits" and Sort list by Prefix) and directly compare the two lists. Any differences will be instantly obvious. Removing "DXCCID <> "291" results in the two lists being identical in my case (when I use a version of the SQL below since I have (pending) LotW credits that have not been submitted). If you have a pending submission (cards/LotW credit marked for submission but not yet processed by ARRL) - then the following works better: DXCCID <> "291" and BAND ='6M' and (QSL_RCVD in ('S','V') or APP_DXKeeper_LotW_QSL_RCVD in ('S','V')) 73, ... Joe, W4TV On 2021-06-21 4:04 PM, Joe Subich, W4TV wrote:
I need an SQL filter to produce a log with 6M QSOs that are not from the US, in other words DX only, and if possible if they are confirmedDo you want confirmed only or *credit granted* (verified)? |
|
|
|
Julio Peralta
Thank you Dave and Joe for your replies. I think it's going to take me some time to work through this information and see how it works. I'll report back when I had a chance to work with these SQL filters.
toggle quoted message
Show quoted text
Julio, W4HY -----Original Message-----
From: DXLab@groups.io [mailto:DXLab@groups.io] On Behalf Of Dave AA6YQ Sent: Monday, June 21, 2021 4:04 PM To: DXLab@groups.io Subject: Re: [DXLab] Report I've been trying to write the needed SQL filter today but I haven't had much luck. Could someone lend a hand. I need an SQL filter to produce a log with 6M QSOs that are not from the US, in other words DX only, and if possible if they are confirmed via card or LOTW or both. + "6m QSOs" => (Band = '6m') + "not from the US" => (DXCCPrefix <> 'K') + "confirmed via card or LOTW or both" => (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V')) + The use of QSL_RCVD in ('Y','V')) + is shorthand for (QSL_RCVD = 'Y') or (QSL_RCVD='V') + This is necessary for both QSL_RCVD and APP_DXKEEPER_LOTW_QSL_RCVD because a QSO can be "confirmed" ('Y') or "confirmed with DXCC award credit granted" ('V'). + You can test each of the above fragments individually. Then put them all together: (Band = '6m') and (DXCCPrefix <> 'K') and (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V')) + If you provide columns in the Log Page Display for QSL_RCVD and APP_DXKEEPER_LOTW_QSL_RCVD, you'll be able to see exactly how each QSO is confirmed. 73, Dave, AA6YQ |
|
|
|
Julio Peralta
I wanted to report back regarding my reconciling my 6M DXCC totals, which I have done with you and Joe's help.
toggle quoted message
Show quoted text
However the SQL filter you sent me didn't work as expected as it returned QSOs from all bands including 6M. (see below) (Band = '6m') and (DXCCPrefix <> 'K') and (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V')) The SQL filter Joe sent me worked as expected and I was able to reconcile my 6M totals. (see below) DXCCID <> "291" and Band='6M' and (QSL_RCVD = 'V' or APP_DXKeeper_LotW_QSL_RCVD = 'V') I don't know if it's worth your time to try to figure out why your SQL filter doesn't work as expected since my issue has been resolved but I wanted to let you know what happened when I ran it. I again want to thank you and Joe for your help. Julio, W4HY -----Original Message-----
From: DXLab@groups.io [mailto:DXLab@groups.io] On Behalf Of Dave AA6YQ Sent: Monday, June 21, 2021 4:04 PM To: DXLab@groups.io Subject: Re: [DXLab] Report I've been trying to write the needed SQL filter today but I haven't had much luck. Could someone lend a hand. I need an SQL filter to produce a log with 6M QSOs that are not from the US, in other words DX only, and if possible if they are confirmed via card or LOTW or both. + "6m QSOs" => (Band = '6m') + "not from the US" => (DXCCPrefix <> 'K') + "confirmed via card or LOTW or both" => (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V')) + The use of QSL_RCVD in ('Y','V')) + is shorthand for (QSL_RCVD = 'Y') or (QSL_RCVD='V') + This is necessary for both QSL_RCVD and APP_DXKEEPER_LOTW_QSL_RCVD because a QSO can be "confirmed" ('Y') or "confirmed with DXCC award credit granted" ('V'). + You can test each of the above fragments individually. Then put them all together: (Band = '6m') and (DXCCPrefix <> 'K') and (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V')) + If you provide columns in the Log Page Display for QSL_RCVD and APP_DXKEEPER_LOTW_QSL_RCVD, you'll be able to see exactly how each QSO is confirmed. 73, Dave, AA6YQ |
|
|
|
Bill Pence
I think the issue might be missing parens... The last "OR" will defeat the first terms .. Try this (Band = '6m') and (DXCCPrefix <> 'K') and ((QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V'))) I wanted to report back regarding my reconciling my 6M DXCC totals, which I have done with you and Joe's help. |
|
|
|
Julio Peralta
Yes Bill that worked.
Thanks, Julio
From: DXLab@groups.io [mailto:DXLab@groups.io] On Behalf Of Bill Pence
I think the issue might be missing parens... The last "OR" will defeat the first terms ..
Try this
(Band = '6m') and (DXCCPrefix <> 'K') and ((QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V'))) On Wed, Jun 30, 2021, 7:47 AM Julio Peralta via groups.io <jperalta4=verizon.net@groups.io> wrote:
|
|
|