Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

SharePoint Lesson #38: Create an ICS (iCal) file for Outlook Calendar

How to create an ICS (iCal) File from a SharePoint list and save it as an event in your personal Outlook Calendar.
by

Peter Heffner

on 31 March 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of SharePoint Lesson #38: Create an ICS (iCal) file for Outlook Calendar

ICS ICAL
Save SharePoint calendar events to your personal Outlook Calendar!
1.
Quick and dirty
3.
Sophisticated
2.
Not bad at all!
http://
<SITE-URL>
/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List={
<LIST-GUID>
}&CacheControl=1&ID=
<ITEM-ID>
&Using=event.ics
It is very technical, I know...
Here is what we do:
The file "owssvr.dll" creates an ICS-file.
A calculated field in the SharePoint Calendar
will generate an ICS-file.
This would be syntax:
where
<SITE-URL>
: The address to the site where your calendar lives
<LIST-GUID>
: The GUID of your Calendar List
<ITEM-ID>
: The ID of the specific event in the calendar
Go, get the parameters first...
<SITE-URL>
Copy the URL of the site
<LIST-GUID>
http://bit.ly/1hruKlK
Please refer to this tutorial how to
find the GUID of your calendar list
It should look like: {8914FF22-2031-45EF-8DD4-671F489F9538}
<ITEM-ID>
The ITEM-ID is passed over as the ID of the event.
3 examples how to create an ICS-file
Create a Calculated Field [ICS]
="http://
<SITE-URL>
/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List=
{
<LIST-ID>
}
&CacheControl=1&ID="&ID&"&Using=event.ics"
="http://
<SITE-URL>
/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List=
%7B
<LIST-ID>
%7D
&CacheControl=1&ID="&ID&"&Using=event.ics"
The string for the calculated field should read like above.
However, regional settings can return an error when using
{
and
}
.
In that case replace
{
with
%7B
and replace
}
with
%7D
.
Create a Calculated Field [URL]
=CONCATENATE("<DIV><a href=' "
;
"
<SITE-URL>
/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List=
{
<LIST-ID>
}
&CacheControl=1&ID="&ID&"&Using=event.ics "
;
"'>"
;
Title
;
"</a></DIV>")
=CONCATENATE("<DIV><a href=' "
;
"
<SITE-URL>
/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List=
%7B
<LIST-ID>
%7D
&CacheControl=1&ID="&ID&"&Using=event.ics "
;
"'>"
;
Title
;
"</a></DIV>")
The string for the calculated field should read like above.
However, regional settings can return an error when using
{
and
}
.
Replace
{
with
%7B
and replace
}
with
%7D
.
The same is for semicolon
;
and comma
,
. If one doesn't work, try the other.
Create a Calculated Field [Date]
="<DIV><a href=' "&
ICS
&" '><img src= <SITE-URL>/Images1/Date.png border='0'></DIV>"
As we created the link for the field [
ICS
] already in step 1, we don't need to add the code again.
Here we use an icon with a link to create the ICS-File.
Assuming the icon would live here:
<SITE-URL>/Images1/Date.png
the formula would read like:
The result
The Result:
Clicking on this link will create an ICS-file and you have the option to open or save it.
By default we will see the HTML-code.
We need to convert this text into HTML.
This is done by a Javascript written by Christophe@pathtosharepoint.com

1. Goto http://goo.gl/IV7S1
2. Download the Script
3. Upload the script to a Document Library
The result
By default we will see the HTML-code.
We need to convert this text into HTML.
This is done by a Javascript written by Christophe@pathtosharepoint.com

1. Goto http://goo.gl/IV7S1
The Script
Add a Content Editor Webpart (CEWP)
below
your calendar list.
Make it "hidden" so it will not appear in your published page.
CEWP Settings
Add the link to the Script in the CEWP.
Done
The hidden script converts the code into HTML.
Either we see a Text-Link or an icon-Link.
2. Download the Script
3. Upload the script to a Document Library
http://www.peterheffner.de/SPTuT.htm
Please find here an overview of all available Presentations:
References:
Christophe@pathtosharepoint.com ; text2html Javascript
MSDN; using the URL protocol
http://goo.gl/IV7S1
http://bit.ly/1hocevp
Full transcript