DXCC worked but not confirmed?

4 posts / 0 new
Last post
N9KT
DXCC worked but not confirmed?

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

oh1kh
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

oh1kh
DXCC worked but not confirmed?

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

N9KT
DXCC worked but not confirmed?

Saku-
That worked perfectly! Thanks!
-David, N9KT