• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 17 views
  • Users 0 members are here
Related

Advice: Custom Tab

Dot Krebs (Past Member)
$organization

Looking for a little advice here.

I'm creating a custom tab on a performance to replace an external db for tracking House Management information and attendance.

In addition to attendance data by price zone and ticket type (comp, sub, single, group, staff), we also track:

 

PERFID Act2Runtimetime
PerformanceCode EndTime
PerformanceType ShowRuntime
Venue AccessiblePerformance?
GateCount #ofBenefitingPatrons
%Capacity #ofLoopDevicesUsed
PerformanceDate #ofRadioDevicesUsed
PerformanceTime AccessibleSeatsUsed
HouseManager LargePrintProgramsUsed
TicketSalesManager WeatherConditions
UsherTeam OutsideTemperature
#ofVolunteers TheatreTemperature2hrsBeforeDoorsOpen
IfHouseOpenLate TheatreTemperaturePreshow
HouseOpen TheatreTemperature30minsin
Pre-ShowBegin LobbyCondition
Pre-ShowEnd TheatreCondition
Pre-ShowRuntime CoatCheckIncome
Act1Begin PatronNotes
Act1End OperationsNotes
Act1Runtime HousekeepingNotes
IntermissionBegin MiscellaneousNotes
IntermissionEnd PreShow?
IntermissionLength PreShowAttendance
Act2Begin PostShow?
Act2End PostShowAttendance

 

My question to you for the attendance data and the performance information (date/time, etc.), do you suggest we insert that into the newly created table or do you suggest we let the stored procedure simply display and refresh that data every time the tab is opened?

 

  • $organization

    I believe speed will make your decision for you. If it is quick let the SP do it, otherwise I guess loading/updating a table nightly would be better.  Just my two cents.

  • $organization

    Those two cents are worth gold to me.

     

    Thanks!

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Travis Armbuster
    Sent: Friday, July 22, 2016 2:45 PM
    To: Dot Krebs
    Subject: Re: [Tessitura Technical Forum] Advice: Custom Tab

     

    I believe speed will make your decision for you. If it is quick let the SP do it, otherwise I guess loading/updating a table nightly would be better.  Just my two cents.

    From: Dot Krebs <bounce-dotkrebs9366@tessituranetwork.com>
    Sent: 7/21/2016 12:44:40 PM

    Looking for a little advice here.

    I'm creating a custom tab on a performance to replace an external db for tracking House Management information and attendance.

    In addition to attendance data by price zone and ticket type (comp, sub, single, group, staff), we also track:

     

    PERFID

    Act2Runtimetime

    PerformanceCode

    EndTime

    PerformanceType

    ShowRuntime

    Venue

    AccessiblePerformance?

    GateCount

    #ofBenefitingPatrons

    %Capacity

    #ofLoopDevicesUsed

    PerformanceDate

    #ofRadioDevicesUsed

    PerformanceTime

    AccessibleSeatsUsed

    HouseManager

    LargePrintProgramsUsed

    TicketSalesManager

    WeatherConditions

    UsherTeam

    OutsideTemperature

    #ofVolunteers

    TheatreTemperature2hrsBeforeDoorsOpen

    IfHouseOpenLate

    TheatreTemperaturePreshow

    HouseOpen

    TheatreTemperature30minsin

    Pre-ShowBegin

    LobbyCondition

    Pre-ShowEnd

    TheatreCondition

    Pre-ShowRuntime

    CoatCheckIncome

    Act1Begin

    PatronNotes

    Act1End

    OperationsNotes

    Act1Runtime

    HousekeepingNotes

    IntermissionBegin

    MiscellaneousNotes

    IntermissionEnd

    PreShow?

    IntermissionLength

    PreShowAttendance

    Act2Begin

    PostShow?

    Act2End

    PostShowAttendance

     

    My question to you for the attendance data and the performance information (date/time, etc.), do you suggest we insert that into the newly created table or do you suggest we let the stored procedure simply display and refresh that data every time the tab is opened?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization

    It seems to me that doing an update to the table regularly would be less overhead – especially because once a performance is over, you wouldn’t expect attendance figures to change much or quickly. The only caveat would be if there are performances for which you are doing after-the-fact scanning, or where scanning on the night doesn’t go as planned and you end up doing a lot of catch-up.

  • $organization

    Hmmm..  That is also true, but House Management has had a few instances the past two years where they forget about off-line scanning and think they have to tear tickets and wait until they hear from me. 

     

    Lemme think on that a bit.  

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jonathan Smillie
    Sent: Friday, July 22, 2016 3:27 PM
    To: Dot Krebs
    Subject: RE: [Tessitura Technical Forum] Advice: Custom Tab

     

    It seems to me that doing an update to the table regularly would be less overhead – especially because once a performance is over, you wouldn’t expect attendance figures to change much or quickly. The only caveat would be if there are performances for which you are doing after-the-fact scanning, or where scanning on the night doesn’t go as planned and you end up doing a lot of catch-up.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!