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

[Ron Stordahl AE5E]

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: Mon, 26 Dec 2011 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
>
>
>