Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
Importing recurring data into calendar list - columns not exposed

已答复 Importing recurring data into calendar list - columns not exposed

  • Wednesday, September 02, 2009 1:05 PM
     
     
    Sign In to Vote
    0

    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?

     

All Replies

  • Saturday, September 05, 2009 5:02 PM
     
     Answered
    Sign In to Vote
    0
    I 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.
    Best regards,

    Riwut Libinuko
    SharePoint Architect, Singapore
    Microsoft MVP | SharePoint Server | Singapore
    Blog : http://blog.libinuko.com
     
  • Friday, September 11, 2009 1:34 PM
     
     Proposed
    Sign In to Vote
    0
    You 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.

    --Heeren Pandya
    Heeren Pandya
    • Proposed As Answer by Heeren Pandya Monday, September 14, 2009 9:29 AM
    •  
     
  • Monday, September 14, 2009 11:56 AM
     
     
    Sign In to Vote
    0
    Yes, 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
     
     
    Sign In to Vote
    0

    Hello everyone,

    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 @ christina.kogut@cargill.com

    Regards

    Christina


    • Edited by TinkaKogut Monday, April 09, 2012 8:04 PM
    •