[Dx4win] LOTW Upload Confirm/Submit/Awarded

[Wendell Wyly - W5FL]

NO!  It is not even practical.  ARRL did not use the same calls in their
list that they had previously awarded for the DXCC awards.  I had previously
carefully entered the QSO that was approved by MODE and BAND as they were
approved.  When they went to LOTW, they used the most recent one that they
had approved for you.  The LOTW data does not include the information to
know from each confirmed contact what award it was actually credited.  The
following is an example:

<CALL:5>TX0DX
<BAND:3>20M
<MODE:3>SSB
<QSO_DATE:8>20000327
<TIME_ON:6>051106
<QSL_RCVD:1>Y
<QSLRDATE:8>20040516
<DXCC:3>512
<CQZ:2>32
<ITUZ:2>56
<IOTA:5>OC176
<GRIDSQUARE:4>QH90
<eor>

This QSO was credited for BAND, but not for SSB Mode, but you cannot tell
that from the QSL record.  The actual credited information is available on
the site, otherwise the award data could not be calculated on the ARRL
website.  Most of us have kept up with this information for many years and
have it correctly stored in DX4WIN at this time.

There are actually two parts to this, though.

1)  The adif import for LOTW download (with INCLUDE QSL DETAIL block
checked) could be improved in DX4WIN to allow import since LOTW records
contain IOTA, DXCC Country, state, gridsquare, cq zone, itu zone, qsl date,
and county data same as a paper QSL in addition to the confirmation and some
of this data is only available from a QSL card unless we can get it from the
LOTW record.  Again, it would be a disaster if you could not check each and
every piece of data before using it.  Believe it or not, many stations DO
NOT know their correct Zone, etc., and the LOTW QSL data is absolutely WRONG
is these cases.

2) IF ARRL makes the WHERE CREDITED data available in the QSL downloads,
then Paul might consider importing this data into DX4WIN, but it would
certainly require a separate program to import this into the log AND ALLOW
YOU to determine that you wanted to accept each and every piece of
information as it would destroy old records that are more accurate (although
now dated) than the LOTW information.

-----Original Message-----
From: dx4win-bounces at mailman.qth.net [mailto:dx4win-bounces at mailman.qth.net]
On Behalf Of ARS NZ3O (Byron) FM29fx
Sent: Thursday, June 10, 2004 8:31 PM
To: dx4win at mailman.qth.net
Subject: [Dx4win] LOTW Upload Confirm/Submit/Awarded

While I suspect this is going to be a nightmare for a short
time, does anyone know a trick for getting the ARRL LOTW
"Awarded" information into your DX4WIN database?

I completed the "roundtrip" to get my ADI download and
import it using "duplicate QSO sets Upload Confirmed"
which is great, but those are also Awarded and I can't
seem to use filters (10m, Upload Conf = Y) to do a mass
QSO update.  So it seems like I need to do a Submission,
which will be a mess since I would need to manually set every
QSL that was previous done (prior to DX4WIN and LOTW, too).

It "feels" like I have years of work ahead of me to get LOTW and
DX4WIN in-sync, since DX4WIN will need me to specify the
specific QSO that was submitted and awarded and that detail
doesn't seem to be readily available electronically.

Ideas?

73, Byron


_______________________________________________
Dx4win mailing list
Dx4win at mailman.qth.net
http://mailman.qth.net/mailman/listinfo/dx4win