[Dx4win] Simple LOTW Search

[ON4AOI]

David,
There is already a memberlist in the DX Spots window (you can setup what you
are looking for standard it shows LoTW, Eqsl etc),
this is updated very often and you can see if the station is Lotw, eqsl or
something else.
This works for every user of DX4WIN since version 8.xx, your way around is
not a bad idea
but for those that don't pay for the XML version It has no use. 

Guy ON4AOI

-----Original Message-----
From: dx4win-bounces at mailman.qth.net <dx4win-bounces at mailman.qth.net> On
Behalf Of David Tingler
Sent: Monday, March 26, 2018 11:51 PM
To: DX4WIN at mailman.qth.net
Subject: [Dx4win] Simple LOTW Search


The ARRL makes available a list of all LOTW users, along with the date of
their last upload. I wrote a simple batch file to search the list and
display the results in DX4WIN when the F3 key is pressed. I thought some of
you might find this useful. 

1. Download the LOTW User Activity report from:
https://lotw.arrl.org/lotw-user-activity.csv and save it in a directory
accessible to DX4WIN. I put mine in a subdirectory of the DX4WIN SAVE
directory I called SEARCH.

2. Create a batch file with Notepad containing the text below and put it in
the same directory where you saved the activity report. I called my batch
file SEARCH.BAT.

@echo off
set call=%1
set result=Not Found
for /f "tokens=1-3 delims=," %%a in (lotw-user-activity.csv) do ( if /i
"%%a"=="%call%" set result=%%b
 )
echo %call% %result%

3. In DX4WIN Preferences, enable the QSL Manager Search (.exe) check box on
the External Data panel and fill in the edit box with the path to your batch
file. I have mine set to C:\DX4W903\SAVE\SEARCH\SEARCH.BAT. You will get an
error when you press F3 if the path is incorrect.

You can add other searches to your batch file using something like the
Windows FINDSTR or a GREP implementation. I have used this method to search
member and bureau lists in the past. 

Here is an example of the output generated by the F3 key. The first part is
from the QRZ XML service and only the last two lines pertain to the search
batch file.

W1AW
ARRL HQ OPERATORS CLUB
225 MAIN ST
NEWINGTON, CT 06111
United States
QSL Info: US STATIONS PLEASE QSL VIA LOTW OR DIRECT WITH SASE.
State: CT
County: Hartford
GRID: FN31pr
----QSL info from: C:\DX4W903\SAVE\SEARCH\SEARCH.BAT W1AW 2018-03-09

The date is replaced with "Not Found" if the station is not found in the
activity report. I don't think you will have any problem with these
instructions. As always, I can't be responsible if anything bad happens.

73, David - N5DT

______________________________________________________________
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN at mailman.qth.net
Message delivered to on4aoi at skynet.be

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html