[rt-users] Error on SetDue

2009-11-23 Thread TONY JOHN - ERS, HCL Tech
Hi, Please find below the Custom action clean up code for Seting DueDate based on a condition: use strict; use warnings; my $date1=$self-TicketObj-FirstCustomFieldValue('CI Valid Till'); my $date2=$self-TicketObj-FirstCustomFieldValue('Date In Gabriel'); my($mm1,$dd1,$1) = split /\//,

Re: [rt-users] Error on SetDue

2009-11-23 Thread berrebi
hi, i don't know if it can help, but i don't use the -ISO on setDue. $self-TicketObj-SetDue($duedate); // when $duedate = 2009--11-23 00:00:00; maybe this can help, regards, On 23/11/2009 11:20, TONY JOHN - ERS, HCL Tech wrote: Hi, Please find below the Custom action clean up code for

[rt-users] Speeding up CLI RT::Shredder

2009-11-23 Thread Maxwell A. Rathbone
Hello, I'm in the same boat as many others I've seen post. We have 35k tickets in one of our queues that I'm trying to shred(shame on us for not automating this previously). I've found the web version of the Shredder to be god-awful slow. We're talking 10min+ just to shred ONE ticket. So I

Re: [rt-users] Error on SetDue

2009-11-23 Thread Ken Crocker
Tony, We have a Custom Field called Need-By Date that we have the customer fill out and we use that to set the Due Date of the ticket when they create a ticket. It overrides the default due date timing set up for the queue. This is the code we use: # # set new values for Due Date from CF

Re: [rt-users] Speeding up CLI RT::Shredder

2009-11-23 Thread Torsten Brumm
Oha, this sounds really useful. Any comment from ruslan if this is save? I have to shred several houndret thousend tickets from 2002-2007 and we need also around 2 minutes per ticket, will try it out tomorrow! Thanks for sharing this Torsten 2009/11/23 Maxwell A. Rathbone mrathb...@sagonet.com

Re: [rt-users] Speeding up CLI RT::Shredder

2009-11-23 Thread Maxwell A. Rathbone
I noticed a typo in probably the most important line in my message. The filename is actually: /opt/rt3/lib/RT/Shredder/Record.pm The line that I suggest to comment out, calls RT's built in Logger() function that basically just writes information either to the log or to the screen. As with

Re: [rt-users] Scrip to remove requestors based on group membership

2009-11-23 Thread Torsten Brumm
Hi, have a look onto your code: 1. Condition: ==Condition== my @exceptionGroups = ('no-reply'); my $principalobj = RT::Principal-new($RT:: SystemUser); $principalobj-Load($self-TransactionObj-CreatorObj-Id); my $transactionType = $self-TransactionObj-Type; if ($transactionType eq 'Create') {

Re: [rt-users] Backup a queue question

2009-11-23 Thread Torsten Brumm
Have a look onto RTx-Shredder at cpan, this will help you! Torsten 2009/11/9 PF phan...@gmail.com I need to backup everything in 2 queues but nothing else. I'm a database .. well I'm poor at it. I've looked through site:bestpractical.com (keywords) but not really found anything on

[rt-users] [Rt-announce] 2010 RT Training Sessions

2009-11-23 Thread Cassandra Phillips-Sears
Best Practical Solutions provides unparalleled instruction in how to get the most out of RT. We've been teaching users and administrators how to get the most out of RT since 2001. Since 2003, we've offered intensive one-day RT administrator training sessions to the general public. 2010 will bring

[rt-users] Tracking changes to queue structure

2009-11-23 Thread gordon
RT provides an excellent history log of all activities relating to a ticket. This provides an unchangeable record which auditors love when reviewing tickets. However we occasionally make changes to a queue such as adding a new custom field. This does not get filled in for historical tickets

Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread Ken Crocker
Gordon, RT has a Bulk Update feature which would allow you to add whatever value to specific Custom Fields on tickets in specific Queues as well as add comments to specific tickets in a queue. By specific, I mean whatever criteria you use for selecting the ticket you want to update. Kenn LBNL

[rt-users] RT installed in a subdirectory (without a RT specific virtual host)

2009-11-23 Thread [ ravi ]
Hello all, this question appears in the archive but the suggested answer does not quite work; I am hoping some of you will be able to suggest solutions. My problem is that I am trying to install RT on an existing web server (Apache 2.x with mod_perl2 on Ubuntu8), in a sub-directory. I went

Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread gordon
Thanks Ken, I use this feature for some fields but others require information specific to a ticket (eg description of product design change). Also, reviewers of historical tickets can still ask the question: why wasn't the field filled in when the ticket was active? Gordon Ken Crocker

Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread Nick Kartsioukas
On Tue, 24 Nov 2009 10:35:31 +1100, gor...@cryologic.com said: I use this feature for some fields but others require information specific to a ticket (eg description of product design change). Also, reviewers of historical tickets can still ask the question: why wasn't the field filled in

Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread gordon
Nice idea, I like it! thanks Gordon Nick Kartsioukas wrote: On Tue, 24 Nov 2009 10:35:31 +1100, gor...@cryologic.com said: I use this feature for some fields but others require information specific to a ticket (eg description of product design change). Also, reviewers of historical

[rt-users] Is SQLite no longer supported?

2009-11-23 Thread Todd Chapman
I just checked RT out of git and ran: ./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite But the database type is set to 'mysql' in RT_Config.pm. What gives? The schema.SQLite file still exists. ___

Re: [rt-users] Is SQLite no longer supported?

2009-11-23 Thread Jesse Vincent
On Mon, Nov 23, 2009 at 10:33:16PM -0500, Todd Chapman wrote: I just checked RT out of git and ran: ./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite It helps if you don't misspell '--with-db-type' But the database type is set to 'mysql' in RT_Config.pm.

Re: [rt-users] Is SQLite no longer supported?

2009-11-23 Thread Todd Chapman
On Mon, Nov 23, 2009 at 10:35 PM, Jesse Vincent je...@bestpractical.com wrote: On Mon, Nov 23, 2009 at 10:33:16PM -0500, Todd Chapman wrote: I just checked RT out of git and ran: ./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite It helps if you don't misspell

[rt-users] Database upgrade failing 3.8.4 to 3.8.6

2009-11-23 Thread Arends, John
When upgrading from 3.8.4 to 3.8.6 I'm getting this error when running bin/rt-setup-database --dba rt_user --prompt-for-dba-password --action upgrade [Tue Nov 24 04:23:47 2009] [crit]: Can't locate RT/FM.pm in @INC (@INC contains: /root/rt-3.8.6/sbin/../local/lib /root/rt-3.8.6/sbin/../lib

[rt-users] QuickSearch Too Slow - rt-3.6.0

2009-11-23 Thread Umasankar Pandurangan
Hi, I am using RT v3.6.0 on RHEL AS 3 with Oracle 9i as the back-end database on a Pentium server with 1GB of RAM. This RT instance is hosting two business applications and there are close to 1200 queues on it. I am facing an issue with the QuickSearch widget on the RT web interface. It was

Re: [rt-users] QuickSearch Too Slow - rt-3.6.0

2009-11-23 Thread Emmanuel Lacour
On Tue, Nov 24, 2009 at 01:01:39PM +0530, Umasankar Pandurangan wrote: Hi, I am using RT v3.6.0 on RHEL AS 3 with Oracle 9i as the back-end database on a Pentium server with 1GB of RAM. This RT instance is hosting two business applications and there are close to 1200 queues on it. I am