background image

Crestron 

e-Schedule

 Programmer’s 

Guide 

 

Configuring the e-Schedule 
Database 

Database Categories 

The e-Schedule Database Directory is divided into four categories: 1) 
Configuration 2) Web Browser 3) Resource and 4) System. The Microsoft 
Access databases in Scheduler_Configuration.mdb must be completed for 
each installation. 

Configuration Databases 

Scheduler_Configuration.mdb

—defines the hardware, group and 

room setup, and user information. The programmer must configure 
the tables in this database. 

Scheduler_Events.mdb

—automatically stores event information by 

system, as well as real-time status of sources and destinations. 

Resource Databases

 

Scheduler_Media.mdb

—media database containing all media 

resources and media attributes.  

Web Browser Database 

(DO NOT MODIFY! This database will be 

overwritten with each new installation and/or upgrade.)

 

 

Scheduler_WebGUI.mdb

—read-only database for the client-side 

Web browser. 

System Database

 (DO NOT MODIFY! This database will be 

overwritten with each new installation and/or upgrade.) 

Scheduler_RealTimeControl.mdb

—read-only database for the 

scheduling software. 

NOTE

:  After opening any table in Microsoft Access, select 

Design View

 

from the 

View

 menu for detailed information about each field in the table, 

including data types and descriptions. 

Programmer’s Guide 

e-Schedule – DOC. 5919  

  8 

Summary of Contents for e-Schedule

Page 1: ...Crestron e Schedule Programmer s Guide Programmer s Guide Crestron e Schedule Crestron Electronics Inc...

Page 2: ...Source Devices 12 Destination Devices 17 Signals 19 Signal Macros 21 Signal Macros 22 Privileges 23 Join Number Pass Throughs 24 Real Time Engine Scheduler exe 25 Diagnostic Utilities 29 Watch Signal...

Page 3: ...ong as there is full crosspoint capability Multiple room scheduling and grouping and multiple head ends Global signals Join number pass throughs for direct communication between a Web browser and a ro...

Page 4: ...dule events which are divided into two types media events and global events To schedule a media event the user requests up to six media titles as well as start and end times and room destinations In a...

Page 5: ...ams that define an extensive sample system Together with the completed configuration databases also included the programs can be used as models for most projects In addition the system requires a CNX...

Page 6: ...teway is servicing NOTE Crestron recommends that all e Schedule components reside on a separate segment or subnet of the Ethernet network in order to help ensure that packets will be routed efficientl...

Page 7: ...ended Crestron Software Files Crestron e Control CNX Gateway 2 8 6 0 or later Active Server Pages Database Directory Real Time Engine PC Hardware 600 MHz Pentium II Processor 128 MB RAM Network Card T...

Page 8: ...hernet connected destinations 0 1 or more Head Ends SourceN CNMSX Source1 0 1 or more Cresnet connected Misc equip CNMSX Misc equip IR Xmit opt CN TVAV IR Transmitter Touchpanel optional CEN TVAV Brow...

Page 9: ...grammer s Guide Data Flow Browser Browser Browser Browser Web Server CNX Gateway Real Time Engine CNX Gateway Databases Scheduling information Real time information Crestron Devices Programmer s Guide...

Page 10: ...ystem as well as real time status of sources and destinations Resource Databases Scheduler_Media mdb media database containing all media resources and media attributes Web Browser Database DO NOT MODI...

Page 11: ...e Schedule does not currently support multiple Web Servers ServerMachineIPAddress The static IP Address of the Web Server computer Cfg_Hardware_RealTimeMachine Field Name Description RealTimeMachineI...

Page 12: ...1 and proceeding sequentially gaps are permitted GroupName The name of the group i e First Year Classes referenced by the Group ID and displayed in the user interface Cfg_Area_SubLocations Field Name...

Page 13: ...1 Example 2 Locations groups and rooms with corresponding tables mapping the relationships between them Group 1 Cfg_Area_MapTable Cfg_Area_Groups Cfg_Area_Locations Cfg_Area_SubLocations Group 3 Room...

