[rt-users] CommandByMail

2009-02-12 Thread hanane ourdani
Hi all, *Since the Queue contains mandatory fields, if these fields are not filled (fill in the e-mail or rather empty), the ticket will not be created. Is there a way to notify the person who sends the mail that his application has not been created?* Thank you,

[rt-users] Content broken on latest RTFM

2009-02-12 Thread David Gubler
Hi all I'm trying to migrate from an old server to a fresh installation on a new server. Old server: Debian etch Package request-tracker3.4 Version 3.4.5 Package rtfm Version 2.0.3 MySQL 5.0 New Server: Debian etch Package request-tracker3.6 Version 3.6.1 RTFM

Re: [rt-users] Content broken on latest RTFM

2009-02-12 Thread David Gubler
Hi Simon Thanks for your response, it got me on the right path: We have an RTFM class FAQ which has two custom fields. For some reason these got disabled during the migration, all I had to do is to reactivate them using the RT GUI and the root account. Thanks again and best regards, David

Re: [rt-users] tracking tickets which have been replied to?

2009-02-12 Thread Sven Sternberger
Hi! On Mi, 2009-02-11 at 14:17 -0800, Jo Rhett wrote: Okay, this is so obvious of a requirement in a ticket system that I've been spinning in circles assuming I'm overlooking something. However, I haven't found it, so could someone please clue me in how to do this? I have exactly the same

Re: [rt-users] Reminders still open after a ticket is closed

2009-02-12 Thread Roedel, Mark
That part of it looks OK to me. I recently had a problem with a similarly-structured scrip that didn't seem to be firing. It turned out to be because I'd left the Custom Action Preparation Code field blank. When I put a return 1; into that field, it started behaving as expected. --

[rt-users] User defined Condition: Autoclose

2009-02-12 Thread Asif Iqbal
How do I define a condition where requestor address is 'u...@example' com? I will use this condition to close a ticket In chapter 6.1.3 Conditions of RT Essentials by Oreilly I see something like this $self-TicketObj-status eq 'deleted'; and my $email = $self-TicketObj-RequestorAddresses[0]

Re: [rt-users] User defined Condition: Autoclose

2009-02-12 Thread Asif Iqbal
On Thu, Feb 12, 2009 at 1:17 PM, Asif Iqbal vad...@gmail.com wrote: How do I define a condition where requestor address is 'u...@example' com? I will use this condition to close a ticket In chapter 6.1.3 Conditions of RT Essentials by Oreilly I see something like this $self-TicketObj-status

Re: [rt-users] Query to get watchers of Qs.

2009-02-12 Thread Rana Tanveer
Hi Torsten BrummThanks for your resopnse. but i need simple SQL query to get watchers from RT Database. my requirement is specific, because i am also creating monitoring script for my RT Service. Again i want to mention, i am using RT 3.8.1. could anyone have this query. I read the stuff on

Re: [rt-users] User defined Condition: Autoclose

2009-02-12 Thread Asif Iqbal
On Thu, Feb 12, 2009 at 2:02 PM, Asif Iqbal vad...@gmail.com wrote: On Thu, Feb 12, 2009 at 1:17 PM, Asif Iqbal vad...@gmail.com wrote: How do I define a condition where requestor address is 'u...@example' com? I will use this condition to close a ticket In chapter 6.1.3 Conditions of RT

Re: [rt-users] User defined Condition: Autoclose

2009-02-12 Thread Potla, Ashish Bassaliel
Try this in the custom condition: if ( $self-TicketObj-RequestorAddresses eq 'vad...@gmail.com') { return 1; } esle { return 0; } -Ashish From: rt-users-boun...@lists.bestpractical.com [rt-users-boun...@lists.bestpractical.com] On Behalf Of Asif Iqbal

[rt-users] Link Relationships Missing: RT 363 to 380 or 382

2009-02-12 Thread O'Leary, Paul
Hello I am trying to upgrade from 3.6.3 to 3.8 or 3.8.2. I initially tried going to 380, using the a copy of the same database that 363 was using in Oracle. I ran the database upgrade scripts fine, and was able to connect to it fine and do just about everything. I say just about, as I noticed

[rt-users] global default auto-refresh patch for 3.8.2

