• Replies 7 replies
  • Subscribers 338 subscribers
  • Views 75 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!

Parents
  • $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!

Reply
  • $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!

Children
No Data