Thursday, August 29, 2013

vanderTrick: Google calendar and vcs import

Annoyed that you cannot import .vcs calendar files (like United Airlines') into Google calendar.  Me too.  Found a very simple trick.
Open the .vcs file in Notepad and change  "End" to "END" (so, all caps) and save as .ics.  Then import it again.
Voila.

27 comments:

BBMoto said...

WORKS! THANKS.
1. Change all "End" to "END"
2. Change all =D0 to \n (optional for proper line feed)

Anonymous said...

OMG, thank you so much for this. I was so annoyed and couldn't find the problem. ~Ben

Anonymous said...

Thank you! Just successfully imported my United reservation!

Anonymous said...

Thanks so much!
1. Change all "End" to "END"
2. Change all =0D to \n (optional for proper line feed) - there were no =D0 on my United itinerary.

Anonymous said...

thanks

Arnoldus said...

Did not work for me.
The next did:
Sure you can. It's not obvious, unfortunately.
0) In the left navigation, in the Other Calendars box, click Add, then select Import Calendar
1) Choose File (note that it says it does CSV and ICS, but it will do VCS as well.
2) Pick the calendar you decide to import to
3) Import

Doug Fir said...

awesomely helpful, but I also found there were no =D0 on my United itinerary, but that =0D did the job.

1. Change all "End" to "END"
2. Change all =0D to \n (optional for proper line feed)

And then you follow these steps...

0) In the left navigation, in the Other Calendars box, click Add, then select Import Calendar
1) Choose File (note that it says it does CSV and ICS, but it will do VCS as well.
2) Pick the calendar you decide to import to
3) Import

gbo said...

Didn't work for me, and I also tried the vcs to ics converter on sourceforge, which indeed converted correctly the events dates and time but not their title nor description (they were all blank).
I then re-exported my calendar on Android using ICS calendar exporter and it worked beautifully. Better use a third-app than Google's own functionalities...

Anonymous said...

no luck, either ics or vcs got this:

Processed zero events.

Failed to import events: Unable to process your iCal/CSV file..

Gary S. said...

Awesome. Sir, you win the Internet.

Anonymous said...

Only change I needed was to change "End" to "END" on a flight schedule from united Airlines.

Anonymous said...

Great, that helped big times!

Anonymous said...

Thanks! Needed that for United! I only had to change "End" to "END" and left extension as .vcs it imported great!

Anonymous said...

thank you!

Michael Leslie Miller said...

Brilliant--thanks!!

Michael Leslie Miller said...

Brilliant--thanks!!

Anonymous said...

It took me a while to do it, but it definitely worked. I am using Windows 7 Ultimate Operating system so I didn't have the option to save it as .ics...however, I chose the "All Files" option when saving. Also, for anyone who is having the same user/dummy response I had to not understanding the "End" to "END" reference...notice that one is all caps and the other is not. Also, you have to change all of the referenced "End"s to "END" or it won't work. There is an "End" at the end of every paragraph (leg of trip).

Hope I made this clean as mud!

Thanks for the insightful recommendations.

ANIRAHUL said...

In my case iam unable to convert it. My file all END are allready in Capital.
Now what shall i do?

Anonymous said...

Worked like a charm - thanks.

buckeyecal said...

did not work for me.

Aziz Poonawalla said...

hello all - i can confirm that the "End" to "END" does work - but there will be mroe than one End. You need to make sure *all* occurrences of "End" are changed to "END". You dont even need to change the file extension.

If you already tried changing one End to END and it still doesnt work, you probably missed one or mroe Ends. Go back and recheck. Its there.

Cheap Flight said...

Lovely Post! I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
This is really very helpful to book united airlines cheap tickets. Thank you

Anonymous said...

This was helpful. Thank you!

Pro Tip: Ctrl + H > Find What: End > Replace with: END > check box in "Match case" > click "Replace All"

Rob Sample said...

I know this is an old post, but I thought I'd weigh in. I changed all "End" to "END" and it imported 4 individual calendars, with my time zone on all entries, not the local times. Not helpful on either count.

I'm assuming that some of the other tweaks fix some of these issues, and while this may be an OK process for coders and others, frankly, I can just enter the information manually into the calendar in less time than this process.

While I applaud your ingenuity, it's not helpful at all to me.

The big disconnect is both at United and Google: United for not offering multiple formats like some do, and Google for not taking the very popular .vcs file!

Anonymous said...

thanks! worked forme

Anonymous said...

Thank you !!! Thank you !!!
I did as per original post:
1. Change all "End" to "END"

Worked for me!

Awesome!

RMHudspeth said...

You also might need to modify the Date/Time from the vcs format:
(example)
DTSTART;VALUE=DATE:20170809T133200
DTEND;VALUE=DATE:20170119T214800

to ics format:
(example)
DTSTART:20170809T133200
DTEND:20170119T214800

If there is no T and subsequent value, then it is imported as an all-day event

I also put:
METHOD:PUBLISH

right before the first:
EGIN:VEVENT