Home | Blogs | rmaclean's blog

SharePoint Holiday Loader

Mon, 02/21/2011 - 12:33 |  Robert MacLean
March 19, 2012: This tool has had a major make over since the original release!

logo

I’m sure, as a SharePoint power user, you’ve had the fun of your boss walking up to you and asking why the public holidays aren’t in your SharePoint calendar? (guess what happened to me last week)

You would think this would be easy, in fact Outlook supports adding holidays to calendars easily. So why isn’t SharePoint easy like that too?

I’ve had this asked a few times and never had a good answer to do it, so I decided that a simple tool needed to be built to solve this once and for all – Let me introduce SharePoint Holiday Loader (SHL).

SHL takes a standard holiday file (.hol) and allows you to publish that to a SharePoint list!

Clipboard01

This tool is very easy to use (just need the file, the server and the calendar name) and it is free and open source. You can get the download the tool, source code, leave comments (or complaints) at: https://bitbucket.org/rmaclean/sharepoint-holiday-loader/

Tags: .NET, Development, SharePoint, Tools & Apps
Visitor's picture

I tried it on Sharepoint Services 3.0 - doesn't work.
The calendar field definitions are different it seems.
Here's the error output (no copy past is possible..grrr):

error inserting to SharePoint. Message: one of more field types are not installed properly.
code: 0x81020014

it wants to insert IT, Title, Location, fAllDayEvent, EventDate, EndDate, Category.

In WSS 3.0 on the default calendar I got:
Title Single line of text
Location Single line of text
Start Time Date and Time
End Time Date and Time
Description Multiple lines of text
Created By Person or Group
Modified By Person or Group

So this cannot work. Any chance you can adopt it to work with WSS 3.0 too?

Submitted by Visitor on Thu, 09/22/2011 - 14:19.
Twitter Trackbacks for SharePoint Holiday Loader | SADev [s's picture

[...] SharePoint Holiday Loader | SADev sadev.co.za/content/sharepoint-holiday-loader – view page – cached I’m sure, as a SharePoint power user, you’ve had the fun of your boss walking up to you and asking why the public holidays aren’t in your SharePoint calendar? (guess what happened to me last week) You would think this would be easy, in fact Outlook supports adding holidays to calendars easily. So why isn’t SharePoint easy like that too? I’ve had this asked a few times and never had a... Read moreI’m sure, as a SharePoint power user, you’ve had the fun of your boss walking up to you and asking why the public holidays aren’t in your SharePoint calendar? (guess what happened to me last week) You would think this would be easy, in fact Outlook supports adding holidays to calendars easily. So why isn’t SharePoint easy like that too? I’ve had this asked a few times and never had a good answer to do it, so I decided that a simple tool needed to be built to solve this once and for all – Let me introduce SharePoint Holiday Loader (SHL). SHL takes a standard holiday file (.hol) and allows you to publish that to a SharePoint list! This tool is very easy to use (just need the file, the server and the calendar name) and it is free and open source. You can get the download the tool, source code, leave comments (or complaints) at: http://shl.codeplex.com, SharePoint Holiday Loader View page Tags [...]

Submitted by Twitter Trackbacks for SharePoint Holiday Loader | SADev [s on Mon, 02/21/2011 - 13:56.
louise's picture

Simple idea, and brilliant execution. thanks rob :)

Submitted by louise on Mon, 02/21/2011 - 13:36.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • Syntax highlight code surrounded by the <pre class="brush: lang">...</pre> tags, where lang is one of the following language brushes: as3, applescript, bash, csharp, coldfusion, cpp, css, delphi, diff, erlang, groovy, jscript, java, javafx, perl, php, plain, powershell, python, ruby, sass, scala, sql, vb, xml.

More information about formatting options

Twitter
Loading my tweets...
Contact Me | RSS Feed | Back to top


© SADev.co.za, SADev and the content here is copyright 2001-2012 Robert MacLean unless otherwise stated. Content reuse license: Creative Commons Attribution 2.5 South Africa License. Disclose Policy: Disclosure. Disclaimer: The views expressed here reflect the views of the authors alone, and do not necessarily reflect the views of any of their organizations, my customers and clients, employers, sponsors, or contributors. In particular, the views expressed here do not necessarily reflect those of the BBD (my employer) or Microsoft. All information and downloads are available without warranty and any use of such information or downloads is at your own risk. Use common sense. If you don't like what is written then do not read it.