• Replies 5 replies
  • Subscribers 415 subscribers
  • Views 131 views
  • Users 0 members are here
Related

moving performances to a different title

Lesley Chaney
$organization

Hi all,

 

I have a series of performances that were built in the wrong title (and by extension, the wrong production and production season).  Is it possible to correct that, or do I need to rebuild the events in the correct place?

 

Thanks,

Lesley Chaney

  • $organization

    You can correct it via SQL by updating the prod_season_no in t_perf for the perfs in question to the correct prod_season_no. You didn't say if the wrongness of the prod_season in turn put the perfs in the wrong  season, but if so you'll need to update that as well. I've done this before without incident.

  • $organization in reply to A. Freeman

    Thanks for the info!  Is there any repercussion to doing this after there are sales in the event, or does it not matter?

  • $organization

    One thing to note would be ticket and subscription history.  Depending on the customization, you may need to delete and recreate the history data.  If you haven’t sold anything to the event, this is one less thing to worry about!

    -Ryan

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lesley Chaney
    Sent: Friday, May 28, 2010 2:40 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Ticketing Forum] moving performances to a different title

     

    Thanks for the info!  Is there any repercussion to doing this after there are sales in the event, or does it not matter?

    From: Amanda Freeman <bounce-amandafreeman5080@tessituranetwork.com>
    Sent: 5/28/2010 1:23:15 PM

    You can correct it via SQL by updating the prod_season_no in t_perf for the perfs in question to the correct prod_season_no. You didn't say if the wrongness of the prod_season in turn put the perfs in the wrong  season, but if so you'll need to update that as well. I've done this before without incident.




    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 Lesley Chaney

    Season overview will still show the perfs in the wrong prod_season until the next full refresh, I think. Local tkt and sub hist, depending on what your local version does may also be mismatchey if you reference the prod_season there, until you next refresh that data. Any report snapshots from before the change, I am pretty sure will not be affected, ie they'll still reflect the previous wrongness. I think.

    Other than that I don't believe it should matter.



    [edited by: Amanda Freeman at 2:07 PM (GMT -6) on 28 May 2010]
  • $organization in reply to Ryan Creps (Past Staff Member)

    performance we want to move to different prod_season is part of a package and is already rolled over. Can we still change the prod_season_no in the t_perf for the performance? What else do we have to check?