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 BursnallInformation Systems Manager
Royal Opera House
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 */)
Thanks Simon - definitely worth looking at.
I'll run it on our TEST Database.
Much appreciated K