Webcal feeds from Serena Calendar Reports Hot

http://serenacentralphotos.s3.amazonaws.com/original/c4/f7/32/calendarfeed-example-86-1427929695.png
by Jeff Malin on April 01, 2015

Extend the existing Calendar report functionality and the "My Calendar" view to add a Webcal Feed link which allows a Serena calendar to be integrated into Outlook, Mac Calendar, Gmail, or any other system which uses standard Web Calendars.

  • Along with many clients of Serena, we use Calendar data extensively in a number of solutions - Time Off, Release Management, Change Management, and others. The "My Calendar" functionality allows us to being many Calendar feeds into a single view within Serena, but it does not provide any capability to view SBM calendars alongside external sources. Thus we lack any way to have a consolidated view of all event data, as Exchange calendars remain our system of record for corporate events. One solution is to allow the ability to export an Event in Serena in .ICS format, which can be imported into Outlook, Gmail, or other systems. We built a custom solution for this using AppScript which writes a file in .ICS format, and prompts the user to open it to add to their calendar. This is useful, but it only operates on an item-by-item basis, and requires manual action to add each item to your own calendar. In addition, it does not automatically update when the item dates or other information change in SBM. To more fully solve this need, we created a custom calendar feed solution using AppScript which publishes WebCal feeds (basically, just a collection of .ICS events in XML format). By adding the URL to this AppScript into Outlook or other Calendar-feed accepting systems, we can integrate a mirror version of any Serena Calendar Report within our external tool, which is automatically updated on a scheduled basis (~5mins is the default). The solution I describe using AppScript is acceptible, but has several issues: 1. Security - because we are not using Integrated Windows authentication, our external tools are not able to authenticate to run the script. To work around this, we encode a generic read-only user account's credentials into the calendar URL. This makes reports using (Current User) difficult to use. 2. Field Types - The AppScript which renders the calendar needs to read the report parameters from the TS_REPORTS table and attempt to synthesize the SQL queries which will return the desired results. This is difficult to do for certain fields or field types. 3. Access - We built a custom "menu" of available calendars for users to pick, to add to Outlook. This lives on its own AppScript page and is not obvious to users. It would be much more powerful if there were a Calendar Feed icon on each individual feed. 4. "My calendar" - our current solution interfaces with individual feeds, not at the "My Calendar" level. It would be helpful if a user could import their "My Calendar" a single time in Serena, then manage the component feeds within the system, as opposed to having to subscribe individually to all components (though, this may be preferable for other users - so both should be an option). In speaking with others at xChange we think that this is a feature that would receive a lot of positive attention, so we would like to request that it be considered for inclusion in a future version of SBM.

    Ideas

    Target Release
    2HCY'18
  • Please login to view any attachments.

  • Already have an account? or Create an account
    This has been further deferred to under consideration for the 2HCY'18 release.
    David J. Easter Commented by David J. Easter November 16, 2017
    #1 Reviewer  -  

    This has been further deferred to under consideration for the 2HCY'18 release.

    blank calendars 2018
    2018 calendar template Excel
    january 2018 calendar with holidays
    blank calendar january 2018
    January 2018 Calendar PDF
    2018 Calendar Template Word
    January 2018 Calendar Word
    2017 Calendar Template Word

    December 2017 Blank Calendar
    December 2017 Printable Calendar
    December 2017 Calendar Template
    james henry Commented by james henry November 13, 2017
    Top 500 Reviewer  -  

    blank calendars 2018
    2018 calendar template Excel
    january 2018 calendar with holidays
    blank calendar january 2018
    January 2018 Calendar PDF
    2018 Calendar Template Word
    January 2018 Calendar Word
    2017 Calendar Template Word

    December 2017 Blank Calendar
    December 2017 Printable Calendar
    December 2017 Calendar Template

    For our desired implementations, I would agree with the original poster that "both" would be useful
    Jennifer Redding Commented by Jennifer Redding March 22, 2017
    Top 500 Reviewer  -  

    For our desired implementations, I would agree with the original poster that "both" would be useful

    This has been deferred for consideration in the 1HCY'17 release.
    David J. Easter Commented by David J. Easter February 14, 2017
    #1 Reviewer  -  

    This has been deferred for consideration in the 1HCY'17 release.

    We will put this idea Under Consideration for the 1HCY'16 release of SBM.
    David J. Easter Commented by David J. Easter August 07, 2015
    #1 Reviewer  -  

    We will put this idea Under Consideration for the 1HCY'16 release of SBM.

     
    View all user comments
     

PrintEmail

Recent Tweets

Twitter response: "Invalid or expired token."