[Dxbase] LOTW import problems

[Joe WA6AXE]

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: W4EF at dellroy.com
> To: dxbase at 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 at mailman.qth.net
> 
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html