[Dxbase] LOTW query?

Sat Apr 2 13:18:59 EDT 2011

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
>