Grass Valley Xpanel Vertigo Suite v.4.8 - Manual (Page 107)

Xpanel User Manual 6-5
Adding a data source to an object
6. If you chose E XCEL S PREADSHEET from the D ATA S OURCE T YPE drop-down list, provide the
required information in the F ILE N AME OR URL field (click to browse).
N
OTE
Only .xls files are supported. Excel’s .xlsx files are not supported.
7. If you chose D ELIMITED T EXT F ILE from the D ATA S OURCE T YPE drop-down list:
a. Provide the required information in the F ILE N AME OR URL field (click to browse).
b. Specify the characters that will act as the column and row delimiters in the text file. By
default, the C
OLUMN DELIMITER is set to a comma character and the R OW DELIMITER is set
to \r\n (carriage return and line feed).
c. Set the URL T IMEOUT property in milliseconds (default = 5000).
d. If the Column delimiter is set to comma and your text file data contains a text string with
an intentional comma (i.e. Smith, Daniel, Jones, Mary), you can avoid the unintentional
breaking on commas by putting the text between double quotations (i.e. “Smith, Daniel”,
“Jones, Mary”) and enabling the D
OUBLE QUOTES ESCAPE COLUMN DELIMITER parameter.
8. If you chose RSS from the D ATA S OURCE T YPE drop-down list, enter the URL.
RSS commonly-used XML format distributes news headlines, links and abstracts
collected from the Web. There are many sites available that conform to this format. For
a sampling, refer to http://www.newsisfree.com/. From there you can create an
account and then start browsing the free news feeds.
N
OTE
Make sure the web site you are entering is correct and up-to date.
9. Click the S AVE button to save the new data source. It displays at left under D ATA S OURCES .
10. Repeat steps 3 to 10 until all data sources for the schema have been created, then click
OK. This closes the D ATA S CHEMA S ETTINGS window.
Editing schemas
When editing a schema, you are editing data source details.
To edit a schema:
1.
Open Xpanel’s Asset Browser (Ctrl+A) and select the D ATA tab.
2. Right-click on the schema that is to be edited and select the E DIT command.
The D ATA S CHEMA S ETTINGS window appears.
3. Select a data source from the list at left.
4. Click the E DIT button. The D ATA SOURCE SETTINGS fields are displayed.
For a description of each data source setting, please refer to page 6-3 .
Or,
Click the D
ELETE button to delete the data source from the schema.
5. When done making changes, click the S AVE button and then click OK to exit the D ATA
S CHEMA S ETTINGS window.