• Replies 7 replies
  • Subscribers 338 subscribers
  • Views 74 views
  • Users 0 members are here
Related

Prize Zone Map not updating within order screen

Morgan Gavaletz
$organization

Hello Tessy Folks!

I'm relatively new to Tessitura, but did take a ticketing class.  In the class we learned about facility manager.  I'm attempting to adjust my "Price zone" map.  It looks correct in facility manager but the old (non-updated) price zone map shows within the order screen.

Any ideas why my changes are not showing up in the best seat map tab, when I try to place an order?

Thank you!

  • $organization in reply to Lucie Spieler

    Hi Lucie,

    Thank you for this, but I'm not sure it applies?  We created this event and made it live yesterday. After doing so, we adjusted the best seating zones but did not add any seats.  Would I still need to run utility procedures if I didn't add seats, just reassigned their "name" (VIP, early bird, general admission)?

    Thanks!

  • $organization

    Hi, Morgan:

     

    I believe you (need to have access through Microsoft SQL Server Management Studio) need to run utility procedures when you update and want to extend the changed onto existing performances. Look at the Tessitura Database Utilities document to see which ones apply in your situation.

     

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Database%20Utilities.aspx

     

    Here’s what I’ve saved to use for myself to fix seat map issues:

     

    ----------------

    declare @season_no int

    set @season_no = 96

     

    --exec UP_POPULATE_TX_PERF_SEAT @season = @season_no

    --exec UP_UPDATE_ZONE_NO @season = @season_no  

    --exec UP_UPDATE_LOGICAL_NOS @season = @season_no     

    --exec UP_REBUILD_ALL_BSMAPS --(no parameter--takes a couple of minutes)

    --exec UP_UPDATE_BSMAP_SEQUENCE @season = @season_no

    --exec UP_UPDATE_COMP_MAPS @season = @season_no

     

    --exec TP_CHECK_SEAT_STATUS @season = @season_no, @fix_problems = 'Y'

    --exec TP_CHECK_BASE_STATUS @season = @season_no, @fix_problems = 'Y'

    -------------

     

    Lucie

     

    __________________________________________

    Lucie Spieler

    IT Development and Training Manager
    FLORIDA GRAND opera

     

  • $organization

    You’d need to run the two best seating procedures, yes.

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Morgan Gavaletz
    Sent: Saturday, July 29, 2017 11:09 AM
    To: Lucie Spieler <lspieler@fgo.org>
    Subject: RE: [Tessitura Technical Forum] Prize Zone Map not updating within order screen

     

    Hi Lucie,

    Thank you for this, but I'm not sure it applies?  We created this event and made it live yesterday. After doing so, we adjusted the best seating zones but did not add any seats.  Would I still need to run utility procedures if I didn't add seats, just reassigned their "name" (VIP, early bird, general admission)?

    Thanks!

    From: Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com>
    Sent: 7/29/2017 2:59:01 PM

    Hi, Morgan:

     

    I believe you (need to have access through Microsoft SQL Server Management Studio) need to run utility procedures when you update and want to extend the changed onto existing performances. Look at the Tessitura Database Utilities document to see which ones apply in your situation.

     

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Database%20Utilities.aspx

     

    Here’s what I’ve saved to use for myself to fix seat map issues:

     

    ----------------

    declare @season_no int

    set @season_no = 96

     

    --exec UP_POPULATE_TX_PERF_SEAT @season = @season_no

    --exec UP_UPDATE_ZONE_NO @season = @season_no  

    --exec UP_UPDATE_LOGICAL_NOS @season = @season_no     

    --exec UP_REBUILD_ALL_BSMAPS --(no parameter--takes a couple of minutes)

    --exec UP_UPDATE_BSMAP_SEQUENCE @season = @season_no

    --exec UP_UPDATE_COMP_MAPS @season = @season_no

     

    --exec TP_CHECK_SEAT_STATUS @season = @season_no, @fix_problems = 'Y'

    --exec TP_CHECK_BASE_STATUS @season = @season_no, @fix_problems = 'Y'

    -------------

     

    Lucie

     

    __________________________________________

    Lucie Spieler

    IT Development and Training Manager
    FLORIDA GRAND opera

     




    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

    Morgan,

    Here is the documentation on Making Changes to a Facility in Use.  It outlines when you need to run the Facility Updates to push those changes out to the individual performances.  Also there is now a Utility available in the Tessitura client under Reports and Utilities that you can run so you do not need to run the Facility Update procs in SQL Server.   Here's the documentation on that.

    Dale

  • $organization

    Hi Morgan,

    There is a utility in the reports menu now to do this for you.  It’s called facility updates.

    Dee Dee

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Lucie Spieler
    Sent: Saturday, July 29, 2017 10:53 AM
    To: Dee Dee Fite
    Subject: RE: [Tessitura Technical Forum] Prize Zone Map not updating within order screen

     

    Hi, Morgan:

     

    I believe you (need to have access through Microsoft SQL Server Management Studio) need to run utility procedures when you update and want to extend the changed onto existing performances. Look at the Tessitura Database Utilities document to see which ones apply in your situation.

     

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Database%20Utilities.aspx

     

    Here’s what I’ve saved to use for myself to fix seat map issues:

     

    ----------------

    declare @season_no int

    set @season_no = 96

     

    --exec UP_POPULATE_TX_PERF_SEAT @season = @season_no

    --exec UP_UPDATE_ZONE_NO @season = @season_no  

    --exec UP_UPDATE_LOGICAL_NOS @season = @season_no     

    --exec UP_REBUILD_ALL_BSMAPS --(no parameter--takes a couple of minutes)

    --exec UP_UPDATE_BSMAP_SEQUENCE @season = @season_no

    --exec UP_UPDATE_COMP_MAPS @season = @season_no

     

    --exec TP_CHECK_SEAT_STATUS @season = @season_no, @fix_problems = 'Y'

    --exec TP_CHECK_BASE_STATUS @season = @season_no, @fix_problems = 'Y'

    -------------

     

    Lucie

     

    __________________________________________

    Lucie Spieler

    IT Development and Training Manager
    FLORIDA GRAND opera

     




    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!