[Dxbase] Confirming all your QSO's are actually on LoTW

Mon Dec 26 11:26:46 EST 2011

Ron,
Years ago -- I made a standalone exe program called LOTW CHECKER ... but, found that too many
DXbase users were downloading the FULL LOTW QSOs and accidentally trying to import THAT
adi file into THEIR LOGBOOK mdb file -- which really makes a real mess of your logbook ....
So, I stopped posting the LOTW CHECKER program to my website ---- and, I simply HELP
anyone who wants to double-check their logbook as compared to LOTW -- by, having the
DXbase user download the FULL adi file -- and email that adi file to me for my use here -- and,
I have them immediately delete that adi file on their computer so that they do not try to USE IT
as an IMPORT to their logbook mdb file ...
The URL that I use to download ALL of my QSOs for DOUBLE-CHECKING against my logbook mdb file
is :
https://p1k.arrl.org/lotwuser/lotwreport.adi?qso_query=1&login=CALLSIGN&password=PASSWORD&qso_qsl=no&qso_qsldetail=yes&qso_withown=yes
I just enter my CALLSIGN in place of the word CALLSIGN and then enter my PASSWORD (log-in to LOTW website) in place of
the word PASSWORD ...
This will bring down ALL of my QSOs ...
Then, I simply USE my LOTW CHECKER program and it will tell me which QSOs are NOT FOUND in my logbook mdb file 
and HOW MANY QSOs that matched are CFMD and how many NOT CFMD ... and, (if any) which QSOs need to be
currently UPLOADED to LOTW and which QSOs need to be downloaded from LOTW ..
This program has been a lifesaver for me -- in being able to diagnose problem between my logbook and what is on
LOTW ...
AGAIN - the only CAUTION I have for any user is: DO NOT try to import this FULL downloaded adi file into your 
actual logbook --- it WILL cause problems ... 
I have always offered this service to any DXbase user who is NEEDING to double-check their logbook against
what is on LOTW ...
Just FYI to Ron and ALL ...
73 Joe wa6axe
> Date: 2011年12月26日 08:13:47 -0800
> From: ronn5in-dxbase2 at yahoo.com
> To: dxbase at mailman.qth.net
> Subject: [Dxbase] Confirming all your QSO's are actually on LoTW
>> I have been wondering if all my 30,000+ qso's are actually recorded on the LoTW site. Although this is only preliminary, here is a starting point in resolving this.
>> First you must download all your QSO's (not just QSL's) from LoTW. This can be done here: http://www.rickmurphy.net/lotwquery.htm.
>> You need only fill in two fields: 'LoTW Username' and 'Report on QSOs starting on what date?'
>> The first is your callsign which you use to signon to the LoTW site, the second is the beginning date in for format YYYY-MM-DD. Depending upon how far back you go and how many QSO's you have on the LoTW this can take quite a bit of time.
>> When completed you will have a file 'lotwreport.adi'. At this point I converted this to CSV, using a program from AD1C http://software.ad1c.us/LoTW_to_CSV/index.html.
>> My next step will be to generate a CSV file from DXBase2007 and massage each into a format where I can run a comparison between them.
>> I have not done this later step as yet.
>> Perhaps there is a simpler way to proceed?
>>> Ron, AE5E
> ______________________________________________________________
> Dxbase mailing list
> Home: http://mailman.qth.net/mailman/listinfo/dxbase
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Dxbase at mailman.qth.net
>> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html