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: [email protected] > To: [email protected] > 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:[email protected] > > This list hosted by: http://www.qsl.net > Please help support this email list: http://www.qsl.net/donate.html ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
