[Vtigercrm-developers] Google Calendar Sync in vtiger 6.2
Richard Hills - Technologywise
richard at tw.co.nz
Tue Mar 3 22:15:52 GMT 2015
After further testing I confirmed this bug on multiple servers.
This now works for us after the following changes, please note that line
numbers may be slightly off due to editing the files:
> modules/Google/connectors/Calendar.php line 143:
was $maxModifiedTime = date('Y-m-d H:i:s',
strtotime(Google_Contacts_Model::vtigerFormat(end($calendarRecords)->getUpdated()))
+ 1);
now $maxModifiedTime = date('Y-m-d H:i:s',
strtotime(Google_Calendar_Model::vtigerFormat(end($calendarRecords)->getUpdated()))
+ 1);
> ./modules/Google/models/Calendar.php
> public function vtigerFormat($date) {
> // EDIT
> $origDate = $date;
> // END EDIT
> list($date, $timestring) = explode('T', $date);
> list($time, $tz) = explode('.', $timestring);
> // EDIT - if this is UTC lets change it to correct system time
> if(substr($tz,-1) == 'Z') {
> $date = new DateTime($origDate);
> $timeZone = new DateTimeZone(date_default_timezone_get());
> $date->setTimezone($timeZone);
> $date = $date->format('Y-m-d H:i:s');
> return $date;
> }
> // END EDIT
> return $date . " " . $time;
> }
> function getStartTimeUTC($user = false) { AND function
> getEndTimeUTC($user = false) {
was $timeZone = new DateTimeZone('UTC');
now $timeZone = new DateTimeZone(date_default_timezone_get());
Would love to get some feedback from the vtiger team.
On 03/03/15 11:54, Richard Hills - Technologywise wrote:
> Another bit of the puzzle.
>
> When I change modules/Google/models/Calendar.php functions
> getEndTimeUTC and getStartTimeUTC to use the default_timezone set in
> config.inc.php I am able to import from google without the dates being
> imported incorrectly as UTC.
>
> The name of this function makes me believe that this is still not a
> solution but rather an incorrect workaround, really keen to hear where
> the translation from UTC to default timezone is meant to be done so
> that I can debug that.
>
> On 02/03/15 14:49, Richard Hills - Technologywise wrote:
>> 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
>>
>>
>> _______________________________________________
>> 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/20150304/36ab1ee8/attachment.html>
More information about the vtigercrm-developers
mailing list