Various Zetta Scripts

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.

Get the Broadcast Technology Newsletter

Sign up for the email newsletter about media and technology. Sent irregularly. No spam.

I'm Anthony Eden, and I'm a broadcast technician / software developer / technology solutions engineer. I've been working in broadcast media since 2008 (getting my start in Community Radio while still at school), and developing software and websites for just as long. Right now, I work in the broadcast industry and provide some freelance services through Media Realm.

Follow Anthony on Twitter: @anthony_eden