Has anyone out in Tessitura land edited the Standard Order Confirmations to include venue name and address with the performance? We have multi venue and multi org orders and are getting to the point where we need to include location and address for each ticket to reduce confusion for the patrons. We have this built into our TNEW web confirmations, but I haven't been able to figure out how to integrate that same code into our other order confirmations. Is anyone out there doing this and willing to share how they do it?
Teresa
We don’t send out ticket order confirmations (we just send the tickets). For subscription orders, though, we do send confirmations, and we update the series name using the following code:
UPDATE #conf_notices SET d_series = case
when d_series = '12M-Opening Night in Miami' then '2011-12 Opening Saturday in Miami'
when d_series = '12M-Wednesday in Miami' then '2011-12 Wednesday Night in Miami'
when d_series = '12M-Saturday in Miami' then '2011-12 Saturday Night in Miami'
when d_series = '12M-Tuesday in Miami' then '2011-12 Tuesday Night in Miami'
when d_series = '12M-Friday in Miami' then '2011-12 Friday Night in Miami'
when d_series = '12M-Sunday in Miami' then '2011-12 Sunday Matinee in Miami'
when d_series = '12B-Thursday in Ft Lauderdale' then '2011-12 Thursday Night in Fort Lauderdale'
when d_series = '12B-Saturday in Ft Lauderdale' then '2011-12 Saturday Night in Fort Lauderdale'
when d_series = '12M-FLL Ron Fri Jan 27' then 'Friday La rondine in Miami for Fort Lauderdale Subscribers'
when d_series = '12M-FLL Ron Open Jan 21' then 'Opening Saturday La rondine in Miami for Fort Lauderdale Subscribers'
when d_series = '12M-FLL Ron Sat Feb 4' then 'Saturday La rondine in Miami for Fort Lauderdale Subscribers'
when d_series = '12M-FLL Ron Sun Jan 29' then 'Sunday Matinee La rondine in Miami for Fort Lauderdale Subscribers'
when d_series = '12M-FLL Ron Tue Jan 24' then 'Tuesday La rondine in Miami for Fort Lauderdale Subscribers'
when d_series = '12M-FLL Ron Wed Feb 1' then 'Wednesday La rondine in Miami for Fort Lauderdale Subscribers'
else d_series end
Lucie
______________________________
Lucie SpielerIT Development and Training Manager
Editor, Season ProgramFLORIDA GRAND opera8390 NW 25th StreetMiami, FL 33122305.854.1643 x. 1521Box Office: 800.741.1010To Give a Gift: 305.403.3315www.FGO.org2011-2012 • 71ST SEASON • LOVE FORBIDDEN, NOT FORGOTTENLuisa Fernanda • La rondine • Rigoletto • Roméo et Juliette