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.

 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.

• Excel
• Google Spreadsheet Template - You can add this template to your own Google Drive by clicking the "Use This Template" button. 
• CSV

 Google Spreadsheet:

 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…'):

- Copy the Google Spreadsheet Validation Script found here and paste it into the editor

 - Click the Save icon and name it. 

 Excel:

The sample file provided above has the validation script built in. If you already have a file you would like to use, you can use the validation script linked here.

 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.