Re: Uploading to the Award Checker
toggle quoted messageShow quoted text
I have a Spreadsheet that uses sheet 2 as a database. All of the members that have an 070 number are listed on the sheet 2. One sheet one. I have a column that when you enter a call in the sheet, does an lookup using the database on sheet 2. If there is an match, it shows the 070 number on sheet one. Also if you happen to enter a call that you already have worked it it cause the background color of the call to turn Green. If you like a copy of my spreadsheet email me direct and I will send you a copy.
On Wednesday, January 26, 2022, 02:46:10 PM CST, Harry Wilkins <k9hw@...> wrote:
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
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: