Log4OM

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

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

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

..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.

DG9MA wrote: 04 Jun 2020, 21:41 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?

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>

DG9MA wrote: 05 Jun 2020, 07:15 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

Hi Terry!

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

73 Manuel