Monthly Archives: April 2012

SharePoint Calendar RSS feed sorting by Start Date

Problem: I wanted to publish our laundry list of marketing events on our SharePoint Blog. We’re not allowed to do any form of development on our internal SharePoint so I had to make do with a feed reader web part. Unfortunately, it seems like the default behavior of the SharePoint Calendar RSS feed is to sort by date modified.

Solution: Google helped me find this forum http://www.edugeek.net/forums/virtual-learning-platforms/65661-sharepoint-2007-calendar-rss-feed-date-order.html where they talk about the solution but I found there were a few more additional steps of which I will highlight in the walk through below:

1. Create a new Calculated Field that will hold the start date, I called mine Event Dateimage

2 . I created a view with the Standard View Format as this is only meant to extract the RSS feed from it. Name the view whatever you want and select which columns you want in the feed but what you’ll want to do is scroll down and modify the Sort order. I’ve also modified the Filter so as not to show events in the past.

 

image

3. Once you click okay, you should have your view with the correct sorting and filter. This is where it gets a bit tricky. For some reason, even when you have the correct view active,  the View RSS Feed on the action Menu doesn’t give you the right feed.

image

so you’ll have to go to list settings

image

and click the view you just created to edit it

image

And click on the RSS Icon, that should give you the correct feed for the view. If you’re in IE (9 as of my testing not sure with the old versions) it automatically sets it to sort by modified date but if you try chrome or the actual feed reader web part, it should give you the correctly sorted/filtered list.

image