Subject: [rt-users] Date/Time in exported spreadsheet wrong

[Andrew Dike]

I haven't looked at the code, but logic would imply that there is a function
somewhere that will convert Date and Time based on the time zone setting
within RT. For some reason the export process doesn't use this function. If
I were trying to fix this problem (and I will probably have to when I have
time), I would find this function and see if I can use this function in the
export process. Or I would go directly to the code that performs the export
and create my own function to apply the timezone to the necessary fields.

As a side note, I don't know of a logical reason for RT not exporting the
data which the correct timezone by default. GMT is of little use to anyone
not in the GMT timezone...

Hope this helps,

Andrew

On 10/9/07, Bjoern Schulz <bjoern.schulz at desy.de> wrote:
>
> Hi Andrew,
> yes, it is GMT. Jesse gave the hint some day ago. But I haven't got an
> idea to fix it.
>
> cheers, Björn
>
> Andrew Dike schrieb:
> > Hi Bjoern,
> >
> > I have noticed the same issue in RT 3.6.0. I'm not sure if I got to the
> > bottom of it but I believe that the time recorded in the database is
> always
> > GMT. When you view times and dates via the web front end, the settings
> in
> > RT_SiteConfig.pm come into effect, adjusting the time for your location.
> > However the export function always outputs data direct from the DB.
> >
> > I hope there's a straightforward way to fix this because it's quite
> > frustrating for users.
> >
> >
> >
> > Andrew
> >
> > Date: Tue, 02 Oct 2007 09:18:39 +0200
> >> From: Bjoern Schulz <bjoern.schulz at desy.de>
> >> Subject: [rt-users] Date/Time in exported spreadsheet wrong
> >>
> >>
> >> Hi list,
> >>
> >> we are using RT 3.6.5 RC2 and I observe the following problem.
> >> We like to export search data to a spreadsheet, but there is a
> different
> >> between the date in the web-UI and the exported data. In our case its 2
> >> hours.
> >>
> >>
> >> Our RT_SiteConfig.pm
> >> # $Timezone is used to convert times entered by users into GMT and back
> >> again
> >> # It should be set to a timezone recognized by your local unix box.
> >> Set($Timezone , 'Europe/Berlin');
> >>
> >>
> >>
> >> Thanks for any input!
> >>
> >> bjoern
> >>
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071009/eab759cf/attachment.htm>