Google Calendar Displays Wrong Times

Events, Tasks, Equipment, and Calendar

Moderators: Tech Support, Moderators

Google Calendar Displays Wrong Times

Postby ronkc » Thu Feb 18, 2010 4:22 pm

I'm a new user to PowerChurch, so I'm hoping the solution is simply something that I'm overlooking.

I've created a recurring event for our Sunday morning services (9:00am each week). When I sync to Google, it displays the first service as 9:00am, but the rest of the meetings show as 10:00am. By the way, the times are correct each week on the PowerChurch calendar.

Because it's off by 1 hour, I'm assuming the problem has something to do with us being on Central Time. However, I have the Googler calendar set to Central Time as well.
ronkc
 
Posts: 5
Joined: Thu Feb 18, 2010 4:13 pm

Re: Google Calendar Displays Wrong Times

Postby Tracy » Thu Feb 18, 2010 10:57 pm

Did you create the calendar, sync them at 10am, or with the Eastern timezone, then change things and re-sync?
Tracy
Tracy
Program Development
Program Development
 
Posts: 494
Joined: Fri Sep 05, 2003 2:08 pm
Location: PowerChurch Software

Re: Google Calendar Displays Wrong Times

Postby ronkc » Thu Feb 18, 2010 11:56 pm

No, I only added them once, and synced afterwards (no changes after I created the events). A little bit ago, I created a "test" event in April at 9am, then ran the sync utility. The Google calendar shows the test event at 10am. :(

Then, I added another "test" event for today at 9am, ran the sync, and it shows correctly in Google (9am).

So, it seems as though it's only events in future months that have this problem. That doesn't make any sense to me. Would you like me to try any other scenarios?
ronkc
 
Posts: 5
Joined: Thu Feb 18, 2010 4:13 pm

Re: Google Calendar Displays Wrong Times

Postby ronkc » Thu Feb 18, 2010 11:58 pm

Is there a way to set time zones in PowerChurch? (I should have asked this first)
ronkc
 
Posts: 5
Joined: Thu Feb 18, 2010 4:13 pm

Re: Google Calendar Displays Wrong Times

Postby Tracy » Fri Feb 19, 2010 12:04 am

Are you noticing the problem begins happening after March 14, 2010?
Tracy
Tracy
Program Development
Program Development
 
Posts: 494
Joined: Fri Sep 05, 2003 2:08 pm
Location: PowerChurch Software

Re: Google Calendar Displays Wrong Times

Postby ronkc » Fri Feb 19, 2010 12:10 am

That appears to be the case. So, does that mean Daylight Savings Time is causing the problem?
ronkc
 
Posts: 5
Joined: Thu Feb 18, 2010 4:13 pm

Re: Google Calendar Displays Wrong Times

Postby Tracy » Fri Feb 19, 2010 12:27 am

Looks to be. I'm not sure if it is a Google Calendar issue, or how the events are created into Google Calendar.
I'll get this investigated. Thanks for pointing it out.
Tracy
Tracy
Program Development
Program Development
 
Posts: 494
Joined: Fri Sep 05, 2003 2:08 pm
Location: PowerChurch Software

Re: Google Calendar Displays Wrong Times

Postby Tracy » Mon Feb 22, 2010 3:25 pm

From scanning the internet, it looks like this is a Google Calendar problem. I'm not sure if Google is going to fix the issue online, as they have done in the past. I did not pick up from the Google API documentation I need to specify the times accordingly by Daylight Savings. If it is something that needs to be addressed by PowerChurch, the timezone of the online calendar will be crucial to the solution. Parts of Arizona do not change the clocks for Daylight Savings. There is also the rest of the world to be aware of.
Tracy
Tracy
Program Development
Program Development
 
Posts: 494
Joined: Fri Sep 05, 2003 2:08 pm
Location: PowerChurch Software

Re: Google Calendar Displays Wrong Times

Postby ronkc » Mon Feb 22, 2010 9:05 pm

I may have found a "work around"...at least for now. This may not work for folks that sync to a mobile phone, etc...not sure.

I went to "Settings" in the Google Calendar. In the time zone setting, I checked the "show all time zones" box which gave me a lot more choices in the time zone dropdown box. I then found that "Central Time - Regina" fixed the problem in my calendar. I'm assuming that Regina is a place that doesn't observe DST. I know that folks in Mountain Time can choose "Mountain Time - Arizona" since Arizona doesn't observe DST. Not sure what to advise those in other time zones...but I'm sure trial and error would work (worked for me).

Hopefully Google will address the issue in case my quick fix causes other problems.
ronkc
 
Posts: 5
Joined: Thu Feb 18, 2010 4:13 pm

Re: Google Calendar Displays Wrong Times

Postby jmichell » Thu Feb 25, 2010 8:03 pm

I don't think this is a Google problem.
I use Google calendar myself, and the recurring items that I have set for 10 am Saturdays are correct before and after March 14th.
But the recurring items we have set up on Powerchurch (choir practice is at 7 pm every Thursday) show as starting one hour later after March 14th.
So it appears that the problem is in the Powerchurch sync program.
Is that your understanding, Tracey?
John
John Michell
Unitarian Church of Calgary
jmichell
 
Posts: 37
Joined: Thu Oct 27, 2005 4:36 pm
Location: Calgary, Alberta, Canada

Re: Google Calendar Displays Wrong Times

Postby NeilZ » Thu Feb 25, 2010 10:29 pm

jmichell wrote:I don't think this is a Google problem.
I use Google calendar myself, and the recurring items that I have set for 10 am Saturdays are correct before and after March 14th.
But the recurring items we have set up on Powerchurch (choir practice is at 7 pm every Thursday) show as starting one hour later after March 14th.
So it appears that the problem is in the Powerchurch sync program.
Is that your understanding, Tracey?
John


John,

Let me verify:

1. Items you enter directly into Google using your browser have the correct time.
2. Items entered in Powerchurch events, then synced to Google show the incorrect time after March 14th on Google, but show the correct time in Powerchurch

If, as I assume, the Powerchurch sync is using XML uploaded to Google to update the calendar, then unless Powerchurch is making time changes (and I don't believe it is), its a time issue on the Google import end which uses the Google APIs you don't use when directly accessing a Google calendar.
Neil Zampella

Pastor's Spouse,
Connellsville Presbyterian Church
Using PC+ since 1999.
NeilZ
 
Posts: 5269
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

Re: Google Calendar Displays Wrong Times

Postby jmichell » Fri Feb 26, 2010 12:22 am

1. Items you enter directly into Google using your browser have the correct time.
2. Items entered in Powerchurch events, then synced to Google show the incorrect time after March 14th on Google, but show the correct time in Powerchurch

You understand my post correctly.
I don't know how pcsync or Google import works. I'll leave that to the Powerchurch support folks.
John
John Michell
Unitarian Church of Calgary
jmichell
 
Posts: 37
Joined: Thu Oct 27, 2005 4:36 pm
Location: Calgary, Alberta, Canada

Re: Google Calendar Displays Wrong Times

Postby Tracy » Fri Feb 26, 2010 11:18 am

Reading the documentation for the Google Calendar API, there is no set way to send the Start and End times. In the examples they specifically use the Universal Time Coordinate (UTC or Zulu). I found a recently added example that did not use any offset or timezone. In my testing this correctly uses the Timezone the calendar is set to, even after Daylight time changes. The code changes need to be verified that I didn't spell a variable wrong, and it still runs for the hosted ONLINE clients. We also do not release Maintenance Releases (MR) on Fridays. I can say with some certainty this will be in a MR before the Daylight time change happens in March.
Tracy
Tracy
Program Development
Program Development
 
Posts: 494
Joined: Fri Sep 05, 2003 2:08 pm
Location: PowerChurch Software

Re: Google Calendar Displays Wrong Times

Postby NeilZ » Fri Feb 26, 2010 1:07 pm

Tracy wrote:Reading the documentation for the Google Calendar API, there is no set way to send the Start and End times. In the examples they specifically use the Universal Time Coordinate (UTC or Zulu). I found a recently added example that did not use any offset or timezone. In my testing this correctly uses the Timezone the calendar is set to, even after Daylight time changes. The code changes need to be verified that I didn't spell a variable wrong, and it still runs for the hosted ONLINE clients. We also do not release Maintenance Releases (MR) on Fridays. I can say with some certainty this will be in a MR before the Daylight time change happens in March.


So its an issue with the way the XML is formatted ?? Interesting ...
Neil Zampella

Pastor's Spouse,
Connellsville Presbyterian Church
Using PC+ since 1999.
NeilZ
 
Posts: 5269
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

Re: Google Calendar Displays Wrong Times

Postby Tracy » Fri Feb 26, 2010 2:35 pm

The difference is between
Code: Select all
<gd:when endTime='2010-05-03T13:30:00.000Z' startTime='2010-05-03T13:00:00.000Z'/>

and (the one which works)
Code: Select all
<gd:when endTime='2010-05-03T08:30:00' startTime='2010-05-03T08:00:00'/>
Tracy
Tracy
Program Development
Program Development
 
Posts: 494
Joined: Fri Sep 05, 2003 2:08 pm
Location: PowerChurch Software

Next

Return to Events

cron