A Livestream Studio Certified Data Source (LSCDS) is a spreadsheet document formatted according to the Livestream Studio specification. An Excel (.xlsx), CSV or Google Spreadsheet document can be used to define LSCDS. Below, you'll find information on the benefits and instructions on how to create/utilize a LSCDS formatted file.
Why do I need Livestream Studio™ Certified Data Sources?
The main advantage of LSCDS in Livestream Studio™ graphics layer compared to any standard custom excel, Google spreadsheet or CSV file is the ability to remotely control data selection “eyeball” in Livestream Studio™. This feature is primarily designed for distributed production workflows, meaning when a dedicated person operates graphics data during a live video production.
This feature can also be used for automation, for example, in combination with custom web services that generate CSV files on the fly to control graphics data in production, such as sports scoring.
In the examples below, you’ll find small scripts for data ON/OFF program validation, as well as illustrations on how to bring dynamic image objects into Livestream Studio using external files.
How to define Livestream Studio™ Certified Data Sources
You can copy one of the examples below and add columns, rows and data to the example as needed (make sure the PROGRAM column remains in the A1position).You may also use an existing file as a Livestream Certified spreadsheet, just add an additional first column and name the first cell (Cell A1) - PROGRAM. Once you have load the file to Livestream Studioas a graphics data layer, you will see a small Livestream logo over the layer thumbnail.
Once the file is identified as a certified data source, Livestream Studio will look for "ON" and "OFF" values within the first column (A2:Ax). "ON" value will activate that row in the Livestream Studio™ GFX layer, while "OFF" deactivates that row. The "ON" or "OFF" status will be represented by the "eyeball" logo within Livestream Studio.
If there are multiple ON values in the column, Livestream Studio will use the first from the top. You can add validation scripts to your spreadsheet by following instructions below to maintain single row selection. More information on using validation scripts below.
Note: All the values that are not equal to ON and OFF will be ignored.
Livestream certified CSV files can be used in Studio via file path on local disk/network or over HTTP protocol.
Sample LSCDS Files
Installing Validation Scripts
The Google Spreadsheet templates linked above already include validation scripts. Below is a link to the source code of the validation script we used for the sample. You can use the text to install the script on your own custom Google Spreadsheets. To install the script, do the following:
- Click 'Tools' > 'Script Editor…' (or 'Script Manager…'):
Dynamic images and LSCDS
External data files may contain columns with HTTP URLs or local/network addresses referencing images you would like to use in your GFX template. To define a column as an Image type column, add [img] at the beginning of the column name. Livestream Studio™ will recognize the path as an image and display it in your graphics template.
Note: When an image can not be found at the provided URL or path, Studio will display an empty (transparent) image field.
Spreadsheet Formatting Best Practices
- Freeze row 1 and column 1 (View - Freeze Row / Freeze Column)
- Add data validation using the shown parameters:
- Add conditional formatting to the A2:A (all the values in A row except A1)
Excel file formatting:
We recommend using the template available HERE when using Excel files for LSCDS.