[Dxbase] LOTW import problems

Sun Aug 14 11:04:48 EDT 2011

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: 2011年8月14日 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