Does anyone know if there's a way to tie our events in Tessiutra to a shared Google calendar?
Yes you can. The basic principle would be to create an internet calendar (ics file) and put it somewhere publicly accessable (a file in a folder on your website) and point google calendar at it. I've written something for Artifax to do our events which is more advanced than the example above, but it could be easily modified by your dba/devs (sql and C#) to fit your needs I'm not in today, but can drop you some example code tomorrow if no one else offers first. WayneFrom: Amy Lehman <bounce-amyfranklin2534@tessituranetwork.com> Sent: 7/9/2014 9:46:46 AMDoes anyone know if there's a way to tie our events in Tessiutra to a shared Google calendar?You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!
Yes you can. The basic principle would be to create an internet calendar (ics file) and put it somewhere publicly accessable (a file in a folder on your website) and point google calendar at it.
I've written something for Artifax to do our events which is more advanced than the example above, but it could be easily modified by your dba/devs (sql and C#) to fit your needs
I'm not in today, but can drop you some example code tomorrow if no one else offers first.
Wayne
From: Amy Lehman <bounce-amyfranklin2534@tessituranetwork.com> Sent: 7/9/2014 9:46:46 AM
Attached link is the project for generating the ics file. At the moment it is just the SQL
http://www.tessituranetwork.com/Community/members/wayneevans6619/files/iCalendar/default.aspx
There are 2 files in the zip:
vCAL Tessitura.sql (query - I haven't converted to a SP)
This is what you want to run to get the data out
TimeDateToUDF.sql (a Scalar-valued Function)
This converts the time and date to Zulu time/date e.g. 20140711T161321Z and works out daylight savings. I haven't worked the code for the US, but the rules around this are in there (you want this to work really). (If you work it out, let me know so I can update mine).
Running vCAL Tesstiura.sql will give you an output the same as:
BEGIN:VCALENDAR
PRODID:-//Tessitura/Wayne Evans//EN
VERSION:2.0
X-WR-CALNAME: University of Notre Dame
X-PUBLISHED-TTL:PT1H
BEGIN:VEVENT
CLASS:PUBLIC
UID:18082
CREATED:20140711T161321Z
DTSTART:20130711T180000Z
DTEND:20130711T214200Z
SUMMARY:Performance of Hamlet
LOCATION:My Location
DESCRIPTION:
CATEGORIES:Entertainment
TRANSP:OPAQUE
END:VEVENT
UID:17950
DTSTART:20130711T181500Z
DTEND:20130711T210400Z
SUMMARY:Performance of A Mad World My Masters
UID:16933
DTSTART:20130711T183000Z
SUMMARY:Performance of Matilda The Musical
UID:20094
DTEND:20130711T200000Z
SUMMARY:Performance of Odyssey
UID:20095
DTSTART:20130712T120000Z
DTEND:20130712T133000Z
UID:18083
DTSTART:20130712T180000Z
DTEND:20130712T214200Z
END:VCALENDAR
Part 2 which I haven't uploaded yet, it an ASHX file which queries the database when called and returns back a .ics file to the caller (Google Calendar service) which it processes and populates your calendar. If you want to skip this and write your own, or just skip it, the text from management studio output window can be saved as a text file called calendar.ics and saved to e.g. the root of your website www.nd.edu/calendar.ics
Let me know how you get on or if you want any other info
Amy the above reply was more for your web developer, so don't worry if you don't follow all of it. Its the info he/she would need.
Thanks so much Wayne!! so helpful!