THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a freelance data mangler in London

Get the SQLBits agenda on your phone

The agenda for the forthcoming SQLBits 8 conference in Brighton is currently available at http://sqlbits.com/information/Agenda.aspx. Unfortunately, useful though it quite clearly is, its only a web page and that means its hard to get the agenda data out and onto something more useful. Like your phone’s calendar.

I have tried to rectify that problem by providing all of the sessions in a subscribable calendar that can be viewed, as a web page, at http://cid-550f681dad532637.calendar.live.com/calendar/SQLBits/index.html. That calendar provides a mechanism that makes it easy to get it onto your phone; as well as publishing the data as a web page it also publishes it as an iCalendar feed (which you can think of as an RSS feed for calendar data). That iCalendar feed can be consumed in two ways:


Here’s how to view the calendar on various clients:

Outlook

Hit the webcal link above from your Windows machine and (if you have it installed) it should open up in Outlook and allow you to subscribe to the calendar. Subscribing is better than importing because if I update the calendar for any reason those changes will automatically propagate into Outlook.

iPhone

iPhone understands the webcal protocol too so hit the webcal link above on your iPhone and you should be subscribed to the calendar.

Windows Phone 7

Windows Phone 7 doesn’t understand webcal and also doesn’t allow you to view calendars from anything other than the accounts registered on your phone. Furthermore, whilst Windows Phone 7 can sync multiple accounts it can only sync the *primary* calendar from each of those accounts. Hence you will need to hit the http link above from your desktop machine, save the .ics file, then import it into the primary calendar of an account that you have synced to your phone (e.g. Hotmail Calendar, Google Calendar, Exchange, etc...). The sessions should then show up on your phone next time it syncs. Note the distinct disadvantage that importing has compared to subscribing on iPhone & in Outlook – any changes I make to the calendar will not propagate to your phone.
Windows Phone changed in the 7.5 release to allow multiple calendars per account to be synced to your phone. Hence head to http://calendar.live.com, login with the same Windows Live ID that your phone is registered with, and subscribe to the webcal link above.

Android and Blackberry

I don’t know the best steps for getting it onto Android or Blackberry devices so perhaps someone could let me know. I’m sure the same technique as used for Windows Phone 7 will work though.

UPDATE: Phil Nolan has replied answering the question about Android. See his comment below.


Hope this is useful.

@Jamiet 

 

P.S. I am a huge advocate of iCalendar and, if you’re at all interested, my thoughts on it are perfectly articulated in this article by Dilbert creator Scott Adams: Calendar as Filter.

Published Monday, April 04, 2011 12:15 AM by jamiet
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

phil nolan said:

for android, easiest way would be to sync with google calendar which will then sync down to the phone.

http://www.google.com/support/calendar/bin/answer.py?answer=37118

great work Jamie :)

April 4, 2011 11:22 AM
 

SSIS Junkie : Get the SQLBits agenda on your phone said:

April 4, 2011 11:29 AM
 

SSIS Junkie said:

For SQLBits 8 in April 2011 I published a calendar containing all of the sessions from the conference

January 18, 2012 6:55 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement