Over the last few years of using RCS Zetta, I’ve written a few random scripts that solve little problems here and there. I thought I’d share a few of them with you today.

For many of these scripts, you will need Python 2.7, PyODBC, and a configured ODBC source pointing to your primary Zetta SQL Database.

These are unofficial scripts, and not supported in any way by myself or RCS.

Log Import Email Alerts

Zetta has a good activity logger, but doesn’t provide much in the way of realtime alerting. This script sends a summary email whenever a log is imported to any station in your Zetta system. This can be particularly useful if you want to find out when a traffic-reload happens.

Add Timestamps to Background Recorder Asset Titles

Zetta allows you to record audio files in the background and override assets – useful for capturing satellite and codec feeds. However, there’s no quick way for on-air talent to see when an asset was last updated. This script checks all background-recorded files in the system, and appends a timestamp to the filename.

Batch Export Assets Based On External ID

Let’s say you need to export a lot of assets from Zetta, and you have a list of their External IDs (perhaps you got this list from an external music scheduling program, or a reconciliation file). How can you export all these files to a folder without locating the assets manually in the Library?

Simply paste your list of External IDs into the CONFIG_AssetList variable in this script, specify the source and destination directories, and run it.

ZettaView: HTML Status Feed Viewer

Update August 2018: ZettaView is now available for download. Check it out on GitHub.

ZettaView is a simple Zetta Status Feed client, which allows you to view the current and upcoming assets for a specific station in a web browser. This can be useful for outside broadcasts, TV displays around the building, or simple remote troubleshooting.

ZettaView is a Python script, with an in-built Flask web server. For convenience, I’ve bundled this script as an EXE.

Simply download the EXE, rename ‘config-sample.json’ to ‘config.json’, put you Zetta Status Feed Server’s address into the config file, run the EXE, and then browse to http://127.0.0.1:4444.

Please note – this is a simple script, which shouldn’t be exposed to the public internet. Please do not port forward to this script.