[Dxbase] LoTW import problems

Sun Aug 14 17:40:02 EDT 2011

Moi aussi.  I usually have my cabrillo off within 24 hours and I upload
LoTW at the beginning of every month.  Never had a single problem.  

73

Al, VE1AL

---------------------------------------------------------------------------
-----
From: dxbase at yahoogroups.com [mailto:dxbase at yahoogroups.com] On Behalf Of
Michael Therrien
Sent: Sunday, August 14, 2011 4:50 PM
To: dxbase at yahoogroups.com
Subject: Re: [Dxbase] LOTW import problems

I have done exactly this for years and eliminated the duplicate QSO
problem.

Mike, N1MD

On Sun, Aug 14, 2011 at 15:47, LA8AW <oddyen at gmail.com> wrote:

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

-- 

Mike
"The truth will set you free . . . but first it will make you miserable."

__._,_.___

Your email settings: Individual Email|Traditional 
Change settings via the Web (Yahoo! ID required) 
Change settings via email: Switch delivery to Daily Digest | Switch to
Fully Featured 
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe 

__,_._,___