[Vtigercrm-developers] Google Calendar Sync in vtiger 6.2

[Richard Hills - Technologywise]

Just another question should anyone know.

Inside ./modules/Google/connectors/Calendar.php function 
transformToSourceRecord

time_start/time_end are set up (as utc), but where is the step where 
this is meant to be converted to the server timezone? I could not find 
this and it is clearly what is failing for us (as all our imported 
records are ignoring timezone setting and being pushed into the database 
as UTC).

Thanks



On 02/03/15 11:09, Richard Hills - Technologywise wrote:
> Just confirming this is actually working on a different server for me. 
> I believe this is an issue with timezone support on our server. Will 
> let you all know if I can actually find something to pin the blame on.
>
> On 27/02/15 10:05, Richard Hills - Technologywise wrote:
>> As some of you will be aware I have been experiencing issues with the 
>> google sync where entries are brought over from google with the wrong 
>> times.
>>
>> I was now able to confirm this issue on a fresh installation of 
>> vtiger and would appreciate someone else verifying to ensure it is 
>> not an issue with our server.
>>
>> Steps to verify:
>>
>>   * Set up a google calendar and set the calendar timezone to
>>     "Auckland New Zealand GMT+12"
>>   * Install vtiger 6.2
>>       o Note, we use GMT+12 as our base time by setting,
>>         $default_timezone = 'Pacific/Auckland'; inside of config.inc.php
>>   * Enable the google calendar sync as outlined here:
>>     http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8482
>>   * Adjust the file modules/Google/connectors/Oauth2.php on line 122
>>     to remove the / after $site_URL.
>>   * Apply the change set here:
>>     http://trac.vtiger.com/cgi-bin/trac.cgi/changeset/14431
>>   * Create an entry starting at 09:00 and ending at 10:00 in google
>>     calendar
>>   * Synchronise with the CRM
>>
>> If you get the same results as me you will find a new calendar event 
>> in the CRM scheduled from 20:00 to 21:00.
>>
>> Sorry that this is not in trac yet, however as Uma confirmed that the 
>> vtiger team will look at this I thought maybe I would be duplicating 
>> something. Uma did you ever get any results from that investigation?
>>
>> Thank you
>>
>>
>>
>> -- 
>> Richard Hills
>> TechnologyWise Ltd, Tauranga, NZ
>> richard at tw.co.nz
>> www.technologywise.co.nz
>> ph: +64 (0)7 571 1060
>> fax: +64 (0)7 571 1061
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
> -- 
> Richard Hills
> TechnologyWise Ltd, Tauranga, NZ
> richard at tw.co.nz
> www.technologywise.co.nz
> ph: +64 (0)7 571 1060
> fax: +64 (0)7 571 1061
>
>
> _______________________________________________
> http://www.vtiger.com/

-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150302/5dea68cc/attachment.html>