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!
Any chance you can email that file to me? MY web developer doesn't have access to the tessituranetwork website
Ive mailed you. Hopefully there is an attachment
Looks like some extra characters went out in the link
This is the right link
I'll reply back here as I've had a couple of direct mails.
There is a video link at the bottom for when this doesn't make sense.
The SQL source code is here:http://www.tessituranetwork.com/Community/members/wayneevans6619/files/iCalendar/default.aspx
Running the script produces the output in management studio in the right format to be copied to a text file (notepad). Once you've copied the output and saved your file (to your desktop?), you can open it in Outlook to prove you can see the file and there are no errors.
Save this file to the root of your website, e.g. www.rsc.org.uk/myfile2.ics (I haven't copied it up, so don't try to click it) and then use google calendar to point at your file:https://www.google.com/calendar
Other calendars --> Add by url --> www.rsc.org.uk/myfile2.ics
As long as the output is correctly formed, there are many different ways of getting the file to your website for google to query. While you're testing, its easier just to manually copy the file there.
Below is the whole process minus copying the file to our website. It will show you the generation of the file, how to copy and save the file and how to open it in Outlook and Google Calendar
http://screencast.com/t/PaVEFah73ki
Thank you!