[Dxbase] DxBase - LoTW Problem

[Ed K1EP]

LoTW allows one to upload any ADIF log, such as one from a contest 
program or from DxBase/  When LoTW first came out, I tried loading 
each contest ADIF output into LoTW and quickly realized that it would 
be easier to load the contests into DxBase first and then 
periodically upload the DxBase ADIF output into LoTW.  This works 
just fine, until you want to download your LoTW QSLs into 
DxBase.  Why?  Because when DxBase imports ADIF contest logs, it 
truncates seconds on the QSO time.  Contest log ADIF outputs have 
HH:MM:SS, but DxBase time converts it to HH:MM:00.  So, if you have 
uploaded an ADIF log directly from your contest program into LoTW and 
then try to match up a QSL with the downloaded report from LoTW, you 
get error messages like (the call has been changed to WA1ABC):

ERROR:  WA1ABC The changes you requested to the table were not 
successful because they would create duplicate values in the index, 
primary key, or relationship.  Change the data in the field or fields 
that contain duplicate data, remove the index, or redefine the index 
to permit duplicate entries and try again. WA1ABC 20050220 
192900  20m  CW 599 599

The QSOs do not match up because the times are now different.  So, I 
created a new ADIF file from DxBase to upload to LoTW that would 
overwrite the old logs.  The original contest ADIF file that was both 
uploaded to LoTW and DxBase looked like:

<CALL:6>WA1ABC <QSO_DATE:8>20050220 <TIME_ON:6>192939 <MODE:2>CW <BAND:3>20M
<FREQ:6>14.094 <RST_SENT:3>599 <RST_RCVD:3>599 <RX_PWR:3>100 <EOR>

The new ADIF file from DxBase to upload looked like:

<CALL:6>WA1ABC <QSO_DATE:8>20050220 <TIME_ON:6>192900 <RST_SENT:3>599 
<RST_RCVD:3>599 <QSL_VIA:4>None
<ITUZ:2>28 <OPERATOR:4>K1EP <PFX:3>HB9 <QSL_RCVD:1>N <DXBQSL_RCVD:1>0 
<FREQ:8>14.09400
<BAND:3>20M <CQZ:2>14
<MODE:2>CW <QSL_SENT:1>N <DXBQSL_SENT:1>2 <COMMENT:10>ARRL DX CW
<DXBPFX:2>HB <DXCC:3>287 <DXBMGRN:1>1 <DXBAWD:1>0 <DXBSEL:1>0 <DXBVAL:1>3
<EOR>

That created the result in LoTW of a second unconfirmed QSO:

Details         K1EP    WA1ABC  2005-02-20 
19:29:39     20M     CW      14.094          SWITZERLAND
Details         K1EP    WA1ABC  2005-02-20 
19:29:00     20M     CW      14.09400

It did not fix the problem, so the QSL from LoTW still has the one 
with the seconds, so when I do a report, I still get the time with seconds.

<APP_LoTW_OWNCALL:4>K1EP
<STATION_CALLSIGN:4>K1EP
<CALL:6>WA1ABC
<BAND:3>20M
<MODE:2>CW
<QSO_DATE:8>20050220
<TIME_ON:6>192939
<QSL_RCVD:1>Y
<QSLRDATE:8>20090325
<eor>

About the only thing I can think of right now to fix this problem, is 
to write a script to edit the downloaded LoTW report and change any 
seconds to :00.

Any other thoughts??