[rt-users] Extract custom fields from tickets using commandline

2008-03-11 Thread Ben Robson
Greetings I was wondering if anyone had any advice on how to best, from the command line, conduct a search for tickets that match a custom field value ('CF.{Invoiced Date}' > '2008-04-03') show values in a custom field in matching tickets ('CF.{Purchase Order Number}'). The intention is to

Re: [rt-users] Hours Worked

2008-03-11 Thread Chaitanya Veludandi
There are 2 things involved here: 1. Calculate hours worked on a ticket, probably using the Business::Hours module and 2. Move the value to a custom field so that it is displayed on the ticket details page and will also help track SLAs. Obviously it has to be triggered 'on resolve' however it shou

Re: [rt-users] RT freezes on some big tickets

2008-03-11 Thread The Anarcat
On Tue, Mar 11, 2008 at 07:45:24AM -0500, Kenneth Marshall wrote: > Welcome to the world of stateless page loads. :) Whee! :) > The only suggestions > that I have are in two areas. Can you modify the page load to skip the > un-interesting transactions/attachments? er... sure i'd like to! > We h

[rt-users] RT update message help

2008-03-11 Thread Kenneth Crocker
To all, I have written a scrip that checks a change to a CF to ensure that the right person changed it. If not, then the scrip changes the value back. My problem is that at the top of the page there is a RT message that shows the EARLIER change, but not my change when my scrip changed

Re: [rt-users] RT 3.6.5 and Sendmail error and looks like perl error

2008-03-11 Thread Ruslan Zakirov
Upgrade File::Temp module from the CPAN to 0.18 or greater. On Tue, Mar 11, 2008 at 9:24 PM, Kobus Bensch <[EMAIL PROTECTED]> wrote: > > > > > Hello everyone > > > > I have been seeing this in the sendmail logs: > > Mar 11 18:20:12 centos sendmail[7978]: m2BGLulV003149: > to="|/opt/rt3/bin/rt-mail

Re: [rt-users] On Owner change set owner as AdminCC

2008-03-11 Thread Ruslan Zakirov
On Tue, Mar 11, 2008 at 7:34 PM, John Arends <[EMAIL PROTECTED]> wrote: > I'm trying to figure out how to write a scrip that will add a ticket > owner as an AdminCC. This way even if the owner changes, each person who > has ever owned the ticket will be on the AdminCC list. > > I'm still very ne

[rt-users] RT 3.6.5 and Sendmail error and looks like perl error

2008-03-11 Thread Kobus Bensch
Hello everyone I have been seeing this in the sendmail logs: Mar 11 18:20:12 centos sendmail[7978]: m2BGLulV003149: to="|/opt/rt3/bin/rt-mailgate --queue 'FSL' --action correspond --url http://rt.comp.co.uk/";, ctladdr=<[EMAIL PROTECTED]> (8/0), delay=01:58:16, xdelay=00:00:01, mailer=prog, pr

Re: [rt-users] Mandatory Custom Field

2008-03-11 Thread Kenneth Crocker
Scott, Very good. I'll get it. Kenn LBNL On 3/11/2008 10:39 AM, Scott Lambert wrote: > On Tue, Mar 11, 2008 at 09:05:09AM -0700, Kenneth Crocker wrote: >> Stephen & Steve, >> >> Thanks a bunch, really. I'm just now learning some perl, so a lot of >> stuff confuses me. I think I se

[rt-users] Second time this error has appeared. Help please

2008-03-11 Thread Mathew
It only happens when creating tickets. error: Can't call method "IsLocal" on an undefined value at /usr/local/rt3/lib/RT/URI.pm line 249. context: ... 245:=cut 246: 247:sub IsLocal { 248:my $self = shift; 249:return $self->Resolver->IsLocal; 250:} 25

Re: [rt-users] Mandatory Custom Field

2008-03-11 Thread Scott Lambert
On Tue, Mar 11, 2008 at 09:05:09AM -0700, Kenneth Crocker wrote: > Stephen & Steve, > > Thanks a bunch, really. I'm just now learning some perl, so a lot of > stuff confuses me. I think I see it, so double thanks. You helped me fix > a problem AND taught me something. This provides a usef

