Log4OM

Posted: **08 Oct 2021, 17:44**

Hi dear Hams,
I like to send a QSL card to all of my FIRST contacts.
How can I make/use a filter of my dbase or using a sql formula in order to get an adif file so I can print the QSL labels of my first contacts? Hans de PA3ACA

Posted: **15 Oct 2021, 09:21**

Hallo Hans,

Een goede vraag, maar zou dit ook niet weten.
Ik kijk uit naar het antwoord.

Hello Hans,

Good question, but wouldn't know either.
I look forward to the answer.

Posted: **22 Oct 2021, 05:20**

Hallo Hans, hallo Patrick,

ik heb dit "probleem" op 1 jan. 2021 al eens aangesneden maar helaas geen oplossing gekregen... Kijk maar eens naar 1 jan. 2021 en mijn call DL4DBM.

Hello Hans, Hello Patrick,

I already asked about this "problem" at Jan. 1st 2021 but never got a 100% solution... Look for Jan. 1st 2021 and my call DL4DBM.

Posted: **22 Oct 2021, 07:42**

Unfortunately, the "Direct SQL" feature in QSO manager only does delete/input/update queries but no selects. I can't think of any valid reason for this limitation. On the contrary, selects are risk-free when compared against delete/input/update.

You have to access the database from outside of Log4OM with a suitable tool. I'm using "Database Browser" by https://www.etl-tools.com/.

This is my query:

Code: Select all

Select *
From Log t1
Join
 (Select
    callsign,
    min(qsodate) as mindate
  From Log
  Group By callsign) t2 On t1.qsodate = t2.mindate
Order By
  callsign

Table t2 finds the first qsodate per callsign, t1 then provides all info for the qsos in t2. I tried this query myself and it produced the expected results.

Workaround for a solution within Log4OM:
- save a copy of your database
- SQL delete all qsos in database which are not among the ones found with the query above
- print QSL cards
- restore original database

Here is a query proposal (not executed myself, your own risk) to delete all "not first" QSOs per callsign:

Code: Select all

Delete From Log
Where qsoid Not In
 (Select qsoid
  From Log t1
  Join
   (Select
      callsign,
      min(qsodate) as mindate
    From Log
    Group By callsign) t2 On t1.qsodate = t2.mindate
 )

73, Markus HB9BRJ

Posted: **03 Dec 2021, 17:17**

Hi dear Markus,

thank you for the work around but I am not familiar with SQL.
I have downloaded the program you mentioned.

Solution now is that I upload all qso's to DCKeeper and in DXKeeper I can select [FIRST CONTACT] and from there I print the labels.

Thanks again and enjoy the hobby.
Best 73's
Hans de PA3ACA

Posted: **12 Feb 2022, 15:44**

Dag Hans,
Hello Hans,

Waar kan je in DxKeeper {FIRST CONTACT} selecteren?

Where can you select {FIRST CONTACT} in DxKeeper?

Log4OM

Prefer to send QSL to all of my FIRST contacts

Prefer to send QSL to all of my FIRST contacts

Re: Prefer to send QSL to all of my FIRST contacts

Re: Prefer to send QSL to all of my FIRST contacts

Re: Prefer to send QSL to all of my FIRST contacts

Re: Prefer to send QSL to all of my FIRST contacts

Re: Prefer to send QSL to all of my FIRST contacts