DXCC Online adif file export from CQRLOG

6 posts / 0 new
Last post
w4jkl
DXCC Online adif file export from CQRLOG

I would like to build an adif export file consisting of qso records that I manually select so that it matches the order that my cards will be submitted to ARRL for DXCC credit. This is suggested at the DXCC Online web site.

I thought I could do a Search for the call, then press the Select Current Record button, then Cancel Filter (shift-F12), and then do another search, etc, until I selected all of the records I want to include in the adif file export. Nope, when I press shift-F12 I get a blank message box and CQRLOG crashes, locked up.

My questions are:

What does Include mean in the Search box? What is its purpose?

What does Select Current Record do and what is its purpose?

What message is in the blank box?

Is it possible to build an adif file for export outside of the filter mechanism in CQRLOG?

Has anyone built an adif file for submission to DXCC Online?

73,
John W4JKL

Forgot to add the condx:
Debian Buster 64 bit. Same thing happens on Debian Stretch 64 bit. Intel Atom boxes in both cases.
CQRLOG 2.3.0 (216)

oh1kh
DXCC Online adif file export from CQRLOG

Hi!

I found few answers from source code:

Include is the same as in filter.
Setting include and callsign as W4J will find your call form log, but also other calls that begin with W4J...

"Select current record" seems to do same as pressing Ctrl and clicking qso lines. (note that selected counter at middle bottom of qso list increases).
It is just so that "Select current record" seems NOT work. Ctrl+click works.

Start cqrlog from console with:
cqrlog debug=1
And look at the console text at the time blank message appears. There my be a glue...or not.

Make full adif export then select records with text editor (delete ones not needed). Very hard, but works.

Last question: no answer.

Credit of your questions was that I found out that shorcutkeys help for qso list does not include Shift-F10 and Shift-F12.
And that Search form is not included into cqrlog project (in Lazarus programming GUi).
And also learned again a bit more from cqrlog.

--
Saku
OH1KH

w4jkl
DXCC Online adif file export from CQRLOG

Here is the work-around I used to get the DXCC Online ADIF file for submitting cards.

1. Export ADIF of CQRLOG log you want to use.

2. Import that ADIF into free ADIFMaster Windows application (I run it under Wine), check it to make sure it is clean, and then export it to a CSV file.

3. Import the CSV file into LibreOffice Calc.

4. Search for each of the contacts you want to include in the DXCC ADIF file, and copy, then paste to a second CSV file that you will use to create the DXCC ADIF file. Be sure to copy/paste the 1st row of the spreadsheet so that you get your column headers for the second spreadsheet.

5. Import the second CSV file into ADIFMaster, check it for errors, then export it as a ADIF file to send to DXCC Online.

73,
John W4JKL

oh1kh
DXCC Online adif file export from CQRLOG

HI!
Fine that you found a way. That is the same as export adif and do edit with text editor, but easier with better tools.

Qso selection from qso list/adif export needs investigations. At present state it does not work properly.

--
Saku
OH1KH

w4jkl
DXCC Online adif file export from CQRLOG

Here is debug=1 output for Filter by callsign, click Select Current Record, and shift-F12. No crash. foo?

SELECT * FROM profiles ORDER BY nr

SELECT * FROM profiles WHERE nr = 1

SELECT * FROM view_cqrlog_main_by_qsodate WHERE (callsign = 'K2DH') AND (qsodate >= ' - - ') AND (qsodate <= '2019-04-25')
SELECT * FROM view_cqrlog_main_by_qsodate WHERE (callsign = 'K2DH') AND (qsodate >= ' - - ') AND (qsodate <= '2019-04-25')

SELECT * FROM view_cqrlog_main_by_qsodate WHERE (callsign = 'K2DH') AND (qsodate >= ' - - ') AND (qsodate <= '2019-04-25')

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

LoadForm: frmMain
select * from view_cqrlog_main_by_qsodate LIMIT 500

SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

w4jkl
DXCC Online adif file export from CQRLOG

After Filter and Select of two callsigns as above (the count never did appear below), releasing the Filter caused the empty window to appear and the following in the debug terminal:

WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
WARNING: TDBGrid.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
Deleting config file: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/john/.config/cqrlog/database/hamradio1.pid
p.Executable: kill Parameters: 8946

Closing ini file ...
[TGtk2WidgetSet.Destroy] WARNING: There are 1 unreleased DCs, a detailed dump follows:
[TGtk2WidgetSet.Destroy] DCs: 00000000056985E8
[TGtk2WidgetSet.Destroy] WARNING: There are 1 unreleased GDIObjects, a detailed dump follows:
[TGtk2WidgetSet.Destroy] GDIOs: 0000000005887A28
[TGtk2WidgetSet.Destroy] gdiBrush: 1

73,
John W4JKL