Page 1 of 1

Merging QSL details from ADIF downloaded from QDure

Posted: 01 Jan 2021, 00:05
by kc2ieb
Hi -

Can someone help me figure out how to merge an ADIF with QSL information into Log4OM so it updates the QSL information in the DB?

I recently requested to send out about 700 QSL cards via QDure. This is a service where you upload ADIF, and they print QSL cards and send them to the right buro. After all is paid and sent, QDure provides an ADIF that looks like this, which contains the QSL status.

Is there a way to merge this ADIF into my Log4OM DB? I've tried a direct import of the ADIF QDure gave me, and Log4OM errors on each ADIF line:

Code: Select all

constraint failed UNIQUE constraint failed: Log.qsodate, Log.callsign, Log.band, Log.mode  Callsign: VA3AAA Date: 12/31/2020 7:09:00 PM Mode: SSB Band: 20m
Here's the line for this QSO from QDure:

Code: Select all

<CALL:6>VA3AAA <QSO_DATE:8>20201231 <TIME_ON:6>190900 <RST_SENT:2>57 <RST_RCVD:2>57 <BAND:3>20M <MODE:3>SSB <PROP_MODE:0> <QSL_SENT:1>Y <QSL_RCVD:1>R <OPERATOR:6>KC2IEB<EOR>
How can I bulk update the QSL_SENT field without doing all 700+ manually?

73, Chris

Re: Merging QSL details from ADIF downloaded from QDure

Posted: 01 Jan 2021, 08:43
by G4POP
I assume these QSO's are already in your logbook thats why the import found each one not to be unique (A dupe)?

If the QSO's can be block selected/identified (Filtered) because for example they are all from a particular contest or the period of a DXPedition etc., then you can use the QSL manager by just select the required QSO's and doing a mass update of the QSL sent confirmation field.

There is no merge routine for paper cards sent status update from an imported ADIF file in Log4OM at this time, although I can see it could be needed, strangely your the first person to my knowledge to request this, probably because most users are still sending paper cards and use our QSL manager.

If you have those paper cards recorded by LOTW (Cards sent to ARRL checker for credit/verification) then an LOTW download with the 'Retrieved credited QSL's' check box checked, with an early start date will do what you require.

Re: Merging QSL details from ADIF downloaded from QDure

Posted: 01 Jan 2021, 13:50
by kc2ieb
Thanks for replying. I’ll likely write a python script to find and merge the QSO details since this can’t be done in the logger.

The problem with bulk selecting QSOs and updating the QSL status is the provider I used to print and mail the cards only sends via bureau, so out of the 900 or so QSO I sent via ADIF export, maybe 700 cards were sent and the remainder are “no buro” or other exceptions which won’t get a card sent.

For now, I just bulk marked as sent. For me, if I can’t go by bureau and I don’t really want the card, well, I guess I’ll just pretend the bureau card never made it.