Overwrite existing QSO during ADIF import possible ?

[DG9MA]

Hello, i am trying to overwrite already exisiting QSOs in Log4OM 2 by importing a modified ADIF file.

As result, i get this log and import seems to be failed:

21:16:48: [IMPORT ADIF FORM] Begin ADIF import task
21:16:49: SEARCHING FULL AWARDS REFERENCES...
21:16:49: End of ADIF import
21:16:49: Begin LOG save
21:16:49: constraint failed UNIQUE constraint failed: Log.qsodate, Log.callsign, Log.band, Log.mode Callsign: DL1ABC Date: 04.06.2020 22:00:00 Mode: PSK Band: 40m
21:16:49: LOG saved
21:16:49: Save completed


Should this be possible and if yes - what i am doing wrong?

Thanks
Manuel

[G4POP]

Log4om does not overwrite existing qso's during adif import

I believe your trying to update qso's like merge, if you explain exactly what your trying to achieve I might be able to help

[DG9MA]

Hi Terry, thanks for your reply.

The problem is that i have missed to transfer the "Qsl sent" and "Qsl rcvd" information through ADIF import.

So i see all QSOs from my old Logbook in Log4OM 2 but without "Qsl Received" / "Qsl Sent" info.


Do i need to delete all QSOs and re-import again properly ? Or is there hopefully a workaround maybe ?

Regards
Manuel

[DG9MA]

..and yes, i would like to merge them. So i tried to add the "Qsl sent / rcvd" info to already existing QSOs by re-importing again.

[G4POP]

Hi Terry, thanks for your reply.

The problem is that i have missed to transfer the "Qsl sent" and "Qsl rcvd" information through ADIF import.

So i see all QSOs from my old Logbook in Log4OM 2 but without "Qsl Received" / "Qsl Sent" info.


Do i need to delete all QSOs and re-import again properly ? Or is there hopefully a workaround maybe ?

Regards
Manuel

What software generated the adif you were trying to import?

[DG9MA]

It's Hamoffice. The ADIF file contains the header and below this row:

<QSO_DATE:8>20200604 <CALL:6>DL1ABC <DXCC:3>230 <DXCC_PREF:2>DL <CQZ:2>14 <CONT:2>EU <WAE:2>DL <MODE:3>PSK <ITUZ:2>28 <TIME_ON:4>2200 <QSL_RCVD:1>Y <QSL_RHO:1>Y <QSL_SENT:1>Y <QSL_SHO:1>Y <RST_SENT:3>599 <RST_RCVD:3>599 <QSL_SENT:1>Y <QSL_SHO:1>Y <QSL_RCVD:1>Y <QSL_RHO:1>Y <BAND:3>40m <EOR>

[G4POP]

It's Hamoffice. The ADIF file contains the header and below this row:

<QSO_DATE:8>20200604 <CALL:6>DL1ABC <DXCC:3>230 <DXCC_PREF:2>DL <CQZ:2>14 <CONT:2>EU <WAE:2>DL <MODE:3>PSK <ITUZ:2>28 <TIME_ON:4>2200 <QSL_RCVD:1>Y <QSL_RHO:1>Y <QSL_SENT:1>Y <QSL_SHO:1>Y <RST_SENT:3>599 <RST_RCVD:3>599 <QSL_SENT:1>Y <QSL_SHO:1>Y <QSL_RCVD:1>Y <QSL_RHO:1>Y <BAND:3>40m <EOR>

Hi Manuel,
Clearly we need to add a merge facility in the near future, I will see what can be done.

Meanwhile I think the easy route is as follows

1. Backup your log4om logbook and save an ADIF file of your log to your desktop.
2. Create a new empty Log4om database
3. Import the hamoffice adif file
4. Now import the ADIF file that you saved in step 1 above

Because we don't allow duplicate qso's the dupes in the imported log4om adif will be ignored and your updated qso's preserved

Bit of a long way round but until we add a merge that will fix your problem, let me know how you get on

[DG9MA]

Hi Terry!

It worked very fine for me and result is perfect!
Many thanks for your great support!
Much appreciated.

73 Manuel