Am I surprised that Joe would have already done this? No!
Thanks Joe Ron, AE5E >________________________________ > From: Joe WA6AXE <[email protected]> >To: [email protected]; [email protected] >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: [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

