[Dxbase] LOTW import problems

Sun Aug 14 17:23:03 EDT 2011

Hi

I import ADIF to DXBASE then use Joe WA6XAE AUTOLOTW 2.54 which takes cares of upload TQ 8 and download a report to DXBASE in a easy way. Joe have easy sollution with passwords etc for LOTW inside his software :)

73 LA6FJA Rag

> From: LA8AW [oddyen at gmail.com]
> Sent: 2011-08-14 21:47:01 MEST
> To: Michael Tope [W4EF at dellroy.com]
> Cc: dxbase at yahoogroups.com, dxbase at mailman.qth.net
> Subject: Re: [Dxbase] LOTW import problems
> 
> 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 <W4EF at 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: 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
> >
> > ______________________________________________________________
> > 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
> >