[Vtigercrm-developers] timezone issue
Richard Hills - Technologywise
richard at tw.co.nz
Thu Jul 16 20:35:05 GMT 2015
Re: http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592
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.
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.
Thanks
On 15/07/15 03:57, Manu urs wrote:
> Hi
>
> Let me make it clear .There are two separate topics discussed in this
> thread .
> 1) Email Related list view issue in 630
> <http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573>
>
> 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.
>
> 2) Time is storing in Default_timezone format
> <http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592>
>
> 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.
>
> Regards,
> Manu Urs
>
>
>
> On Tue, Jul 14, 2015 at 8:44 PM, Garry Brighton
> <garryatbrighton at gmail.com <mailto:garryatbrighton at gmail.com>> wrote:
>
> Dont get it Manu.. it means that timezone issue in mentioned
> emails can not be fixed?
> I read thread and it suit perfectly to my case. Emails are
> attached in UTC where my timezone is UTC + 4
> 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?
>
> Cheers
>
> On Mon, Jul 13, 2015 at 1:13 PM, Manu urs <manu.k at vtiger.com
> <mailto:manu.k at vtiger.com>> wrote:
>
> Hi
>
> 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.
>
> Regards,
> Manu Urs
>
> On Sat, Jul 11, 2015 at 5:06 AM, Stacey Johnson
> <stacey.johnson110 at gmail.com
> <mailto:stacey.johnson110 at gmail.com>> wrote:
>
> Manu, dont you think this is very important issue for
> those who working worldwide?
> CRM is not for use solely in same timezone. It is hard to
> catch order in threads if time is that mixed.
> I will be wise to attend to this issue asap
>
> cheers
>
> On Thu, Jul 2, 2015 at 12:32 AM, Manu urs
> <manu.k at vtiger.com <mailto:manu.k at vtiger.com>> wrote:
>
> Hi
>
> 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 trac
> <http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592> .
>
>
> Regards,
> Manu Urs
>
>
> On Wed, Jul 1, 2015 at 9:43 PM, Phasaphon Kwanrutai
> <sunkohchangresort at gmail.com
> <mailto:sunkohchangresort at gmail.com>> wrote:
>
> Have the same problem here. Additionally each time
> I click Emails related list link, records are
> sorted in different pattern - kind of lucky dip...
> anybody got same issue with vtiger_activity?
>
> On Tue, Jun 30, 2015 at 11:51 PM, Stacey Johnson
> <stacey.johnson110 at gmail.com
> <mailto:stacey.johnson110 at gmail.com>> wrote:
>
> 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.
>
> On Tue, Jun 30, 2015 at 10:53 PM, Stacey
> Johnson <stacey.johnson110 at gmail.com
> <mailto:stacey.johnson110 at gmail.com>> wrote:
>
> This did't change issue. System still
> recording GMT time instead of my server time
> Any clue?
>
> Stacey
>
> On Tue, Jun 30, 2015 at 9:59 PM, Manu urs
> <manu.k at vtiger.com
> <mailto:manu.k at vtiger.com>> wrote:
>
> Hi to resolve the
> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573
> issue
>
> In the
> /modules/Vtiger/models/Module.php
> replace the (Line no 561-566)
>
> */foreach ($list_fields as $key => $fieldInfo) {
> $columnName = $fieldInfo[1];
> if(array_key_exists($key, $list_fields_name)){
> $relatedListFields[$columnName] = $list_fields_name[$key];
> }
> }
> /*
> with the
>
> */foreach ($list_fields as $key => $fieldInfo) {
> foreach ($fieldInfo as $columnName) {
> if(array_key_exists($key, $list_fields_name)){
> $relatedListFields[$columnName] = $list_fields_name[$key];
> }
> }
> }/*
>
>
>
> We will address #8282 enhancement in
> the next release.
>
>
> Regards,
> Manu Urs
>
>
>
>
> On Tue, Jun 30, 2015 at 7:49 PM,
> Stacey Johnson
> <stacey.johnson110 at gmail.com
> <mailto:stacey.johnson110 at gmail.com>>
> wrote:
>
> I meant #8282
>
> On Tue, Jun 30, 2015 at 9:18 PM,
> Stacey Johnson
> <stacey.johnson110 at gmail.com
> <mailto:stacey.johnson110 at gmail.com>>
> wrote:
>
> sure is reproducible but why
> ticket is open 9 months?
> can you guys look at it before
> releasing new version please
>
> cheers
> Stacey
>
> On Thu, Jun 11, 2015 at 8:59
> PM, Manu urs
> <manu.k at vtiger.com
> <mailto:manu.k at vtiger.com>> wrote:
>
> Hi Stacey,
>
> This issue is reproducible
> due to wrong entry in the
> related list header
> fields. Here is a trac
> link regarding the issue .
> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573
>
> Regards,
> Manu Urs
>
> On Thu, Jun 11, 2015 at
> 9:46 AM, Stacey Johnson
> <stacey.johnson110 at gmail.com
> <mailto:stacey.johnson110 at gmail.com>>
> wrote:
>
> I got set timezone
> correctly in
> config.inc and php.ini
> and system
> Despite that, emails
> attached to records
> have UTC time.
> Server is in Kuala
> Lumpur and this
> causing confusion.
> Email is sent from
> Gmail account where
> timezone is also set
> correctly.
> Where to look?
>
> Stacye
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
> --
> Regards,
> Manu
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
> --
> Regards,
> Manu
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
> --
> Regards,
> Manu
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
> --
> Regards,
> Manu
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
> --
> Regards,
> Manu
>
>
> _______________________________________________
> 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/20150717/491293c0/attachment-0001.html>
More information about the vtigercrm-developers
mailing list