Has anyone played around/created a HTML template for pre-show emails? We want to keep this in tess so a record of the email lives in the constituency record vs using outlook/ect.
I've done a bit of exploration into this recently, although the bulk of my pre-show code is designed to work with WordFly. (N.B. that when configured correctly, it is possible to view sent pre-show campaigns on the constituent record using the WordFly custom screen.) That said, I can see the value in moving this into HTML templates for a number of reasons, and this will likely be a future project for me.
Recently I've done some work with post-order emails for virtual events ("how to watch"-type emails for video-on-demand, for example), but the basic concepts are going to be the same for preshow emails. The way I would choose to implement this would be with a Constituent Info template, because I want to send a single email to each constituent with all of their events for a given weekend, regardless of how many orders they have made. You might choose to do this differently, as there is likely going to be more code required within the template (or perhaps behind it in stored procedures for the Custom/Execute endpoint) for a constituent-based approach. I would have the expectation that template parameter functionality will be required for a pre-show template, for example, to pass in the date of the events that are meant to be included in the email.
After the template has been developed, then you still need to automatically schedule the queueing of these emails. This could be done using a SQL Agent Job, or perhaps a scheduled report/utility. I wrote up some developer documentation a few days ago in the community wiki that dives into some of the particulars of this.
Hopefully this gives you some reference to how big of a project this would be. Curious to know if others have come up with simpler approaches.
Nick Reilingh said:Recently I've done some work with post-order emails for virtual events ("how to watch"-type emails for video-on-demand, for example)
Nick,
you hit it on the head with the comment above. This is what sparked this need to move away from WF and onto a tess html email for this information based email that is NOT a marketing/sales email.
Do you have a Html template you could share with me regarding this sentence? “Recently I've done some work with post-order emails for virtual events ("how to watch"-type emails for video-on-demand, for example)
glad to see another org looking into the same project!
-Stephen
Happy to share my template code, but I don't think it would be all that helpful. So far, the way I've chosen to implement these has actually been to let our comms team write their copy in a WordFly template, using the existing implementation of our design language that we would use in marketing emails. I devised a process to "export" the WordFly HTML in a format that is suitable for use in a Tessitura HTML template, and then I smack some C#/Razor code up at the top to generate the dynamic content fields referenced inside the template. (This means on the WordFly template side, I'm actually using Razor's @-syntax as "merge fields" instead of the typical WordFly template merge field syntax. The @-syntax gets passed through unmangled, and is interpreted as part of the Razor template when it is rendered by Tessitura.)
The dynamic content in question isn't really anything more than an "add to calendar" button and some special date parsing for one particular performance where single-attendee timeslots are implemented as different price zones inside of a performance. We're using separate templates for each production. (Nowhere near the amount of dynamism that I have in my WordFly preshow email process.) So, the only things it really demonstrates are some specific applications of the .NET DateTime and TimeZone APIs, how to construct a URL query string per the API of the vendor I am using for calendar integration, and one specific filtering of the Tessitura OrderProductView data model per the Tessitura API spec. Likely too much "give a man a very strange looking fish" and not enough "teach a man to fish" given the rest of the process I'm using.
I could probably be persuaded to give a talk or screencast on the WordFly->Tessitura template export process if there is significant interest...
Hi Alicia, looping you into this thread to see if this will be helpful for our night of email instructions.
I rolled in our Preshow emails into our PAH ticket template. THere's not much in the way of dynamic parameters to play with but it saves patrons having to open more than one thing. It worked pretty well with only 2% requiring a reprint at the BO and everyone having the COVID instructions and Digital Program link.
Heath that sounds amazing. Would you mind sharing your template code so I can take a look at how that presents?
I like this idea.
Can anyone tell me where in the constituent record the record of the email would live?
Ashley
Emails sent to a customer through the Tessitura API can be found under Connections -> Contact Log.
It's a little less than amazing design wise but it doesn't mean that it can't be. We went with super simple to get the COVID messaging across.
You could do more though if you like. I used html-cleaner.com when I was updating and saved it to P:\PAH_Templates\MAIL Change the extension to .htm (I had to use .txt because you can't attach .htm) and view in browser
<Title>@@Subject</Title> <span style="font-family: Arial;"> <p>Hello,</p> <p>We are looking forward to seeing you for <em>New Breed</em> at Carriageworks.</p> <p><strong>Your Tickets</strong><br /> Attached are your eTickets with your seat allocation. Take a moment to check the details are correct, including date and time so that you can arrive safely and on time. Please download or print your eTickets and have them ready for scanning on arrival. If you have any questions about your order, please get in touch with us at the Sydney Dance Company <a href="mailto:boxoffice@sydneydancecompany.com">box-office</a>. </p> <p><strong>COVID Safety</strong><br /> The comfort and safety of our customers are of utmost importance to us and we want to ensure that the first time we perform in 2020 will be a great experience for everyone. Carriageworks is a COVID-Safe registered business. To ensure the wellbeing of audiences, they are following strict guidelines set by NSW State Government and Live Performance Australia. Help us keep the community safe by adhering to their plan. Click <a href="https://carriageworks.com.au/visit/#covid-19-safety">here</a> to view their COVID-Safe procedures. A pre-show bar will be operating from 6:30pm onsite.</p> <p>For performances at Carriageworks a mask is required at all times within performance spaces for patrons 12 years and older. Please bring your own mask; masks will be available should you need one. By entering Carriageworks Public Space you agree to wear a mask inside the theatre. If you refuse to do so you may be denied entry or asked to leave the venue. Please do not visit Carriageworks if you have experienced cold or flu like symptoms in the past 14-days, are awaiting the results of a COVID-19 test, or have returned from overseas or <a href="https://www.nsw.gov.au/covid-19/latest-news-and-updates?promo=#latest-covid-19-case-locations-in-nsw">hotspot area</a>. Stay home and take care.</p> <p><strong>Performance Content Warnings</strong><br /> The performance will run for approximately 90 minutes, including short pauses between the four works.</p> <p>Please note the final piece in the program is an exploration of cultural appropriation of the swastika from Hindu culture. The work contains images of the swastika, intermittently projected for three minutes at the start of the work, and some militaristic choreography. Recognising how sensitive the subject of the swastika is, we have consulted with the NSW Jewish Board of Deputies. We deeply appreciate their constructive input and their acknowledgement of the important discussion around this subject.</p> <p>There will be a short break before this work begins, giving patrons the opportunity to leave the theatre if they wish.</p> <p>You can read more from the choreographer in his artist statement <a href="https://www.sydneydancecompany.com/performance/2020-season-three/#artist-statements">here</a>.</p> <p>Please note at various points in the program, haze and strobe/or strobe-like lighting effects will be used. The program also contains film content depicting cigarette smoking and simulated cigarette smoking on stage.</p> <p>Latecomers will be admitted at a suitable break in the performance.</p> <p><strong>Performance Program</strong><br /> In our new COVID-safe world, our <em>New Breed</em> program is digital and available online. You can view or download <a href="https://issuu.com/sydneydancecompany/docs/2020_new_breed_program?fr=sZWZlNTIzMzE4ODk">here</a>.</p> <p>Should you have any questions about the work, we would be pleased to assist you. Please contact our Box Office team on 02 9221 4811.</p> <p>Thank you for your support of the emerging artists of Australia's contemporary dance ecology and Sydney Dance Company.</p> <p>Anne Dunn<br /> Executive Director</p> </span> <div style="font-family: arial; font-size: 14px; font-weight: bold;"><strong style="font-family: Cambria;"><br /> <span style="font-family: Arial; font-size: small;">Sydney Dance Company<br /> </span></strong><span style="font-size: small;"><span style="font-weight: normal; font-family: Arial;"><strong><br /> T </strong> <span class="gmail-m_744573002170500248Apple-tab-span" style="white-space: pre-wrap;">+</span>61 2 9221 4811<br /> <strong>A </strong></span><span style="font-family: Cambria; font-weight: normal;"><span style="font-family: Arial;">GPO Box 1598 Sydney NSW 2001<br /> </span><br /> </span></span> <img src="https://www.sydneydancecompany.com/wp-content/uploads/2020/07/SDC_Wordmark_Stacked_BLACK_reduced.png" alt="" width="300" /><br /> <span style="font-size: small;"><span style="font-family: Cambria; font-weight: normal;"><br /> <span style="font-family: Arial; color: #000000;"><a style="color: purple;" href="https://www.facebook.com/sydneydanceco"><span style="color: #000000;">Facebook</span></a></span><span style="font-family: Arial;"> / <a style="color: #000000;" href="https://www.instagram.com/sydneydanceco/"><span style="color: windowtext;">Instagram</span></a> / <a style="color: #000000;" href="https://twitter.com/sydneydanceco"><span style="color: windowtext;">Twitter</span></a> / <a style="color: #000000;" href="https://www.youtube.com/user/sydneydancecompany">Youtube</a> / <a style="color: #000000;" href="http://weibo.com/sydneydancecompany">Weibo</a> / <a style="color: purple;" href="https://www.sydneydancecompany.com/wp-content/uploads/2017/06/WeChat-QR-Code.jpg"><span style="color: #000000;">WeChat</span></a></span></span></span></div>