Ham Radio

Monday, November 1. 2021

OE Amateurfunk-Rufzeichen 11/2021

Änderungen seit 10/2021

Folgende 16 Rufzeichen sind verstummt:

OE1AGF
OE1DKB
OE1XCA
OE2GDN
OE2JYN
OE2XBO
OE3CZA
OE5HLN
OE5RKM
OE6GKG
OE7JVI
OE8MAK
OE8XEK
OE8XHR
OE8XNR
OE9MIE

Folgende 18 Rufzeichen wurden bewilligt:

OE1CSK
OE1MIE
OE1XDU
OE3AGF
OE3HLN
OE5BYE
OE5CZA
OE5GZE
OE5OSW
OE8ABJ
OE8AEV
OE8BKX
OE8CGU
OE8EGR
OE8EWJ
OE8JDI
OE8MCR
OE8TOH

Quelle: Fernmeldebüro

Dieser Eintrag wurde automatisch erstellt. Angaben ohne Gewähr.

Posted by Stephan Paukner in Ham Radio at 12:30 | Comments (0) | Trackbacks (0)

Defined tags for this entry: austria, german

Friday, October 1. 2021

OE Amateurfunk-Rufzeichen 10/2021

Änderungen seit 09/2021

Folgende 11 Rufzeichen sind verstummt:

OE1SYW
OE3ASS
OE3HJS
OE3ROW
OE6ETF
OE7FBT
OE7KPJ
OE7SJT
OE7UDH
OE8HGQ
OE9YVV

Folgende 2 Rufzeichen wurden bewilligt:

OE5XOO
OE7XKG

Quelle: Fernmeldebüro

Dieser Eintrag wurde automatisch erstellt. Angaben ohne Gewähr.

Posted by Stephan Paukner in Ham Radio at 12:30 | Comments (0) | Trackbacks (0)

Defined tags for this entry: austria, german

Friday, September 10. 2021

OE Amateurfunk-Rufzeichen 09/2021

Änderungen seit 08/2021

Folgende 20 Rufzeichen sind verstummt:

OE1JFB
OE1UPA
OE2BZL
OE2LKP
OE2WIM
OE3GRU
OE3HYE
OE3TFW
OE3WEW
OE5AAP
OE5BGO
OE5WIL
OE6HJG
OE6LSE
OE6WHE
OE6WRG
OE6YKF
OE7HAH
OE8ATQ
OE8CLR

Folgende 7 Rufzeichen wurden bewilligt:

OE1CLR
OE2HYE
OE2VBO
OE3WIM
OE8TGK
OE9HIE
OE9UHI

Quelle: Fernmeldebüro

Dieser Eintrag wurde automatisch erstellt. Angaben ohne Gewähr.

Posted by Stephan Paukner in Ham Radio at 17:30 | Comments (0) | Trackbacks (0)

Defined tags for this entry: austria, german

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