<div dir="ltr">Hi,<div><br></div><div>The above shared code by you, has been verified by our end. Will be picking up these changes through this <a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8497">trac</a>. Please do update your further updates in this trac.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 4, 2015 at 3:45 AM, Richard Hills - Technologywise <span dir="ltr"><<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
After further testing I confirmed this bug on multiple servers.<br>
<br>
This now works for us after the following changes, please note that
line numbers may be slightly off due to editing the files:<br>
<br>
<blockquote type="cite">modules/Google/connectors/Calendar.php line
143:<br>
</blockquote>
was $maxModifiedTime = date('Y-m-d H:i:s',
strtotime(Google_Contacts_Model::vtigerFormat(end($calendarRecords)->getUpdated()))
+ 1);<br>
now $maxModifiedTime = date('Y-m-d H:i:s',
strtotime(Google_Calendar_Model::vtigerFormat(end($calendarRecords)->getUpdated()))
+ 1);<br>
<br>
<blockquote type="cite">./modules/Google/models/Calendar.php</blockquote>
<blockquote type="cite"> public function vtigerFormat($date) {<br>
// EDIT<br>
$origDate = $date;<br>
// END EDIT<br>
list($date, $timestring) = explode('T', $date);<br>
list($time, $tz) = explode('.', $timestring);<br>
// EDIT - if this is UTC lets change it to correct system
time<br>
if(substr($tz,-1) == 'Z') {<br>
$date = new DateTime($origDate);<br>
$timeZone = new
DateTimeZone(date_default_timezone_get());<br>
$date->setTimezone($timeZone);<br>
$date = $date->format('Y-m-d H:i:s');<br>
return $date;<br>
}<br>
// END EDIT<br>
return $date . " " . $time;<br>
}<br>
</blockquote>
<br>
<blockquote type="cite"> function getStartTimeUTC($user = false)
{ AND function getEndTimeUTC($user = false) {<br>
</blockquote>
was $timeZone = new DateTimeZone('UTC');<br>
now $timeZone = new DateTimeZone(date_default_timezone_get());<br>
<br>
<br>
Would love to get some feedback from the vtiger team.<div><div class="h5"><br>
<br>
<br>
<br>
<div>On 03/03/15 11:54, Richard Hills -
Technologywise wrote:<br>
</div>
<blockquote type="cite">
Another bit of the puzzle.<br>
<br>
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.<br>
<br>
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.<br>
<br>
<div>On 02/03/15 14:49, Richard Hills -
Technologywise wrote:<br>
</div>
<blockquote type="cite">
Just another question should anyone know.<br>
<br>
Inside ./modules/Google/connectors/Calendar.php function
transformToSourceRecord<br>
<br>
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).<br>
<br>
Thanks<br>
<br>
<br>
<br>
<div>On 02/03/15 11:09, Richard Hills -
Technologywise wrote:<br>
</div>
<blockquote type="cite">
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.<br>
<br>
<div>On 27/02/15 10:05, Richard Hills
- Technologywise wrote:<br>
</div>
<blockquote type="cite">
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.<br>
<br>
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.<br>
<br>
Steps to verify:<br>
<ul>
<li>Set up a google calendar and set the calendar timezone
to "Auckland New Zealand GMT+12"</li>
<li>Install vtiger 6.2</li>
<ul>
<li>Note, we use GMT+12 as our base time by setting,
$default_timezone = 'Pacific/Auckland'; inside of
config.inc.php<br>
</li>
</ul>
<li>Enable the google calendar sync as outlined here: <a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8482" target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8482</a></li>
<li>Adjust the file modules/Google/connectors/Oauth2.php
on line 122 to remove the / after $site_URL.</li>
<li>Apply the change set here: <a href="http://trac.vtiger.com/cgi-bin/trac.cgi/changeset/14431" target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/changeset/14431</a><br>
</li>
<li>Create an entry starting at 09:00 and ending at 10:00
in google calendar</li>
<li>Synchronise with the CRM</li>
</ul>
<p>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.<br>
</p>
<p>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?<br>
</p>
<p>Thank you<br>
</p>
<br>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
</div></div></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">With<br>Best Regards<br>Uma.S<br><div>Vtiger Team</div></div></div>
</div>