At 05:02 PM 11/4/2003 -0600, FireBrick wrote: >I'm having to update my DXB log listing who has qsl'ed via LoTW by hand.. >It will be easier when DXB makes this automatic.
I just submitted my log to LOTW (for the first time--actually went flawlessly). Since you can download a "confirmed report" in .adi format, I did it in this somewhat convoluted fashion in DXB2003. (I'm still awaiting my '2004 upgrade, I don't know whether it handles LOTW any better or not or whether there is a better way. I opened a new, empty database and then imported the lotwreport.adi into it. This is now your log with only/all QSOs confirmed via LOTW. Now you can import your regular log into this database and everything is up to date. There isn't any key to indicate LOTW confirmations, except that the QSLREC will = whatever date you submitted on. You can use the wizard to key on this and build your reports. I changed the file name on my "original" log to N7WS_1.mdb and renamed the new and improved log as N7WS.mdb. Clearly, you don't want to do this too often, but it works in a pinch. One upside is that the IOTA and Grid numbers are filled in too, if the other guy submitted his info. Wes N7WS

