Importing ADIF file with paper QSL confirmations – How to avoid duplicates?

[IT9GHW]

Hi everyone, I’m Carmelo (IT9GHW).
I need some advice regarding the import of ADIF files containing paper QSL confirmations into Log4OM V2.

Here’s my situation:
I have an ADIF file that I processed using external software for QSL label printing. I find this method more convenient because I haven’t been able to fully understand or configure the label printing module in Log4OM.

The external software I’m using (such as BV7, for example) requires an ADIF export from Log4OM to print the labels. After printing, I would like to import the updated ADIF file back into Log4OM to keep my records complete and up-to-date.
I think that aren't only the main import function of toolbar but I know that Log4OM has an automatic ADIF reading function based to UDP sockets feature, but I’m not sure if this can help in my case. Could this feature be used to manage the import of QSL confirmations and avoid creating duplicate entries?

I’d appreciate any advice or guidance on the best way to handle this process, as well as any insights into how to properly use the automatic import function for this type of task.

Thank you very much for your time and support!

Best regards,
Carmelo IT9GHW.

[G4POP]

Importing the adif won't work you need to bulk update within log4om

[IT9GHW]

Thanks dear Ferry.
Merry XMAS to you and you family.
Can you tell me about bulk update?
Tnx.
Carmelo - IT9GHW.

[ko4def]

You can manipulate the sqlite database with python fairly easily. As long as the database schema does not change you would be golden.

Code: Select all

import sqlite3

# Connect to the Log4OM database
conn = sqlite3.connect('path/to/your/log4om/database.db')
cursor = conn.cursor()

# Update a record
cursor.execute('''
    UPDATE LOG
    SET QSO_COUNTRY = 'United States'
    WHERE ID = 12345
''')

# Commit the changes
conn.commit()

# Close the connection
conn.close()

[ko4def]

I took a browse on the database and it looks like 2 tables .... Log and Informations. You would be looking to execute an update operation against the database in the Log table where the field qsoid matched your QSO that you exported into that ADIF file. There is another field called qsoconfirmations that you will want to change data in to do what you are talking about.

qsoid is in the format
20221011133037539
where the last number increments and

qsoconfirmations is the format

[{"CT":"EQSL","S":"Yes","R":"No","SV":"Electronic","RV":"Electronic","SD":"2022-02-25T00:00:00Z"},{"CT":"LOTW","S":"Yes","R":"Yes","SV":"Electronic","RV":"Electronic","RD":"2020-12-07T00:00:00Z"},{"CT":"QSL","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"QRZCOM","S":"Yes","R":"No","SV":"Electronic","RV":"Electronic","SD":"2020-11-20T00:00:00Z"},{"CT":"HAMQTH","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"HRDLOG","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"CLUBLOG","S":"No","R":"No","SV":"Electronic","RV":"Electronic"}]

Always make a backup and be very careful/mindful about what you update in the database with SQL