To Configure Connection Settings for DB

1. Open Schedule Collector.

2. Set Automation system to DB.

3. Set Heartbeat Interval (default is every 60 seconds) for how often the Schedule Collector should send a heartbeat query.

To Configure Schedule Details for DB

1. Open Schedule Collector.

2. Click the New Channel button.

3. Set Channel Name.

   Note:Channel ID is automatically set.

4. Set to Active to activate this channel setting.

5. Set the Updates Folder where the Schedule Collector will create its playlists.

6. Enter the ScheduleList Query.

   • This query must query the database for available schedule table names, creation dates and when last modified. The selected table name is then used by the Event Query.

   • Use the following syntax in your SQL statement (e.g. SELECT TableName, CreationDateUTC, LastModificationTimeUTC FROM [table name]).

7. Enter the Event Query.

   • This query must query the data from the selected schedule table name provided by the ScheduleList Query.

   • Use the following syntax in your SQL statement (e.g. SELECT * FROM [%table%]), where [%table%] is required.

8. Enter the database Connection String.

9. Select a Database Server:

   • Microsoft SQL

   • MySQL

   • Oracle

10. Enter the ID Field that stores the schedule table name.

11. Click Save.

To Configure Connection Settings for Harris

1. Open Schedule Collector.

2. Set Automation system to Harris.

3. Open Schedule Collector’s configuration file

   • Windows XP: %ProgramFiles%\vizrt\Viz Multichannel\Tools\Schedule Collector\ScheduleCollector.config

   • Windows 7: %ProgramData%\Vizrt\Multichannel\ScheduleCollector\ScheduleCollector.config

4. Set General.ExtraConfigFiles to Bxf.config.xml.

   <add key="General.ExtraConfigFiles" value="Bxf.config.xml"/>

5. Save and close the file.

To Configure Schedule Details for Harris

1. Open Schedule Collector.

2. Click the New Channel button.

3. Enter the Channel Name as defined by the Harris automation system.

4. Enter the unique Channel ID for the channel as defined by the Harris automation system.

   • Ensure that Channel ID is identical to Viz Multichannel’s Channel Name in Schedule.

5. Enter the Updates Folder path.

   • This is the path where updates will be received. Make sure you select an existing folder as Schedule Collector will not create on for you.

6. For the Schema Query, under Query Interval, enter the desired interval in seconds.

7. In the BXF Input Folder field, enter the path for protocol input files. This must be an existing folder, and must match the corresponding folder in the Harris automation system.

8. In the BXF Output Folder field, enter the path for protocol output files. This must be an existing folder, and must match the corresponding folder in the Harris automation system.

9. Click Save.

10. Repeat this procedure for each Harris channel, as required.

To Configure Schedule Details for Multi DB

1. Create an XML file and name it Extra.config.xml.

2. Add the XML file to the SCC folder in your Viz Multichannel installation directory.

3. Use the sample XML below to configure a connection to your multi DB instance. Example:

   <MultiDBConfigs>

   <QueryIDField>EventUniqueID</QueryIDField>

   <ConnectionString>Data Source=hostname;Initial Catalog=FLORICAL_SCHEDULES_MAX;User Id=name;Password=123456;</ConnectionString>

   <QueryForOnAirEvent>SELECT * FROM [FLORICAL:ARL:MAX1:2011:02:25]</QueryForOnAirEvent>

   <QueryForEvent>SELECT * FROM [FLORICAL:ARL:MAX1:2011:02:25]</QueryForEvent>

   </MultiDBConfigs>

4. Set QueryIDField to be the column name in the database that stores Event IDs.

5. Set ConnectionString to be specify the database instance you are connecting to.

6. Set QueryForOnAirEvent to query for on-air events.

7. Set QueryForEvent to query for a list of events to create the playlist.

8. Open Schedule Collector.

9. Click the New Channel button.

10. Set Channel Name.

    Note:Channel ID is automatically set.

11. Set to Active to activate this channel setting.

12. Set the Updates Folder where the Schedule Collector will create its playlists.

13. Enter the database Connection String.

