Messing with CQRLOG data behind the application

Sunday, August 8. 2021

Messing with CQRLOG data behind the application

Currently, in CQRLOG 2.5.1 of Ubuntu 21.04, QSL export for label printing is broken due to a FreePascal bug:

TRegExpr exec: empty input string.

Version 2.5.2 contains a fix, though. Now I had the choice between these unpleasent options:

Go through dependency hell by using the CQRLOG PPA for Ubuntu. This repo however has got some unresolvable dependencies. Attempts to work around these moved my system from MariaDB back to MySQL, resulting in a migration of the system database directory, what made a “downgrade” back to MariaDB another huge stumbling block. Luckily, I could switch back to 2.5.1 on MariaDB again.
Go through dependency hell by trying to compile CQRLOG from source. Either I’d have to mess with several odd development packages on my system directly, or by using a Docker container. This was a path I didn’t really want to take.
Delay printing QSL cards for several months until Ubuntu 21.10 is out (which hopefully contains that fix).

Couldn’t I somehow work around that bug? After all, I just wanted to dump certain log entries to a CSV. This could be done using an ordinary MySQL client! And this is the procedure to do so:

Start CQRLOG, this launches a MySQL (MariaDB) server instance in the CQRLOG data directory, which is ~/.config/cqrlog/database by default, listening on port 64000. Now, simply connect to it:

$ mysql -h 127.0.0.1 -P 64000

Use the desired database:

> use cqrlog001;

Query, using the columns you usually export:

> select qsodate, time_on, callsign, mode, freq, rst_s, qsl_via, remarks, stx, stx_string into outfile ’/path/to/qsl_test.csv’ fields terminated by ’,’ from cqrlog_main where qsl_s in (’SMB’, ’SB’);

The resulting CSV is already almost in the usual format, except for the date. In Vim, I did these transformations:

:%s/^$\d\+$-$\d\+$-$\d\+$/\3-\2-\1 :%s/-05-/-May- :%s/-06-/-Jun- :%s/-07-/-Jul-

etc.

As soon as I was satisfied with the result (in gLabels), I marked these QSL as sent:

> update cqrlog_main set qsl_s = ’B’ where qsl_s = ’SB’; > update cqrlog_main set qsl_s = ’MB’ where qsl_s = ’SMB’;

Querying around in that table is also a good opportunity for one’s own statistics.

Posted by Stephan Paukner in GNU/Linux, Ham Radio at 19:51 | Comments (0) | Trackbacks (0)

Defined tags for this entry: software

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

No comments

Add Comment

Name
Email
Homepage
In reply to
Comment	Phone* What is seven minus five? Enclosing asterisks marks text as bold (word), underscore are made via _word_. Standard emoticons like :-) and ;-) are converted to images. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above: BBCode format allowed
	Remember Information? Subscribe to this entry