Re: [rt-users] Wrong date displayed

2011-03-31 Thread Francesco Tordini
RT will always log GMT in the logs and in the database. But wiht RT logs written in GMT, and Apache logs in local time, we have inconsistent log entries (in /var/log/httpd/error_log) like these: [Wed Mar 30 15:21:21 2011] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations

Re: [rt-users] Wrong date displayed

2011-03-31 Thread Francesco Tordini
RT will always log GMT in the logs and in the database. But wiht RT logs written in GMT, and Apache logs in local time, we have inconsistent log entries (in /var/log/httpd/error_log) like these: [Wed Mar 30 15:21:21 2011] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations

Re: [rt-users] Query tickets by user custom field

2011-03-31 Thread Daniel De Marco
* Kevin Falcone falc...@bestpractical.com [03/30/2011 10:58]: Unfortunately, TicketSQL doesn't support searching on User CFs. You can group by it in a chart, but you can't search by it without extending the TicketSQL syntax. Grouping by it in a chart would be exactly what I need. However I

[rt-users] Change Email Subject Line ??

2011-03-31 Thread Adrian Stel
Hi All, I would like to add issues priority to Email Subject, for example: orginal subject is: [support #98] [Comment] Testing - Ignore me... new subject: [support #98] [Comment] Testing - Ignore me... Priority 5 -- Best Regards Adrian Stelmaszyk

Re: [rt-users] Change Email Subject Line ??

2011-03-31 Thread Raed El-Hames
Adrian: You can modify the templates associated with the emails you want to send (ie Correspondence template, Admin Comment templates etc) to include the Priority Eg: Subject: [Comment] [{$Ticket-QueueObj-Name}] [$Ticket-Subject] Priority [{$Ticket-Priority}] I would suggest you put the

[rt-users] RTFM : is there a CLI ?

2011-03-31 Thread Gerard FENELON
Hello Does anyone know if it is possible to add RTFM articles using a CLI or a API ? Thanks Gerard

[rt-users] FCKEditor , browser, and colors

2011-03-31 Thread Raphaël MOUNEYRES
Hello, The quick descritpion symptom i have is sometimes RT is not displaying the colors edited in the FCKEditor. RT version 3.8.8, and FCKEditor version 2.6.4 My analysis is : When i edit my text with IE8, FCK Editor generates the following code : span style=color: #ffROUGEbr /

Re: [rt-users] FCKEditor , browser, and colors

2011-03-31 Thread Thomas Sibley
On 31 Mar 2011 09:59, Raphaël MOUNEYRES wrote: The Firefox code is displayed in color on RT web interface, but the code from IE is displayed all in black colour. Now, when i forward the ticket to my LotusNotes messaging, BOTH codes are displayed in colours. So i beleive there is something to

[rt-users] Ticket Status History

2011-03-31 Thread Eric Stoycon
Hello everyone. I need to create a report which shows the average length of time a ticket is in each status. I tried adapting the 'include ticket history' template in a perl script but I cannot seem to get it to include status changes. I've dug through the wiki some and the list archive but

Re: [rt-users] FCKEditor , browser, and colors

2011-03-31 Thread Raphaël MOUNEYRES
thank you thomas for this quick effective answer. Still i'm going to try and find why FCK generates different htlm code with different browsers, there should be something in its config, at least i hope so. Raphael Subject: Re: [rt-users] FCKEditor , browser, and colors Message-ID:

Re: [rt-users] RTFM : is there a CLI ?

2011-03-31 Thread Kevin Falcone
On Thu, Mar 31, 2011 at 03:56:44PM +0200, Gerard FENELON wrote: Does anyone know if it is possible to add RTFM articles using a CLI or a API ? There is no CLI, the API is defined and documented in the .pm files that make up RT::FM -kevin pgpaYDX38ERjU.pgp Description: PGP signature

Re: [rt-users] RTFM : is there a CLI ?

2011-03-31 Thread Gerard FENELON
OK Thanks Gerard On 2011-03-31 16:34, Kevin Falcone wrote: On Thu, Mar 31, 2011 at 03:56:44PM +0200, Gerard FENELON wrote: Does anyone know if it is possible to add RTFM articles using a CLI or a API ? There is no CLI, the API is defined and documented in the .pm files that make up RT::FM

Re: [rt-users] Ticket Status History

2011-03-31 Thread Gerard FENELON
Hi we do something similar here. The idea is : define Tickets attributes (you could use CFs) one for each Status called TimeSpentInOpen/TimeSpentInNew/... plus one called TimeSinceLastStatusChange Then each time the status changes, add to the timer associated with the old value the time since

Re: [rt-users] Ticket Status History

2011-03-31 Thread Ruslan Zakirov
Something like this: SELECT t1.OldValue status, AVG(TIMESTAMPDIFF(SECOND, t2.Created, t1.Created)) FROM Transactions AS t1 CROSS JOIN Transactions AS t2 LEFT JOIN Transactions AS t3 ON t3.id t1.id AND t3.id t2.id AND t3.ObjectType = t1.ObjectType AND t3.ObjectId =

Re: [rt-users] Query tickets by user custom field

2011-03-31 Thread Ruslan Zakirov
On Thu, Mar 31, 2011 at 4:54 PM, Daniel De Marco d...@bartol.udel.edu wrote: * Kevin Falcone falc...@bestpractical.com [03/30/2011 10:58]: Unfortunately, TicketSQL doesn't support searching on User CFs. You can group by it in a chart, but you can't search by it without extending the TicketSQL

Re: [rt-users] Time Worked Report

2011-03-31 Thread Kenneth Crocker
Walid, In step 4, you don't mention editing the Tabs file with the changes specified in the instructions. In steps 5 6, those files should have been moved to usr/share/rt3/local/html/Tools/*Reports*. 1) The Tabs and index.html files must be modified kept* in-sync* in order to see the option

Re: [rt-users] Template not seeing value just set in Scrip

2011-03-31 Thread Kenneth Crocker
Drew, Did you *turn on* TransactionBatch (*Set($UseTransactionBatch, '1');* ) in your RT_SiteConfig.pm file? Kenn LBNL On Wed, Mar 30, 2011 at 5:26 PM, Drew Hahn dh...@newsroomsolutions.comwrote: Kenn, Thanks for the suggestion, but that didn’t seem to do it. I set both the Scrip that

Re: [rt-users] Exchange Email Set-up

2011-03-31 Thread Carl Palmer
I wanted to thank you for your input and share the solution that I finally came to. After adding the ip address of the RT server to the SMTP relay on our Small Business Server I started to get an error The message contains a content type that is not supported domain.com #5.6.1

[rt-users] recurring requests

2011-03-31 Thread Roedel, Mark
Obviously it's pretty simple to write a script against the REST API and launch it from a cron job, but has anybody done anything that's more end-user facing to allow for the setup of recurring tickets for periodic maintenance and the like?

[rt-users] How do I submit a ticket in behalf of a user?

2011-03-31 Thread Rocel M. Lacida
Hello All, Good Day! It's my first to post a mail to the mailing list so bear with me. First I am previous user of other ticketing system (Accord Trellis) and I have many problems about it and upon searching on the net about what is best ticketing system out there I found RT and it really

Re: [rt-users] How do I submit a ticket in behalf of a user?

2011-03-31 Thread Thomas Sibley
On 31 Mar 2011 22:08, Rocel M. Lacida wrote: Hello All, Good Day! It's my first to post a mail to the mailing list so bear with me. First I am previous user of other ticketing system (Accord Trellis) and I have many problems about it and upon searching on the net about what is best

Re: [rt-users] How do I submit a ticket in behalf of a user?

2011-03-31 Thread Rocel M. Lacida
Thanks Thomas, Wow, It's just that simple how stupid I am.. On 4/1/2011 10:25 AM, Thomas Sibley wrote: On 31 Mar 2011 22:08, Rocel M. Lacida wrote: Hello All, Good Day! It's my first to post a mail to the mailing list so bear with me. First I am previous user of other ticketing system