SharePoint DIY

Main navigation

  • ← Creating a Custom Permission level
  • Assigning Custom Permission Levels →

Import Outlook Calendar into SharePoint

Posted on Feb 17, 2009 by admin

  1. Create a calendar list on your WSS site.
  2. Export your Outlook Calendar into a Excel file format with the following column:
    - Subject
    - Location
    - Start Date
    - Start Time
    - End Date
    - End Time
    - All Day event
  3. Go to the Calendar list and switch to All Event View
  4. Export this empty view to Spread and open it.
  5. Open your exported Outlook Calendar, merge Start Day and Start Time to a fingle column
  6. Merge End Date and End Time to another single column. Both of these two column should have two sapces between date and time and YY as year, not 4 digits.
  7. Copy Subject from exported to Title column of the Calendar list. The rest are straight forward. Do not put naythng to WorkSpace column since it’s read-only.
  8. Correct any errors if you have. Then sync this list.

 

Category: Articles, Tutorials

top ^

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Recent Posts

  • Create a nicer looking hyperlink instead of the full URL using simple HTML
  • “The template you have chosen is invalid or cannot be found” – Solution
  • Making the “Encoded absolute URL” work with a list in SharePoint
  • Export a SharePoint site as a Site Template (.stp file)
  • Upload and use a site template (.stp) in SharePoint

Recent Comments

  • RYAN on Add a new subsite using SharePoint Designer
  • JAMES on “The template you have chosen is invalid or cannot be found” – Solution
  • SEAN on The paste text dialog box
  • Webmaster on Security settings for a subsite
  • morison dony on Export a SharePoint site as a Site Template (.stp file)

Archives

  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009

Categories

  • Articles
  • Featured
  • Tutorials

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Go Metal Detecting!

Check it out: The Best Metal Detector Store @ Serious Metal Detecting


  • Adventure Metal Detectors
  • Treasure Metal Detectors
  • Gold Metal Detectors

Minelab E-TRAC for sale at Serious Detecting

Tags

HTML MOSS Outlook SharePoint Designer Workflow WSS

Categories

  • Articles
  • Featured
  • Tutorials

Search

SharePoint DIY | Copyright SharePoint DIY