[rt-users] RT Large Scale Performance Issues: Resolved

2007-06-26 Thread Andrew Armstrong
Hi Everyone, We have been making use of RT for almost a year now, however the performance began to quickly degrade (tickets would take 30+ seconds to open at times) over time. We're using RT v3.6.3 After we checked both this list and other resources for a solution, we were unable to fin

Re: [rt-users] Reducing noise in ticket history

2007-06-26 Thread Toby Darling
Hi David I created a thread about this in April, suggesting the history could be collapsed. I think there was a feeling it could be done and was desirable, but it would need someone with the time and ability to carry it out. I've got a trivial (4 line) change to html/Ticket/Elements/ShowTran

Re: [rt-users] Reducing noise in ticket history

2007-06-26 Thread Stefan Hornburg
Toby Darling wrote: Hi David I created a thread about this in April, suggesting the history could be collapsed. I think there was a feeling it could be done and was desirable, but it would need someone with the time and ability to carry it out. I've got a trivial (4 line) change to html/Tic

Re: [rt-users] Reducing noise in ticket history

2007-06-26 Thread Toby Darling
Stefan Hornburg wrote: Toby Darling wrote: Hi David I created a thread about this in April, suggesting the history could be collapsed. I think there was a feeling it could be done and was desirable, but it would need someone with the time and ability to carry it out. I've got a trivial (4

Re: [rt-users] Reducing noise in ticket history

2007-06-26 Thread Richard Brady
Thanks, this is super, will try and apply to 3.6 sometime this week. On 6/26/07, Toby Darling <[EMAIL PROTECTED]> wrote: > Well, i would like to see details :-) as this would be a very nice feature. No problem. Sorry, it's a tad more involved than I remembered ... -- Richard Brady T: +44

[rt-users] Default Time Worked

2007-06-26 Thread Mathew Snyder
Due to the nature of our beast, we need to default the Time Worked value to 5 on replies and comments. Anyone know where I go to look at this? -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com/cgi-b

[rt-users] multiple deletes

2007-06-26 Thread slamp slamp
is it safe to delete tickets directly from the mysql db? meaning change status to 'delete' from 'new'? and then let RTx-Shredder do its thing? we have a bunch of tickets that needs to be deleted (SPAM got through) and there is not quick way of deleting them other than going into the actual ticket

Re: [rt-users] multiple deletes

2007-06-26 Thread Mathew Snyder
It is safe to do this. Just don't actually remove the ticket from the database. I've had to do this in the past when I was initially moving our setup to a new version of RT. Keep up with me and what I'm up to: http://theillien.blogspot.com slamp slamp wrote: > is it safe to delete tickets di

[rt-users] Adding multiple requestors from the command-line

2007-06-26 Thread Andreas Vögele
I need to add several requestors from the command-line but it seems that I can only add one requestor and multiple Ccs with the "rt" command-line tool. Or is there a way to add multiple requestors with "rt"? This question might be related to the message "Creating tickets with Perl" that was poste

Re: [rt-users] multiple deletes

2007-06-26 Thread Stephen Turner
At Tuesday 6/26/2007 08:33 AM, slamp slamp wrote: is it safe to delete tickets directly from the mysql db? meaning change status to 'delete' from 'new'? and then let RTx-Shredder do its thing? we have a bunch of tickets that needs to be deleted (SPAM got through) and there is not quick way of del

RE: [rt-users] Default Time Worked

2007-06-26 Thread Edge, Sean
Mathew, You could accomplish this using a Scrip with conditions "On Comment" and "On Correspond". Then just grab the current Time Worked, increment by 5 and update the db field. So something like this might work for your custom Scrip Action: my $temp = $self->TicketObj->TimeWorked; $temp += 5; $s

Re: [rt-users] Default Time Worked

2007-06-26 Thread Mathew Snyder
That will be good plan "B". I'll have to clarify with the powers that be what they want because we want the ticket to start at 5 and go up as people add time. Not necessarily go up by 5 each time. Although, that might actually make more sense just in case people forget to add any time anyway. T

