Re: [rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread Ruslan Zakirov
Probably pointing managament at the following tutorial will help speed upgrade: http://blog.bestpractical.com/2009/02/rt-38-tutorial-dashboards.html On Fri, Aug 28, 2009 at 2:28 AM, Kimberly McKinnis wrote: > Cool. We're using 3.4.5, I don't see a dashboard, but this may be an excuse > for an up

Re: [rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread Allen
> anyone had written a reporting script that did something such as listing the > numbers and subjects of all open > and new tickets Our PMs would like to have this info automated and emailed Why not use the "Dashboards" that are already built into RT? Click "Tickets" do create a search for n

Re: [rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread Kimberly McKinnis
Cool. We're using 3.4.5, I don't see a dashboard, but this may be an excuse for an upgrade. Thanks guys :) -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of spark Sent: Thursday, August 27, 2009 3:21 PM Cc: rt

Re: [rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread spark
Hi Kimberly, We use dashboards to automate the emailing of new/open lists each morning. Perhaps that might work for you? - Sean Kimberly McKinnis wrote: > I guess I should be more specific. Our PMs would like to have this info > automated and emailed, instead of cutting and pasting it from the

Re: [rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread Jerrad Pierce
On Thu, Aug 27, 2009 at 18:14, Kimberly McKinnis wrote: > I guess I should be more specific. Our PMs would like to have this info > automated and emailed, instead of cutting and pasting it from the query > builder in RT. Thanks! So they want to use a dashboard. Point them at it (assuming you're u

Re: [rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread Kimberly McKinnis
I guess I should be more specific. Our PMs would like to have this info automated and emailed, instead of cutting and pasting it from the query builder in RT. Thanks! -Original Message- From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com] Sent: Thursday, August 27, 2009 3:10 PM To: Ki

Re: [rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread Ruslan Zakirov
Hello Kimberly, Do you need script? In the RT web ui you can use Charts for that. As well, you can re-use code from the latest version of share/html/Search/Elements/Chart my $Query = "Queue = 'X'"; use RT::Report::Tickets; my $tix = RT::Report::Tickets->new( $session{'CurrentUser'} ); my ($coun

[rt-users] Reporting: List of new/open tickets?

2009-08-27 Thread Kimberly McKinnis
Before I attempt to reinvent the wheel, I was wondering if anyone had written a reporting script that did something such as listing the numbers and subjects of all open and new tickets. I found something on the wiki, but it requires manual input of ticket numbers. I also have some rudimentary s

Re: [rt-users] HELP with RT API

2009-08-27 Thread Ken Crocker
Jerrad, DUH!! I changed it, same results. By the way, When I look for results, I use both SQL Navigator to look at the records in the database (dates always show January 1970) AND I also use RT Query and the dates are alway "Not Set". Kenn LBNL On 8/27/2009 11:44 AM, Jerrad Pierce wrote: > Yo

Re: [rt-users] HELP with RT API

2009-08-27 Thread Jerrad Pierce
You resolved date has a typo (zero instead of dash) But maybe try banging around with it for awhile rather than giving us the play by play? As for warning out, reread my previous message, I explained what I was and gave you code to do it. It's not high-tech, but liberal prints (or warns for stuff

Re: [rt-users] HELP with RT API

2009-08-27 Thread Ken Crocker
Kevin, OK. I changed the code to this: #-- # build ticket values #-- %ticket_vals = ( Subject => $ISSUE_DESCRIPTION,

[rt-users] contrib Censorware delete-transaction script errors

2009-08-27 Thread Allen
I am on 3.8.4 trying to use Jesse's delete-transaction script written in 2001 from http://download.bestpractical.com/pub/rt/contrib/3.0/Other/Censorware/delete-transaction the purpose of the script is to edit a transaction to redact all info from it (whether file Attachment, Comment, or Reply) for

Re: [rt-users] HELP with RT API

2009-08-27 Thread Kevin Falcone
On Thu, Aug 27, 2009 at 10:58:52AM -0700, Ken Crocker wrote: >Kevin, > >When I used "hard-coded" dates this is what I get: Kenn I just wrote and ran this: my ($id, $msg) = $Ticket->Create( Queue => 'General', Subject => 'test manual creation', Started =

Re: [rt-users] HELP with RT API

2009-08-27 Thread Ken Crocker
Kevin, Jerrad, In the beginning of my program, I have this: use strict; use lib "/apps/rt/rt/perl/lib"; use lib "/apps/rt/rt/lib"; use RT; use RT::Ticket; use RT::Transaction; use RT::Attachment; use MIME::Entity; Do I need something else? Like :use RT::Date;" or something like that? Kenn LB

[rt-users] How to create user and assign it to a group with CLI

2009-08-27 Thread mezgani ali
Hi, Well i'm trying to create a user from the command line like this: $ export RTUSER="rtuser" $ export RTPASSWD="rtpassword" $ export RTSERVER="http://rt.domain.tld/"; $ rt create -t user set username=test emailaddress=t...@domain.tldpassword=testpwd Lang='fr' The user test is create with succe

Re: [rt-users] HELP with RT API

2009-08-27 Thread Ken Crocker
Jerrad, I still do not understand. I'm not much at Perl, so I don't know how to translate that term into a line of code. I printed out the values but I have no idea of how to "warn" a data field. Kenn LBNL On 8/27/2009 11:02 AM, Jerrad Pierce wrote: Nothing in those messages syas I have

Re: [rt-users] E-Mail to Queue Doesn't Generate Outbound Notifications

2009-08-27 Thread Tim Gustafson
> Yep. Do you have notification scrips set up for your > watchers (AdminCc, Cc) in that Queue and are those > scrips enabled? I do now. :) The problem was, generally, that I inherited this system from someone who abruptly disappeared and didn't leave any documentation. He had each queue set u

Re: [rt-users] HELP with RT API

2009-08-27 Thread Jerrad Pierce
>Nothing in those messages syas I have a code problem or anything. You > have the code (attached >in last note). The code seems simple enough, I just can't seem to see the > problem. No he means using warn($data) so that it gets logged -- Cambridge Energy Alliance: Save money. Save the pl

Re: [rt-users] E-Mail to Queue Doesn't Generate Outbound Notifications

2009-08-27 Thread Ken Crocker
Tim, Yep. Do you have notification scrips set up for your watchers (AdminCc, Cc) in that Queue and are those scrips enabled? Kenn LBNL On 8/27/2009 9:59 AM, Tim Gustafson wrote: > Hi, > > I have a web form that is sending an e-mail directly to an RT Queue address. > Tickets are being created

Re: [rt-users] HELP with RT API

2009-08-27 Thread Ken Crocker
Kevin, When I used "hard-coded" dates this is what I get: -bash-3.00$ ./RT-TravelConversion.pl Use of uninitialized value in concatenation (.) or string at /apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 35. Use of uninitialized value in concatenation (.) or string at /apps/rt/rt-3.6.4/etc/RT_Site

[rt-users] E-Mail to Queue Doesn't Generate Outbound Notifications

2009-08-27 Thread Tim Gustafson
Hi, I have a web form that is sending an e-mail directly to an RT Queue address. Tickets are being created based on those e-mails, but no messages are being sent out to the queue watchers when the new ticket is created. There is nothing in the ticket history that says any attempt to send out

Re: [rt-users] HELP with RT API

2009-08-27 Thread Kevin Falcone
On Thu, Aug 27, 2009 at 08:52:21AM -0700, Ken Crocker wrote: >Kevin, > >My log has been on and it gives no errors. This is it (for a small file > for testing): > >-bash-3.00$ ./RT-TravelConversion.pl >Use of uninitialized value in concatenation (.) or string at >/apps/rt/rt-3

Re: [rt-users] HELP with RT API

2009-08-27 Thread Ken Crocker
Kevin, My log has been on and it gives no errors. This is it (for a small file for testing): -bash-3.00$ ./RT-TravelConversion.pl Use of uninitialized value in concatenation (.) or string at /apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 35. Use of uninitialized value in concatenation (.) or str

[rt-users] Search results filtered (queue permission)

2009-08-27 Thread Tassni Eunice Miguel Lopes Cançado
Hi. When I search something and don't include the queue in search terms', RT shows "Found N tickets", but lists only M (M < N). This probably was happening because I don't have permission on the N-M tickets' queues. Is there a way to change de order of the result, "filter queues -> search" instead

Re: [rt-users] No permission to view ticket after requeue

2009-08-27 Thread Kevin Falcone
On Thu, Aug 27, 2009 at 11:25:52AM +0100, Ray Horne wrote: > I have 2 users each of whom wants to be able to only see tickets in the > queue they look after. Each of them needs however to be able to requeue into > the other queue. To achieve this I've granted them both SeeQueue globally, > but Show

Re: [rt-users] HELP with RT API

2009-08-27 Thread Kevin Falcone
On Wed, Aug 26, 2009 at 01:50:36PM -0700, Ken Crocker wrote: >Kevin, > >I hate to bug you, but I went to your link and saw some code. I'm not a > big perl guy (I can >code some simple scrips, etc.) so some of it confuses me. Attached is the > program I've been >speaking of. I put

[rt-users] No permission to view ticket after requeue

2009-08-27 Thread Ray Horne
I have 2 users each of whom wants to be able to only see tickets in the queue they look after. Each of them needs however to be able to requeue into the other queue. To achieve this I've granted them both SeeQueue globally, but ShowTicket only on the queue they look after. This works fine but after