Stump the Panel

Paul Grenier, Lead Moderator

Stump the Panel » End Users and Information Workers

1. 

   rickjgoodman
   Member

   Struggling how to tackle this problem without doing developing a custom web part. Out of the box, SharePoint provides a calendar view (Current Items) that displays all instances of recurring events. But you cannot group this view, and you cannot create a connection from this view to another web part (hoping to group and format there). You can do this with the All Items view, but then you only retain the top level event and not the recurring instances. I'm guessing this can somehow be accomplished with a Data Form Web Part or a Content Query Web Part, but am not quite sure how to do it.

   Microsoft provides some clues in an earlier post (http://blogs.msdn.com/sharepoint/archive/2007/05/14/understanding-the-sharepoint-calendar-and-how-to-export-it-to-ical-format.aspx) but I'm still not sure how to best utilize this information.

   Can this be done?

   Posted 3 weeks ago #
2. 

   AutoSponge
   Administrator

   That's mainly because a recurring event does not create multiple instances of itself. There's only one object with a special set of attributes that allow it to appear in views based on the attribute's data.

   This is what recurrence data looks like:
   <recurrence><rule><firstDayOfWeek>su</firstDayOfWeek><repeat><weekly mo="TRUE" weekFrequency="1" /></repeat><repeatForever>FALSE</repeatForever></rule></recurrence>

   For a CQWP the fields you need are fRecurrence and RecurrenceData. But I'm still not clear what you want to do with that data.

   Posted 2 weeks ago #
3. 

   rickjgoodman
   Member

   Thanks for that feedback. I'm currently enjoying a rare 4-day weekend, so it'll be Tuseday before I can work on this again. As for the intended objective, my user schedules out events weeks and months in advance. Some are recurring, others are individual. In any given day there may be 5 to 20 events. The user needs to be able to see the event information in a list view (versus a calendar view) and see event details. The data needs to be grouped by day, showing all events on that day (recurring or not). This works fine in calendar view, but not in a list view. The Current Events view breaks out recurring events but does not allow grouping. So that is where we hit the block.

   I need to be able to reference the list via CQWP or DFWP and pull the data for all events (including the actual instances of recurring events) and then group them by date. So... do you think the information from your last post will help me get there, or is there something else needed to pull out all the instances of the recurring events.

   I really appreciate your help here. And I am very surprised that SharePoint doesn't enable this ootb, or that there is not a readily available solution to help. I will certainly be glad to post my solution if I can get something to work. THANKS!

   Posted 2 weeks ago #

RSS feed for this topic

Reply

You must log in to post.