• Replies 5 replies
  • Subscribers 414 subscribers
  • Views 125 views
  • Users 0 members are here
Related

Hold Code Removal

Robert Reay
$organization

Hi

how can i remove a large amount of holds without running the expire hold code report? (as its not set up yet.)

it is tedious removing the holds one by one.

any ideas??

Many Thanks,

Robert

  • $organization

    Hi Robert

    Do you mean holds for just one concert? If so you can right click and select the entire area on the seat map that you want to remove the holds from, then sekect Block Selection: Holds. Then in the Expire Hold Codes box, choose ALL (or whichever hold code you want to remove if it's just one type) and expire all.

    Hope that helps - try it in your Test environment first to make sure you get it right as I don't think it's reversable!

    Siobhan

  • $organization

    Hi Robert,

     

    You can expire multiple hold codes at once and in multiple performances at once from season maintenance.  See the Deleting Hold Codes section in the Hold Codes document for details:

    http://www.tessituranetwork.com/~/media/Documentation/Ticketing/Hold_Codes.ashx

     

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

  • Former Member
    Former Member $organization
    For multiple performances, go into Season Manager --> Season Maintenance, search for and find the performances you want, and then go to the Hold Tab. From there you can select whichever codes you want to expire and expire them. You can also go into the map tab on the side, and manually change the codes.
     
     
    Katie Kring
    Box Office Manager
    Florida Studio Theatre
    Phone: 941.366.9000
     
    -----Original Message-----
    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Robert Reay
    Sent: Thursday, August 20, 2009 9:32 AM
    To: Katie Kring
    Subject: [Tessitura Ticketing Forum] Hold Code Removal

    Hi

    how can i remove a large amount of holds without running the expire hold code report? (as its not set up yet.)

    it is tedious removing the holds one by one.

    any ideas??

    Many Thanks,

    Robert




    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 in reply to Siobhan Parker (Past Member)

    Great! thats worked perferctly.

    will save me alot of time.

    Many thanks.

    Robert

  • $organization in reply to Robert Reay

    Hi All,

    All the Hold codes are sitting in a table called TX_PERF_HC.

    If you delete a record from this table, the hold code of that seat will be removed.

    Not every seat has a hold code, but every HC record has a seat.

     

     

    SELECT

     

    perf_no, seat_no, hc_no, priority, start_dt, end_dt, session_no

    FROM

     

    TX_PERF_HC

    have fun

    Ben