RE: [rt-users] Default Time Worked

2007-06-26 Thread Edge, Sean
Oh, sorry, I thought that's what you were asking. If you just want it to start at 5 minutes by default you can simply make the condition "On Create" and just make the action: $self->TicketObj->SetTimeWorked(5); return 1; Any new ticket in any Queue (provided you make it a Global Scrip) would, on

Re: [rt-users] Default Time Worked

2007-06-26 Thread Mathew Snyder
It isn't working. This is how I've configured it: Description: Default Time Worked Condition: On Create Action: User Defined Template: Global template: Transaction Stage: TransactionCreate Custom Condition: $self->TicketObj->SetTimeWorked(5); Custom action preparation code: Custom action cleanup

RE: [rt-users] Reducing noise in ticket history

2007-06-26 Thread D . J . Rickard
Thanks, I'll see how that works on our install. David Rickard -Original Message- From: Toby Darling [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 10:10 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Reducing noise in ticket history Stefan Hornburg wrote: > Toby Darlin

[rt-users] "PerlModule" error

2007-06-26 Thread Mendez, Felix
I have installed the RT-3.6.3 over OpenSuse 10.2, all the modules of CPAN are well installed. But when I modify the file httpd.conf of the Apache, it gives me the following error "invalid command "PerlModule" perhaps misspelled or defined by a module not included in the server configuration" Pleas

RE: [rt-users] Default Time Worked

2007-06-26 Thread Edge, Sean
Mathew, -- It isn't working. This is how I've configured it: Description: Default Time Worked Condition: On Create Action: User Defined Template: Global template: Transaction Stage: TransactionCreate -- I generally use a Blank template so there's no correspondance sent when making

Re: [rt-users] Default Time Worked

2007-06-26 Thread Mathew Snyder
Edge, Sean wrote: > Mathew, > -- > It isn't working. This is how I've configured it: > Description: Default Time Worked > Condition: On Create > Action: User Defined > Template: Global template: Transaction > Stage: TransactionCreate > -- > > I generally use a Blank template so th

Re: [rt-users] Default Time Worked

2007-06-26 Thread Roger Gammans
On Tue, Jun 26, 2007 at 10:46:46AM -0400, Edge, Sean wrote: > Mathew, > The only way I could think to have the "Time Worked" field automatically > filled would be to modify the RT code or db schema, neither of which I > would recommend. Matt, Does visitng the following URL give you what you want

Re: [rt-users] Default Time Worked

2007-06-26 Thread Mathew Snyder
YES!!! That's exactly what I need. And the change worked perfectly. Thanks Keep up with me and what I'm up to: http://theillien.blogspot.com Roger Gammans wrote: > On Tue, Jun 26, 2007 at 10:46:46AM -0400, Edge, Sean wrote: >> Mathew, >> The only way I could think to have the "Time Worked" fie

[rt-users] Re: Default Time Worked

2007-06-26 Thread Andreas Vögele
Mathew Snyder writes: > I've clarified with my boss. He does want the field to be > pre-populated. [...] If the string '&UpdateTimeWorked=5' is added to the update URL, e.g. https://www.example.com/rt/Ticket/Update.html?Action=Comment&id=50&UpdateTimeWorked=5, the field will be pre-populated.

[rt-users] Possible bug? Change CF type

2007-06-26 Thread Mathew Snyder
I need to change a CF type from Select One to Combobox. When I make the change in the configuration it comes back saying "CustomField Environment: That is already the current value". When I go to test the changes the type is changed from Select One to Enter One Value. I'm not given the option of

RE: [rt-users] Default Time Worked

2007-06-26 Thread Steve Anderson
What you have there won't work, as it's using what you want to do, as it's condition on if it should work or not. In addition, create isn't fired, when someone adds a comment, or reply. If you were to add a condition for those, it would add 5 to the time worked, no matter what someone put in on th

