beautypg.com

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

background image

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.

This manual is related to the following products: