Home :: Forums :: Support :: How-To

Google calendar integration

By lady_teacher - Posted on March 8th, 2009
Tagged:  

Hi again,

Ok so I am trying to integrate milestones with google calendar by clicking on "Add By URL" under "Other Calendars" and I get "We could not parse the calendar at the url requested.".

From what I read from other post I must have my google calendar subscribe to my URL...

Anyone who has done that knows how it's done?

Thank you,

Anna

‹ Transfer to a new server Where are the files to upload? ›
Anyone
Submitted by lady_teacher on Wed, 03/11/2009 - 17:50.

Anyone guys?

I am sorry for insisting on this feature, its just the kind of feature we wanted for our project management system.

Please if anyone managed to integrate google's calendar with projectpier, please tell me how it was done. I would appreciate it very very much :-)

Thank you,

Anna

Touchy subject
Submitted by lady_teacher on Tue, 03/17/2009 - 07:49.

Ok seems like noone wants to touch the google calendar integration issue thingy. Even in google forums you cant find an answer for that specific error :-s.

Oh well what to do

Calendar Issue, please log it in the issue tracker
Submitted by Jon on Tue, 03/17/2009 - 23:32.

In order for software issues to be addressed by the development team they need to be logged into the issue tracker with as much information as possible. What are the exact symptoms, what steps are taken to reproduce the problem, etc. The issue tracker is located at http://www.projectpier.org/project/issues

Once it's logged in the issue tracker I hope someone from the user community with the appropriate level of technical expertise will take responsibility for identifying a fix and provide a patch. Patches are then reviewed by the developers and tested before they can become part of the next version.

Thanks for taking part in the ProjectPier community!

-Jon

Thanks Jon will do :-)
Submitted by lady_teacher on Wed, 03/18/2009 - 10:51.

Thanks Jon will do :-)

Validator
Submitted by soxos on Sun, 04/12/2009 - 21:45.

Hello,
I am trying also to get it working with Google Calendar.
There is a iCal validator here : http://severinghaus.org/projects/icv/
And Project Pier seems to output a well formed ical format so it may be a Google Calendar bug !
Cheers.
Stef.

Any success?
Submitted by berenb on Fri, 01/08/2010 - 22:07.

Hey there, any news on the subject? It doesn't work for me either :(
The calendar can be added to sunbird so I guess it's some issue with the formatting for google?
Any help appreciated, thanks :)

I would like to know as
Submitted by rhand on Wed, 02/24/2010 - 07:35.

I would like to know as well. I also would like to see a possibility to show milestones spread across several days so you see how long milestones last. Now, when I import a calender I only see the milestone on the end date..

My Two cents...
Submitted by Purple_tentacle on Sun, 05/02/2010 - 22:55.

Hi folks,

I just discovered this program and I must say I love it.

The Ical idea was nice so I also tried to sync it with google calendar, using the URL, with no luck. So I exported it in a .ics file, then uploaded it into Google calendar, no luck either.

Then I looked into the code and noticed some differences between Google's ics and PP's.

Here's my modification. Open application/controllers/FeedController.class.php.
Look for "$event->setPropertyValue('DTSTART', $date->format('Ymd')".

Replace:
$event->setPropertyValue('DTSTART', $date->format('Ymd'), array('VALUE' => 'DATE'));
$date->advance(24 * 60 * 60);
$event->setPropertyValue('DTEND', $date->format('Ymd'), array('VALUE' => 'DATE'));
$event->setPropertyValue('UID', $milestone->getId());

with:

$event->setPropertyValue('DTSTART', $date->format('Ymd') . 'T070000Z');
$event->setPropertyValue('DTEND', $date->format('Ymd') . 'T090000Z');
$event->setPropertyValue('UID', 'a9idfv00fd99q344o' . rand() . 'cgef733m6bs@google.com');

And you're set. I'm not much of a hacker, so there are some flaws in my mod: I use a random google-like id, this was apparently the problem when importing into google (PP gives a one number ID)
Every milestone goes from 07am to 09am. I'll enhance this later, I just prefer to see my milestones on the main google calendar planning.

Hope this will work for you!

Cheers,

Purple

works with file or URL?
Submitted by mato on Tue, 02/01/2011 - 16:54.

I do not understand: it work downloading the iCal file from PP and then uloading in Google Calendar with this work-around or it work synchronized with the URL?

How have you sync whit URL? For me is very could be very useful ...

Thank's
Marco

Read before speak!!
Submitted by mato on Thu, 02/03/2011 - 08:33.

Yes, if I do not read the previus posts is normal that I do not understand!!!

It is not needed to download the ical file; simply copy the ical adress (right click on the icon or the link from PP, then copy adress)
From google calendar, just do: "Add" (last line of the left sidebar), then "add via url", then paste your url. This should work (it can take some time to update, up to one hour)

I have placed the code in application/controllers/FeedController.class.php as Purple suggestion (but I have only changed the line with your "random google-like id" and the subscription works both on google calendar and thunderbird, because I prefer to have a look of my calendars in thunderbird anyway)

Thak's to Purple for his mod!!!

Great
Submitted by phpfreak on Thu, 02/03/2011 - 17:13.

Thanks Purple for the mod and mato for testing.

I will test the mod tonight 0.8.6 and if it works add it to PP.

Please test it
Submitted by mato on Wed, 02/23/2011 - 16:30.

Patch in http://www.projectpier.org/node/2242 need test
Thank's
Marco