By

The ARRL makes available a list of all Logbook of the World (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 the EXTDATA subdirectory of DX4WIN.

  2. Create a batch file with Notepad containing the text below and put it in the same directory where you saved the activity report (EXTDATA). I called my batch file LoTW.BAT (LoTW "dot" BAT), which you can download and save by clicking on the link:
            @echo off
            set call=%1

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

            set result=1
            for /f "tokens=1-3 delims=," %%a in ('findstr /r "^%call%[,/] /%call%[,/]" lotw-user-activity.csv') do (
            echo %%a        %%b
            set result=0
            )
            if %result%==1 echo %call% Not Found
  1. In DX4WIN Preferences, Ext Data tab, 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, as shown below. Pay special attention to the backslash between "EXTDATA" and "LoTW.BAT". If the path is incorrect, DX4WIN will crash when you press F3!

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: EXTDATA\LoTW.BAT
          W1AW 2018-03-09

This shows that W1AW last uploaded to LoTW on 9 March, 2018. 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.