for some reason the outgoing ical feeds are not supported by google calendar? I can sucessfully import google ical feeds into the drupal calendar but it doesn't work the other way round (google can add the ical feed as a calendar and even picks up the correct calendar name from the feed but it doesn't display any events)

currently my outgoing ical feed looks like this

BEGIN:VCALENDAR
VERSION:2.0
METHOD:PUBLISH
X-WR-CALNAME:AV Resource
PRODID:-//strange bird labs//Drupal iCal API//EN
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070516T000000Z
DTEND;VALUE=DATE-TIME:20070516T000000Z
UID:http://host.brightonhosting.co.uk/~avresour/?q=node/4
URL;VALUE=URI:http://host.brightonhosting.co.uk/~avresour/?q=node/4
SUMMARY:Test Event 3
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070518T000000Z
DTEND;VALUE=DATE-TIME:20070518T000000Z
UID:http://host.brightonhosting.co.uk/~avresour/?q=node/5
URL;VALUE=URI:http://host.brightonhosting.co.uk/~avresour/?q=node/5
SUMMARY:Test Event 4
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070522T000000Z
DTEND;VALUE=DATE-TIME:20070522T000000Z
UID:http://host.brightonhosting.co.uk/~avresour/?q=node/6
URL;VALUE=URI:http://host.brightonhosting.co.uk/~avresour/?q=node/6
SUMMARY:Test5
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070525T000000Z
DTEND;VALUE=DATE-TIME:20070525T000000Z
UID:http://host.brightonhosting.co.uk/~avresour/?q=node/8
URL;VALUE=URI:http://host.brightonhosting.co.uk/~avresour/?q=node/8
SUMMARY:test notification
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070525T000000Z
DTEND;VALUE=DATE-TIME:20070525T000000Z
UID:http://host.brightonhosting.co.uk/~avresour/?q=node/9
URL;VALUE=URI:http://host.brightonhosting.co.uk/~avresour/?q=node/9
SUMMARY:test again
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070527T000000Z
DTEND;VALUE=DATE-TIME:20070527T000000Z
UID:http://host.brightonhosting.co.uk/~avresour/?q=node/10
URL;VALUE=URI:http://host.brightonhosting.co.uk/~avresour/?q=node/10
SUMMARY:test subscriptions
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070729T230000Z
DTEND;VALUE=DATE-TIME:20070806T230000Z
UID:el55abhpn94et7l6r1i60qpn9s@google.com
URL;VALUE=URI:el55abhpn94et7l6r1i60qpn9s@google.com
SUMMARY:Schnews BGG Solar PA Projector
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070601T230000Z
DTEND;VALUE=DATE-TIME:20070602T230000Z
UID:cms9r7kou0larh931cg80v37uc@google.com
URL;VALUE=URI:cms9r7kou0larh931cg80v37uc@google.com
SUMMARY:Schnews Solar PA Screen Projector
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070510T230000Z
DTEND;VALUE=DATE-TIME:20070513T230000Z
UID:jtcohgut56g7hf7b6ntdvtaqk4@google.com
URL;VALUE=URI:jtcohgut56g7hf7b6ntdvtaqk4@google.com
SUMMARY:Schnews PA Projector Screen
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070412T230000Z
DTEND;VALUE=DATE-TIME:20070413T230000Z
UID:9dlcqcmph3ct256prbviliirtg@google.com
URL;VALUE=URI:9dlcqcmph3ct256prbviliirtg@google.com
SUMMARY:pa hired by little dave
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070721T230000Z
DTEND;VALUE=DATE-TIME:20070722T230000Z
UID:b0rtscja8q0f73u3nvrs6fsdog@google.com
URL;VALUE=URI:b0rtscja8q0f73u3nvrs6fsdog@google.com
SUMMARY:Solar Cinema - Peace Festival Hove
END:VEVENT
BEGIN:VEVENT
DTSTAMP;VALUE=DATE:20070514T132623Z
DTSTART;VALUE=DATE-TIME:20070228T000000Z
DTEND;VALUE=DATE-TIME:20070301T000000Z
UID:teodsehqb03hcit318s2q4d078@google.com
URL;VALUE=URI:teodsehqb03hcit318s2q4d078@google.com
SUMMARY:Video Projector\\\, Screen.
DESCRIPTION:Test booking by tom
END:VEVENT
END:VCALENDAR

the calendar can be seen at http://host.brightonhosting.co.uk/~avresour/?q=calendar if anyone can help i'd be really pleased!

Comments

alandd’s picture

Priority: Normal » Critical

I have the same problem. The title of the calendar shows up but none of the events display on the Google calendar.

I changed Priority to critical. This is an important function to our use of the Drupal Calendar.

alandd’s picture

I have opened a bug report with Google for the Drupal ical feed events not showing the Google calendar. I hope that brings some action from somewhere.

One of the reasons we chose Drupal as a CMS is to do ical feeds to other groups and interested parties. Many said parties use Google calendar. With this bug effecting things, we are seriously hampered from doing something we need. Are there any other calendar modules around that do feeds?

peterdeitz’s picture

Same problem here -- please help.

KarenS’s picture

