none
Add Holiday Calendar to SharePoint

    Question

  • I'd like to add Holidays to our SharePoint calendar. We are using MOSS 2007 and Outlook 2003. I can't seem to figure out how to import an outlook calender with holidays to SharePoint calendars or how to impost and Excel holiday calendar to SharePoint. I think my best bet is Excel. If you know how to import a holiday calender to SharePoint via Excel, will you provide me step-by-step instructions?
    mercredi 14 octobre 2009 13:31

Réponses

  • Hi.

    Export your calendar from Outlook using these steps:

    1. File -> Import and Export
    2. Select "Export to a file", Next.
    3. Select "Tab separated values (Windows)", Next
    4. Select your Calendar, Next
    5. Select y export file name and folder, Next
    6. Select Finish
    7. Click Ok in the Set Date Range" dialog.

     Import the file into a new list using these steps:

    1. Site actions -> Create
    2. In the "Custom Lists" section, select "Import Spreadsheet"
    3. Enter a name and description for your list
    4. Browse to your exported text file.
    5. Click Import

     Excel will start up with a Import dialog.

    1. In the import dialog, select "Range of cells"
    2. Click in the "Select range" text box.
    3. Select the Subject to End Time columns and drag down to all rows you want to import.
      (So it will result in something like MyExportedCalendar!$A$1:$E$46 , I had 45 + header rows)
    4. Click Import.

    The data is now imported in to a list.

    1. Select View and -> Create View.
    2. Select "Calendar View"
    3. Enter a name for the View, for example My Calendar View
    4. In the Time Interval section, select Begin -> Start Date and End -> End Date
    5. In the Calendar Columns, select Month View Title -> Subject, Week View Title -> Subject and Day View Title -> Subject
    6. Click Ok.

    You now have a Calendar view your imported items.

    Hope this helps.

    Regards,
    Magnus


    My blog: http://InsomniacGeek.com
    • Marqué comme réponse mswanson19 mercredi 14 octobre 2009 15:32
    mercredi 14 octobre 2009 14:24

Toutes les réponses

  • Hi.

    Export your calendar from Outlook using these steps:

    1. File -> Import and Export
    2. Select "Export to a file", Next.
    3. Select "Tab separated values (Windows)", Next
    4. Select your Calendar, Next
    5. Select y export file name and folder, Next
    6. Select Finish
    7. Click Ok in the Set Date Range" dialog.

     Import the file into a new list using these steps:

    1. Site actions -> Create
    2. In the "Custom Lists" section, select "Import Spreadsheet"
    3. Enter a name and description for your list
    4. Browse to your exported text file.
    5. Click Import

     Excel will start up with a Import dialog.

    1. In the import dialog, select "Range of cells"
    2. Click in the "Select range" text box.
    3. Select the Subject to End Time columns and drag down to all rows you want to import.
      (So it will result in something like MyExportedCalendar!$A$1:$E$46 , I had 45 + header rows)
    4. Click Import.

    The data is now imported in to a list.

    1. Select View and -> Create View.
    2. Select "Calendar View"
    3. Enter a name for the View, for example My Calendar View
    4. In the Time Interval section, select Begin -> Start Date and End -> End Date
    5. In the Calendar Columns, select Month View Title -> Subject, Week View Title -> Subject and Day View Title -> Subject
    6. Click Ok.

    You now have a Calendar view your imported items.

    Hope this helps.

    Regards,
    Magnus


    My blog: http://InsomniacGeek.com
    • Marqué comme réponse mswanson19 mercredi 14 octobre 2009 15:32
    mercredi 14 octobre 2009 14:24
  • This is EXACTLY what I needed. Thanks!
    mercredi 14 octobre 2009 15:32
  • This is also exactly what we needed.

    Thanks.

    mercredi 27 juin 2012 12:27