Reply to comment

Cabrillo format from cqrlog

I wanted to get a ARRL DX contest participation pin which requires sending the first page of your log in Cabrillo format so I had to figure out how to go from my logging program CQRLOG to cabrillo format. The funny thing about Cabrillo format is it's not really a format. The only thing that is the same is the header, the order of columns and included columns for each QSO vary by contest. Here is how the ARRL defines Cabrillo for their use: ARRL Cabrillo format You can also use the cabrillo web form to generate the logs from your own manual input. I used it to check my cabrillo header. Okay, here we go.

Header

here is how the header should look

START-OF-LOG: 3.0
LOCATION: NC
CALLSIGN: KG4AKV
CATEGORY-OPERATOR: SINGLE-OP
CATEGORY-TRANSMITTER: ONE
CATEGORY-POWER: LOW
CATEGORY-ASSISTED: NON-ASSISTED
CATEGORY-BAND: ALL
CONTEST: ARRL-DX-SSB
OPERATORS: KG4AKV
EMAIL: johnbrier@blablahno.com
NAME: John Brier
ADDRESS: 5206 LUndy Dr. Apt 101
ADDRESS: Raleigh, NC 27606
SOAPBOX: First contest! worked so many DX stations!

END-OF-LOG:

QSO data

example:

QSO:, Freq, mode, date, UTC, mycall, contest exchange, dxcall, contest exchanged recieved

QSO: 14000 PH 2008-03-01 1456 W1AW 59 CT 6Y5/NN1N 59 100
QSO: 14000 PH 2008-03-01 1459 W1AW 59 CT G0ABC 59 400
QSO: 14000 PH 2008-03-01 1504 W1AW 59 CT EA8XYZ 59 500
QSO: 21000 PH 2008-03-01 1508 W1AW 59 CT XE1ABC 59 100
END-OF-LOG:

Export QSO data from CQRLOG

CQRLOG > File > Show QSO List (CTRL + O) > Filter > SQL Console

use the following SQL

select freq, mode, qsodate, time_on, my_loc, rst_s, my_loc, callsign, rst_r, pwr from cqrlog_main where qsodate >= '2012-03-03' AND qsodate <= '2012-03-04'

we are using my_loc twice as it is always the same (our grid square) for each row. Later on we will use two separate instances of regular expressions to change the first instance to KG4AKV (my callsign) and the second instance to NC (my state)

click the export data icon (looks like a mailbox I think)
save the file as cqrlog-ARRL-DX-cabrillo.csv
use sed to format the CSV into the cabrillo style:

reformat CSV into cabrillo with sed and awk

sed -e 's/;/ /g' -e 's/SSB/PH/' -e 's/FM05PS/KG4AKV/' -e 's/FM05PS/NC/' cqrlog-ARRL-DX-cabrillo.csv > cqrlog-ARRL-DX-cabrillo.txt

use awk to insert "QSO: " in front of each line

awk '{print "QSO: " $0}' cqrlog-ARRL-DX-cabrillo.txt > cqrlog-ARRL-DX-cabrillo.cab

cqrlog-ARRL-DX-cabrillo.cab should look like this
note you will want to remove the first line with column descriptions from the original export from cqrlog

QSO: freq mode qsodate time_on my_loc rst_s my_loc_1 callsign rst_r pwr
QSO: 14.262 PH 2012-03-03 01:27 KG4AKV 59 NC V26M 59 100
QSO: 14.267 PH 2012-03-03 01:30 KG4AKV 59 NC EF8R 59 100
QSO: 14.2795 PH 2012-03-03 01:31 KG4AKV 59 NC YW4D 59 100
QSO: 14.3195 PH 2012-03-03 01:44 KG4AKV 57 NC XE1XOE 59 100

Reply

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.