CKMS 102.7 FM Radio Waterloo (elongated teal rectangle with yellow and black sunflower on the left and black text on the right and empty space at the bottom)

Create Log Files with LibreTime and a Spreadsheet

Here is one tool that may help you fill in your music logs. If you use LibreTime to schedule your tracks then you can see what aired from the “Calendar” menu item.

Click on your show and select “View”:
LibreTime Calendar screen showing "View" option
In this example, the show is “Training at 20:31 on Sun 9/4”

A “Contents of Show ‘Training’” window pops up, then drag the cursor from “Start”…
LibreTime Calendar screen with Contents of Show option, partially selected (highlighted)

…all the way to the end of the timeslot (the pop-up window will scroll):
LibreTIme Calendar screen with Contents of Show popup, showing selected (highlighted) tracks

Right-click and select “Copy”:
LibreTime Calendar view showing Contents of Show with tracks highlighted and context menu with cursor on Copy

And paste into your favourite spreadsheet application:
LibreOffice Spreadsheet with data from LibreTime (nicely formatted)
(some formatting may be required)

Track List History

You can now view the hour-by-hour track list history for the previous 60 days, and download .csv files in SOCAN log format from https://web.radiowaterloo.ca/ckmstracklist.php

Problems? Questions? Contact the Programming Committee at progcom@radiowaterloo.ca.

Community Radio in Waterloo Region