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
…sorry, the phone rang, and I hit send without finishing the thought…
You might be able to use an update like this to put in text you want. You could also add facility_no (from t_perf, tied in by perf_no) to the #lineitems temp table in tp_order_ack (I’d create lp_order_ack) and then use a case statement to update the facility_no with the appropriate description (including address) in the data returned at the end of the procedure.
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
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Lucie SpielerSent: Tuesday, February 28, 2012 10:46 AMTo: Lucie SpielerSubject: RE: [Tessitura Technical Forum] Custom Order Confirmations
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
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!