<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Re: <a class="moz-txt-link-freetext" href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592</a><br>
<br>
I guess this explains all of my issues with google calendar sync. I
had to adjust only code there in order to get time saving in local
as we have had the config.inc.php timezone override since over 4
years ago before I came to work with this vtiger installation. <br>
<br>
Now that we know of this limitation we will look at converting all
of our current databases entries to utc and reset that along with
the adjustments we made to the google sync.<br>
<br>
Thanks<br>
<br>
<div class="moz-cite-prefix">On 15/07/15 03:57, Manu urs wrote:<br>
</div>
<blockquote
cite="mid:CAJ0TF5_r_WaoYhN4ehkrVGKGOeCgf_rxBeKFhYqiGAsTa7vzpA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Hi <br>
<br>
</div>
Let me make it clear .There are two separate topics
discussed in this thread .<br>
</div>
1) <a moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573">
Email Related list view issue in 630</a> <br>
<br>
The Related email list from contact module showing only
three header field , Subject , Parentid , fields are
missing.and sent time is not showing properly . To fix this
issue I have already updated the patch in this thread.<br>
</div>
<div><br>
<div>2) <a moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592">Time
is storing in Default_timezone format</a><br>
<div> <br>
As we are not providing an entry to edit default
timezone in Config Editor, We wont recommend to Edit of
config.inc.php to change the default timezone .Time data
should be saved into database in UTC format only.<br>
<br>
</div>
<div>Regards,<br>
</div>
<div>Manu Urs<br>
</div>
<div> <br>
<br>
</div>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Jul 14, 2015 at 8:44 PM, Garry
Brighton <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:garryatbrighton@gmail.com" target="_blank">garryatbrighton@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Dont get it Manu.. it means that timezone
issue in mentioned emails can not be fixed?
<div>I read thread and it suit perfectly to my case.
Emails are attached in UTC where my timezone is UTC + 4</div>
<div>It is not correct obviously. Does the same appear in
OnDemand? If not maybe just copy piece of code and paste
it to open source?</div>
<div><br>
</div>
<div>Cheers</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">
<div>
<div class="h5">On Mon, Jul 13, 2015 at 1:13 PM, Manu
urs <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:manu.k@vtiger.com" target="_blank">manu.k@vtiger.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div class="h5">
<div dir="ltr">
<div>
<div>Hi<br>
<br>
Editing config.inc.php for change in default
timezone is not allowed, As we are providing
an entry to edit configuration changes
through Config Editor. Where we not letting
user edits the Timezone value. Time data
should be saved into database in UTC format
only.<br>
<br>
</div>
Regards,<br>
</div>
Manu Urs<br>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Jul 11,
2015 at 5:06 AM, Stacey Johnson <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:stacey.johnson110@gmail.com" target="_blank">stacey.johnson110@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex">
<div dir="ltr">Manu, dont you think this
is very important issue for those who
working worldwide?
<div>CRM is not for use solely in same
timezone. It is hard to catch order
in threads if time is that mixed. </div>
<div>I will be wise to attend to this
issue asap</div>
<div><br>
</div>
<div>cheers</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">
<div>
<div>On Thu, Jul 2, 2015 at 12:32
AM, Manu urs <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:manu.k@vtiger.com"
target="_blank">manu.k@vtiger.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div>
<div>
<div dir="ltr">Hi <br>
<br>
Thanks for notifying us. As
of now the data's are
storing to Database in
$default_timezone format. We
will check the cause of the
issue and update it in this
thread, It is also reported
it in <a
moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592"
target="_blank">trac</a> .<br>
<br>
<br>
Regards,<br>
Manu Urs <br>
<br>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On
Wed, Jul 1, 2015 at
9:43 PM, Phasaphon
Kwanrutai <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:sunkohchangresort@gmail.com" target="_blank">sunkohchangresort@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">Have
the same problem
here. Additionally
each time I click
Emails related
list link, records
are sorted in
different pattern
- kind of lucky
dip...
<div>anybody got
same issue with
vtiger_activity? </div>
</div>
<div
class="gmail_extra"><br>
<div
class="gmail_quote">
<div>
<div>On Tue,
Jun 30, 2015
at 11:51 PM,
Stacey Johnson
<span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:stacey.johnson110@gmail.com"
target="_blank">stacey.johnson110@gmail.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div>
<div>
<div dir="ltr">wrong
time is
recorded in
vtiger_activity,
I just cant
get where is
code
responsible
for passing
UTC instead of
default
timezone to
this table.</div>
<div>
<div>
<div
class="gmail_extra"><br>
<div
class="gmail_quote">On
Tue, Jun 30,
2015 at 10:53
PM, Stacey
Johnson <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:stacey.johnson110@gmail.com"
target="_blank">stacey.johnson110@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">This
did't change
issue. System
still
recording GMT
time instead
of my server
time
<div>Any clue?</div>
<div><br>
</div>
<div>Stacey</div>
</div>
<div
class="gmail_extra"><br>
<div
class="gmail_quote">
<div>
<div>On Tue,
Jun 30, 2015
at 9:59 PM,
Manu urs <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:manu.k@vtiger.com" target="_blank">manu.k@vtiger.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div>
<div>
<div dir="ltr">
<div>
<div>
<div>
<div>Hi to
resolve the <a
moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573"
target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573</a>
issue <br>
<br>
</div>
In the
/modules/Vtiger/models/Module.php
replace the
(Line no
561-566)<br>
<pre><b><i>foreach ($list_fields as $key => $fieldInfo) {
$columnName = $fieldInfo[1];
if(array_key_exists($key, $list_fields_name)){
$relatedListFields[$columnName] = $list_fields_name[$key];
}
}
</i></b>
with the
<b><i>foreach ($list_fields as $key => $fieldInfo) {
foreach ($fieldInfo as $columnName) {
if(array_key_exists($key, $list_fields_name)){
$relatedListFields[$columnName] = $list_fields_name[$key];
}
}
}</i></b>
</pre>
<br>
<br>
</div>
We will
address #8282
enhancement
in the next
release. <br>
<br>
<br>
</div>
Regards,<br>
</div>
Manu Urs<br>
<div>
<div>
<div><br>
<br>
<br>
</div>
</div>
</div>
</div>
<div>
<div>
<div
class="gmail_extra"><br>
<div
class="gmail_quote">On
Tue, Jun 30,
2015 at 7:49
PM, Stacey
Johnson <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:stacey.johnson110@gmail.com"
target="_blank">stacey.johnson110@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">I
meant #8282<br>
</div>
<div>
<div>
<div
class="gmail_extra"><br>
<div
class="gmail_quote">On
Tue, Jun 30,
2015 at 9:18
PM, Stacey
Johnson <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:stacey.johnson110@gmail.com"
target="_blank">stacey.johnson110@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div>sure is
reproducible
but why ticket
is open 9
months? <br>
</div>
can you guys
look at it
before
releasing new
version please<br>
<br>
</div>
cheers<br>
</div>
Stacey<br>
</div>
<div
class="gmail_extra"><br>
<div
class="gmail_quote">
<div>
<div>On Thu,
Jun 11, 2015
at 8:59 PM,
Manu urs <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:manu.k@vtiger.com" target="_blank">manu.k@vtiger.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div>
<div>
<div dir="ltr">
<div>
<div>
<div>Hi
Stacey,<br>
<br>
</div>
This issue is
reproducible
due to wrong
entry in the
related list
header fields.
Here is a trac
link regarding
the issue .<br>
<a
moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573"
target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573</a><br>
<br>
</div>
Regards,<br>
</div>
Manu Urs<br>
</div>
<div
class="gmail_extra"><br>
<div
class="gmail_quote">
<div>
<div>On Thu,
Jun 11, 2015
at 9:46 AM,
Stacey Johnson
<span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:stacey.johnson110@gmail.com"
target="_blank">stacey.johnson110@gmail.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div>
<div>
<div dir="ltr">I
got set
timezone
correctly in
config.inc and
php.ini and
system
<div>Despite
that, emails
attached to
records have
UTC time.</div>
<div>Server is
in Kuala
Lumpur and
this causing
confusion.</div>
<div>Email is
sent from
Gmail account
where timezone
is also set
correctly.</div>
<div>Where to
look?</div>
<div><br>
</div>
<div>Stacye</div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><span><font
color="#888888"><br>
</font></span></blockquote>
</div>
<span><font
color="#888888"><br>
<br
clear="all">
<br>
-- <br>
<div>
<div dir="ltr">
<div>Regards,<br>
</div>
Manu<br>
</div>
</div>
</font></span></div>
<br>
</div>
</div>
_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br
clear="all">
<br>
-- <br>
<div>
<div dir="ltr">
<div>Regards,<br>
</div>
Manu<br>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
<br>
_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div>
<div dir="ltr">
<div>Regards,<br>
</div>
Manu<br>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a moz-do-not-send="true"
href="http://www.vtiger.com/"
rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
<br>
_______________________________________________<br>
<a moz-do-not-send="true"
href="http://www.vtiger.com/"
rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div>
<div dir="ltr">
<div>Regards,<br>
</div>
Manu<br>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer"
target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
<br>
_______________________________________________<br>
<a moz-do-not-send="true" href="http://www.vtiger.com/"
rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div class="gmail_signature">
<div dir="ltr">
<div>Regards,<br>
</div>
Manu<br>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a class="moz-txt-link-abbreviated" href="mailto:richard@tw.co.nz">richard@tw.co.nz</a>
<a class="moz-txt-link-abbreviated" href="http://www.technologywise.co.nz">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
</body>
</html>