Automatically import ical file in Google Calendar

Hello.  

I'm using a piece of software called ThinkingRock.  It's a Java application for managing GTD methodology.  The software will export to an ical format file which can be imported into my Google Calendar.  

I have done this successfully manually, but wondered if there might be a way to do this automatically.

Now - which category does this fit neatly into ....... hmmmmm???  I'm open to suggestions on where this might better be posted.

TIA
LVL 1
ttist25Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

scrathcyboyCommented:
See these to auto sync them --

gcaldaemon.sourceforge.net/usage13.html
gcaldaemon.sourceforge.net/usage16.html
www.timegnosis.com/content.php?importing
0
ttist25Author Commented:
Thanks scratch.  I've downloaded and installed it and tried to wing the setup.  I got a bunch of errors when when I ran the sync bat.  

The last few lines have the following:
ERROR | Unable to load calendar!
java.lang.exception: Invalid iCal file: http://www.google.com/calendar/ical/example%40gmail.com/private- and then a bunch of gibberish I'm assuming is an encrypted login or something then /basic.ics

THen it says "synchronization finished" but (not surprisingly)  the Google calendar is not updated.

Have you personally used the combination of GCALDaemon and ThinkingRock (v2) together?  

Thanks again for your response.
0
scrathcyboyCommented:
No I haven't sorry, but from what I have heard, many have got it to work.  It looks like the problem is simply in your systems ability / inability to upload with the java applet -- all of this uploading happens with Java applets.    I think just updating the JAVA install on your machine will solve this, that is my best guess.  It is not easy to find where to get these new JAVA versions -- basically SUN makes them, and I do know they come with a download of the free open office package -- www.openoffice.org -- you can also get them from www.sun.com -- kinda hard to find, but they are there.  It won't just to update JAVA, set a restore point before you do if you are uncertain.  THen try it again.  Maybe Thinking rock has the latest Java update, I don't know, you could check the version against what google requires.

It simply might not be possible to automate this.  Most of these apps require a point and click mentality, and google is as bad as the rest, they assume everything is done by point and click, and automate nothing.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

ttist25Author Commented:
I managed to get Google Calendar to pull from a file on my hosted shared web server.  I think if I could use some sort of FTP daemon that would upload the iCal file every 10 minutes or so I'd bee happy.

Have any ideas how I could do that - maybe even with a batch file?
0
scrathcyboyCommented:
sure, use task scheduler, which is in the OS, hard to find, but there.  Schedule a task to run every 10 mins, which would involve loading a program PLUS a profile, telling it what to load, as an example

WSFTP -"google"

you will have to find an FTP program that will take a command line argument, like -"google" and this profile will provide the login and password to the site, and the file to upload.  Finding the right program may be the challenge.  You could try windows explorer with something like this --

cmd explorer.exe "ftp://profiles/google.com -login=joe -pw=test -file=update.file

Those are just made up parameters, but it will give you an idea of what is involved.  Good luck.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ttist25Author Commented:
Here's what I ended up doing:

I'm using WebSynchronizer (open source from sourceforge.net) to upload my .ics file to my FTP server.  WebSynchronizer has a built in scheduler and I've got it set to upload every 10 minutes.

In Google calendar I added a new calendar using "Add --> Add by URL" and typed in the URL to the .ics file.  Seems to be working well thus far.  

Although I'm just overwriting the remote file right now, WebSynchronizer has the ability to synchronize remote to local as well as local to remote.  I might try tht later.  I might also try using FireDaemon to run WebSynchronizer as a service.  

Thanks for the help!
0
scrathcyboyCommented:
excellent solution !!   It will help lots of people in the future, these questions go into a database that can be searched by others down the line.  WEbSynchronizer sounds like a great program.  Good luck.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.