Understanding the SharePoint calendar and how to export it to iCal format

" + title + "

" + title + " — Wed, 16 May 2007 09:30:15 GMT

PingBack from http://www.virtual-generations.com/2007/05/16/sharepoint-link-love-05-16-2007/

re: Understanding the SharePoint calendar and how to export it to iCal format

Jack Jones — Thu, 17 May 2007 06:40:41 GMT

Matt,

Having this information a few years ago for WSSv2 would have saved me much frustration. There is something that I am struggling with now though - WSSv3 has added recurrence patterns that use the Nth day, weekday, and weekend day of the month in addition to the normal days (Monday, Tuesday, etc.) that were there before. When retrieving the RecurrenceData field for patterns that use these new additions, the only data in the field is <V3RecurrencePattern />. Before I drive myself batty, could you explain how this works, and how I can get the recurrence data? Also, is there a way to use the ExpandRecurrence property when getting list data via the web services? If this were possible I could retire my in-house parser and use the real SharePoint logic that does this.

TIA to anyone that can help me.

re: Understanding the SharePoint calendar and how to export it to iCal format

Matt Swann — Thu, 17 May 2007 07:44:33 GMT

Jack,

Are these recurring items that were created through Outlook, or through the WSS UI? I'll take a look first thing tomorrow morning and get back to you on this and the web services question.