14. Set the Small and Big intervals for how many and how often Schedule Collector should query the database for new or updated events.

15. Select a Database Server:

    • Microsoft SQL

    • MySQL

    • Oracle

16. Click Save.

Omnibus General Automation

To Configure Connection Settings for Omnibus BXF

1. Open Schedule Collector.

2. Set Automation system to OmnibusBXF.

3. Enter the link to your Web Service.

4. Enter the number of days to get the playlists for in the LookAhead field.

5. Enter a value to determine the Polling Interval, in seconds, to poll the automation system for changes.

6. Optional: Enable Live Item Update if you want to receive live updates from the your web service.

7. Enter the Date(xPath) path in the XML that defines the event date.

   • Example: /BxfMessage/BxfData/Schedule/ScheduledEvent/ScheduleElements/EventData/StartDateTime/SmpteDateTime/@broadcastDate

   • See Playlist Structure for a more complete XML example.

To Configure Schedule Details for Omnibus BXF

1. Click the New Channel button.

2. Enter the Channel Name as defined by the Omnibus Adaptor.

3. Enter the unique Channel ID for the channel as defined by the Omnibus Adaptor.

   • Ensure that Channel ID is identical to Viz Multichannel’s Channel Name in Schedule.

4. In the *Day Switch *field, enter the day switch as defined in the Day Switch Options.

5. Enter the Updates Folder path.

   • This is the path where updates will be received. Make sure you select an existing folder as Schedule Collector will not create on for you.

6. Click Save.

7. Repeat this procedure for each Omnibus BXF channel, as required.

Playlist Structure

Channel name and event ID are highlighted, and checked by the Schedule Collector. All the rest of the event information and is checked in Viz Multichannel according to the mapping.

Another alternative is to use different field names instead of the Schedules/Scheduled/EventData is Schedule/ScheduledElements/EventData. However, it is worthwhile to run tests with examples to verify first. Sample structures can be found in Harris documentation.

An example of the second type with primary/secondary events:

An example for the SMPTE date-time format:

To Configure Connection Settings for PBS

1. Open Schedule Collector.

2. Set Automation system to PBS.

3. Enter the PBS machine’s Host.

   Note: The host machine will always be given priority in connections.

4. Enter the listener Port number, default is 10600.

5. Enter the Heartbeat Interval time, in seconds.

   • This allows the Schedule Collector to indicate to the PBS automation system it is still “alive”, even if no updates have been requested.

6. Enter the PBS backup machine’s Backup host.

To Configure Schedule Details for PBS

From the Schedule drop-list, select a schedule.

1. Click Edit Channel.

2. Enter the Channel name as defined by the PBS automation system.

3. Enter the unique Channel ID for the channel as defined by the PBS automation system.

   • Ensure that Channel ID is identical to Viz Multichannel’s Channel Name in Schedule.

4. Optional: Enable Active.

   • This will enable automatic updates.

5. Enter the Updates folder path.

   • This is the path where updates will be received. Make sure you select an existing folder as Schedule Collector will not create on for you.

6. For minor but frequent updates, under Small interval, enter the number of events to be received within an indicated time frame. Zero events and/or zero seconds disables this update option.

7. For major but infrequent updates, under Big interval, enter the number of events to be received within an indicated time frame. If also updating minor events, ensure that the Big Interval is greater than the Small Interval. Zero events and/or zero seconds disables this update option.

8. Click Save.

   Note: Repeat the above procedure for each PBS channel, as required.

To Configure Connection Settings for SGT

1. Open Schedule Collector.

2. Set Automation system to SGT.

3. Enter the link to your Web Service.

4. Enter the Client ID.

To Configure Schedule Details for SGT

1. Open Schedule Collector.

2. Click the New Channel button.

3. Enter the Channel Name as defined by the SGT automation system.

4. Enter the unique Channel ID for the channel as defined by the SGT automation system.

   • Ensure that Channel ID is identical to Viz Multichannel’s Channel Name in Schedule.

5. Enter the Updates Folder path.

   • This is the path where updates will be received. Make sure you select an existing folder as Schedule Collector will not create on for you.

6. Click Save.