Page 14: ...cher Enable Check box to enable or remove the device in the system Cfg_Source_FormatType Field Name Description FormatTypeId Each format type must be assigned a unique identifier starting with 1 and p...

Page 15: ...Ignored in baseband systems enter 0 ChannelName The channel name i e Bloomberg History Channel SwitcherInput In baseband systems only this is the switcher input ID number that is specified in SIMPL Wi...

Page 16: ...ecimal equivalent of the Cresnet IP ID of the device SwitcherID For baseband systems this is the switcher used by the device This ID number is taken from the table Cfg_Hardware_Switcher Ignored in bro...

Page 17: ...abase Table Cfg_Hardware_Source Database Table Status_Src SrcStatusId 3 SrcStatusDesc Ready Database Table RealTimeSrcStatus SrcId 3 SrcStatus 0 Database Table Cfg_Hardware_Switcher SwitcherId 1 Switc...

Page 18: ...Crestron e Schedule Programmer s Guide Programmer s Guide e Schedule DOC 5919 16 Example 4 continued...

Page 19: ...aken from Cfg_Hardware_RealTimeMachine this ID number must be 1 IPAddress The static IPAddress of the set top box or control system if set top box does not have its own IP Address IPID The decimal equ...

Page 20: ...Field Name Description OptionId ID for the conflict checking option see below OptionName 1 RecurringEvents not available 2 Groups 3 Multilocation Active Check box to enable or disable each option Opt...

Page 21: ...stat Cfg_EventSignals_Signals Field Name Description EventSignalId Every signal must be assigned a unique identifier starting with 1 and proceeding sequentially gaps are permitted EventSignalName The...

Page 22: ...erenced by the FolderNameId and displayed in the user interface Cfg_EventSignals_MapTable Field Name Description FolderNameId Taken from Cfg_EventSignals_Folders EventSignalId Taken from Cfg_EventSign...

Page 23: ...grammer s Guide e Schedule DOC 5919 21 IO 0 Output from the Real Time Engine 1 Real Time Engine will receive this signal from the hardware IOType 1 Digital 2 Analog 3 Serial CNXType 0 None 1 Source 2...

Page 24: ...nal into the table Cfg_EventSignals_Signals The EventSignalID must be 1000 Then in the table Cfg_EventSignals_MacroMapTable define the signals that this macro will trigger The field Order specifies th...

Page 25: ...dministrator The recommended default values below assume that the administrator s user ID is 1 Cfg_User_MapTable UserId PrivilegeId _Key 1 1 NONE 1 3 NONE 1 9 NONE 1 10 NONE 1 4 NONE 1 108 NONE 1 5 NO...

Page 26: ...o its corresponding set top box and those sent from a set top box are transmitted to all connected browsers A pass through is only valid between a Web browser and a set top box not between a Web brows...

Page 27: ...ne marked Next Scheduled Events to End lists events that are currently in progress while the bottom pane marked Next Scheduled Events to Start lists the events that have been scheduled to start next T...

Page 28: ...Select Edit Preferences to open the Preferences dialog box which consists of a tabbed page The File Paths tab displays the path that points to the Crestron e Schedule Database Directory containing al...

Page 29: ...Server See Web Server Gateway IP Address below Web Server Gateway IP Address specifies the IP Address of the CNX Gateway computer for the Web Server Check for scheduled events every n seconds configur...

Page 30: ...Check for new connections every n seconds since set top boxes and browsers are likely to be dynamically connected and disconnected to the system at any time the Real Time Engine will continuously pol...

Page 31: ...t from the Scheduler and this is specified in the I O field The IO Type field gives the type of signal digital analog or serial The Value field gives the value that was sent Command Type lists the typ...

Page 32: ...to view information about the corresponding entries as they appear in the configuration databases The Status window will list any errors or omissions NOTE Whenever a new e Schedule version is install...

Page 33: ...Crestron e Schedule Programmer s Guide Programmer s Guide e Schedule DOC 5919 31...

Page 34: ...ple system illustrated in Figure 1 Together with the completed configuration databases also included these can be used as programming models Programming Requirements Firmware Software Version Minimum...

