User Guide
Infocaster™ Data Source Wizard 6/6/2014
175-100355-00
Infocaster™ Data Source Wizard
User Guide
Publication Information © 2014 Imagine Communications. Proprietary and Confidential. Imagine Communications considers this document and its contents to be proprietary and confidential. Except for making a reasonable number of copies for your own internal use, you may not reproduce this publication, or any part thereof, in any form, by any method, for any purpose, or in any language other than English without the written consent of Imagine Communications. All others uses are illegal. This publication is designed to assist in the use of the product as it exists on the date of publication of this manual, and may not reflect the product at the current time or an unknown time in the future. This publication does not in any way warrant description accuracy or guarantee the use for the product to which it refers. Imagine Communications reserves the right, without notice to make such changes in equipment, design, specifications, components, or documentation as progress may warrant to improve the performance of the product.
Trademarks Infocaster™ and Infocaster Manager™ are trademarks or trade names of Imagine Communications or its subsidiaries. Microsoft® and Windows® are registered trademarks of Microsoft Corporation. All other trademarks and trade names are the property of their respective companies.
Contact Information Imagine Communications has office locations around the world. For domestic and international location and contact information, visit our Contact page (http://www.imaginecommunications.com/company/contact-us.aspx).
Support Contact Information For domestic and international support contact information see:
Support Contacts (http://www.imaginecommunications.com/services/technical-support.aspx) eCustomer Portal (http://support.imaginecommunications.com) Academy Training (http://www.imaginecommunicationsacademy.com)
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 2
Infocaster™ Data Source Wizard User Guide
Contents
Contents Introduction to the Data Source Wizard ................................................................ 5 Create Data Tags....................................................................................................................................... 5 Data Source Wizard Workflow ................................................................................................................. 6 Open the Data Source Wizard .................................................................................................................. 6 Change Selections..................................................................................................................................... 6 Exit the Data Source Wizard ..................................................................................................................... 6 External Data Output ................................................................................................................................ 6
Set Up a Data Source ............................................................................................. 7 Data Source Type Options ........................................................................................................................ 8 Set Up a New Text File .............................................................................................................................. 8 Add a Text File with ODBC .................................................................................................................... 9 Add a Text File without ODBC ............................................................................................................ 10 Set Up a New RSS/XML Feed .................................................................................................................. 11 Select an Existing Data Source................................................................................................................ 14 Use ODBC Data Sources ..................................................................................................................... 14 Use Non-ODBC Data Sources ............................................................................................................. 14 Set Up Live Chat Data ............................................................................................................................. 14
Link Data Tags to Data Sources ............................................................................ 16 Choose The Data Sources ....................................................................................................................... 16 Link Data Tags to Data Sources .............................................................................................................. 16 Establish Other Source Tables ................................................................................................................ 18
Format, Refine, and Sort the Data ....................................................................... 19 Data Formatting...................................................................................................................................... 19 Refine Range & Style .............................................................................................................................. 20 Refine Data With Condition Selection ................................................................................................ 20 Refine Data With Manual Entry ......................................................................................................... 22 Data Sorting ............................................................................................................................................ 22
Choose Playback Settings ..................................................................................... 23 Data Playback ......................................................................................................................................... 23 Data Expiration ....................................................................................................................................... 23 © 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 3
Infocaster™ Data Source Wizard User Guide
Contents
Publish Data Source As ........................................................................................................................... 23 Last Access Time ..................................................................................................................................... 24
Index .................................................................................................................... 25
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 4
Infocaster™ Data Source Wizard User Guide
Introduction to the Data Source Wizard
Introduction to the Data Source Wizard By creating data tags in your Infocast items and linking them to data sources with the Data Source Wizard, Infocaster™ allows you to link your items to content in an external data source. Maintaining your data in an external file allows you to update information automatically, without needing to edit the items. You can add new text files or RSS/XML sources to the Data Source Wizard. You can also format the data tags, use SQL conditions to refine the data selection, color the text, sort the data, set rules for data retrieval, and set output behavior for when data sources become unavailable.
Create Data Tags This guide assumes you have already created data tags within one or more Infocast items in Infocaster. For information about creating data tags in Infocaster, please see your Infocaster User Guide.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 5
Infocaster™ Data Source Wizard User Guide
Introduction to the Data Source Wizard
Data Source Wizard Workflow The Data Source Wizard contains multiple dialogs that you move through as you set up and link your data. The dialogs follow this workflow:
Choose an existing data source to link to, or add a new data source to the wizard. Link an item’s data tags to columns or entries in the data source. Format, refine, and sort the data as required. Choose playback settings for the data source.
The rest of this guide describes how to use the features of the Data Source Wizard.
Open the Data Source Wizard Check the External Data Source checkbox in an item’s Content Editor. Click the Setup button to open the Data Source Wizard.
The Data Source Wizard also opens when you are setting up a "Data Source Changes" rule or referencing item content from a data source.
Change Selections Click the Back button to change selections you made in previous Data Source Wizard dialogs.
Exit the Data Source Wizard Click the Cancel button to exit the Data Source Wizard. You lose any changes you have made.
External Data Output For information about how your external data will appear on output, please see your Infocaster User Guide.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 6
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
Set Up a Data Source Use the Data Source Wizard to link the data tags in your items to an external data source. The Data Source Wizard displays a list of ODBC sources that are already defined on your system. Select an ODBC source in the Existing ODBC Source list to view the tables associated with that source, then select a table from the Associated Tables list to see a preview of the data in the source’s table.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 7
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
Data Source Type Options The Data Source Wizard provides the following options for setting up a data source. Data Source Type Options Data Source Wizard Option
Description
Use Existing ODBC Data Sources
Allows you to use an existing ODBC database, ODBC text file, or RSS/XML data file. These are files that have been added to your system’s ODBC system list, either with the Data Source Wizard or with the Windows Data Source Administrator. See Use ODBC Data Sources (on page 14).
Use Existing Non-ODBC Data Sources
Allows you to use an existing non-ODBC data source. These are text files which were added to the Data Source Wizard as non-ODBC sources. See Use Non-ODBC Data Sources (on page 14).
Create New Text File Data Source
Adds a new text file to the Data Source Wizard’s list of available data sources. More than one text file can be used in a single data source, and you can choose to handle the sources with the Windows ODBC driver. See Set Up a New Text File (on page 8).
Create New RSS/XML Data Source
Adds a new RSS/XML feed to the Data Source Wizard’s list of available data sources. The Data Gatherer application stores its data in XML format. If you are using Data Gatherer to manage your data sources, use this option. See Set Up a New RSS/XML Feed (on page 11).
Live Chat Data
If your item is a roll you will also see a Live Chat Data radio button. This option allows you to connect your roll to an Internet Relay Chat (IRC) server. See Set Up Live Chat Data (on page 14).
Set Up a New Text File To add a new text file to the list of available data sources, select the Create New Text File Data Source radio button and click Next.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 8
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
In the following dialog you can define one or more text files to use as data sources, and you can choose to handle the sources with the Windows ODBC driver.
Add a Text File with ODBC Use the ODBC driver to manage a single text file if you want to control user access to the data. The ODBC driver also gives you control over how the data is managed. 1. Click the Browse button and select a text file. The file’s data is displayed in the Data Source Wizard’s Data Preview list. 2. Enter a data source name for the text file in the Data Source Name field. 3. Check the ODBC Handles Text Files checkbox. 4. If only the current Windows user is allowed access to this data, select the User DSN radio button. To allow all users on the system to access the data, select the System DSN radio button. If the content is being sent to player systems with Infocaster Manager, this setting will also determine which users on the player system can view the data source. 5. Click the Next button. A new dialog opens with options for managing the text file.
6. The Data Delimiter radio buttons allow you to choose ways of separating each data line into multiple columns.
Select Comma to divide each data line into multiple columns based on the commas in the line. Select Tab to divide each data line into multiple columns based on the tab stops in the line. Select Specify My Column Width to specify how many characters can fit into each column. You will set the column widths in the next dialog. To choose your own character delimiter, select Custom and enter a character in the Custom field. Each data line will be divided into multiple columns based on the occurrences of the custom character.
7. Checking the Set First Row as the Column Headers checkbox sets the first line of the text file to be the column header names. You will not be able to change the names of the headers when this option is checked. If you don’t check the Set First Row as the Column Headers checkbox, you will be able to name each column header in the next dialog. 8. Choose character set standards with the Character Set radio buttons. Select the ANSI radio button if the text file uses the ANSI character set. Select the OEM radio button if the text file uses an OEM character set.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 9
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
9. Click the Next button. A new dialog opens with options for formatting the columns. The options available will depend on the delimiter selected and whether or not the first row is set as the column header.
10. Select a data column in the Data Preview list.
If you unchecked the Set First Row as the Column Headers checkbox in the previous dialog, you can type a new name for the column in the Column Header field. Select a data type from the Data Type drop-down list. If you select the DateTime data type you must specify how the date and time are stored in the database file. Choose a format from the Format drop-down list. To use a custom format for dates and times, choose the Custom option and enter date and time formats in the appropriate fields. If you selected the Specify My Column Width delimiter in the previous dialog, enter the width for the column in the Column Field. Any characters beyond this column width will be moved to the next column. Otherwise, enter the column’s maximum number of characters in the Data Maximum field. Characters beyond this limit will not be displayed. 11. Click the Set button to finalize the column parameters you have changed. The data preview window reflects your changes. 12. Repeat steps 10 and 11 for the rest of the columns. 13. When you’ve finished setting the parameters for the columns, click the Next button to start linking the columns to the data tags in the Infocast item. See Link Data Tags to Data Sources (on page 16) to continue.
Add a Text File without ODBC You do not need to use the ODBC driver to manage text files. If you choose not to use the ODBC driver, you will be able to link multiple text files to the items in a region but you will not have the formatting options available to ODBC text sources. Once you have added non-ODBC text files to the Data Source Wizard, you can access them in the future by selecting the Use Existing Non-ODBC Data Sources radio button in the Data Source Wizard’s main window. 1. Click the Browse button and select a text file. The file’s data is displayed in the Data Source Wizard’s Data Preview list. 2. Enter a data source name for the text file in the Data Source Name field.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 10
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
3. Uncheck the ODBC Handles Text Files checkbox. The Add Source button and the All Text Sources list appear. 4. Click the Add Source button. The data source is added to the All Text Sources list. 5. Repeat steps 1-4 to add additional text file data sources. Select the sources in the All Text Sources list to view their content in the Data Preview list. 6. When you are finished adding data sources, click the Next button to start linking the sources to the data tags in your items. See Link Data Tags to Data Sources (on page 16) to continue.
Set Up a New RSS/XML Feed If you are accessing an RSS or XML feed, select the Create New RSS/XML Data Source radio button. Because the Data Gatherer application stores its data in XML format, you will want to use this option when Data Gatherer is managing your sources. After you have selected the Create New RSS/XML Data Source radio button, click Next. A new dialog opens with options for browsing to the data source, giving it a name, and setting its user permissions. Note: If a single page in your Infocast contains multiple items that connect to the same RSS feed, all of the items can share the same source. If, however, different pages or different items all connect to the same RSS feed, you must create a new source with a unique name for every Infocast page that wishes to use the feed.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 11
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
1. In the URL/XML File Path field, enter a URL for an RSS feed or an FTP location to access an XML file over a server. You can also choose an XML file manually by clicking the Browse button and selecting an XML/RSS file.
Note: If you are using the Data Gatherer application to manage your data sources, consult your administrator to find out where the gathered data is stored. The Data Gatherer User Guide provides information about default configurations. 2. Enter a data source name for the XML file in the Data Source Name field. 3. If only the current Windows user is allowed access to this data, select the User DSN radio button. To allow all users on the system to access the data, select the System DSN radio button. If the content is being sent to player systems with Infocaster Manager, this setting also determines which users on the player system can view the data source. 4. If your URL contains a get query, you can replace the value of a specific query tag with the Infocaster player’s location setting. a. Ensure that the get query in the URL/XML File Path field contains a valid default key value. If the value in the URL is invalid or blank, Infocaster will be unable to connect to the feed. b. Check the Update the URL Query Tag checkbox. c. In the field, enter the name of the query tag whose value you want to replace. When Infocaster connects to the data source from a player, the player’s location setting replaces the value of the query tag. For example, if the player’s location setting is waterloo and the query tag is location, Infocaster will connect to the URL with the get query location=waterloo. See the Infocaster User Guide to learn how to change a player’s location setting. 5. Click the Next button.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 12
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
6. If the data source is being retrieved from a URL or FTP location, the next dialog allows you to enter a user ID and password.
If your data source does not accept authentication, select the No Authentication option. Select the Anonymous radio button if the data source does not require a specific user ID or password. Select the Login With the Following radio button if the data source requires a user ID and a password. Enter the login information in the User ID and Password fields. If the data source is being retrieved from an FTP location, navigate to the proper directory using the FTP File Directory list. When you have finished entering the login information click Next to continue. 7. Use the next dialog to select the data elements you want to retrieve from the XML file:
a. In the Data File Structure list, select the data element you want to link to. b. Click the arrow button to add the element to the list of selected data sources. The element is added as a column in the Data Preview list. c. Repeat to add additional elements to the list of data sources. 8. To remove data sources that you have chosen, select the data source in the Selected Data Source list and click the Remove button. © 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 13
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
9. When you have finished adding data elements, click the Next button to start linking the elements to the data tags in your item. See Link Data Tags to Data Sources (on page 16) to continue.
Select an Existing Data Source Each time you open the Data Source Wizard, all of the previously-added sources are available to be selected and linked to the data tags.
Use ODBC Data Sources Follow these steps if you would like to use an existing ODBC database, ODBC text file, or RSS/XML data file. 1. Select the Use Existing ODBC Data Sources radio button. 2. Select a source in the Existing Source list. The tables in that source are listed in the Associated Tables list. 3. Select a table from the Associated Tables list. A preview of the table’s data appears in the Data Preview list. 4. Click the Next button to start linking the table to the data tags in the Infocast item. See Link Data Tags to Data Sources (on page 16) to continue. Note: If a single page in your Infocast contains multiple items that connect to the same RSS feed, all of the items can share the same source. If, however, different pages or different Infocasts all connect to the same RSS feed, you must create a new source with a unique name for every page that wishes to use the feed.
Use Non-ODBC Data Sources If you want to use existing non-ODBC files: 1. Select the Use Existing Non-ODBC Data Sources radio button. 2. Click Next. 3. The next dialog displays all of the existing non-ODBC data sources. Add or remove sources within the list as described in Add a Text File without ODBC (on page 10). 4. Click the Next button to start linking the data sources to the data tags in the Infocast items. See Link Data Tags to Data Sources (on page 16).
Set Up Live Chat Data Roll itemss can be linked to Internet Relay Chat (IRC) servers. If you launched the Data Source Wizard from a roll item, follow these steps to link to live chat data.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 14
Infocaster™ Data Source Wizard User Guide
Set Up a Data Source
1. Select the Live Chat Data radio button and click Next. The next dialog allows you to configure the IRC connection.
2. Enter the user name with access to the IRC server. 3. Enter the IRC server, port, and channel you wish to connect to. 4. Click the Connection Test button to ensure that your information is valid and a connection is possible. The connection test fails if you are creating this Infocast on a system without access to the IRC server. Be sure that the Infocaster players will have proper access to the server when they play the Infocast. 5. Click Next. The roll is automatically linked to the live chat data and the next dialog prompts you to choose your playback settings. See Choose Playback Settings (on page 23). Unlike other data sources you do not need to manually link your roll tag to the data field and you cannot format, refine, or sort the data.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 15
Infocaster™ Data Source Wizard User Guide
Link Data Tags to Data Sources
Link Data Tags to Data Sources After you have chosen one or more data sources, use the Data Source Wizard to link the sources to the data tags in the Infocast item.
Choose The Data Sources See Set Up a Data Source (on page 7) for information about choosing data sources.
Link Data Tags to Data Sources After you have chosen one or more data sources, a new dialog opens which allows you to link the data sources to the data tags in the Infocast item. The Data Preview list shows a preview of the available data source headings.
1. Select one of the item’s data tags in the Field drop-down list. © 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 16
Infocaster™ Data Source Wizard User Guide
Link Data Tags to Data Sources
Note: If your item has been set to associate an audio source, an Audio tag is available in the list. Link this tag to a source containing paths to your audio files. 2. From the Source drop-down list, select the heading that you want to link to the data tag. If the heading is an external key to another table, check the This Source Is An External Key checkbox. You will establish the other source table when you proceed to the next dialog. 3. If the item has more than one data tag, add each tag link to the Assignment list. Click the Add button to add a link to the list. To remove a link from the Assignment list, select the link and click the Remove button. Each column can only be linked to one field by default. If you want to link a column to multiple fields, check the Show Selected Columns checkbox. When this option is checked, columns remain available in the Column drop-down list even after they have been linked to a field. 4. If the link is an external key to another table, select the link in the Assignment list and click the Modify button to establish the other source table. You can also establish any other source tables by clicking the Next button when you’re done linking your tags. See Establish Other Source Tables (on page 18). 5. When you have finished linking data tags to data sources, click any of the buttons on the bottom of the dialog to format, filter, color, or sort the data:
Click the Data Formatting button to format the text, data, and date fields. See Data Formatting (on page 19). Click the Refine Range & Style button to filter or add color to the data. See Refine Range & Style (on page 20). Click the Data Sorting button to sort the data. See Data Sorting (on page 22). 6. Click the Next button when you are ready to set up playback and expiration rules for the data. See Choose Playback Settings (on page 23) to continue. If any of the links are to an external key on another table, a dialog opens with options for establishing the other source table (see Establish Other Source Tables (on page 18)).
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 17
Infocaster™ Data Source Wizard User Guide
Link Data Tags to Data Sources
Establish Other Source Tables If any of the data tags are linked to data sources which are keys to other tables, you need to establish the other source table, the column that contains the external keys, and the column that contains the data that needs to be returned.
1. From the Found In Table list, select the table that the link connects to. 2. Pick the column that contains the external keys in the External Key References drop-down list. 3. Select the column that contains the data that needs to be returned in the Return the Value In drop-down list. 4. Click the Commit button to finalize the settings. If you are only establishing a link to one source table, the next dialog allows you to choose playback and expiration settings for the data. See Choose Playback Settings (on page 23) to continue. If you are establishing links to multiple source tables you are returned to the Assign Source dialog (see Link Data Tags to Data Sources (on page 16)).
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 18
Infocaster™ Data Source Wizard User Guide
Format, Refine, and Sort the Data
Format, Refine, and Sort the Data While you are using the Data Source Wizard to link data tags to data sources, select the buttons at the bottom of the dialog to format, refine, and sort the data.
Data Formatting Click the Data Formatting button to format text, data, and date fields. The choices you make will appear when you output the Infocast.
Select a field from the Detected Fields list. The available formatting options depend on the type of data in the field. The data types for the fields were chosen when you added the data source to the Data Source Wizard or to the ODBC System List. Presentation Style Formatting Options Field Type
Formatting Options
Date / Time
Select a date format from the Format drop-down list. Add a prefix to the date by checking the Prefix checkbox and entering a prefix in the text field. Add a suffix to the date by checking the Suffix checkbox and entering a suffix in the text field.
Numerical
Select a Comma, Period, or Space for the Numerical Separator. Select a Comma or Period for the Decimal. Select the number of decimal places from the Decimal Places drop-down Add a prefix to the numbers by checking the Prefix checkbox and entering a prefix in the text field. Add a suffix to the numbers by checking the Suffix checkbox and entering a suffix in the text field.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 19
Infocaster™ Data Source Wizard User Guide
Format, Refine, and Sort the Data
Field Type
Formatting Options
Text
Add a prefix to the text by checking the Prefix checkbox and entering a prefix in the text field. Add a suffix to the text by checking the Suffix checkbox and entering a suffix in the text field.
Click the Commit button when you are finished formatting the fields.
Refine Range & Style Click the Refine Range & Style button to filter data using SQL statements. You can also use statements to show, hide, and add color to the data.
The SQL statements can be entered either manually or with condition selection. Switch between methods with the button in the bottom-left corner of the dialog. You can only switch to Manual Entry when you have no conditions in the All Defined Parameters list.
Refine Data With Condition Selection Use the If connector to show, hide, and add color to the data. 1. Select the If connector from the Connector drop-down list. 2. Choose the conditions for the query: a. Select a data source column from the Column drop-down list. b. Select an operator from the Operator drop-down list. c. If applicable, enter a value in the Value field.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 20
Infocaster™ Data Source Wizard User Guide
Format, Refine, and Sort the Data
Click on the Value field to use three special player values: Player Name, Player Location, and Machine Name.
These values allow you to create conditions that depend on the names and locations of your player system. Use player values to display different external data on different player systems, all with a single Infocast. When using machine names, make sure the machine names in the external data source are in capital letters (eg. "PLAYERC"). 3. Choose how to display the data that meets the conditions:
To prevent a particular data tag from being displayed, select Hide Field from the Apply Style drop-down list, and select the tag you want to hide from the Field drop-down list. To hide the entire item, select Hide Item from the Apply Style drop-down list. To colorize the data in a particular data tag, select Change Field Color from the Apply Style drop-down list, select the tag you want to colorize from the Field drop-down list, and click on the color box beside the Apply Style drop-down list. A color picker opens, allowing you to choose a color for the data tag. To display ONLY the data that meets the conditions, select None from the Apply Style drop-down list. 4. Click the Add button to add the condition to the All Defined Parameters list. Add additional conditions to the All Defined Parameters as required. To delete a condition, select it in the list and click the Delete button. Use the And and Or connectors to filter the data. Use multiple conditions to further refine the data range. 1. Select a connector from the Connector drop-down list:
2. 3. 4. 5. 6.
Choose the And connector to apply the current condition to the previous condition using "and" logic. Choose the Or connector to apply the current condition to the previous condition using "or" logic. Select a data source column from the Column drop-down list. Select an operator from the Operator drop-down list. Enter a value in the Value field. Click the Add button to add the condition to the All Defined Parameters list. All data that meets the condition will be displayed. Create and add additional conditions to the All Defined Parameters list. These conditions will further refine the data range.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 21
Infocaster™ Data Source Wizard User Guide
Format, Refine, and Sort the Data
7. To delete a condition, select it in the All Defined Parameters list and click the Remove button. Click the Commit button when you are finished refining your data range.
Refine Data With Manual Entry Click the Switch to Manual Entry button to manually enter conditions with SQL statements. You can only switch to Manual Entry when the All Defined Parameters list is empty. Type a valid SQL statement in the SQL Statements field and click the Set button to apply the statement. Its result displays in the Data Preview list. Click the Commit button to finish refining the data range.
Data Sorting Click the
Data Sorting button to establish a sorting priority for the data.
1. Select the column with the highest sorting priority from the Reference drop-down list. 2. Use the Sort Order drop-down list to select the way your data is sorted. If the column contains text, the text is sorted alphabetically.
Select Ascending to sort the content in ascending order. Select Descending to sort the content in descending order. If you are using the Play From Source feature in your content editor, you can also choose to play all referenced content in random order.
3. Click the Add button to add the column to the Sorting Sequence list. The Data Preview list sorts the data according to the sorting sequence. 4. Add more sorting sequences as required. 5. To delete a sorting sequence, select a sequence from the Sorting Sequence list and click the Delete button. 6. When you are finished sorting the data, click the Commit button.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 22
Infocaster™ Data Source Wizard User Guide
Choose Playback Settings
Choose Playback Settings After you have chosen the data sources and linked them to the Infocast item’s data tags, set the rules for data playback and data expiration. When you have finished choosing the playback settings, click the Finished button. If you still have data tags that you haven’t assigned to a data source, a dialog allows you to either return to Infocaster or continue linking tags to data sources.
Data Playback The Data Playback section of the dialog allows you to set when Infocaster checks the data source for new information.
Select the Every Time radio button to update items whenever the data source updates. Select the Retrieve Updates at the Following Interval checkbox to specify how often Infocaster looks for new information in the data source. Enter a time in the Interval box. Choosing this option speeds up retrieval and playback if the connection to the data source is slow.
Data Expiration The Data Expiration section of the dialog allows you to set when Infocaster expires data if the data source is unavailable. For example, the data source may be unavailable if it is stored on a network and the network is down.
Select the Show Last Known Data radio button if you want to show the last available data when the data source becomes unavailable. Select the Don’t Show Any Data radio button if you do not want to show any data when the data source becomes unavailable. Select the Expire After An Interval Of radio button and enter an interval to expire unavailable data sources after a specific time. When a data source becomes unavailable it will continue to display until the interval has elapsed.
If you choose to expire data or not show data from unavailable data sources, you can display a message when the data has expired. Check the When Data Expires checkbox and type a message in the field.
Publish Data Source As Use the Publish Data Source As controls to set where your data source handle is created.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 23
Infocaster™ Data Source Wizard User Guide
Choose Playback Settings
Network Source: A network data source (such as an ODBC connection to a file on a network share, or a network text file through direct reading) is left in its original location and not published to the player. Local Source: The local file or network file is published to the player. If you check the Move to Infocast Layout Folder checkbox, the data source is moved to the player’s Infocast layout folder and the ODBC DSN is changed to point to the new location. Otherwise the data source is copied to its original file path, but on the player machine. Don’t Publish: The data source is not published at all and the ODBC DSN is not registered on the player. This allows the user to manually reconnect data sources on the player machine.
Last Access Time The Last Access Time button is enabled when the data source is an SQL/Oracle database. Click the button to update a separate table with the time the data was last accessed.
© 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 24
Infocaster™ Data Source Wizard User Guide
Index
Index A ANSI character set • 9 Associate Audio Source link to database • 16 Audio data tag • 16
C character set standards • 9 close Data Source Wizard • 6 color data fields • 20 column in an ODBC text file • 9 maximum number of characters • 9 name • 9 set first row as the column headers • 9 width • 9 Content Editors open the Data Source Wizard • 6
D data delimiter • 9 data expiration • 23 data formatting • 19 Data Source Wizard add a text file with ODBC • 9 add a text file without ODBC • 10 add live chat data • 14 add RSS/XML feed • 11 add text file • 8 cancel • 6 character set • 9 color data fields • 20 data expiration • 23 data playback settings • 23 data type • 9 delimiter • 9 DSN choice • 9 external keys • 18 filter data • 20 format data source • 19 last access time • 24 link column to multiple tags • 16 link data tags to database • 16 © 2014 Imagine Communications.
name column • 9 open • 6 player values • 20 publish data source • 23 refine data range • 20 select existing data source • 14 select RSS/XML data elements • 11 set first row as the column headers • 9 sort data • 22 SQL statements • 22 update interval • 23 workflow • 6 data tags audio • 16 color data fields • 20 link to database • 16 database add RSS/XML feed • 11 add text file to Data Source Wizard • 8 becomes unavailable • 23 color data fields • 20 decimal point • 19 external keys • 18 filter data • 20 format text • 19 last access time • 24 link column to multiple tags • 16 link to data tags • 16 numerical separator • 19 refine data range • 20 sort data • 22 SQL statements • 22 use multiple data sources • 10 decimal places • 19 decimal point • 19
E expire data • 23 external keys • 18
F filter data • 20
H hide data • 20
I item link to RSS/XML feed • 11 Proprietary and Confidential.
6/6/2014 | Page 25
Infocaster™ Data Source Wizard User Guide
Index
sort data • 22 SQL external keys • 18 filter data • 20 last access time • 24 manually enter conditions • 22 suffix (Data Source Wizard) • 19 system DSN • 9
L last access time • 24 link data tags to database • 16 live chat data • 14 local source • 23
M machine name • 20 multiple data sources • 10
T
N
text file add to Data Source Wizard • 8 handle with ODBC driver • 9 handle without ODBC driver • 10 multiple data sources • 10 separating into columns • 9
network source • 23 numerical separator • 19
O ODBC DSN choice • 9 handle text file • 9 OEM character set • 9 open Data Source Wizard • 6
U update database • 23 user DSN • 9
P
X
player external data • 20 machine name • 20 player location • 20 player name • 20 player values • 20 prefix date/time • 19 presentation style • 19 publish data source • 23
XML select data elements • 11 user ID and password • 11 XML feed • 11
R refine range & style • 20 color data fields • 20 roll live chat data • 14 RSS select data elements • 11 user ID and password • 11 RSS feed • 11
S set first row as the column headers • 9 show data • 20 show last known data • 23 Show Selected Columns • 16 © 2014 Imagine Communications.
Proprietary and Confidential.
6/6/2014 | Page 26
