Anyone Home @ Google Calendar?

by Elijah Nicolas on Monday, August 10, 2009

I’ve been getting into a rhythm on importing my schedule into Google Calendar over the last couple of months. Once it’s available in final format from my company I’m usually able to upload my custom made, Google tailored-CSV file so that my family and friends are aware of my “awesome” overnights. But during the last few weeks, I’ve been unsuccessful at too many attempts.

Sorry, Calendar is unavailable right now

Sorry, Calendar is unavailable right now

Trying to import a CSV file so that I wouldn’t have to manually add each line item one at a time, I found myself editing it over and over thinking it was my fault that I didn’t format it correctly. I even copied the example that Google provides with their respective headers (Google Help:About CSV Files), added it to the first line of my CSV file and crossed my fingers. Result –> #FAIL

After two weeks of failure on what I can only determine is / was on Google’s Part, I was able to successfully import my CSV file only when it contained 4 lines under the header. This idea was originally put forth by another fellow Google Calendar user by the name of “Ripp” where he was able to successfully import his CSV file 8 lines at a time. My CSV file was, without a doubt, formatted correctly as I’ve been doing this for the last few months. If you are wondering what calendar I am importing into, you can access it located immediately to the right under “Personality Links – current flight schedule”

Over the last few months, many users of Google Calendar who rely on importing their own CSV files have complained in Google’s support forums specifically under “calendar not loading“. Many have seen constant outages on various Sundays throughout the year and others have seen that the process of uploading a CSV or CalDEV file remains hopeless. User “Coach McGurk” posted an issue back on April 30th with the suspicion that Google abandoned the Calendar application and even diagnosed the service issue.

I have managed to find some more info on what is failing.

The service at: http://www.google.com/calendar/upload_event is what has broken. Neither CalDAV nor csv will upload regardless of browser, location, http vs https, or calendar being uploaded to.

Of course, just a couple of days later, the service was up and running once again.

It’s hard when you come to depend on a company like Google for your simple “cloud” services if the cloud is raining constantly. I’ve been using gcal and gmail for the last couple of years, but just lately, the syncing, lack of push on the iPhone and proper IMAP configuration, as well the shortfall of what MobileMe has not become, I just don’t know what to do anymore. It’s more than frustrating that I have to spend more than 1-2 hours a week troubleshooting this. Why can’t we just have something that works properly? It’s 2009 guys.

Facebook comments:

  • Adam Cole

    I’ve just been tearing my hair out because of the same problem, which is how I found this post. Only, in my case, I had just successfully imported another CSV to a different calendar, so I was suspicious that the server should have gone “down” in the space of a few seconds. I retried the file that had worked before, and it worked again. The server was obviously still OK.

    After hours of wrangling with various formatting problems and testing smaller chunks of the data, I found that any .csv file containing the ampersand (&) character in the Subject field caused the “Sorry, Calendar is unavailable…” error. My data contained many items of the form “Cindy – dinner & movie, 09/2/09, 8:00:00 PM” When I replaced all the &’s with ‘and’, the import went right thru.

    There may be other characters that cause this behavior too; I can’t say. The & sign is certainly unfortunate, since it’s pretty natural to use it in this context.

    It is possible that the server is in fact unavailable for long periods, but my experience shows that this error message can be misleading. If you’re reading this and having similar issues, try removing ALL special characters from your import data and stick to letters, numbers, and comma delimiters ONLY.

  • http://www.elijahnicolas.com Elijah Nicolas

    The only character that I have is a hyphen “-” in between the cities that I fly to my code [e.g. DL 4995,8/18/09,8:05,8/18/09,9:58,1:53,DAY-ATL] Like I have mentioned though before, I have been able to successfully import this kind of data string for up to 50 lines, but it was just recently where it would only take 4-6 lines. I have yet to try it again for the following month of September, but I will update this post then. I’m crossing my fingers for a successful first try.

Previous post:

Next post: