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
Prefer to send QSL to all of my FIRST contacts
Re: Prefer to send QSL to all of my FIRST contacts
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.
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
Member UBA-IPA
WCA: ON-01354
Re: Prefer to send QSL to all of my FIRST contacts
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.
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
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:
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:
73, Markus HB9BRJ
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
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
)
Re: Prefer to send QSL to all of my FIRST contacts
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
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
Dag Hans,
Hello Hans,
Waar kan je in DxKeeper {FIRST CONTACT} selecteren?
Where can you select {FIRST CONTACT} in DxKeeper?
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
Member UBA-IPA
WCA: ON-01354