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.
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
It is a very slow process.
On 1/26/2022 12:20
PM, David Godden wrote:
For those that
have numbers greater than 2787 can we just
submit our logs and have the endorsements
alternative method is extremely arduous
difficult time consuming and very frustrating.
While reviewing the logs uploaded to the
Award Checker, I've noticed a number of
members that appear to have not uploaded
their log since their initial 50 contacts.
It's not a requirement to upload the log
periodically however to receive endorsements
it is necessary. If you're not chasing
endorsements, you might want to give it a
try, chasing endorsements is a lot of fun.
Remember when uploading your logs make sure
you upload the entire log, even the ones you
have already uploaded.
Award Submission and Validation Director
“Too much of a
good thing is bad, but too much of good Whisky
is barely enough!” Mark Twain
73 de KK6M
David "ROY" Godden
Jim, K5SP #483
Executive Director/Member Services Director