Creating and configuring data entities, Creating a snapshot, Creating and configuring data entities -7 – Grass Valley Xpanel Vertigo Suite v.4.8 User Manual
Page 109: Creating a snapshot -7

Xpanel User Manual
6-7
Adding a data source to an object
Creating and configuring data entities
Snapshots, tickers and multi-tickers are all data entities -- combinations of specific data
from a data source (more than one data source in the case of multi-tickers), and instructions
on how to display the data once it has been linked to an object (e.g. in ticker format, as a
snapshot value).
The following sections describe how to create and edit data entities:
•
“Creating a snapshot” on page 6-7
•
“Creating a ticker” on page 6-9
•
“Creating a multi-ticker” on page 6-11
•
“Editing and deleting data entities” on page 6-12
•
“Renaming or saving a copy of a data entity with a new name” on page 6-12
Creating a snapshot
A snapshot is a table of data values that is periodically refreshed. Use a snapshot to display
a single data value, in contrast to a ticker which cycles through a set of values.
To create a snapshot:
1.
Open Xpanel’s Asset Browser (Ctrl+A) and select the D
ATA
tab.
2.
Right-click on the schema that you want to add the snapshot to and select the N
EW
S
NAPSHOT
command.
The D
ATA
S
NAPSHOT
S
ETTINGS
window appears.
3.
In the S
NAPSHOT
N
AME
field enter a name for your snapshot.
4.
In the D
ATA
SOURCE
drop-down list, select one of the data sources that is already
defined in the schema.
The Data Setting fields that are displayed depend on the type of data source selected.
If the Data source is an Excel Spreadsheet:
• Verify the E
XCEL
FILE
path (read-only) and specify the sheet name in the
S
HEET
NAME
field.
If the Data source is a text file:
• Verify the T
EXT
FILE
path (read-only).
If the Data source is an RSS:
• Verify the URL path (read-only).
If the Data source is a database:
a.
Select one or more tables from the S
ELECT
TABLE
(
S
) section (hold down the SHIFT
or CTRL key for multiple selections)
b.
Select the columns to be returned from the query in the S
ELECT
R
ETURN
C
OLUMN
(
S
). To change the titles of selected columns, click the E
DIT
C
OLUMN
N
AMES
button. When the C
OLUMN
H
EADERS
dialog box displays, click in a column
name to make the text editable.