Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
alandd CreditAttribution: alandd commentedI 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.
Comment #2
alandd CreditAttribution: alandd commentedI 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?
Comment #3
peterdeitz CreditAttribution: peterdeitz commentedSame problem here -- please help.
Comment #4
KarenS CreditAttribution: KarenS commentedI'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.
Comment #5
alandd CreditAttribution: alandd commentedThank you, KarenS, for looking into this issue. I'd be willing to try any test code or help in some other way.
Comment #6
KarenS CreditAttribution: KarenS commentedIf 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.
Comment #7
teach42 CreditAttribution: teach42 commentedTried 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"
Comment #8
alandd CreditAttribution: alandd commentedSome 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:
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.
Comment #9
KarenS CreditAttribution: KarenS commentedThat 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.
Comment #10
alandd CreditAttribution: alandd commentedAn additional communication from Google today.
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!
Comment #11
alandd CreditAttribution: alandd commentedI 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?
Comment #12
KarenS CreditAttribution: KarenS commentedThis 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!
Comment #13
(not verified) CreditAttribution: commentedComment #14
interfaced CreditAttribution: interfaced commentedI 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
Comment #15
mbria CreditAttribution: mbria commentedHi 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.
Comment #16
batigolixI 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
Comment #17
TyraelTLK CreditAttribution: TyraelTLK commentedHi,
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.
Comment #18
KarenS CreditAttribution: KarenS commentedThe 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.
Comment #19
anarcat CreditAttribution: anarcat commentedSo this was fixed in 5.x, I'm closing the issue.
Comment #21
karthick62 CreditAttribution: karthick62 commentedI 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???