[Dxbase] Reconstructing my log

Fri Mar 30 17:25:05 EDT 2012

Bud,
 Yes, there is a way to do it. You might try K1MU's LoTW Query 
page here:
http://www.rickmurphy.net/lotwquery.html
 Put in the start and end dates for the WPX CW contest and you will 
get an ADIF file that contains the basic log information. Make sure on 
the above Query page that you do NOT check the "Report on QSL Records 
Only?" box. If you check that box, you will only get back QSO's that 
have been confirmed. Leaving the box unchecked gets you ALL your QSO's 
for the date range you specify.
 The returned ADIF file will consist of QSO's that look like this:
<APP_LoTW_OWNCALL:4>WF2B
<STATION_CALLSIGN:4>WF2B
<CALL:4>PJ4C
<BAND:3>12M
<MODE:3>SSB
<QSO_DATE:8>20120115
<TIME_ON:6>162106
<QSL_RCVD:1>N
<eor>
 That should be sufficient to import back into your log. If the 
contact HAS been confirmed on LoTW, the QSL_RCVD field will show "Y". 
You may need to change that before importing the ADIF file into DXBase, 
I'm not sure. I don't know how DXBase records your QSL's as being 
confirmed so I can't comment in detail. DXBase may see that as a paper 
QSL instead of an LoTW one. The simple solution would be to just use a 
text editor like Notepad and use Find/Replace to remove all instances of 
"<QSL_RCVD:1>Y" through the entire ADIF file.
 I hope this helps. Good luck.
Clark, W8TN
On 3/30/2012 2:27 PM, Harry Hovey wrote:
> With Joe's help, I have reinstalled DXBase2007 on another computer.
> Everything after December 2010 was lost so I am in process of
> reconstructing.
>> First I have imported my contest log files for 2011 and 2012. I have only a
> few non contest files and they are all in LoTW. I am manually putting those
> in. *HOWEVER*, I did not save the contest file for the WPX CW in 2011.
> Eveything is in LoTW, but putting in hundreds of calls and dates, time,
> frequency etc manually will be very time consumming and prone to typing
> errors. Does anyone know how I can download that info as adi file (not the
> one that only outputs QSLs) or even as an Excel file (which I can do, but
> don't know how I would convert to adif.)
>> 73 Bud WF2B