[Dxbase] LOTW query?

Sat Apr 2 13:58:32 EDT 2011

Tnx, Gary, your instructions were very clean and I did just that, there do
not seem to be any variations in how it works for 2006 and 2007. It seems a
little awkward and I had a slight problem in convincing the popup box that
my TARGET was the mdb and the source was the adi file but that worked out
okay and now I think I have enough 6m Qso for a VUCC. But those, if they are
in LOTW and dxbase seems to think they are, aren't going away so I can
figure out how to apply for that award some other day. My dxcc counts look
seemingly okay so I think I am in good shape for a while Again, thanks.
I will be working at the ARRL expo portion of Dayton again and hope that
Dxbase will finally return as an exhibitor, they have not had a booth for
several years since Jack bowed out around the 2009 show.
Larry
W4RA
> -----Original Message-----
> From: Gary AL9A [mailto:al9a at mtaonline.net]
> Sent: Saturday, April 02, 2011 1:19 PM
> To: DXbase Reflector
> Subject: Re: [Dxbase] LOTW query?
>> Larry,
>> I'm still using DXB 2006, but downloading your LOTW QSOs and importing
> them
> should be pretty similar.
>> 1. Again, make a backup of your DXB mdb file.
> 2. Log into LOTW and go to the "Your QSOs" tab.
> 3. On the left side of window under "QSOs Menu" select "Download
> Report".
> 4. The box with the date should be the date of your last LOTW download.
> If
> you want a different date enter it here. You do not need to check the
> "Include QSL detail" box. Enter your call sign or select it from the
> drop
> down list if you have multiple accounts set up.
> 5. Click on "Download report" and select a destination for the file to
> be
> saved. Remember both the file name and its location.
> 6.You are now done with LOTW. Make sure the DXB log is closed and
> backed up
> from item 1 above.
> 7. Go to the Non-DXB import utility in the DXB programs group and
> select the
> mdb file you wish to import into.
> 8. On the Import window make sure the box labeled "QSOs for these OPR
> Calls"
> is showing the correct call. If not, highlight it and use the red X to
> delete it. Enter the correct OPR call in this box.
> 9.Check the "Do Not load any records" button.
> 10. In the "Source Data Type" box select "LoTW ADIF". Make sure the
> box for
> "DXbase 2007 Full Path" is pointing to your mdb location.
> 11. In the "Source Database File" click on the the ... box and navigate
> to
> the file you just downloaded from LOTW.
> 12. If all the boxes are correctly filled in click on the green box
> under
> Import to start the trial load. As the Import utility runs watch the
> Errors
> and Warnings counters to see if there are any problems. If so, note
> what
> they are so you can correct them later.
> 13. If the trial run went ok, click on the "Load All Records" button
> and
> run it again. Click Yes on the warning message about did you make a
> backup
> file. This time the LOTW records will be added to your mdb file and you
> can
> see the total in the "Records Loaded" counter. A message will pop up
> to
> remind you to initialize the data tables when you next start DXB.
> 14. You're now done importing. Close the Import utility and restart
> DXB.
> After initializing the data records and making sure things look ok exit
> DXB
> and make another backup. The end.
>> 73,
> Gary AL9A
>>>> ----- Original Message -----
> From: "Larry E Price" <Price.LE at frontiernet.net>
> To: "'Crownhaven'" <crownhaven at bellsouth.net>; "'N3XX'"
> <n3xx at charter.net>
> Cc: "'DXBase List'" <dxbase at mailman.qth.net>; <LPrice at IARU.org>
> Sent: April 02, 2011 8:07 AM
> Subject: Re: [Dxbase] LOTW query?
>>> > Thanks, Steve. I did backup my w4ra.mdb file to the "F" drive,
> created an
> > adi file per the N3XX instructions and uploaded it to ARRL thru the
> web
> > site. It was received okay and the QSOs show up from 2006-2010 okay.
> Now
> > if
> > I can figure out how to download a file to Import into DXb I will be
> good
> > to
> > go! Tnx to everyone for their suggestions. I hope the next DXb 20xx
> > version
> > (since it will have been created long after LOTW was up and running)
> will
> > have a button or two to Click to do all this stuff automatically (I
> can
> > figure out how to rotate my antenna, I really don't need my logger to
> do
> > that). But getting my log into ADIF format and uploading it to ARRL
> LOTW
> > is
> > a little more cumbersome and not as intuitive to me as knowing the
> > difference between LP and short path.
> >
> > Tnx again to all.
> >
> > Larry
> > W4RA
> >
>> ______________________________________________________________
> 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

 _____ 
avast! Antivirus <http://www.avast.com> : Outbound message clean. 
Virus Database (VPS): 4/2/2011
Tested on: 4/2/2011 1:58:22 PM
avast! - copyright (c) 1988-2011 AVAST Software.