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
Hi Teresa,
We aren't doing anything like this, but I think a way to included the address would be to modify the XSL file to have a condition to check which facility_description the ticket is for. Based on what facility description is the proper address would be printed.
Jon
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
…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.
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
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!
We have our TN_Express_Order_Confirmation configured for use in the client. It appears as an option for our Box Office staff in the Acknowledgement dropdown. When selected, the primary email address on the Constituent record is selected. Clicking on OK then sends the confirmation, the email has the exact same information as if the patron ordered online. Our box office staff uses this all the time and we don't even touch any of the other confirmation templates now.
In T_DEFAULTS, you may want to check in with the TNEW team for entries in each of the ORDER_EMAIL parameters where Impresario is the Parent Key. TNEW and RAMP set this up for us.
Duane
Thanks Duane.
I’ll check into that….for whatever reason, I didn’t think I could use the TNEW confirmations through the client, but it makes sense. It’d also make life easier!!!!
Don't quote me because my info might be outdated but last I checked you can use the TNEW confirmations from the client. It won't throw an error or anything, but for aux items and receipt text, it won't hide the date/time (if you have aux set to do that) and it won't show the various receipt text, and the subject line will be the email confirmation subject line from t_defaults for impressario, which may be different than what's in your TNEW template. So it still totally works and does show the venue, but may look slightly different than it would've when sent from the web. For the purpose you mentioned, it doesn't seem like that'd be a problem since you want the venue to show, but if you're considering using only the TNEW template in the future, it's not completely identical and it may not be a good solution for orders containing aux items.