Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Convert Outlook calendars into iCal calendars Apps
If you're like me, you like sports, but because their are so many games, you need a schedule. Well, this is just great but when it comes to iCal's calendar format, hardly anyone uses it (Apple's iCal Library page lists all of two sports teams).

So, I decided to code an AppleScript importer, which basically takes a Microsoft Outlook calendar and creates an iCal calendar file from it. Now, the importer was coded to work with what seemed to be an Excel formatted file (.cvs), but when it was downloaded, Safari appended a .txt to its name. Here's the downloadable schedule, in Microsoft Outlook format, that I used to develop the converter: Sixers schedule.

The importer may work with other formats, but I doubt it. Since I don't have Microsoft Outlook, I don't know if other formats are available. If there are, let me know by linking/emailing me the other-format calendar, so I can add proper support for it.

The first step is, of course, to download the application (27KB), unzip it, and store it somewhere. After that, to use the converter, just do this:
  1. Download a schedule in the proper format.
  2. Drag-and-drop the schedule/s onto the application, or double-click the application and choose a single schedule to process.
  3. When prompted, type in the name for the calendar to use within iCal -- Sixers 2004-2005, for instance.
Any questions or comments, email or reply to this hint. I'll be sure to follow-up.

[robg adds: This script worked well for me, and the source is viewable/modifiable (just use File: Open from within Script Editor) if you want to see what it does. The biggest challenge may be finding free Outlook calendars to use! In a brief search with Google, I found a site that has schedules available for sale, at not completely cheap prices ($1.99 for one team's NBA schedule?). I had better luck searching for a specific team's schedule with something like Trailblazers outlook schedule download. If you know of any good, free, Outlook calendar compilation sites, please post them in the comments.]
    •    
  • Currently 2.38 / 5
  You rated: 4 / 5 (8 votes cast)
 
[51,886 views]  

Convert Outlook calendars into iCal calendars | 14 comments | Create New Account
Click here to return to the 'Convert Outlook calendars into iCal calendars' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Convert Outlook calendars into iCal calendars
Authored by: MightyB on Nov 17, '05 06:59:27AM

I use iCalShare to find great calendars availabe for iCal.


http://icalshare.com/



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: cougar718 on Nov 17, '05 09:55:48AM

Great, now you can go import some official schedules, and post them to iCalShare as iCal calendars :P

---
Rick alias cougar



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: pairof9s on Nov 17, '05 06:34:13PM

Actually, I think that's his point. You don't need to use this hint if you're looking for sports calendars for iCal. iCalShare has a plethora of sports schedules for all types of sports, teams, and levels that you can subscribe to.



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: cougar718 on Nov 17, '05 07:14:44PM

Okay. This hint was not geared towards finding sport schedules but to announce/share an importer that I created which takes schedules exported by Microsoft Outlook using comma-separated values format. iCalShare did not have the schedule for my team. So, I created the importer.

I have already received many emails sharing their thoughts and reasons for using this importer and all of them are the reason why I created it in the first place. That being, if they, they being an association, club, website, etc. offer a schedule, it's not going to be in iCal format. And so far, some of those who have emailed me are members of some sort of group and the group offers a calendar with 100s of entries and the calendar is not able to imported by iCal which they prefer to use.

---
Rick alias cougar



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: bkemper on Nov 19, '05 12:28:04PM
That being, if they, they being an association, club, website, etc. offer a schedule, it's not going to be in iCal format.
Why not? iCal uses the open iCalendar format, which Mozilla also uses. There is no reason not to use that format. I believe Outlook will even import it.

[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: strachan on Nov 17, '05 10:12:04AM

I only checked NBA basketball, so YMMV in other sports, team schedules can be downloaded from the official team NBA website in .csv (comma separated values) format. The file is not compressed.



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: osxpounder on Nov 17, '05 12:34:03PM

That's great! I wonder if anyone here knows of a converter that will convert GroupWise calendars [or even just single GroupWise emailed appointments] to iCal and back? My company uses GroupWise, for which there is no decent Mac client, and I'm stubbornly sticking with iCal because its features are so much more useful to me than GroupWise's.

---
--
osxpounder



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: Peter Kraniak on Nov 17, '05 09:20:23PM

This is great!! I've been dying to get the Pistons schedule into my Palm 650. The only problem is that I tried it and it didn't work. Do you mind seeing if I did something wrong?

http://www.nba.com/pistons/schedule/download_200506.html

kraniak@gmail.com



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: cougar718 on Nov 17, '05 11:15:28PM

Everyone: Please do not download or try to use the importer until I have further developed it. Reason being with the cvs format OutLook uses, there is no standard for the order of the fields. For example, where in 1 file the 3rd item is the starting date, in another file it may be the description. So as I just found out, my importer will quit when it encounters bad data.

I will try to further develop my importer so it can adapt and get it to Rob as soon as possible so he can host the new version.

Sorry for the inconvenience.

---
Rick alias cougar



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: cougar718 on Nov 18, '05 09:19:22AM

Everyone: Please continue to download the importer. The new version is up and now should work regardless of the order of the fields.

If you have any problems with the importer, please contact me via email.

Again, sorry for the inconvenience.

---
Rick alias cougar



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: jhave on Nov 18, '05 01:40:56PM

This is fantastic news, Rick. At work we will be moving from GroupWise to Outlook soon, and I am looking forward to exporting my Outlook calendars to my iBook !

---
Viva X



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: eddyer on Jan 06, '06 05:41:49AM

My company provides an Outlook export option from our web calendars, but it comes to me in an XML snippet of text (ok a big chunk) in an email. How should I format it in either text wrangler or BBEdit to do this? The first version of the tool errored out, and the second version simply quits after I name the iCalendar...

---
keep on keepin on



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: jfort on Mar 05, '07 08:05:40AM

I tried this program with the Indians 07 schedule. I runs and imports into iCal, but only the month of March is imported. The file has the entire schedule. How can I get the whole thing into iCal?



[ Reply to This | # ]
Convert Outlook calendars into iCal calendars
Authored by: netshare on Jan 04, '10 10:55:09AM

hello there,

could anybody provide the source code to the script from cougar. we would have to use this script on an older mac with OSX 10.5 installed but the script provided by cougar is compiled and cannot be be used with OSX 10.5. If this code is not freely available, a pre-compiled script which runs on OSX 10.5 as well as on OSX 10.6 would do the trick too.

Any help is greatly appreciated.

Best regards,

netshare

Edited on Jan 04, '10 10:55:46AM by netshare



[ Reply to This | # ]