Page 35: ...IR CNECI 4 ID 7E IR Local VCR Cresnet Local TV Local VCR DVD2 IP ID 0B IR VCR3 IP ID 09 VCR2 IP ID 07 Ethernet IR IR IR Tuner IP ID 0C Touchpanel ID 03 Cresnet Classroom 2 CEN TVAV 192 168 2 171 Clas...

Page 36: ...1 1 television tuner at IP ID 0C on Headend MSX 1 1 switcher at IP ID 08 on Headend MSX 1 1 CN TVAV Classroom 1 at Cresnet ID 50 which is bridged from Cresnet to Ethernet by Headend MSX 1 2 CEN TVAVs...

Page 37: ...ropriate control system The Cfg_EventSignals_Signals table can then be configured to schedule and activate specified join numbers on this ActiveCNX Interface Non Ethernet Cresnet Hardware In the sampl...

Page 38: ...t as usual and the MRHC transmitter will control settings for Power Mute Volume Source Control and View Channel Points to Remember All components of an e Schedule system the Web Server Real Time Engin...

Page 39: ...indicates to the Scheduler that the specified source device is being requested for use The Scheduler then checks the validity of the request dig i21 i27 Feedback for SourceA SourceF and SourceLocal I...

Page 40: ...essed dig i41 i42 Mute On and Mute Off Enables the Web browser to control a room s Mute On or Mute Off button dig o43 o44 TV Power On Off Sends feedback to the Web browser when a local TV Power On or...

Page 41: ...olume Up or Volume Down button dig i63 i64 TV Channel Up Down Enables the Web browser to control a room s TV Channel Up or Channel Down button dig i74 Controlling Room When signal is high indicates th...

Page 42: ...e Scheduler i e join number 21 which identifies SourceA on the Destination ActiveCNX Interface the Pass Through takes priority and the original command is ignored A signal cannot be configured as both...

Page 43: ...Controls Can be customized for specified SourceA SourceF transport controls that may not exist in the database i e Super Fast Rewind dig i105 i124 Generic Transport controls Feedback from the customiz...

Page 44: ...numbers defined in the fixed database Scheduler_RealTimeControl mdb to be used to indicate the unique page on a Crestron touchpanel that would display the transport controls of a device For example if...

Page 45: ...annel in the Cfg_Hardware_LegalChannels database table Serial Signals i6 i11 Media titles for SourceA SourceF i e The Matrix i12 i17 Device names of SourceA SourceF i e VCR 5 i18 Group name i19 Room n...

Page 46: ...SS and MN indicates a space Field Description Format HH Hour 00 23 MM Minutes 00 59 SS Seconds 00 59 MN Month 01 12 DD Day 01 31 YYYY Year 4 digits NOTE The Classroom programs of the sample system con...

Page 47: ...trols Input from the Scheduler to activate a transport control for the corresponding source typically tied to logic for the device or to an IR driver o21 o40 Transport feedback for the source routed f...

Page 48: ...ontrols that may not exist in the database o41 o60 Generic Transport Controls Feedback for customized transport controls Analog Signals o1 Ready status of the source When initialized to 0 indicates th...

Page 49: ...hat should be loaded into the source device for the next event based on the scheduling information When an event is over and the end user physically changes the media in a source device the READY butt...

Page 50: ...ccession to this ActiveCNX Interface This might occur if there were several rooms in a group and one source was selected the switcher would have to switch the input to each room or if more than one ro...

Page 51: ...ugh commands data or instructions from or to another computer b for local campus or wide area network internet or web hosting services or c pursuant to any rental sharing or service bureau arrangement...

Page 52: ...iod of ninety 90 days from the date of receipt and b that any hardware accompanying the Software will be subject to its own limited warranty as stated in its accompanying written material Crestron sha...

Page 53: ...0 days batteries and incandescent lamps are not covered This warranty extends to products purchased directly from CRESTRON or an authorized CRESTRON dealer Purchasers should inquire of the dealer rega...

Reviews: