When I run contests, I generate the Cabrillo and ADIF file from my test program (Win-Test). I send off the cabrillo file to the test organizer, and always import the ADIF into DXBase. I then export ADIF from DXBase, sign it with TQSL before uploaded to LoTW - bankers!.
I also had some issues when I first started using DXBase, with duplicate QSO's etc. But found the way I described above as the best way of doing it..... _____________________ 73 de LA8AW - Odd-Egil _____________________ On Sun, Aug 14, 2011 at 17:04, Michael Tope <w...@dellroy.com> wrote: > Thanks for the detailed response on both problems. Some of my LOTW qsos > have been uploaded using cabrillo format and some were from ADIF format > files. Likewise with the second problem my LOTW uploads have been in a > number of cases generated from the N1MM logging program. > > 73, Mike W4EF................... > > On 8/14/2011 4:23 AM, Joe WA6AXE wrote: > > Mike, > > > > On the first item .. You submitted your QSOs in the CABRILLO format > > (vice ADIF) > > format - when you made your TQ8 file -- and, you are not using the latest > > version of the IMPORT.exe program .. the most recent version takes > > care of the > > problem with a CABRILLO format submission to LOTW ... > > > > I have posted a ZIP file with just the Import.exe file enclosed to my > > Ham Radio website > > for you to download .. the LINK is: > > > > http://www.navycthistory.com/DXbase/Import.zip > > > > > > With this version of the Import.exe file - you still can submit in > > Cabrillo format - and > > now - the import.exe program will recognize the PHONE mode -- (which > > comes from your > > Cabrillo formatted file) .. > > > > You now are good for your first problem .. > > > > > > Second problem -- when you submit to LOTW from ANOTHER logging program > > (other than > > from DXbase) -- there is a good chance that the TIME will be OFF by > > seconds -- and this causes > > the duplicate entry ... What happens, is that if the IMPORT.exe > > program CAN NOT find > > the EXACT MATCH from the incoming LOTW data with your DXbase QSOs -- > > it will > > make a new QSO ... in your case, the TIME (6 digits) is OFF by just > > enough that the > > current LOGIC can not find a match ... > > > > The BEST way to submit to LOTW -- is to ALWAYS do an adif export FROM > > DXBASE .. > > Then make your TQ8 file (for submission to LOTW) from the DXBASE made > > adif file .. > > This way - your MAIN logging (DXbase) program's TIME FIELD (full 6 > > digits) will be used ... > > > > > > 73 Joe wa6axe > > > > > > > > > Date: Sun, 14 Aug 2011 00:26:11 -0700 > > > From: w...@dellroy.com > > > To: dxbase@mailman.qth.net > > > Subject: [Dxbase] LOTW import problems > > > > > > In the course of trying to import my LOTW confirmation statistics into > > > DXbase 2007, I've run into several problems. The first problem was that > > > the ADIF report created by the ARRL's LOTW website identified "SSB" > > qsos > > > as "PHONE" qsos. When I tried to import these QSOs in Dxbase, they were > > > turned into "DIGITAL" mode contacts. This was relatively easy to fix > > > using the "replace" function in Microsoft Notepad (I replaced > > > "<mode:5>phone" with "<mode:3>SSB" before importing the ADIF file into > > > Dxbase). > > > > > > The 2nd problem I encountered when trying to import LOTW data was that > > > in some cases the Dxbase IMPORT program created a duplicate QSO instead > > > of just updating the database "CFM" field from "No" to "LOTW". This > > > seemed to happen with QSOs from certain contests, but I couldn't > > discern > > > a particular characteristic of the log data that was predictive for > > this > > > outcome. One thing I did notice was that for a given segment of > > W4EF.mdb > > > log data that was unique to a particular contest, the Dxbase import > > > program either correctly annotated the "CFM" field for all the QSOs > > > where LOTW confirmations occurred, or it created a duplicate contact > > > with the "CFM" field set to "LOTW" for all the QSOs where LOTW > > > confirmations occurred. There was never a mixture of the two outcomes > > > within a segment of my W4EF.mdb log file that was unique to a given > > > contest. The log data that produced duplicate QSOs instead of just a > > > change in the "CFM" flag was from the following contests: > > > > > > Feb 2011 CW Sprint > > > Jan 2011 NAQP CW > > > 2010 CQ WW CW > > > 2010 ARRL SS Phone > > > Sept 2010 CW Sprint > > > August 2010 NAQP CW > > > > > > Numerous other contests (including prior runnings of the contests > > listed > > > above) going back as far as 1997 did not show duplicate contacts when I > > > loaded the LOTW ADIF. Any idea why this happens? > > > > > > Thanks, > > > > > > Mike W4EF........... > > > > > > ______________________________________________________________ > > > Dxbase mailing list > > > Home: http://mailman.qth.net/mailman/listinfo/dxbase > > > Help: http://mailman.qth.net/mmfaq.htm > > > Post: mailto:Dxbase@mailman.qth.net > > > > > > 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:Dxbase@mailman.qth.net > > 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:Dxbase@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