[rt-users] On Owner change set owner as AdminCC

2008-03-11 Thread John Arends
I'm trying to figure out how to write a scrip that will add a ticket owner as an AdminCC. This way even if the owner changes, each person who has ever owned the ticket will be on the AdminCC list. I'm still very new to writing scrips so I may be missing something obvious. Any suggestions? This

Re: [rt-users] Mandatory Custom Field

2008-03-11 Thread Kenneth Crocker
Stephen & Steve, Thanks a bunch, really. I'm just now learning some perl, so a lot of stuff confuses me. I think I see it, so double thanks. You helped me fix a problem AND taught me something. Kenn LBNL On 3/11/2008 6:19 AM, Stephen Turner wrote: > At Monday 3/10/2008 05:10 PM, Kenn

Re: [rt-users] RT 3.6.6 on ubuntu 7.10

2008-03-11 Thread Sven Sternberger
Hi! look if the postfix user is allowed to access the folder with the script "ls -ld /etc/request-tracker3.6" And you can btw. simply check the rest with a cat file_with_a_complete_mail | /etc/request-tracker3.6/rt-mailgate \ --queue general --action correspond --url http://localhost/rt"; regar

[rt-users] No permission to create tickets in the queue

2008-03-11 Thread Nicolas GUIOT
Hi all I have a queue where "everyone" is grnated the right to create a ticket. I tested with a "foreign", brand new email : it just works (TM), and it added the email to the MySQL DB. But, we have a user that always gets this error : No permission to create tickets in the queue 'support-toto'

Re: [rt-users] RT 3.6.6 on ubuntu 7.10

2008-03-11 Thread Andrew Fay
Cheers for that - got RT up and running now! Andy IT Engineer Wenaas UK Ltd -Original Message- From: Ruslan Zakirov [mailto:[EMAIL PROTECTED] Sent: 11 March 2008 13:27 To: Andrew Fay Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.6.6 on ubuntu 7.10 Check first line o

[rt-users] Merge Scrip/Template

2008-03-11 Thread Jean-Sebastien Morisset
Hi everyone, I'd like to create a Scrip/Template for a merged ticket. I was thinking of something like this for the Scrip: Condition: User Defined Action: Notify Requestors and Ccs Template: Global template: Merged Ticket Custom condition: return ( $self->TransactionObj->Type eq "Merge"); I'

Re: [rt-users] RT 3.6.6 on ubuntu 7.10

2008-03-11 Thread Ruslan Zakirov
Check first line of the mailgate script, it's a shebang string and should point to your perl binary, something like: #!/usr/bin/perl As well check that script has x mode set. On Tue, Mar 11, 2008 at 4:11 PM, andywenaas <[EMAIL PROTECTED]> wrote: > > I am having a problem with rt-mailgate > > I

Re: [rt-users] Mandatory Custom Field

2008-03-11 Thread Stephen Turner
At Monday 3/10/2008 05:10 PM, Kenneth Crocker wrote: >Stephen, > > > Why does yours have so much code? I just tried adding the > '?' at the end, in front of the '$' and it still doesn't work. > Where would I make a change to yours in order to get 4 positions for year? > >Kenn >LBNL Kenn,

[rt-users] RT 3.6.6 on ubuntu 7.10

2008-03-11 Thread andywenaas
I am having a problem with rt-mailgate I am using ubuntu 7.10.. mysql as the database server and postfix for emails I have my aliases set up as rt: "|/etc/request-tracker3.6/rt-mailgate --queue general --action correspond --url http://localhost/rt"; rt-comment: "|/etc/request-tracker3.6/rt-mail

Re: [rt-users] RT freezes on some big tickets

2008-03-11 Thread Kenneth Marshall
Welcome to the world of stateless page loads. :) The only suggestions that I have are in two areas. Can you modify the page load to skip the un-interesting transactions/attachments? We had to do that here with system events (not attachments) and added a brief/full button on the history. The defaul

[rt-users] updating attachments

2008-03-11 Thread Benjamin Weser
Hi list, since I haven't found an answer in the mailing list or the wiki and can't think of a good solution myself I have to ask you all: Is there a possibility to update attachments instead of adding new versions all the time? Background: My boss intends to attach more or less often changed