[Dxbase] LOTW query?

Sat Apr 2 17:02:08 EDT 2011

Hi Gary,
Initially I would agree. I keep my log files very well backed up. As
I mentioned; I screwed up one day and had my log file open as I did a Non
DXB import. I have been doing this for quite a while so I am fairly
confident in doing so by now. However what is the difference between doing
this and having, say, DM780 feed the qsos into DXBase automatically? You
have to have your log file open for this. They are both done with an adif
file.
73,
Joe WL7E/W7
On Sat, Apr 2, 2011 at 1:10 PM, Gary AL9A <al9a at mtaonline.net> wrote:
> I think I'd be a little nervous about importing records into an open data
> base. Seems like a train wreck waiting to happen!
>> 73,
> Gary AL9A
>> ----- Original Message -----
> *From:* Joe <wl7e at arrl.net>
> *To:* Gary AL9A <al9a at mtaonline.net>
> *Cc:* DXbase Reflector <dxbase at mailman.qth.net>
> *Sent:* April 02, 2011 10:45 AM
> *Subject:* Re: [Dxbase] LOTW query?
>> Hi Gary and Larry,
>> I am able to import both kinds of adif files while I have my log file open.
> It saves me a lot of time when doing my updates to and from LoTW. I am using
> DXB 2007 but also did it from DXB 2006. I know the Help files say to have it
> closed but I screwed up one day. One can not stress enough backing up your
> mdb file regularly. Also when either uploading to or downloading from LoTW I
> save my adif files by call and date; WL7E_W7 Apr 2, 2011 LoTW Report (from
> LoTW). I do this because I have multiple certificates/calls to track. If
> you're dealing with only one call sign I suppose it is a mute point.
>> Also some things that we do in DXB depends on how many qsos you have in
> your logs. If your log file is 10k qsos that is different than dealing
> with 200k or more qsos and multiple call signs. There is always more than
> one way to skin a cat.
>> 73,
> Joe WL7E/W7
>> On Sat, Apr 2, 2011 at 10:18 AM, Gary AL9A <al9a at mtaonline.net> wrote:
>>> 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
>>>>