[rt-users] Time Left

2007-06-26 Thread Mathew Snyder
Has anyone set up the Time Left field to auto-populate based on the Due Date? I'm trying to figure out how to best go about this. I'm thinking that I could updated it similar to how the priority gets escalated every night when either the rt-crontool or rt-escalate runs. However, it would be nice

[rt-users] Mandatory Subject Field

2007-06-26 Thread Matt Gilstrap
Does anyone know how to make the Subject a mandatory field when creating a ticket through the web interface? It seems that people around here forget to fill in some fields. Matt ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RE: [rt-users] Mandatory Subject Field

2007-06-26 Thread Jeff Stark
The code is in Ticket_Overlay.pm you should create Ticket_Local.pm and update the "Create" sub routine. Jeff Stark, Sr Systems Administrator SumTotal Systems, Inc. (Nasdaq; SUMT) OFFICE+1 919 326 7548 MOBILE +1 919 622 0418 EMAIL [EMAIL PROTECTED] The

Re: [rt-users] Time Left

2007-06-26 Thread Mathew Snyder
Correction: As Time Left is in minutes, all I need to figure out is how to set it initially. I would assume that I need to grab the due date and Diff it with the current time. However, the scrip I've cobbled together clearly isn't the way to do it as it doesn't work ;) Condition: On Create Acti

[rt-users] Trouble with CF display

2007-06-26 Thread Kenneth Crocker
To all, I have a Custom Field called "QA Started" and I am setting it to $cf_value = localtime; in a scrip. When the scrip runs that updates this field, it seems to work. When I look at the content of the DataBase record ObjectCustomFieldValue for the ticket, it shows the current date & tim

Re: [rt-users] Re: Default Time Worked

2007-06-26 Thread Roger Gammans
On Tue, Jun 26, 2007 at 05:41:52PM +0200, Andreas V?gele wrote: > I haven't figured out how to set a default value for UpdateTimeWorked > though. The field won't be pre-populated if you add > '$UpdateTimeWorked => "5"' to the %ARGS section at the bottom of > Update.html. >From the O'reilly book

Re: [rt-users] FW: Ticket Report We Use

2007-06-26 Thread [EMAIL PROTECTED]
Anyone worked on JasperReports and RT? El Jue, 21-06-2007 a las 12:17 -0400, Helmuth Ramirez escribió: > Hi everyone, here is what I was told by the person who created the > report, I hope this helps: > > > In crystal, they have to go to Database>Set Location, click on each of > the tables then

[rt-users] modifying group or queues

2007-06-26 Thread slamp slamp
i am stumped. i have granted all rights to a group and all rights to a user belonging to that group within the queue and when i log in as that user there is no place to modify the group or the queue. where do i go? i did this in: configuration -> groups -> groupname -> group rights configuration

Re: [rt-users] modifying group or queues

2007-06-26 Thread slamp slamp
does it have to be global for this to work? On 6/26/07, slamp slamp <[EMAIL PROTECTED]> wrote: i am stumped. i have granted all rights to a group and all rights to a user belonging to that group within the queue and when i log in as that user there is no place to modify the group or the queue. w

Re: [rt-users] New Installation

2007-06-26 Thread Robert Canary
Thanks Ruslan, Sorry for the delay I was called out of the office on some trouble tickets. Here is what I put in the httpd.conf ServerName mchn37.ocdirect.net ServerAdmin [EMAIL PROTECTED] DocumentRoot /opt/rt3/share/html ErrorLog /var/log/rt/rt-web-error.log CustomLog /var/log/

Re: [rt-users] FW: Ticket Report We Use

2007-06-26 Thread Joop
[EMAIL PROTECTED] wrote: Anyone worked on JasperReports and RT? Yes, I created a report to count the hours spend by queue by staff member per month.I'm using iReports which is using JasperReports as its engine I believe. Joop ___ http://lists.b