First off, I LOVE CQRLOG. Second, how can I get a list of just the DXCC stations I worked but have not gotten a confirmation from?
Thanks!
-David, N9KT
Tue, 2020-04-21 09:23
#1
DXCC worked but not confirmed?
Hi David!
I did not find that kind of feature from cqrlog, but as qsos are in database mysql can be used.
I copied and slightly modified the sql sentence that produces DXCC statistic table in cqrlog.
I do not know are results correct but you must study.
Download file from
https://drive.google.com/file/d/12q6FxhpE9w8eiHfeUfQMbcBTbk6QVjiG/view?u...
Using command console change to directory you downloaded the file
Edit the file with your favorite text editor:
change "saku" in "mysocket" to be your username
change log number "001" to point your current log in use
Save file
Then set execute bit with command:
chmod a+x dxccdump.sh
Open your cqrlog (so that database engine starts).
Then execute file with command:
./dxccdump.sh
Study results in /tmp/DXCC.txt
Was this useful?
--
Saku
OH1KH
Hi David!
If you want to pick just unconfirmed qsos to spreadsheet from the resulting /tmp/DXCC.txt
give this console command:
cat /tmp/DXCC.txt | tr -d [" "] | awk -F"\x7C" '{if ($6 =="" && $7 =="" && $8 =="") {print $2","$3","$4","$5","$9} }' > /tmp/DXCC.csv
You may need to install awk package if you system does not provide it as default.
Then open /tmp/DXCC.csv with your spreadsheet program (like LibreOffice)
--
Saku
OH1KH
Saku-
That worked perfectly! Thanks!
-David, N9KT