TNEW: including iCal in booking confirmation

If you mean "booking confirmations" specifically to refer to the "booking" functionality in Tessitura, then no.  But we now include an "Add to Calendar" button in all of our e-mail confirmations as well as on our TNEW receipt page and the event pages themselves (Corporate side).  It required a custom API call to be set up that creates the .ics file based upon the performance number, but essentially then it is just a link that we can now place anywhere as long as we can grab the performance number.  It is built into our corporate event pages directly, added to the receipt page via Javascript, and then I had to edit the CartHTML.xslt file to put the link in there (will be MUCH easier in HTML templates once that happens).

If you want to go through an example on our website and see all three in action, start here:  https://thecenterpresents.org/tickets-events/events/2122/center-presents/live-at-the-center-sophie-faught-quartet/.  Just make sure you choose the LIVESTREAM option, as that is free.

Let me know if you have any questions.

John

Hi John,

What you have is EXACTLY what we're looking for - as a ticket buyer, it's simple and elegant. FYI, I booked a comp for the event - I will keep the booking because, in my time zone, the event is at 10am and so will be a wonderful distraction as I wrangle Tessi! Sadly, we lack the in-house expertise to be creating API calls so I guess our process will have to be a little more tedious:

1. create the iCal files (the tedious part) using a free online tool like https://ical.marudot.com/ one by one - we'll probably name each file according to its T_PERF.perf_code value
2. upload each file into a publicly (but hidden) area of our website
3. insert a performance-specific entry into LTR_TNEW_DYN_EMAIL_CONTENT - meaning it will be included in the booking confirmation email and the joy of it being displayed on the receipt page of our TNEW site (JUST like yours does!)

The tedious part will be creating and saving the iCal files - I reckon I can easily do item 3 by SQL.

If anyone has a better suggestion (many thanks for your feedback John!) I'm all ears!

Roll on TLCC!!

Martin

Hi John,

What you have is EXACTLY what we're looking for - as a ticket buyer, it's simple and elegant. FYI, I booked a comp for the event - I will keep the booking because, in my time zone, the event is at 10am and so will be a wonderful distraction as I wrangle Tessi! Sadly, we lack the in-house expertise to be creating API calls so I guess our process will have to be a little more tedious:

1. create the iCal files (the tedious part) using a free online tool like https://ical.marudot.com/ one by one - we'll probably name each file according to its T_PERF.perf_code value
2. upload each file into a publicly (but hidden) area of our website
3. insert a performance-specific entry into LTR_TNEW_DYN_EMAIL_CONTENT - meaning it will be included in the booking confirmation email and the joy of it being displayed on the receipt page of our TNEW site (JUST like yours does!)

The tedious part will be creating and saving the iCal files - I reckon I can easily do item 3 by SQL.

If anyone has a better suggestion (many thanks for your feedback John!) I'm all ears!

Roll on TLCC!!

Martin