I'm not sure but I'll bet that Google is not handling 'VALUE=DATE-TIME'. The ical spec says both 'VALUE=DATE' and 'VALUE=DATE-TIME' are valid, but as I do more research it looks like most places are using 'VALUE=DATE', so I'm guessing that switch the code to use that instead might fix the problem. I'm doing a rewrite of the ical handling (see http://drupal.org/node/156418 and other issues) and once that's done we'll see if it fixes this problem.

alandd’s picture

Thank you, KarenS, for looking into this issue. I'd be willing to try any test code or help in some other way.

KarenS’s picture

If you want to test my theory, create two files, one with the code you have above and one where you change everything that says 'VALUE=DATE-TIME' to 'VALUE=DATE'. Give them both names that end in '.ics', like old.ics and new.ics and put them on your web server.

Then try to get them into Google calendar by linking to the files you created and see if there is any difference between the way they behave.

I'll can't work on this immediately, so if you're in a hurry you can test that out and if it works, I can just make the necessary change to the code.

teach42’s picture

Tried that and it didn't work for me.

Just a bit more info, I was able to import via URL, but it didn't create any events, it just added a new empty calendar to Google.

When I tried to import the iCal file (with value=date-time OR value=date) it says "Processed zero events"

alandd’s picture

Some weeks ago I hacked the module/events/ical.inc file to do the switch from "VALUE=DATE-TIME..." to "VALUE=DATE..." as KarenS suggested. The produced ICal file had the change so I thought I did the change correctly. After waiting to check for a few days, this did not change the results. Still no events in Google Calendar. I just left my hack in place anyway.

Two days ago I follow-up emailed Google about my previous bug report to see if they had done anything. This is the response I got back:

Thank you for your reply. The calendar you provided in the previous email
doesn't contain "VALUE=DATE-TIME," instead it contains only "VALUE=DATE."
As such, it appears that Google Calendar is reading the date information
and isn't able to read the time information for your calendar. While
"VALUE=DATE" is valid, without time information, the event information
won't appear. If you're able to change the occurrences of this line to
"VALUE=DATE-TIME," you should be able to subscribe to your calendar
correctly. We appreciate your taking the time to update us on the status
of this issue.

Regards,
The Google Team

So, I copied my backup of ical.inc into place, deleted the calendar from my Google Calendar, added it back into Google calendar and.... no events still. But I'll not declare it a failure for a couple of days to be sure Google has refreshed the feed.

KarenS’s picture

That doesn't make sense, the current calendar DOES use DATE-TIME for the event dates (not for the timestamps, but I doubt they're using the timestamps anyway). I don't know what you sent them, but if you sent them what you posted at the top of this page, that answer makes no sense and solves nothing. According to that, the current code should be working.

alandd’s picture

An additional communication from Google today.

Thank you for your response.  We appreciate the additional information you've provides on this issue. We were able to successfully import your calendar by changing all instances of "VALUE=DATE" to "VALUE=DATE-TIME." This includes the "DTSTAMP" lines. Please check to see if this change allows you to successfully subscribe to your calendar. 

We appreciate your assistance as we work to resolve this issue.

Regards,
The Google Team

The calendar feed I provided to them is http://plug.phoenix.az.us/event/ical

I have not tried nor proven this yet. When I do, I'll update things here.

Thanks for working on this, KarenS!

alandd’s picture

I had success last night!

I edited the modules/event/ical.inc file. I replaced all instances of "VALUE=DATE" with "VALUE=DATE-TIME". A couple of hours later my personal Google Calendar was displaying the events from the feed.

Caution: I did not do a code analysis or any other checking if the above described change breaks something. The correct way to fix the issue may involve something more sophisticated. Until a fix from someone who understands the code comes along, be careful with my above suggestion.

I'm going to do some other checking of the results but I think this is the right direction. What do you think, KarenS?

KarenS’s picture

Status: Active » Fixed

This is a very simple change and should not break anything else. I'm puzzled why it didn't work the other way since it was already valid according to the standards, but it won't hurt anything to do it this way.

I'm in the process of rewriting the Date and Calendar modules (the ical script is in the Date API) and I'll get that change in the new version. It's a simple enough change I can put it in the current version, too, so I just committed it.

Thanks for all the help getting this figured out!

Anonymous’s picture

Status: Fixed » Closed (fixed)
interfaced’s picture

I think the ical file should have some header information like google's does:

BEGIN:VCALENDAR
PRODID:-//Google Inc//Google Calendar 70.9054//EN
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Canadian Holidays
X-WR-TIMEZONE:America/Los_Angeles
X-WR-CALDESC:2005 Calendar]

BEGIN:VTIMEZONE
TZID:America/Los_Angeles
X-LIC-LOCATION:America/Los_Angeles

BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:19700308T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT

BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:19701101T020000
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD

END:VTIMEZONE

mbria’s picture

Hi all,

I'm playing with last calendar/date releases and I didn't see any events in google calendar.
May be it's because I still need to wait until tomorrow....

Could anybody confirm the issue is fixed?

The funny part it's that I remember it working a year or so ago.

Thanks a lot in advance, specially Karen for the great development,

m.

batigolix’s picture

I replaced all instances of "VALUE=DATE" with "VALUE=DATE-TIME" in mydwupalsite/sites/all/modules/event/ical.inc

and now the events show up correctly in google calendar

TyraelTLK’s picture

Version: 5.x-1.x-dev » 6.x-2.0-rc6
Status: Closed (fixed) » Active

Hi,
I have reactivated this bug because I can import a .ics file downloaded from my drupal site into google calendar but I can't add the same feed with the "add url" option in google calendar.

KarenS’s picture

Version: 6.x-2.0-rc6 » 5.x-1.x-dev

The 5.1 version and the 6.1 version are totally and completely different. No issue for 5.1 can have any applicability to 6.2. If you have a problem in 6.2, create a new issue.

anarcat’s picture

Status: Active » Fixed

So this was fixed in 5.x, I'm closing the issue.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

karthick62’s picture

I could not get this text file through the ical feed .. Is there any particular settings need to be done during i cal feed. could some one help me on this???