logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

LOTW last contact date
w2zi
#1 Posted : Monday, September 2, 2019 6:59:11 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 180
Man
Location: Daytona Beach

Thanks: 48 times
Was thanked: 67 time(s) in 62 post(s)
I tend to only work stations that are on LOTW. I've wondered why stations that are on the HB9BZA list LOGic uses...but I still don't get confirmations for so many QSOs.

I wonder no more! Turns out the LOTW servers make available a CSV file with the date and time of the last contact of every station (133,112 as of today). It appears they generate that list at the beginning of the month.

I have massaged that into a membership list item I've called 'LOTW LAST' so when I'm thinking of working a station, I can see they are on LOTW but so many of then have not been on for YEARS!

I've attached the list (from 2-SEP-2019) as a DBF for importing.

Go to Tools -> Setup -> Membership lists. Click on Import List, select the file. Give it a field name (I used LOTW LAST) and then click import. This takes a long time.

73s, Don

I'VE HAD TO ZIP THE DBF FILE AS IT'S OVER 600MB. UNZIP AND PROCEED AS ABOVE
File Attachment(s):
lotw_last.zip (3,830kb) downloaded 44 time(s).
1 user thanked w2zi for this useful post.
WN4AZY on 9/6/2019(UTC)
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.011 seconds.