(I'm pretty sure you can use the QueryOptions string as given in the code sample in the web service call, but I want to try it first.)

re: Understanding the SharePoint calendar and how to export it to iCal format

Jack Jones — Thu, 17 May 2007 20:09:25 GMT

Matt,

I am creating them using the UI. It only happens when using those three new options in the Monthly by Day or Yearly by Day pattern are used.

Thanks for your help.

re: Understanding the SharePoint calendar and how to export it to iCal format

Matt Swann — Thu, 17 May 2007 20:19:21 GMT

Jack,

I did a little research and found the answer for you. We ran into a problem during the development of WSSv3 where clients who parsed our recurrence XML would get tripped up by our new day/weekday/weekend day pattern data. To resolve this, we hide the recurrence XML for those patterns unless the client sets a flag in the queryOptions parameter of the SOAP request.

To get the actual recurrence XML pattern, send the following as the value for the queryOptions parameter:

As you've probably already discovered, passing <ViewFields /> to the viewFields parameter will return all the item's fields in the SOAP response.

Now, on to expanding recurrences via SOAP... I tried using the query string given in the OM example (wrapped in <Query></Query> like the web service expects) and didn't get any response. It looks like this is because the CalendarDate property needs to be set before the query is made, but there isn't any provision for that in the web service to date. I'll ask around, but it sounds like you'll have to parse the recurrences out by hand on the client.

re: Understanding the SharePoint calendar and how to export it to iCal format

Monica — Tue, 22 May 2007 23:45:14 GMT

We haven't yet installed the exporter solution, but I do have one question -- does this also allow a user to export one event to their calendar? We have folks using Entourage and iCal, and when they see an event listed on a calendar they want to be able to add it (seamlessly?) to their own calendars.

At first glance, your tool would appear to export the entire calendar to iCal, which isn't what they want to do -- they want to export only a few specific events. Any advice there? TIA!

re: Understanding the SharePoint calendar and how to export it to iCal format

Mughal — Mon, 04 Jun 2007 14:05:36 GMT

Thanks Matt for the nice and informative article. How can we achieve the same with WSS v 2.0?

re: Understanding the SharePoint calendar and how to export it to iCal format

Sergio Calleja — Tue, 12 Jun 2007 13:49:36 GMT

Hi,

I want to get all events from a list with recurrent events expanded, like in "Current Events" view. How can i do it?

Thanks in advance.

re: Understanding the SharePoint calendar and how to export it to iCal format

Trent Clayphan — Thu, 14 Jun 2007 02:26:42 GMT

My question is the same as Monica's, Is there anyway you can export single events from the export menu? or will it export the entire calendar and every listing?

Thanks for your time.

re: Understanding the SharePoint calendar and how to export it to iCal format

Stacey Bailey — Mon, 18 Jun 2007 23:23:49 GMT

Matt,

This was a great article and addresses the export to ical aspect quite thoroughly. I'm working with a group, though, that uses Zimbra as their email solution and is interested in parsing and viewing icals published there within SharePoint. Any insights into this opposite side of the equation--importing iCals into SharePoint?

Thanks.

re: Understanding the SharePoint calendar and how to export it to iCal format

andy — Wed, 27 Jun 2007 14:21:37 GMT

i am getting the Error on ical.aspx as:

Year, Month, and Day parameters describe an un-representable DateTime.

re: Understanding the SharePoint calendar and how to export it to iCal format

Jon — Mon, 02 Jul 2007 16:24:05 GMT

Any information on an iCal importer?

re: Understanding the SharePoint calendar and how to export it to iCal format

David S — Sat, 07 Jul 2007 07:56:27 GMT

Good article...but I have to say I'm baffled and disappointed that SharePoint's RSS feeds and/or web services (asmx) do not provide a sensible way to extract SharePoint's calendars with EXPANDED recurring events.

What I've been trying to do is simple:

- I'd like to pull data out of a SharePoint calendar (currently within an intranet) and use that data to publish a calendar of events in our extranet (not a SharePoint site).

- I have some limitations -- i.e. I can't make the SharePoint pages available to anonymous visitors (yet) and cannot install my own asmx files within the SharePoint site (yet) therefore the query.ExpandedRecurrence property isn't available in my situation. Such changes to our SharePoint site have to be approved by a series of administrators and what I'm attempting to do shouldn't be terribly difficult...but it is!

- Hence, bound to these limitations I have only a few options to extract calendar data from our SharePoint: an 'iCal'-type export as you've described, the calendar's RSS feed (which doesn't expand recurring events), or the asmx web services such as "Lists" and "Dspsts".

However, while it's obvious that SharePoint itself is able to calculate recurrence properly, the output from an iCal, rss-feed, and the web services is lacking. I'd think there should be a relatively simple way to request 'expanded' recurrences via the web services but, unfortunately for me, there isn't.

So, here's what I'm currently doing:

- I'm retreiving a calendar's data by SOAP request to Dspsts.asmx. (This provides a nice XML document...<Calendar_Row>s).

- And using the "Lists.asmx" GetListItems method as well (because the Dspsts.asmx query is missing the very important 'recurrence' data) and because there's no option to ask SharePoint to expand the recurring events. "GetListItems" outputs XML nodes which have the "ows_Recurrence" attribute...from which I:

- have to (a) correlate each XML node from GetListItems with the XML nodes from DspSts.asmx (which is WAAYY easier than parsing all the garbage in "GetListItems"; and (b) calculate the recurrences on my own!!

However, when calculating the recurrences on my own I:

- have to GUESS at what sort of model I might or might not encounter in the <recurrence> XML contained in the ows_Recurrence attribute. (This element doesn't appear to be documented anywhere!)

- then I have to further correlate items which have "Deleted: <event title here>" and then attempt to backpeddle the calculation of the recurrences -- or based on the peculiar combination of EventType, fRecurrence, fAllDayEvent GUESS again at whether or not my calculations will cause duplicate events.

All in all, MY COMPLAINT IS SIMPLY THIS:

- can you (the SharePoint team) PLEASE expose the "query.ExpandRecurrence" functionality somehow in the built-in asmx web services?

- OR, (and I think calendars are just complicated enough to warrant it), add a "Calendars.asmx" web services (which could behave similar to the "Lists.asmx" service) but with options and methods that would take into account the 'uniqueness' of calendaring. ("Lists.asmx" is a bulky way to syndicate calendar event information).

- OR, publish a complete reference for the "<recurrence>" node and it's various\possible sub-elements.

- OR, fix the "Actions" > "RSS Feed" feature for wss3.0 Calendars -- the fact that the RSS feed doesn't expand recurring events make a calendar's RSS feed completely USELESS wouldn't you agree?

NOTE: In two weeks while working to syndicate a simple calendar, and searching far and wide on the internet, THIS BLOG POST is the only page I've found which even touches on the <recurrence> and its relation to fRecurrence, fAllDayEvent, EventType elements. If there's more documentation somewhere/anywhere about these items, please post the links somewhere!

ALSO NOTE: What I'm attempting to do is not unlike the requests of dozens of others who have already commented in this post. It boggles my mind to think that, while trying to simply syndicate 'current events' from a SharePoint calendar, either I've missed something fundamental - or you have.

Is there a question in here anywhere? Yes:

- Have I missed something entirely? To get a collection of events from a SharePoint calendar (one which I don't have to manually calculate recurrence!) to display, say, as an RSS feed or to dump into a database table...is there no way to do this?

re: Understanding the SharePoint calendar and how to export it to iCal format

donal mcweeney — Mon, 09 Jul 2007 13:46:51 GMT

Hi,

Is it possible to get expansion of recurring events in the past using SPQuery. It appears to expand recurring dates from the current datetime forward but I cannot get it to expand recurring events in the past.

Thanks

Donal

re: Understanding the SharePoint calendar and how to export it to iCal format

Ruchi — Tue, 24 Jul 2007 14:39:49 GMT

hi,

I am facing same error as Andy. Any solution for that?

re: Understanding the SharePoint calendar and how to export it to iCal format

tronn — Thu, 26 Jul 2007 21:54:45 GMT

Any ideas on getting expansion of recurring events in the past using SPQuery?

re: Understanding the SharePoint calendar and how to export it to iCal format

Frederic LATOUR — Fri, 03 Aug 2007 18:46:00 GMT

Hi,

Thought this is an interesting article but I must admit that I just can't understand why MS can't do a decent job with recurring events within SharePoint?

With WSS V2:

No api for expanding recurring events.

Undocumented recurrence data schema (just a few samples in the sdk).

Incomplete documentation for CAML markup related to recurring events.

Starting with WSS V3, one would think that the recurring events "nightmare" would end. But hey :

Still undocumented recurence data schema though this article puts some light on it.

Undocumented api for expanding recurring events (just look at the Query.CalendarDate property for which there is not even a word of explanation in the sdk).

No implementation in the web services query interface.

Moreover the object model implementation seems rather limited (and useless as far as I am concerned) :

It looks like it is impossible to get past occurences of a recurring event.

It looks like you can only get occurences for 2 years starting from current date. From my test, there is no way to get anything else even though you would specify a 01/01/2011 as a value for "DateRangesOverlap".

CalendarDate property is rather mysterious as I can't see much change when setting a value or even not using it.

Considering that MS is obviously using some api (even if it's not written in managed code) for displaying the Event list current events view, I just can't understand why :

- this api is not completely interfaced within the SharePoint Object model.

- the recurence data schema is still not completely documented in a reference section.

Being now 4 years that people are struggling (or reinventing the wheel) with recurring events in SharePoint, a reasonnable approach would be that someone from MS publish a .net version of the inhouse used algorithm, even if it is unsupported. Codeplex?

Of course a better approach would be as someone suggested some kind of specialized class for querying events data.

Regards,

re: Understanding the SharePoint calendar and how to export it to iCal format

David S — Sun, 05 Aug 2007 23:57:35 GMT

Hello Frederic LATOUR,

Well said!!

re: Understanding the SharePoint calendar and how to export it to iCal format

Jason Y — Fri, 10 Aug 2007 00:38:24 GMT

I absolutely agree with Latour. I seriously wonder how many hours have been wasted by developers researching and redeveloping procedures that are either lacking or not documented.

re: Understanding the SharePoint calendar and how to export it to iCal format

Simmons — Tue, 14 Aug 2007 22:40:22 GMT

Is it possible, from a SharePoint user perspective (or otherwise) for a single event to be added (at the same time) to multiple SharePoint calendars? Alternatively, is it possible to "link" calendars so an event added to one automatically feeds into another, unless it is set not to link into that calendar? How, in either case, please?

re: Understanding the SharePoint calendar and how to export it to iCal format

Peter — Wed, 22 Aug 2007 12:38:00 GMT

I am trying to access all the items in Calender including recurrances irrespective of date range. I am not able to do it.Can u plzz give a solution.

Thanks in advance.

Peter

re: Understanding the SharePoint calendar and how to export it to iCal format

Edward M. Meshuris — Thu, 23 Aug 2007 00:43:25 GMT

Hi,

I have a list with start and end dates.

I create a calendar view based on those dates.

When I look at the calendar view, the item bar is always 1 day less.

I find this frustrating, since there is no 'alldayevent' function for this item.

-Edward

re: Understanding the SharePoint calendar and how to export it to iCal format

Ryan — Sat, 25 Aug 2007 15:58:53 GMT

Just puting in my 2 cents worth and adding my kick up the SharePoint teams backside!

Just look at some of these comments - you are driving your customers insane with this recurring event nightmare - please make it stop... please... ;)

Recurrence in Room and Equipment Reservations

Thilakka — Tue, 28 Aug 2007 11:35:37 GMT

Hi ,

I am trying to use the Room and Equipment Management System to book a meeting room(it is the resource here).

How do i book it for recurring dates..

I know that the template is to be modified supoorting recurring events.

Any other simple way

re: Understanding the SharePoint calendar and how to export it to iCal format

Ryan — Tue, 28 Aug 2007 17:33:49 GMT

Hi Matt,

I think your ical.aspx code contains a little bug in WriteTimeZones - although to be honest I have not tested this, its just from visual inspection.

You assume that daylight savings starts at the start of the year and ends at the end of the year.

It doesn't in the southern hemisphere!

2007 MOSS Resource Links (Microsoft Office SharePoint Server)

The Boiler Room - Mark Kruger, Microsoft SharePoint MVP — Wed, 12 Sep 2007 18:07:40 GMT

2007 MOSS Resource Links (Microsoft Office SharePoint Server) Here is an assortment of various 2007 Microsoft

re: Understanding the SharePoint calendar and how to export it to iCal format

Anonymous — Mon, 01 Oct 2007 22:34:24 GMT

Hi,

Now can i edit a single instance of the recurring event through code.

re: Understanding the SharePoint calendar and how to export it to iCal format

SharePoint Calendar Web Part — Sun, 28 Oct 2007 22:01:52 GMT

Great Blog.

I would like you to check kwizcom: SharePoint Calendar Web Part.

I try it and find out it is a great webpart.

re: Understanding the SharePoint calendar and how to export it to iCal format

Brian Bolton — Thu, 01 Nov 2007 23:21:40 GMT

Any easy way to expand recurring events for a query against the CrossListQueryCache?

I am doing a calendar rollup and would like to accurately represent recurring events.

re: Understanding the SharePoint calendar and how to export it to iCal format

Brian Bolton — Fri, 02 Nov 2007 23:12:51 GMT

This is the code I have so far but it's not expanding events. It is just giving me one instance of a recurring event. I'd like it to give me an instance of each recurring event.

CrossListQueryInfo crossListInfo = new CrossListQueryInfo();

crossListInfo.ViewFields = "<FieldRef Name=\"Title\" Nullable=\"True\" Type=\"Text\"/>" +

"<FieldRef Name=\"EventDate\" RefType=\"StartDate\" />" +

"<FieldRef Name=\"EndDate\" RefType=\"EndDate\" />" +

"<FieldRef Name=\"RecurrenceID\" />" +

"<FieldRef Name=\"FileRef\" />" +

"<FieldRef Name=\"RecurrenceData\" />" +

"<FieldRef Name=\"fRecurrence\" />";

crossListInfo.Query = "<Where><DateRangesOverlap><FieldRef Name=\"EventDate\" /><FieldRef Name=\"EndDate\" /><FieldRef Name=\"RecurrenceID\" /><Value Type=\"DateTime\"><Month /></Value></DateRangesOverlap></Where>";

crossListInfo.RowLimit = 100;

crossListInfo.Webs = "<Webs Scope=\"Recursive\" />";

crossListInfo.Lists = "<Lists ServerTemplate=\"106\">";

crossListInfo.WebUrl = "depts/deptname";

crossListInfo.UseCache = true;

SPSite querysite = new SPSite("http://server/sites/divsite/");

CrossListQueryCache xlqCache = new CrossListQueryCache(crossListInfo);

DataTable results = xlqCache.GetSiteData(querysite);

re: Understanding the SharePoint calendar and how to export it to iCal format

Justin — Sun, 18 Nov 2007 19:06:41 GMT

Is there a way to have sharepoint constantly exporting to iCal. As a mixed shop our intranet runs a sharepoint calendar, but the mac department would like it in iCal. Do an export everytime they change the calendar becomes a burden. Since iCal can do subscriptions, is there a way to link it to sharepoint?

Thanks

re: Understanding the SharePoint calendar and how to export it to iCal format

BC — Mon, 10 Dec 2007 21:47:34 GMT

Hello

Has anyone got this code to work as expected. I am trying to get all types of events ( single, allday, recurring events) for a date and it seems impossible to get it. The problem seems to be with the actual instances of the recurring events. I have not been able to get any code that would give the actual instances of the recurring events . I do get the Master Series recurring Event but the actual events seems to be impossible to get, Any one who has luck to get all events for a date please post the code . Thank you very much BC

MOSS 2007 - Content Query Web Part - Start Date 'is equal to' [Today] - fails for recurring events

RD — Tue, 08 Jan 2008 16:43:40 GMT

Great explanation of the Calendar parameters, I'm hoping you can explain how to get around the change in values when dealing with recurring events and content query web parts' filters.

If:

EventDate is "Start date and time" for single events,

and:

EventDate is "Start date and time set for the recurring event when it was created, which may be an earlier date than the first instance of the recurring event.",

how do you do a lookup and display for recurring events similarly to how one would lookup a single event, eg: Start Date 'is equal to' [today] ? Is there something you can do with the Duration parameter?

Thanks!

re: Understanding the SharePoint calendar and how to export it to iCal format

Qamar — Thu, 10 Jan 2008 12:55:24 GMT

RD - For Recurring events, the EventDate has two parts; the datepart is when the event was created, but the time part is start time of the event.

Together with using RecurrenceData, the Start time and Duration I should be able to construct all instances of recurring event (although I am not sure wherther timezone will play any part), but is there a simple Query (against CrossListQueryCache) that I can perform to get all recurring events within a given date range.

Alternatively, has anyone gone through the manual process of working out all recurring event instances?

re: Understanding the SharePoint calendar and how to export it to iCal format

dennis elsensohn — Fri, 11 Jan 2008 00:16:28 GMT

anyone ever get this work without this error? "Year, Month, and Day parameters describe an un-representable DateTime."

re: Understanding the SharePoint calendar and how to export it to iCal format

stefan demetz — Thu, 17 Jan 2008 14:36:34 GMT

Shame the is no conflict resolution in the sharepoint calendar

Synchronizing with Windows SharePoint Services, Part 1

Microsoft SharePoint Developer Documentation Team Blog — Tue, 22 Jan 2008 00:37:11 GMT

Introduction There may be occasions where you will need to synchronize third party programs with Windows

Synchronizing with Windows SharePoint Services, Part 1

Noticias externas — Tue, 22 Jan 2008 01:19:38 GMT

Introduction There may be occasions where you will need to synchronize third party programs with Windows

Modifying SharePoint calendar to compress or eliminate weekends

John Wells — Tue, 05 Feb 2008 01:39:27 GMT

I have been trying to find someone who can tell me how to eliminate or compress the weekend columns in the sharepoint calendar. No luck, though I did find an option to start on monday.

Do you know how or can you direct me to some information on this topic? thanks

re: Understanding the SharePoint calendar and how to export it to iCal format

Tired — Tue, 05 Feb 2008 17:57:05 GMT

Hi, this post is very helpfull, but howto update item from calendarItems collection without "Expanded recurrence items can not be updated." exception?

Thanks

re: Understanding the SharePoint calendar and how to export it to iCal format

Paul Perry — Thu, 07 Feb 2008 13:07:26 GMT

On the topic of recurring events not showing in some views, after taking a look, I find that the moment you edit an instance of an item, it actually becomes an item, and thus appears in my custom 30 day list as well as current events.

Is there a way to simply change the value that is changed upon clicking "Edit Item" whenever I create a recurring series so that I can see all items in a series?

Is the field that is changed the itemType as per the table at the top of this page?

Thanks!

Regarding recurring event

Murali — Wed, 05 Mar 2008 17:46:02 GMT

Hi Guys,

I tried to create a recurrence event using WSS Webservices.I used RecurrenceDate tag to set the recurrence pattern.Here is how the my Recurrence data looks.

<rule>

</repeat>

</rule>

</recurrence>

But WSS3.0 Calender is not able to recognize thi event.When i click edit item and click ok.It says recurrence exception of the old event will be lost.Why is this problem coming.Can any one send me the format of the RecurrenceDate Field i need to pass and other things which i need to take care.

This event is getting listed in All Events though.

re: Understanding the SharePoint calendar and how to export it to iCal format

Stephen Sheaf — Mon, 10 Mar 2008 04:04:35 GMT

Great stuff, why does MS not have this as a standard feature?

I had not trouble installing, but in my case it skips "Deleted" events, rather important when there is money involved!

It would also be very useful if it 1) expanded recurring events and 2) accepted filters for a date period (eg one month)

re: Understanding the SharePoint calendar and how to export it to iCal format

SteveSchaff — Wed, 19 Mar 2008 05:41:50 GMT

Has anyone been able to interact with MOSS using UpdateListItems? I have

been using it as my applications primary means to interact with MOSS. I can

retrieve and modify any calendar item using UpdateList items sending cmds in

batch xml format and it works fine (its not easy but it does work). I'm

stuck on writing modifications to recurring events. I.E. deleted or

otherwise modified individual or recurring items within a recurring event.

I have found several great articles such as: How to add recurring items:

http://msdn2.microsoft.com/en-us/library/ms434156.aspx and this one;

but these articles don't talk about writing events to the sharepoint event

list. Thus far I've gotten by but supporting recurring event individual

ocurrence changes has been frustrating. I can write the deleted instance of

the recurring event to the event list but its not associated to the

masterItem. And not coincidentally it isn't displayed in the sharepoint

calendar view, it does show up in the all events display. From this post I've found to associate the deleted instance you must set the

MasterSeriesItemID with the itemID of the parent recurring event and the

RecurrenceID with the originalDate/Time of the modified occurrence. Also

I've found but it's not documented anywhere imperical evidence looking at the underlying db table for list data that the UID

field must match the parent items UID field (I did this by viewing what's

done in the MOSS UI when modified to what happens when I do from my

application)

But even after all of this I can't display in the calendar view list items

that are recurring with deleted or otherwise modified individual ocurrences,

Does anyone know what I'm missing?

re: Understanding the SharePoint calendar and how to export it to iCal format

SteveSchaff — Thu, 20 Mar 2008 02:45:01 GMT

All I can help with recurring events as long as they do not include modified or deleted instances. The biggest problem I ran into is that all day recurring events need to be in ztime. I've also found in your recurrence xml string you can't use double quotes, this is because it gets embedded in the batch cmd in the xml as an html encoded field. My recurring events work great. Feel free to send me questions though.

re: Understanding the SharePoint calendar and how to export it to iCal format

SteveSchaff — Thu, 20 Mar 2008 17:01:25 GMT

All - I finally figured out modifications to recuring item instances! So I thought I would share it - when you submit a NEW recurring item or an update to a recurring item you get back a new ows_UID save this cuz you have to send any modifications or deletions using that UID...

re: Understanding the SharePoint calendar and how to export it to iCal format

Steve Peterson (steve@mcmillaninc.com) — Wed, 02 Apr 2008 18:28:58 GMT

I ran through the installation and was able to install and deploy the solution. I rebooted the server but, I still dont see the ICAl in the site features.

What am I doing wrong?

Thanks,

Steve

re: Understanding the SharePoint calendar and how to export it to iCal format

Steve Peterson (steve@mcmillaninc.com) — Thu, 03 Apr 2008 17:37:33 GMT

Never mind... I was being dumb.

I was looking at site features, not site collection features.

I logged in as an admin and the site collection features were then available.

Steve

re: Understanding the SharePoint calendar and how to export it to iCal format

Karl H — Wed, 23 Apr 2008 00:04:11 GMT

The information is great, but...

I'm having problems expanding a recurring all-day event. If anyone can point me to some info, that would be great.

Thanks.

karl

re: Understanding the SharePoint calendar and how to export it to iCal format

Roojo — Wed, 30 Apr 2008 16:46:27 GMT

How do I go about creating a calendar which only returns events and recurrence entries within a specific time frame?

I'm only ever able to test against the EventDate and I don't understand how to reference the dates generated for recurrence entries.

Using WSSv3 and SPD2007

re: Understanding the SharePoint calendar and how to export it to iCal format

SteveSchaff — Thu, 08 May 2008 05:08:59 GMT

Karl,

This post is the best info I can think of for breaking out the recurring all-day event which part is giving you trouble?

re: Understanding the SharePoint calendar and how to export it to iCal format

Joan — Wed, 04 Jun 2008 11:07:29 GMT

Hi,

I tried to use this SPquery:

-----

"<Where><DateRangesOverlap><FieldRef Name=\"EventDate\" /><FieldRef Name=\"EndDate\" /><FieldRef Name=\"RecurrenceID\" /><Value Type=\"DateTime\"><Month /></Value></DateRangesOverlap></Where><OrderBy><FieldRef Name=\"Title\" /></OrderBy>"

-----

,but it returns all the recurrences in the actual month view.

Then, If we are at 2 June, the query returns the recurrences from 26 May to 6 July.

How could I see the recurrences from today to 30 days ??

Thanks.

re: Understanding the SharePoint calendar and how to export it to iCal format

Àlex — Thu, 19 Jun 2008 17:56:28 GMT

Hi Joan,

You could make 2 CAML queries, pass the result to a DataTable, set the PK for each DataTable and finally marge the 2 DataTables.

Then you can select only the events in the next 30 days.

Salut,

Àlex.

re: Understanding the SharePoint calendar and how to export it to iCal format

Eddy — Tue, 24 Jun 2008 23:45:28 GMT

Hi Joan,

You can set the CalendarDate property of the SPQuery to today's date.

re: Understanding the SharePoint calendar and how to export it to iCal format

aeltawil — Wed, 25 Jun 2008 18:27:04 GMT

Is there a way to generate/create the <recurrence> xml? I am looking for a recurrence XML string generator. I have been researching the interweb for a long time with no luck. Plz email me: mistertall2004@yahoo.com

re: How to modify a calendar view type?

Sruli — Thu, 03 Jul 2008 17:00:08 GMT

I'm trying to work with calendar views but missing some basic info:

1. If I have a SPView calendar object, how can I tell its type (month/week/day)?

2. How can I modify the type, e.g. from week to day?

Thanks in advance

re: Understanding the SharePoint calendar and how to export it to iCal format

Sruli — Thu, 03 Jul 2008 17:57:55 GMT

I wonder how I can handle a calender view given in a SPView object:

1. How can I tell the calendar type (month/week/day)?

2. How can I change the calendar type, e.g., from month to week?

Thanks in advance

re: Understanding the SharePoint calendar and how to export it to iCal format

John — Fri, 04 Jul 2008 18:35:31 GMT

I need to add a link on Event Detail page to open the iCal format event directly by using webcal:// protocal. The link would be like "Add to iCal calendar". Could anyone tell me how to implement it? Thanks in advance!

re: Understanding the SharePoint calendar and how to export it to iCal format

Sruli — Tue, 08 Jul 2008 12:21:00 GMT

I have problem with calendar view. Hope you can help.

I have a SPView object of Calendar type.

How can I change it's default type programatically, e.g., from Month to Week or Day calendar?

The calendar type is located in SPView.schemaXML member, but this is a readonly property. How can I change it?

Thanks in advance

Sruli

re: Understanding the SharePoint calendar and how to export it to iCal format

Rex — Fri, 25 Jul 2008 11:29:20 GMT

Thank you for the post!

I wonder where can I find the schema of XML in RecurrenceData field.

It will be helpful if someone gives me an example with full element of the XML.

Links 2009-04-06

Gunnar Peipman's ASP.NET blog — Mon, 06 Apr 2009 22:58:36 GMT

SharePoint Customizing SharePoint Context Menus Hidden SharePoint Lists, Fields, and other Advanced List

web tasarım

web tasarım — Mon, 03 Aug 2009 13:57:50 GMT

miracle mhttp://www.parcakontorbayiniz.com