2009-02-12 Thread Jo Rhett
This patch is adapted from something Ian posted for 3.6.4 adapted for 3.8.2. Jesse, please consider adopting this for the mainline as it is a popular question and this patch allows the person to override the default. --- html/autohandler_orig2009-02-12 11:31:49.0 -0800 +++

Re: [rt-users] Convert Bugzilla to RT3

2009-02-12 Thread Keith A McDermott
Trying to bring this back since the list is a bit more active than the last time i asked... :-) Anyone have success importing bugzilla data into RT 3.8.x? I have a script from the archives, but it's from a good three years ago and the original creator's company has been bought out by Sun.

[rt-users] change updates from unprivileged user to a different transaction type?

2009-02-12 Thread Jo Rhett
Jesse, how would you feel about having an action which indicates an update not by a privileged user? Ie, Correspond and Comments would be from privileged. Update or Response (or any other name you like) would be an update from an unprivileged user. This kind of change would make it easy to

Re: [rt-users] global default auto-refresh patch for 3.8.2

2009-02-12 Thread Kevin Falcone
On Feb 12, 2009, at 2:43 PM, Jo Rhett wrote: This patch is adapted from something Ian posted for 3.6.4 adapted for 3.8.2. Jesse, please consider adopting this for the mainline as it is a popular question and this patch allows the person to override the default. Since 3.8 added user

[rt-users] Asset shredder not working in 3.8.x

2009-02-12 Thread Peter Boguszewski
I posted twice to the code.google.com site but thought this would be a better forum to see if anyone is having the same issues that I am. Background: we have been using RT and AT for a couple of years now and the shredder for tickets and assets worked until the update to 3.8.x. I am

Re: [rt-users] global default auto-refresh patch for 3.8.2

2009-02-12 Thread Jo Rhett
On Feb 12, 2009, at 2:43 PM, Jo Rhett wrote: This patch is adapted from something Ian posted for 3.6.4 adapted for 3.8.2. Jesse, please consider adopting this for the mainline as it is a popular question and this patch allows the person to override the default. On Feb 12, 2009, at 12:12 PM,

Re: [rt-users] global default auto-refresh patch for 3.8.2

2009-02-12 Thread Kevin Falcone
On Feb 12, 2009, at 3:19 PM, Jo Rhett wrote: On Feb 12, 2009, at 2:43 PM, Jo Rhett wrote: This patch is adapted from something Ian posted for 3.6.4 adapted for 3.8.2. Jesse, please consider adopting this for the mainline as it is a popular question and this patch allows the person to

[rt-users] displaying query builder screen taking forever

2009-02-12 Thread Gary Lon Brown
We've been on RT 3.8.0 now since Nov. 2008. In the last couple of weeks, whenever you try and go to the query builder screen, it causes mysqld to take 100% of the cpu for several minutes before displaying the query builder screen. Any idea what could cause that all of a sudden? Some suspect

[rt-users] GIS Software

2009-02-12 Thread Jerrad Pierce
Options: Free software: It looks like the free software I had in mind will work. It's less sophisticated though, and we may eventually run up against some limitations. Few people are likely to be initially familiar with it either, but that may or may not be a problem. ESRI pay: $1,500 per

[rt-users] Make non-custom field mandatory

2009-02-12 Thread Brown, Matt A.
Long time lurker, first time poster. Does anyone know if there's a way to make the standard Worked field on a ticket update a Mandatory field? People are forgetting to enter their time worked on certain projects, and it's making our project billing process inaccurate. I know this can be done

Re: [rt-users] GIS Software

2009-02-12 Thread Jerrad Pierce
Apologies, somehow google apps mixed up the recipients of the multiple drafts I was composing. -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help:

Re: [rt-users] Make non-custom field mandatory

2009-02-12 Thread Jerrad Pierce
On Thu, Feb 12, 2009 at 15:52, Brown, Matt A. matt.br...@pearson.com wrote: Does anyone know if there's a way to make the standard Worked field on a ticket update a Mandatory field? People are forgetting to enter their time worked on certain projects, and it's making our project billing

Re: [rt-users] Query to get watchers of Qs.

2009-02-12 Thread Rana Tanveer
Hi All again I have write Below Query, and is working for me, posting here for community review and sugessions. SELECT DISTINCT Queues.id AS Q_ID, Groups.id AS R_Gr_ID, Groups.Type As Gr_Type, CachedGroupMembers.MemberId AS RoleMember_id, Principals.PrincipalType AS PrincipalType, Users.Name AS