• Replies 3 replies
  • Subscribers 415 subscribers
  • Views 123 views
  • Users 0 members are here
Related

Import / Export -- changing facilities

Lou Ann Mendoza
$organization

Hi,

For our upcoming season (which we've already sold a number of packges to) and a few single tickets, we will be changing the seats and consequently need to create a new facility and roll everyone over into the new facility.

From researching on the network, the knowledge base article, "Rollover into a new facility using conversion process" as well as the thread which details the Export / Import utilities are very useful:

http://www.tessituranetwork.com/Community/forums/t/4519.aspx

My question is that we don't want to rebuild the season for the new facility as the old performances even if they are off sale will still show up in Season Manager. Plus it is very labor-intensive.

My idea is after exporting all the order information is to switch the facility in t_perf for the productions, and then import the new orders (through a dummy season for packages and directly for single tickets). Then to release the old seats using performance seat release (hopefully it still works even if there is a facility change). Box office will then apply payments to the new orders.

Does anyone know if this will work?

Thanks,

Lou Ann

Parents
  • $organization

    Once a performance has had ticketing activity or pricing setup added, the facility cannot be changed.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lou Ann Mendoza
    Sent: Tuesday, July 17, 2012 8:49 PM
    To: Ryan Creps
    Subject: [Tessitura Ticketing Forum] Import / Export -- changing facilities

     

    Hi,

    For our upcoming season (which we've already sold a number of packges to) and a few single tickets, we will be changing the seats and consequently need to create a new facility and roll everyone over into the new facility.

    From researching on the network, the knowledge base article, "Rollover into a new facility using conversion process" as well as the thread which details the Export / Import utilities are very useful:

    http://www.tessituranetwork.com/Community/forums/t/4519.aspx

    My question is that we don't want to rebuild the season for the new facility as the old performances even if they are off sale will still show up in Season Manager. Plus it is very labor-intensive.

    My idea is after exporting all the order information is to switch the facility in t_perf for the productions, and then import the new orders (through a dummy season for packages and directly for single tickets). Then to release the old seats using performance seat release (hopefully it still works even if there is a facility change). Box office will then apply payments to the new orders.

    Does anyone know if this will work?

    Thanks,

    Lou Ann




    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 Ryan Creps (Past Staff Member)

    Thanks Ryan.

    I am wondering now if we should just make changes to the existing facility. The seat numbers will be completely different, and I think the number of seats is a bit less but the general configuration is pretty similar. If we run up_populate_tx_perf_seat, up_update_logical_nos, up_update_zone_no, and up_update_comp_maps just for the upcoming season, then seat maps for past performances should not be affected? If no one is in an existing seat I know how to get rid of it from tx_perf_seat.

    My other thought is to create a new facility, rebuild the season, then make the perf_dts for the old facility way in the future so they won't show up this upcoming season.

    Next time we will definitely do this before rollover!

    Thank you.

Reply
  • $organization in reply to Ryan Creps (Past Staff Member)

    Thanks Ryan.

    I am wondering now if we should just make changes to the existing facility. The seat numbers will be completely different, and I think the number of seats is a bit less but the general configuration is pretty similar. If we run up_populate_tx_perf_seat, up_update_logical_nos, up_update_zone_no, and up_update_comp_maps just for the upcoming season, then seat maps for past performances should not be affected? If no one is in an existing seat I know how to get rid of it from tx_perf_seat.

    My other thought is to create a new facility, rebuild the season, then make the perf_dts for the old facility way in the future so they won't show up this upcoming season.

    Next time we will definitely do this before rollover!

    Thank you.

Children
No Data