Re: Uploading to the Award Checker
toggle quoted messageShow quoted text
I recently built an Excel file to parse my log and find contacts with all LONP members, it compares their start date to the QSO contact date and checks to see if it was the first contact. It still takes a little manipulation, reducing the log file to just the columns needed and converting the date and time to separate columns and go through a few sorts. If you're well-versed with Excel, I would be happy to share it with you, or if you would like to send me your log, I can parse it and provide you with a list of LONP contacts you can forward to Milt.
From: main@070Club.groups.io [mailto:main@070Club.groups.io] On Behalf Of Jim K5SP
Sent: Wednesday, January 26, 2022 12:44 PM
Subject: Re: [070Club] Uploading to the Award Checker
David, the checker will work fine for numbers >2787, except for the LONP awards.
The checker doing the LONP requires access to a Google Spreadsheet that contains all member information. For every submission, it would go and check the sheet to see if any changes had been made, and if so, built a new file to compare the logs against. The link to the spreadsheet no longer works due to Google deprecating the API, and us not having access to the source code to fix it. Therefore, it cannot build a new file, and retains the one that it had previously built and uses it to compare logs. We quickly learned that the API quit working at #2786, and that is why anyone with a >2786 member number does not get recognized for LONP purposes. It also means that those of us that have contacts with members >2786 have to submit to N6MG for confirmation and credit.
There is a new endorsement checker in progress, but, it is a tremendously huge program, (to allow for checking for ALL endorsements), and is being done by a volunteer in his spare time, while juggling, work, family, and pursuit of a masters degree.
It is a very slow process.
On 1/26/2022 12:20 PM, David Godden wrote: