At 01:11 AM 11/18/2003 -0500, Tony Cash wrote: >In a work, NO. Not quite.
As I wrote earlier, you can open an empty database (I called mine lotw.mdb) and import the .adi file into it. This will populate the log with all lotw confirmed qsos. Unfortunately, DXB will report these as confirmed by "card", rather than "lotw." It will also report the qslrecd date with whatever arrl reports. If you wish, you can then import your regular log and have a complete log. The downside, outside of the obvious complexity and possibilty of screwups, is that if you have paper qsls for some qsos that are confirmed by lotw, you've lost this info because when you import the second time, previous records are not overwritten. For example, I have paper cards for several qsos with HC8N. HC8N has submitted his logs to lotw so if I start with an empty database and import the .adi, I load a dozen or so records that DXB will dutifully report as confirmed by "card" on such-and-such date. Now if I use the DXB import to bring in the records from my "regular" log, all of the HC8N records are ignored so I've lost any data that shows what qsos are actually confirmed by paper cards and whether I've sent a card. What you do have by going through this exercise is a complete look at what you have confirmed by both paper and lotw. What I now have is too many damn databases after backing up the backups before trying another experiment. <g> Note: This is not a lotw problem but a DXbase issue. What we need is an LoTW import program that looks at each existing record and if it is not confirmed, writes confirmed by "lotw". If it is already confirmed by "card" then it changes that to "both". It would also be nice if it imported grid, state and iota too if those fields are empty in the log. Wes N7WS > >73 de Tony, KD4K > >My Weather Page >http://home.adelphia.net/~tonycash/ >My Ham Radio Page >http://home.adelphia.net/~tonycash/kd4k/radio.html >Sawnee Mountain (WB4GQX 147.15 +.600) Repeater Page >http://home.adelphia.net/~tonycash/sawnee/index.html > >----- Original Message ----- >From: "Peter Dougherty" <[EMAIL PROTECTED]> >To: <[email protected]> >Sent: Monday, November 17, 2003 5:40 PM >Subject: [DXBase] LoTW confirmations via ADIF file > > >> Hi, >> Can anybody advise if it's yet possible to load the ADIF file I get from >> the ARRL's LoTW site into DXBase? I don't like to have to go in and >> manually add each LoTW QSO if I don't have to, and since they now offer a >> download in ADIF format of all QSLs, that seems like the preferred way to >go. >> >> Any suggestions? >> >> If I try to import these records every line errors out with something like >> the following: >> >> "ERROR: HH4/W4WX The field is too small to accept the amount of data you >> attempted to add. Try inserting or pasting less data. HH4/W4WX 20030xxx >> yyyy 10m USB 59 59" (where x and y are actual values of date and time) >> >> >> >> >> >> 73 de Peter (W2IRT) >> [EMAIL PROTECTED] >> >> Please visit http://www.nyctrackbook.com for details of my book >> Tracks of the NYC Subway >> >> >> _______________________________________________ >> DXBase Reflector - Please visit us on the web at www.dxbase.com >> - - - - - - - - - - - - - - - - - - - - - - - >> To UNSUBSCRIBE please visit: >> http://mailman.qth.net/mailman/listinfo/dxbase >> > > >_______________________________________________ >DXBase Reflector - Please visit us on the web at www.dxbase.com >- - - - - - - - - - - - - - - - - - - - - - - >To UNSUBSCRIBE please visit: >http://mailman.qth.net/mailman/listinfo/dxbase > >
