Search found 4 matches

by ko4def
27 Dec 2024, 03:06
Forum: General discussions
Topic: Print QSL cards from exported ADIF - Tool
Replies: 1
Views: 2567

Print QSL cards from exported ADIF - Tool

I don't know if Log4OM was already capable of this or not but I made a tool in Python for printing QSL cards. It was as much for me as it was for anything. You are welcome to use it. https://github.com/joeburden/ADIF2QSL
by ko4def
27 Dec 2024, 03:02
Forum: User support
Topic: How is the QSOID database field created?
Replies: 0
Views: 812

How is the QSOID database field created?

How is the QSOID database field created? I see it is partially time and date. I cannot seem to figure out where the last part of that field comes from. I'd like to make a DB conneciton to make an update.
by ko4def
26 Dec 2024, 01:13
Forum: General discussions
Topic: Importing ADIF file with paper QSL confirmations – How to avoid duplicates?
Replies: 4
Views: 1175

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

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 ...
by ko4def
25 Dec 2024, 23:25
Forum: General discussions
Topic: Importing ADIF file with paper QSL confirmations – How to avoid duplicates?
Replies: 4
Views: 1175

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

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

import sqlite3

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

# Update a record
cursor.execute ...