Hi there,
I was just wondering whether anyone has discovered or created a way to bulk update the segments to indicate running times across a season of performances after they have been built as yet?
We often do not know the running times for performances ahead of the on sale date - and so have the laborious and time-consuming task of updating this information individually once it becomes available.
Is there any clever people out there who have created a report or similar to do this ?
Any thoughts or suggestions would be greatly appreciated!
regards,
Mardi.
Funny you should mention this, Richard - I was thinking that only the other day. I know I’m going to have to make changes to our performance segments in the next few days and was beginning to dread it – I wish segments had the option of appearing at the Production Season level.
I’d resolved to run a script in SQL – something like:
UPDATE TX_PERF_SEG
SET rel_start_min = *new segment run time in minutes*
WHERE perf_no in ( *comma separated list of performance IDs* )
AND perf_seg = *ID of the row in TR_PERF_SEG that matches the Segment you want to update*
Just re-run this for every segment ID you want to update. Good luck!
C.//
X.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Richard Rubio Sent: 08 April 2015 22:53 To: Chris Campbell Subject: [Tessitura Ticketing Forum] Segment updates
Has anybody come up with a way to update the Segments section for show run times for an entire production rather than updating individually at the performance level?
Thanks,
Richard
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!
Thanks, Chris. We'll give it a try.
Cheers,