• Replies 9 replies
  • Subscribers 415 subscribers
  • Views 20 views
  • Users 0 members are here
Related

Inactivating Price Maps

Becci Brace
$organization

I am curious to know if anyone inactivates price maps from past performances.  If so, do you do this per season, or after the show closes? Pros?  Cons?

I can only see pros in my corner:

  • Less clutter
  • Our naming convention for maps includes a 2 letter acromyn for the show, sometimes we get duplicates across the years

 

  • $organization

    I usually ask the Box Office to inactivate the price maps after a show has been settled and closed, although they don't always remember to do so.

    I then do a check at the end of the calendar year and inactivate any that are still active for that year. I do find it does help eliminate pricemaps being assigned to incorrect shows if they get inactivated after a show is closed, especially where there can be several names of maps that are similar and could easily be miss selected.

    Caryl

  • $organization

    Becci,

     

    We try to do this at the end of each season.  We haven’t really run into any issues with doing this…..yet (knock on wood).  It does help tremendously in cleaning up clutter since we have several organizations sharing facilities and we reuse zone maps from season to season  because of SYOS.

     

    Teresa

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Becci Brace
    Sent: Tuesday, April 26, 2011 9:39 AM
    To: Teresa Dean
    Subject: [Tessitura Ticketing Forum] Inactivating Price Maps

     

    I am curious to know if anyone inactivates price maps from past performances.  If so, do you do this per season, or after the show closes? Pros?  Cons?

    I can only see pros in my corner:

    • Less clutter
    • Our naming convention for maps includes a 2 letter acromyn for the show, sometimes we get duplicates across the years

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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

    Becci,

    We inactivate old price maps during a setup whenever using the same zone map. It's just a standing rule: before making new, inactivate the old. We have a hefty amount of zone maps, and this is the best method for us to keep up with them.

    You're correct in that it cleans up the clutter. We've been doing this for at least two seasons with no problems.

    Hope that helps!

  • $organization

    This has been our practice since converting to Tessitura (going on season 8 now) and we have not run into any negatives from this practice.  In fact, I consider it essential to keeping the data in that area of the system clean.

  • $organization

    Funny you should ask: I was just running the following in SQL Server Management Studio:

     

    update T_PMAP set inactive = 'Y'

    where inactive = 'N' and description like '13%' replace with appropriate zone maps

     

    Obviously, you need to get the description and zone maps that are appropriate for your database.

     

    Lucie

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

  • $organization

    The query in my e-mail changed from what I sent. I’m trying again…

    << 

    update T_PMAP set inactive = 'Y'

    where inactive = 'N' and description like '13%' replace with appropriate zone maps

    >> 

     

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

  • $organization

    Nope—third line of code is still getting stripped—says “and zmap_no in (##,##,##)”.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

  • $organization

    Hi Becci,

    We only inactivate for our general admission houses, however all our price maps are prefaced with the season indicator (10, 11, 12, 13 etc) so it's never an issue grabbing the wrong one. We create new main stage houses for each season, so there isn't an issue there.

    Michele

  • Former Member
    Former Member $organization

    Thanks, I will ask him.

    Andy

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Beth Hawryluk
    Sent: Tuesday, July 02, 2013 4:19 PM
    To: Andy Fogel
    Subject: Re: [Tessitura Ticketing Forum] Inactivating Price maps

     

    Your database person can probably do that for you through SQL.

    From: Andrew Fogel <bounce-andrewfogel8036@tessituranetwork.com>
    Sent: 7/2/2013 12:39:36 PM

    Dose anyone know if there is a way to Inactivate more than one price map at a time?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!