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.
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:
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:
CQRLOG > File > Show QSO List (CTRL + O) > Filter > SQL Console
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:
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
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