Segment Updates

Hi Mardi,

As an interim solution while some poor soul is updating on a perf by perf basis, we’ll put running times in the synopsis tab in title or production within ticketing setup.  It’s not ideal for pulling through to the web, but it lets the sales advisors know right away… 

Cheers,

Kathleen

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.

--
View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/5071/16385.aspx#16385 or reply to this message
--
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!

Mardi

Segment info is stored for each performance in TX_PERF_SEG and you could import it into there (after a lot of testing of course) for a performance or performances. Of course making sure that you had the correct details for perf_no and the rest of the info, ie segment type id (from tr_perf_seg), duration and the segment order.

Be worth giving it a try in Test at least.

S.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Mardi Osborn
Sent: Tuesday, 2 August 2011 2:00 PM
To: Sandra Ashby
Subject: [Tessitura Ticketing Forum] Segment Updates

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.

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!

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!