Topics

Sort log by SOTA summit ref#

Kent N6WT
 

I just made my 200th contact with someone on a New Mexico summit and would like to apply for the Double NM Century Award. 

I would like to sort my log by SOTA summit reference #, only showing contacts starting with ref # "W5N", then sort by date. Then I would like to print a report showing these contacts. How would be the best way to do this??

I have tried a SOTA CSV Progress Report and sorted it in Excel. But I can't sort it by date that way. 

Thanks
73
Kent
N6WT

Dave AA6YQ
 

+ AA6YQ comments below

I just made my 200th contact with someone on a New Mexico summit and would like to apply for the Double NM Century Award.

I would like to sort my log by SOTA summit reference #, only showing contacts starting with ref # "W5N", then sort by date. Then I would like to print a report showing these contacts. How would be the best way to do this??

+ Filter the Log Page Display to show the desired subset of QSOs. Use the Sort panel on the "Advanced Sorts, Filters, and Modifiers" window to sort by reference number and then by date. Then click the Report button above the Log Page Display on the main window's "Log QSOs" tab.

73,

Dave, AA6YQ

Kent N6WT
 

Dave

I guess I am missing how to sort the SOTA_REF to just "W5N"? 

I tried SOTA_REF='W5N*' and it did not work. I can do SOTA_REF='W5N/SM-019' and it will give me a list of the 2 qso's I have with that summit, but I want all qso's in the W5N association. What is the syntax??

Sorry, I am not a good programmer.

Thanks
73
Kent
N6WT


On Fri, May 29, 2020 at 1:50 PM Dave AA6YQ <aa6yq@...> wrote:
+ AA6YQ comments below

I just made my 200th contact with someone on a New Mexico summit and would like to apply for the Double NM Century Award.

I would like to sort my log by SOTA summit reference #, only showing contacts starting with ref # "W5N", then sort by date. Then I would like to print a report showing these contacts. How would be the best way to do this??

+ Filter the Log Page Display to show the desired subset of QSOs. Use the Sort panel on the "Advanced Sorts, Filters, and Modifiers" window to sort by reference number and then by date. Then click the Report button above the Log Page Display on the main window's "Log QSOs" tab.

     73,

                Dave, AA6YQ




Dave AA6YQ
 

+ AA6YQ comments below


On Fri, May 29, 2020 at 03:20 PM, Kent Olsen wrote:

I tried SOTA_REF='W5N*' and it did not work. I can do SOTA_REF='W5N/SM-019' and it will give me a list of the 2 qso's I have with that summit, but I want all qso's in the W5N association. What is the syntax??

+ When you want to filter the Log Page Display using a wildcard character like *, you must use the LIKE operator instead of the = operator. In this case

SOTA_REF LIKE 'W5N*'

+ No apologies necessary, Kent; we're all learning here...

         73,

                Dave, AA6YQ

Kent N6WT
 

Dave

Thanks

73
Kent
N6WT


On Fri, May 29, 2020 at 4:05 PM Dave AA6YQ <aa6yq@...> wrote:

+ AA6YQ comments below


On Fri, May 29, 2020 at 03:20 PM, Kent Olsen wrote:

I tried SOTA_REF='W5N*' and it did not work. I can do SOTA_REF='W5N/SM-019' and it will give me a list of the 2 qso's I have with that summit, but I want all qso's in the W5N association. What is the syntax??

+ When you want to filter the Log Page Display using a wildcard character like *, you must use the LIKE operator instead of the = operator. In this case

SOTA_REF LIKE 'W5N*'

+ No apologies necessary, Kent; we're all learning here...

         73,

                Dave, AA6YQ

Kent N6WT
 

Dave

When the report prints it shows Call, DXCC, Starting UTC, Band, Mode, Sent, Rcvd and name. Can I choose which is printed?? I need Call, Date, Band, Mode but would also like to show the SOTA Ref#.

Thanks
73
Kent
N6WT


On Fri, May 29, 2020 at 4:29 PM Kent Olsen via groups.io <kilo6dko=gmail.com@groups.io> wrote:
Dave

Thanks

73
Kent
N6WT


On Fri, May 29, 2020 at 4:05 PM Dave AA6YQ <aa6yq@...> wrote:

+ AA6YQ comments below


On Fri, May 29, 2020 at 03:20 PM, Kent Olsen wrote:

I tried SOTA_REF='W5N*' and it did not work. I can do SOTA_REF='W5N/SM-019' and it will give me a list of the 2 qso's I have with that summit, but I want all qso's in the W5N association. What is the syntax??

+ When you want to filter the Log Page Display using a wildcard character like *, you must use the LIKE operator instead of the = operator. In this case

SOTA_REF LIKE 'W5N*'

+ No apologies necessary, Kent; we're all learning here...

         73,

                Dave, AA6YQ

Kent N6WT
 

I figured it out!!

Thanks
73
Kent
N6WT


On Mon, Jun 1, 2020 at 6:06 AM Kent Olsen <kilo6dko@...> wrote:
Dave

When the report prints it shows Call, DXCC, Starting UTC, Band, Mode, Sent, Rcvd and name. Can I choose which is printed?? I need Call, Date, Band, Mode but would also like to show the SOTA Ref#.

Thanks
73
Kent
N6WT


On Fri, May 29, 2020 at 4:29 PM Kent Olsen via groups.io <kilo6dko=gmail.com@groups.io> wrote:
Dave

Thanks

73
Kent
N6WT


On Fri, May 29, 2020 at 4:05 PM Dave AA6YQ <aa6yq@...> wrote:

+ AA6YQ comments below


On Fri, May 29, 2020 at 03:20 PM, Kent Olsen wrote:

I tried SOTA_REF='W5N*' and it did not work. I can do SOTA_REF='W5N/SM-019' and it will give me a list of the 2 qso's I have with that summit, but I want all qso's in the W5N association. What is the syntax??

+ When you want to filter the Log Page Display using a wildcard character like *, you must use the LIKE operator instead of the = operator. In this case

SOTA_REF LIKE 'W5N*'

+ No apologies necessary, Kent; we're all learning here...

         73,

                Dave, AA6YQ