Reporting

Program Schedule Reports

Most radio stations require the generation of annual reports for regulatory or funding purposes.

AURA provides a Django management command to generate yearly CSV reports based on the program schedule in Steering.

Report with shows and categories

To generate a report for the year 2026, with shows with their categories, you can run:

docker compose run --rm steering generatereport category 2026 > orange-2026.csv

Alternatively, you can find a database query script provided by Radio ORANGE 94.0 in the aura/contrib/rtr-reporting directory.

Contributions are unsupported

Note, this script serves as a helpful reference for your own reporting needs. Please keep in mind that external contributions in the contrib folder are not officially tested or supported by the AURA team.

Report with shows and funding categories

To generate a report for the year 2026, with shows with their funding categories, you can run:

docker compose run --rm steering generatereport funding_category 2026 > helsinki-2026.csv

Report with shows, funding categories and people involved

To generate a report for the year 2026, with shows with their funding categories and the number of people involved, you can run:

docker compose run --rm steering generatereport people 2026 > freirad-2026.csv

Play-out Reports

To generate playlog reports you can use the playlog endpoint of Engine API. These reports have to be manually generated and aggregated for now.

Learn how playlogs are structured in the API Schema for PlayLog.