Zzz Software:Foyer Display
Introduction
The display monitor in the foyer above the main entrance displays information about all forthcoming events at the theatre. This includes:
- Auditions
- Comedy nights
- Dance schools
- Film screenings
- Musical shows
- Musicians
- Opera nights
- Pantomime
- Plays
- Social events
- Spoken Word events
- Training sessions
Hardware Overview
The system runs on a Raspberry Pi 3 (RPi3). At present, there is one monitor attached, above the main entrance. It is envisaged that a second monitor might be placed in the "Shop Window" if the front of the building is redesigned.
Software Overview
The RPi3 runs bespoke in-house developed software. The data is hosted in the Google Cloud and updated through a Google Sheet and through an Android Smartphone App. Encryption and passwords ensure its security.
Spreadsheet Tabs
- Raw Data - The main data entry point
- Created
- Updated
- Updates
- Status
- Show Title
- Show Type
- Venue
- Visitors Or In-House
- Image URL
- Start Date
- End Date
- Performances
- Get In Date
- Get In Time
- First Show Time
- Get Out Date
- Get Out Time
- Interval 1
- Interval 2
- Unreserved
- Flash Bang Smoke
- Event Text
- Contact for Technical Queries
- Management Company
- Mobile Number
- Email Address
- Get-In Lead
- Get-In Mobile
- Get-In Email
- Get-In 2nd
- Get-In 2nd Mobile
- Get-In 2nd Email
- SM Lead
- SM Mobile
- SM Email
- SM 2nd
- SM 2nd Mobile
- SM 2nd Email
- Sound Lead
- Sound Mobile
- Sound Email
- Sound 2nd
- Sound 2nd Mobile
- Sound 2nd Email
- Overview Of Sound Requirements
- Lapel Radio Mics
- Hand-Held Radio Mics
- XLR Mics
- DI Boxes
- Audio From Laptop
- Audio From CD
- Audio From DVD
- Audio From Memory Stick
- Audio From Mini-Disc
- Audio From Cassette
- Other Audio
- Lighting Lead
- Lighting Mobile
- Lighting Email
- Lighting 2nd
- Lighting 2nd Mobile
- Lighting 2nd Email
- Overview Of Lighting Requirements
- Cues Or Adhoc
- Specials
- Followspot
- Followspot Lead
- Followspot Mobile
- Followspot Email
- Followspot 2nd
- Followspot 2nd Mobile
- Followspot 2nd Email
- Projection
- Projection Lead
- Projection Mobile
- Projection Email
- Projection 2nd
- Projection 2nd Mobile
- Projection 2nd Email
- Overview Of Projection Requirements
- Projection Source
- Projection Audio
- Piano
- Piano Comment
- Additional Comments
- Artiste Document 1
- Artiste Document 2
- Archived - Storage for events that have completed. Currently moved across manually.
- Exactly the same columns as Raw Data
- Formatted - A copy of Raw Data but with formatting applied to columns and headings.
- Exactly the same columns as Raw Data
- Foyer Display - A subset of Formatted which is used by the RPi3.
- Created
- Updated
- Updates
- Status
- Show Title
- Show Type
- Venue
- Visitors Or In-House
- Image URL
- Start Date
- End Date
- First Show Time
- Management Company
- Event Text
- Interval 1
- Unreserved
- Flash Bang Smoke
- Start Times - The start times of shows that vary, such as panto.
- Tweets - {Probably To Be Removed} The diary of tweets relating to forthcoming events.
- Rota - Who is currently assigned to each of the various technical roles.
- Copy Of Rota - A subset of Rota but only showing the Leads (i.e. without the 2nds). Used for emailing.
- Ticker - The composited messages used by the ticker system.
- LookupPersonnel - Details of each technical persons roles and contact details.
- LookupShowType - A definitive list of Show Types used by the Smartphone app.
- LookupStatus - A definitive list of Show Statuses used by the Smartphone app.
- LookupVenue - A definitive list of Venues used by the Smartphone app.
- LookupColumns - {Probably To Be Removed} A table of lookups for each of the columns in Raw Data.
Multiple Start Times
Where an event has multiple and different start times, such as with panto, leave the First Show Time field blank.
This will cause "times vary" to be appended to the date range string.
Version Updates
From time to time a new version will be issued. Click here here for a copy of the Acceptance Test.
Development Roadmap
| Now | Ticker+ | 5mb+ | Solo | ??? | |||
|---|---|---|---|---|---|---|---|
| = = = = = > |
|
= = = = = > |
|
= = = = = > |
|
= = = = = > |
|