CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • civievent with google calendar
Pages: [1]

Author Topic: civievent with google calendar  (Read 2585 times)

vijai

  • I post occasionally
  • **
  • Posts: 46
  • Karma: 0
civievent with google calendar
January 03, 2008, 03:04:50 pm
Hi,

I haven't been able to use civicrm with the Drupal Calendar module because of the GMT issue (times only display in GMT)

I have it working with google calendar by importing an ical file. Has anyone got it working as an ical feed? When I try it, I always get this error : "Could not fetch the url"

-v

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civievent with google calendar
January 03, 2008, 04:59:32 pm

most likely this is a permission issue. Can u try fetching the RSS feed as an anonymous user (which google calendar is when fetching a page)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

vijai

  • I post occasionally
  • **
  • Posts: 46
  • Karma: 0
Re: civievent with google calendar
January 03, 2008, 08:03:24 pm
I can fetch both the rss feed and ical feed as anonymous user

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: civievent with google calendar
January 20, 2008, 05:27:52 pm
I'm having the same problem - dates are not correct.

bchoc

  • Guest
Re: civievent with google calendar
January 20, 2008, 08:28:54 pm
I, too, have this issue.
This event, in CiviEvent:
Quote
Intro to using a Keyboard
This is a fake event. Ignore it.
When    January 31st, 2008 6:45 PM   through   08:45 PM

Produces this iCal code:
Quote
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//CiviCRM//NONSGML CiviEvent iCal//EN
BEGIN:VEVENT
UID:CiviCRM_EventID_7@http://www.example.com/
SUMMARY:Intro to using a Keyboard
CATEGORIES:Workshop
DTSTART:20080201T004500Z
DTEND:20080201T024500Z
URL:http://www.example.com/civicrm/event/info?reset=1&id=7
END:VEVENT
END:VCALENDAR

I can see it, but it shows up at the wrong time (wrong day, in fact).

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civievent with google calendar
January 20, 2008, 08:47:12 pm

Can you reproduce this problem on the sandbox server at http://sandbox.civicrm.org/

if so, can you please file an issue on the issue tracker along with details on how to reproduce it

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bchoc

  • Guest
Re: civievent with google calendar
January 20, 2008, 10:02:06 pm
Yup the problem "works" in sandbox too.  Here you go.

http://issues.civicrm.org/jira/browse/CRM-2571

bchoc

  • Guest
Re: civievent with google calendar
January 20, 2008, 11:05:19 pm
A bit of further research brings up this:
http://drupal.org/node/156418

bchoc

  • Guest
Re: civievent with google calendar
January 21, 2008, 11:47:03 am
vijaiprao and sonicthoughts --

It seems there is a problem with Drupal calendar ical handling GMT (see the link I posted above).  However, for me CiviCRM is generating GMT 1 hour off.  Are your iCal files getting times that are in proper GMT (in which case Drupal's the problem) or off by some other amount?

bc

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civievent with google calendar
January 21, 2008, 05:44:36 pm

bchoc:

we use the server time/timezone, so you might want to check that and ensure that the gmt time generated by civicrm is valid/invalid :) The sandbox is on PST which is currently GMT-8 and hence valid :)

We use a php function to accomplis this, the relevant code is:

Code: [Select]
            return gmdate( "Ymd\THis\Z",
                           strtotime( $date ) );

lobo

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bchoc

  • Guest
Re: civievent with google calendar
January 21, 2008, 07:45:15 pm
That would be the root of it.

I think my webserver is in Chicago (Central), but we're in Denver (Mountain).  Thus, CiviCRM assumes a human-entered date is GMT-6 when it's really GMT-7.  Perhaps what's needed is a default timezone setting, such as the one in Drupal, to tell CiviCRM how to adapt times to GMT.

This would be, I think, a problem for many organizations who do not own their own servers.

bc

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civievent with google calendar
January 21, 2008, 08:35:36 pm

we probably will try to avoid dealing with TZ and TZ related issues till a later release. You might want to check this thread for some ideas on how to get around it:

http://forum.civicrm.org/index.php/topic,303.0.html

if this is important to your org, please consider contributing some code to address the issue

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bchoc

  • Guest
Re: civievent with google calendar
January 21, 2008, 11:26:11 pm
You wouldn't like my code!   ;D

That said, I agree that most of the troubles in this thread is a Drupal issue, but I think CiviEvent does need to be able to adapt to disparate timezones.  I've put in a lower-priority feature request so this doesn't get forgotten. http://issues.civicrm.org/jira/browse/CRM-2575

bc
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • civievent with google calendar

This forum was archived on 2017-11-26.