Wednesday, September 02, 2009 1:05 PM
We have a team calendar that an end user will update periodically by copying/pasting data from a spreadsheet that is sourced from an external system (haven't gotten to the point of automated integration yet) into a datasheet view. It works fine, but they are now wanting to import data that uses the recurring feature. If you click Recurrence in the UI, it exposes several additional fields where you can select attributes of the recurring entry (day of the week, duration, etc.). Those fields are not available as columns in a view. So I have no idea how to import them from a spreasheet as a recurring entry. Any advice?
Saturday, September 05, 2009 5:02 PMI think you need to go with custom code. Or may be a temporary list with event receiver.
The event receiver is the one which will update the calendar, so you don't update directly calendar using spreadsheet.
SharePoint Architect, Singapore
Microsoft MVP | SharePoint Server | Singapore
Blog : http://blog.libinuko.com
- Marked As Answer by Lambert Qin [秦磊]MVP Wednesday, September 09, 2009 3:14 AM
Friday, September 11, 2009 1:34 PMYou can write a web service which will read data from the Excel sheets and then based on that data writes it back to the SharePoint Calendar. You cna make use of SharePoint list APIs or web services for this functionality.
- Proposed As Answer by Heeren Pandya Monday, September 14, 2009 9:29 AM
Monday, September 14, 2009 11:56 AMYes, I figured this was the case. But I think there's more to it than just standard MOSS object coding, like we've all done. I think there are some oddities about creating recurring entries. Have you actually done this yourself? If so, please provide greater detail.
Monday, April 09, 2012 8:04 PM
If anyone has a step by step guide on how to do this effectively, I would love to see it! I am struggling with being able to import an excel data into a sharepoint calendar on the same premise, each activity has reoccurances, and they all vary.. 1 week, 4 weeks etc etc. There are about 900 different activities and having to manually enter them all will be a pain. There must be a smarter way of achieving this?
If you can assist please email me with guide @ email@example.com
- Edited by TinkaKogut Monday, April 09, 2012 8:04 PM