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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > >> 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: [EMAIL PROTECTED] > > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com > >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
