Prefer to send QSL to all of my FIRST contacts

Post Reply
PA3ACA
Novice Class
Posts: 3
Joined: 19 Sep 2021, 19:06

Prefer to send QSL to all of my FIRST contacts

Post by PA3ACA »

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
on6at
Advanced Class
Posts: 42
Joined: 19 Oct 2020, 13:36
Location: Gavere
Contact:

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

Post by on6at »

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.
73 Patrick ON6AT
Member UBA-IPA
WCA: ON-01354
DL4DBM
Novice Class
Posts: 14
Joined: 01 Jan 2021, 12:29

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

Post by DL4DBM »

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.
HB9BRJ
Old Man
Posts: 173
Joined: 23 Nov 2014, 10:46
Location: Schaffhausen

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

Post by HB9BRJ »

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
PA3ACA
Novice Class
Posts: 3
Joined: 19 Sep 2021, 19:06

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

Post by PA3ACA »

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
on6at
Advanced Class
Posts: 42
Joined: 19 Oct 2020, 13:36
Location: Gavere
Contact:

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

Post by on6at »

Dag Hans,
Hello Hans,

Waar kan je in DxKeeper {FIRST CONTACT} selecteren?

Where can you select {FIRST CONTACT} in DxKeeper?
73 Patrick ON6AT
Member UBA-IPA
WCA: ON-01354
Post Reply