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 To: Gary AL9A Cc: DXbase Reflector 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 <[email protected]> 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" <[email protected]> To: "'Crownhaven'" <[email protected]>; "'N3XX'" <[email protected]> Cc: "'DXBase List'" <[email protected]>; <[email protected]> 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:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
