Skip to main content

An Outlook/Google Calendar Revolution

That screenshot from my iPhone to the left is not a simple view of my calendar with multiple colors. Oh no. No, what you are seeing is, in no uncertain terms, a complete revolution. That's right: a revolution.

Here's the problem that is being so elegantly solved with that innocent image. The most popular way to see calendar data in multiple applications is the popular iCal standard; iCal essentially works like an RSS feed for calendar data. Why is this interesting? Say you want to see your favorite sports team's schedule: just subscribe to their iCal feed, for example. In my case, I wanted to get my travel plans from the superb TripIt site into my Outlook and iPhone, so I'd have the details without having to have online access. Seems easy, right? Sure, but one thing: Outlook 2003 does not handle iCal feeds. I know, you're saying "Outlook 2003? Um, that's almost 6 years old, and why the heck are you using Outlook for e-mail still?" Valid question. Answers:
  1. Outlook 2007, which is the latest version, does indeed handle iCal feeds, but does not pull the data into your calendar. Instead, it creates separate calendar folders. Not bad, but not great.
  2. I still use Outlook, as I run off of Exchange at work, and I need to sync with Salesforce, Plaxo, and more. There is not a desktop client that does this. And web suites, like Google, do not run offline without some seriously kludgy solutions. Plus, I love Outlook's integration with Word, which offers real-time inline autocorrect for spelling.
  3. Many of the things I need to sync my data with, such as Salesforce, have had serious limitations in syncing with Outlook 2007; Outlook 2003 is still the "gold standard."
So, how to get an iCal feed into Outlook 2003? Well, I tried using RemoteCalendars, which worked beautifully, but the sheer bulk of it and it's unstable nature caused Outlook to eventually freeze and crash, repeatedly. Another option was to try to move exclusively to Google, who's Google Calendar uses iCal feeds perfectly, but then so long to Exchange: not an option. Eventually, I came across the idea of setting up a Google Calendar that would pull my iCal feeds down, and then syncing the Google Calendar with Outlook 2003. Google themselves make such a utility...but of course it does not sync with iCal calendars. Sigh. I resigned to be defeated.

And then I found OggSync. A utility with the specific goal of syncing Google Calendar with Outlook 2003. Could it be? Oh yes, it could be. A quick, lightweight install later, and I was set. So, I created a new Google Calendar, and created a new corresponding Outlook calendar, hooked it up to my TripIt iCal feed, and a trembling press of the Sync button...voila. Thanks to the elegance of Exchange, and it's iPhone integration, you see the color-coded joy that is my ideal.

Now, there are some downsides. First, the free version of OggSync will only sync 3 days in advance, and there is no automatic sync, so I have to remember to sync. And I had to do some jiggering to get my Exchange calendar in red and the TripIt calendar in blue (instead of orange), but a solution nonetheless. The paid version of OggSync claims to support both automatic sync, and unlimited days in advance, but the price is a bit steep for those minor improvements.

In truth, I could explore Outlook 2007 a bit more and hope for the best, but this ultimately gives me the ability to have multiple iCalendars in Outlook 2003, and for free. Good enough for me.




Comments

Popular posts from this blog

Loyalty Review: Kohl's Yes2You

 As some of you know, I've spent over 15 years in the customer loyalty space. So, when I come across a new retail loyalty program, I can't help but see the pluses and minuses. After this many years, it's kind of ingrained. Periodically, I'll share my thoughts with you. Today, it's Kohl's turn under the scope. Let's have a look, shall we? I've divided the review up into three sections: what's good about the program, what's bad about the program, and what I'd change about it. That last one has some actual value: I charged hundreds of dollars per hour for loyalty program consulting, and had over a dozen clients, before I moved to JustAnswer FT. But, being a pandemic and all, I'm giving it away for free here. Kohl's, you're welcome. Here we go! The Good Sign up is opt in Seems odd to praise Kohl's for this, but in department store loyalty, this is a rarity, and a smart one. It means the customers who are opted in are already prime...

Revisiting Star Trek: The Next Generation: Season 1

I recently started rewatching Star Trek: The Next Generation from the beginning. I have nothing but fond memories of the original run in the 1980s, given how excited I was for a new Trek series in my lifetime (I had only reruns and the movies to stoke my Trek interest), and it recently occurred to me that, while I diligently consumed every TNG episode, I had not experienced the series since it's original run.  Why did I do this? Well, a few reasons: With the triumphant return of Sir Patrick Stewart to the smaller screen as the venerable Jean Luc Picard , I thought it would be interesting to contrast this version with the previous, and see how far he has come. It would add color to the character, as well as Sir Patrick. Frankly, with the COVID19 lockdown, the series I have binged upon have been intense, dark, and disturbing. Combined with the activity of the world, including insane politics, homicidal police who seem to view people of color as "prey," rather than their ch...

The Icarus Effect

This morning's news started with the latest grim proof of overdevelopment in a tough sector: SkyBus Airlines shut down , less than year from when it started. Never heard of Skybus? Not surprising; they chose to focus on trips from Ohio to the West Coast for ridiculously low fares. Yes, you read that right: the airlines' unique niche was that they focused on trips from Ohio . Was air travel such an amazingly profitable business that we needed that much segmentation and focus? Of course not. A year ago, when Skybus was just getting off the ground (har har), fuel costs were at an all time high. United was still in bankruptcy; Delta, a fellow airline with a major hub in Ohio, was just exiting Chapter 11. And yet, "irrational exuberance" led investors like Nationwide Mutual Capital, Huntington Capital Investment Co., and Battelle Services Co. to ignore the obvious signs of risk, and dive into what was a dubious investment. Today, they, and the passengers who were lured by ...