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

Mon Dec 26 11:31:38 EST 2011

Am I surprised that Joe would have already done this?  No! 
Thanks Joe
Ron,  AE5E
>________________________________
> From: Joe WA6AXE <wa6axe at hotmail.com>
>To: ronn5in-dxbase2 at yahoo.com; dxbase at mailman.qth.net 
>Sent: Monday, December 26, 2011 10:26 AM
>Subject: RE: [Dxbase] Confirming all your QSO's are actually on LoTW
>>>>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
>>>