Dealing with the Proliferation of MOS

Thanks Simon,

 I’ll have a look at this on our TEST Database.

 Much appreciated.

 K

 Keith Bursnall
Information Systems Manager

 Royal Opera House
Covent Garden, London WC2E 9DD
Telephone: +44 (0)20 7212 9408
Email: keith.bursnall@roh.org.uk

Website: www.roh.org.uk
YouTube: www.youtube.com/royaloperahouse
Join us on Facebook: www.roh.org.uk/facebook
*Please consider the environment before printing this email

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Simon Davidson
Sent: 10 January 2012 15:32
To: Keith Bursnall
Subject: Re: [Tessitura Technical Forum] Dealing with the Proliferation of MOS

As a quick and dirty way could you do something like this?  (I haven't tested this code, but imagine if you have a lot of perfs your updating, and alot of MOS it will take awhile to run)

USE impresario

DECLARE @start_dt DATETIME,

@end_dt DATETIME,

@seat_ind CHAR(1),

@print_ind CHAR(1)

SET @start_dt = GETDATE()

SET @end_dt = GETDATE()

SET @seat_ind = 'Y'

SET @print_ind = 'Y'

INSERT INTO TX_PERF_PKG_MOS

SELECT p.perf_no,

0 AS pkg_no,

m.id AS MOS,

@start_dt,

@end_dt,

@seat_ind,

@print_ind

FROM T_PERF AS p

CROSS JOIN TR_MOS AS m

WHERE p.perf_no IN (/* Put your perf_no here */) AND

m.id IN (/* Put your MOS here */)

Hi,

Just wondering whether anyone out there has written a report that can make the job of applying large numbers of Modes of Sale to multiple Performances.

Our problem is that, with our new website development, we have had to switch from using web code to move our members to their appropriate Mode of sale, to using native Tessitura functionality (i.e. applying a Rank and Rank Value to a constituent and linking that Rank/Rank Value to a specific Mode of Sale). Because we are also launching Access/Wheelchair Seating Online and we also have a sizeable Student Membership, we have found the only way of providing appropriate access and discounts to those constituents that may share a 'Friends Membership' (currently 10 levels) with both Access Requirements (5 levels) and a Student Status, is to create upwards of 120 new Modes of Sale.

Managing this myriad of Modes of Sale is, understandably, daunting to our Set-Up Department - particularly when you consider the number of different Productions/Performances that need to be kept up-to-date.

Season Maintenance certainly makes the job easier, but Modes of Sale can still only be applied one at a time using this facility.

Does anyone have any suggestions or solutions - it would be greatly appreciated.

Cheers K

Keith Bursnall
Information Systems Manager

Royal Opera House

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!