Page 1 of 1
Prefer to send QSL to all of my FIRST contacts
Posted: 08 Oct 2021, 17:44
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
Re: Prefer to send QSL to all of my FIRST contacts
Posted: 15 Oct 2021, 09:21
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.
Re: Prefer to send QSL to all of my FIRST contacts
Posted: 22 Oct 2021, 05:20
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.
Re: Prefer to send QSL to all of my FIRST contacts
Posted: 22 Oct 2021, 07:42
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
Re: Prefer to send QSL to all of my FIRST contacts
Posted: 03 Dec 2021, 17:17
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
Re: Prefer to send QSL to all of my FIRST contacts
Posted: 12 Feb 2022, 15:44
by on6at
Dag Hans,
Hello Hans,
Waar kan je in DxKeeper {FIRST CONTACT} selecteren?
Where can you select {FIRST CONTACT} in DxKeeper?