Re: [rt-users] Move ticket queue on date expiry

2010-09-02 Thread Tom Lanyon
On 03/09/2010, at 5:59 AM, Gareth Tupper wrote: That sounds great. Currently, I can build a search that says: Status != 'resolved' AND LastUpdated '2010-09-02' What's the correct syntax for something like: Status != 'resolved' AND LastUpdated (TODAY-3) RT uses Perl's Time::ParseDate

[rt-users] Inter-RT dependencies

2009-07-03 Thread Tom Lanyon
Hi list, RT::URI *appears* to have all the bits to do external links - is anyone here doing any linking (eg. dependencies) between different RT instances or know if it works at all? Regards, Tom ___

Re: [rt-users] RFC: Optional extra fields in ticket creation?

2008-08-18 Thread Tom Lanyon
On 18/08/2008, at 9:23 PM, Richard Hartmann wrote: Hi all, when I create tickets, I usually need to go to the ticket just created and assign it a priority various dependencies. What I would love to have is one of those up/down arrows to click upon which then fold a few extra fields in/out

Re: [rt-users] 3.8.1

2008-08-17 Thread Tom Lanyon
On 18/08/2008, at 5:16 AM, Helmuth Ramirez wrote: So there's a lot of 3.8.1 talk lately. Should I wait to go live on 3.8.1 in lieu of 3.8? Are there that many enhancements/improvements fro 3.8? Cheers Helmuth There's a pile of bug fixes, as far as I can see; it seems to be only days

Re: [rt-users] Changing Symbols in Ticket Reference in Subject Line

2008-08-04 Thread Tom Lanyon
On 05/08/2008, at 2:17 AM, Phillip Tan wrote: Was wondering if the system can be configured to accept a different symbol (i.e. other than '#' prefix) in the ticket reference used in the subject line? Hi Phillip, Only if you override RT/Interface/Email.pm's ParseTicketId() method, I

Re: [rt-users] RT + relay

2008-08-04 Thread Tom Lanyon
On 05/08/2008, at 8:44 AM, Chaim Rieger wrote: Jerrad Pierce wrote: add cambenergy.org to mydestinations that will keep the emails going to [EMAIL PROTECTED] local But all @cambenergy.org (except explicitly configured for local delivery) are supposed to be relayed, hence the lack of

Re: [rt-users] Problems installing RT 3.8 on Centos 5.2 with FastCGI

2008-08-01 Thread Tom Lanyon
for mod_fastcgi-2.4.6 off-list if you need (100k each). Regards, Tom -- Tom Lanyon Systems Administrator NetSpot Pty Ltd ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support

Re: [rt-users] Any BenchMarkings??

2008-08-01 Thread Tom Lanyon
. Regards, Tom -- Tom Lanyon Systems Administrator NetSpot Pty Ltd ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets

Re: [rt-users] Automatically opening stalled RT tickets

2008-07-21 Thread Tom Lanyon
On 22/07/2008, at 9:58 AM, Ryan Hardester wrote: I tried this, put the PM in the correct folder, and ran the script. I get the following error under RT3.8.0 [Tue Jul 22 00:37:05 2008] [crit]: Can't call method Message on an undefined value at /opt/rt3/bin/../lib/RT/Action/AutoOpen.pm line

Re: [rt-users] Automatically opening stalled RT tickets

2008-07-20 Thread Tom Lanyon
, ); $self-TicketObj-Comment( Content = $self-Argument, ); return(1); } =head1 DESCRIPTION A slight modification to the AutoOpen action, so that we can change the Transaction 'Data' field and Comment on the ticket. =head1 AUTHOR Tom Lanyon =cut 1

Re: [rt-users] Performance Issues after 3.8.0 upgrade -- PostgreSQL delays

2008-07-17 Thread Tom Lanyon
For what its worth, I believe this is a big performance hit on RT 3.6.x too, so I'd recommend fixing rather than downgrading. :) I witnessed this query with a high execution rate on RT 3.6.1. On 17/07/2008, at 1:28 PM, Jessie Bryan wrote: Update- Ok, after several hours of logging, what

Re: [rt-users] RT Ticket creation

2008-07-03 Thread Tom Lanyon
On 03/07/2008, at 10:20 PM, Caglar wrote: Hello everybody, I have just started to develop a web application with RT. But I have some problems that I couldn't solve . I will be so grateful to you, if anyone can help me. I have a php form in which users enter an incident and submit

Re: [rt-users] Automating mail alias on queue creation

2008-07-03 Thread Tom Lanyon
On 04/07/2008, at 1:59 AM, Damon Miller wrote: Hi all. I'm trying to automate email alias creation and deletion based on queue actions in RT and I'm wondering if anyone out there has any thoughts or suggestions. Basically the situation is this: I'm planning to offer RT instances to a

Re: [rt-users] Trouble with LDAP authentication (equivalent config)

2008-07-02 Thread Tom Lanyon
On 02/07/2008, at 10:43 PM, mailing list wrote: --- On Tue, 7/1/08, Tom Lanyon [EMAIL PROTECTED] wrote: Do you have SELinux enabled? Check your /var/log/audit/audit.log for any 'denied' messages and repair them. You might need to create a policy which allows Apache (mod_perl) or FastCGI

Re: [rt-users] Trouble with LDAP authentication (equivalent config)

2008-07-01 Thread Tom Lanyon
On 02/07/2008, at 8:27 AM, mailing list wrote: RT 3.6.4 on redhat linux 4.6 I am attempting to setup a development RT site. The current issue I'm running into is getting the dev. RT to authenticate against LDAP. I have compared my RT_SiteConfig.pm between dev. and production RT

[rt-users] Difference in time zone handling between database, 3.6 and 3.8

2008-06-30 Thread Tom Lanyon
Hi all, I'm running some searches to find tickets from a certain queue which were created in February but having some strange issues with time zones. Assuming that the 'created' column in the database is UTC (which it seems to be), querying the database directly tells me there was 816

Re: [rt-users] rt-3.8.0rc testing on same pc running rt-3.6

2008-06-24 Thread Tom Lanyon
On 24/06/2008, at 4:19 PM, [EMAIL PROTECTED] wrote: Hi, I was wondering if I can install a test instance of rt-3.8.0rcX on the same computer running our production rt-3.6.3? Gordon You can, but I'd advise against it since an unrelated 3.8 crash could take down your production instance.

Re: [rt-users] Dependencies, Status and visibility.

2008-06-23 Thread Tom Lanyon
On 23/06/2008, at 7:41 PM, Roger Gammans wrote: Hi I want to make it easy to pick out the tickets which are in workable on more easily as many of our tickets are stalled waiting other tickets, among other things (such as more correspondence, or an customer appointment). In some cases this

Re: [rt-users] how to add ability to escalate to another queue

2008-06-23 Thread Tom Lanyon
On 23/06/2008, at 11:20 PM, slamp slamp wrote: Has anyone done this? We have this requirement in our workflow. I'm just about to implement this on our dev environment. We are planning on adding a button marked 'Escalate' which will create a *new* ticket in the next Queue and add it as a

Re: [rt-users] RT 3.8 beta 2 now available

2008-06-23 Thread Tom Lanyon
On 18/06/2008, at 10:50 PM, Ruslan Zakirov wrote: I think this has been fixed in RC1 jesse released several days ago. Fantastic! Thanks guys, 3.8.0rc2 now works with perl 5.10.0. Regards, Tom ___

Re: [rt-users] Sort by DueDate excluding 'not set' tickets

2008-06-19 Thread Tom Lanyon
On 17/06/2008, at 10:48 PM, Jason Fenner wrote: It looks like you have two options: 1) You can add to your search/query a line that says 'Due 0' What this will do is only return results that have a due date set, it will not return results without a due date set. You could then run a

Re: [rt-users] Performance Issues

2008-06-19 Thread Tom Lanyon
On 18/06/2008, at 11:43 PM, David Nalley wrote: Hey guys, I am running a pilot installation of RT and experiencing some performance anomalies A bit about the environment: RT 3.6.6 on CentOS 5, using mod_perl against Postgres 8.1. Postgres and RT on separate boxes, and are on the same

[rt-users] Sort by DueDate excluding 'not set' tickets

2008-06-16 Thread Tom Lanyon
Hi all, I need to sort tickets by due date ascending to display oldest due dates first. Tickets with no due date should come after as there's no impending timeline. However, because a due date of 'not set' is numerically 0, it sorts before any tickets that have a due date set. Anyone have

Re: [rt-users] Per-queue page customisations?

2008-05-28 Thread Tom Lanyon
On 28/05/2008, at 10:42 PM, Stephen Turner wrote: We've implemented this by using Attributes to store queue preferences. You can attach Attribute objects to most RT objects (Tickets, Queues etc.) - in this case you'd attach them to your Queue objects. For example, you could choose an

Re: [rt-users] Per-queue page customisations?

2008-05-27 Thread Tom Lanyon
On 27/05/2008, at 11:25 PM, Todd Chapman wrote: The queue is known once you get to the ticket Create page, so the template can have logic to display fields based on the queue. Thanks, that's what I figured the solution was going to be; just one big Create.html with lots of logic depending

Re: [rt-users] Per-queue page customisations?

2008-05-27 Thread Tom Lanyon
On 27/05/2008, at 11:24 PM, Roedel, Mark wrote: Well, queue-specific custom fields are added to the create-ticket layout based on the queue you selected. Based on that, I'd say that the best-case scenario is that your requirements can be met by configuring custom fields for those

Re: [rt-users] Per-queue page customisations?

2008-05-27 Thread Tom Lanyon
We do that at the moment but it has a lot of logic that we would like to bring into RT itself to keep it as a single system. Thanks, Tom On 28/05/2008, at 11:15 AM, [EMAIL PROTECTED] wrote: Alternatively you could have a custom web form for creating tickets in a particular queue and

Re: [rt-users] RT 3.8 beta 2 now available

2008-05-21 Thread Tom Lanyon
On 20/05/2008, at 5:42 PM, Tom Lanyon wrote: On 20/05/2008, at 2:05 PM, Jesse Vincent wrote: Jesse Jesse, It seg faults for me on a dev box, RedHat Enterprise Linux 5 with Perl 5.10.0. This box was successfully running 3.6.6 with no issues and only had a few dependencies which

Re: [rt-users] RT 3.8 beta 2 now available

2008-05-20 Thread Tom Lanyon
On 20/05/2008, at 2:05 PM, Jesse Vincent wrote: Jesse Jesse, It seg faults for me on a dev box, RedHat Enterprise Linux 5 with Perl 5.10.0. This box was successfully running 3.6.6 with no issues and only had a few dependencies which needed upgrading to pass a 3.7.85 'make

Re: [rt-users] RT with phone support?

2008-05-19 Thread Tom Lanyon
On 19/05/2008, at 5:23 PM, Ricky Jelm wrote: Hello, We are evaluating several ticketing systems and came across RT. Our agents usually get the tickets by phone and I've seen RT is especially set up as a mail gateway. I've found this thread but it's quite old:

Re: [rt-users] RT 3.8 beta 2 now available

2008-05-18 Thread Tom Lanyon
On 08/05/2008, at 6:35 AM, Jesse Vincent wrote: We've integrated about 350 changes to RT in the last two months as part of the big push toward RT 3.8.0. Many of those changes were made to integrate features Best Practical has built or prototyped for clients over the past several years.

[rt-users] Anyone seen RT used as a service catalog?

2008-05-17 Thread Tom Lanyon
dependency links (some of these could be done in parallel, but some need to be done sequentially -- ie. we need to wait before the new web server arrives before we can configure it!) Any input appreciated. Regards, Tom -- Tom Lanyon Systems Administrator NetSpot Pty Ltd

Re: [rt-users] Multiple faces for single queue?

2008-04-22 Thread Tom Lanyon
/2008 8:08 PM, Tom Lanyon wrote: Hi list, Is there an existing solution to have a single queue (used for product support) to be used for multiple clients? In our case, different clients require different support email addresses and ticket auto- response messages, but all other queue

[rt-users] Multiple faces for single queue?

2008-04-21 Thread Tom Lanyon
Hi list, Is there an existing solution to have a single queue (used for product support) to be used for multiple clients? In our case, different clients require different support email addresses and ticket auto- response messages, but all other queue behavior, watchers, scrips etc is the

[rt-users] Bounces back to tickets?

2008-03-17 Thread Tom Lanyon
List, Emails coming from RT have a Return-Path of our postmaster, so bounced messages are sent there. Has anyone redirected these bounce messages back into RT to be added as comments/correspondence onto the related ticket? Any side-effects or issues that we should be wary of? Regards, Tom

Re: [rt-users] Bounces back to tickets?

2008-03-17 Thread Tom Lanyon
On 18/03/2008, at 12:28 AM, Vivek Khera wrote: On Mar 17, 2008, at 8:22 AM, Tom Lanyon wrote: Has anyone redirected these bounce messages back into RT to be added as comments/correspondence onto the related ticket? Any side-effects or issues that we should be wary of? http

[rt-users] Possible to extract 'To:' mail field?

2008-03-02 Thread Tom Lanyon
Greetings, For a queue which has multiple email addresses reaching it, we wish to pull out statistics of which addresses are being used and set up some custom fields based on it. I could do this via a few extensions to rt-mailgate, but was wondering if there's any way to extract the

[rt-users] TicketSQL for HasMember?

2008-02-28 Thread Tom Lanyon
Hi List, Can I add a clause to my Ticket SQL query to say has a dependancy ? I am searching for tickets but do not want to return ones that depend on another. Thanks, Tom -- Tom Lanyon Systems Administrator NetSpot Pty Ltd ___ http

Re: [rt-users] Generate a billing report?

2008-02-28 Thread Tom Lanyon
___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Tom Lanyon

Re: [rt-users] TicketSQL for HasMember?

2008-02-28 Thread Tom Lanyon
On 29/02/2008, at 1:18 PM, Tom Lanyon wrote: Hi List, Can I add a clause to my Ticket SQL query to say has a dependancy ? I am searching for tickets but do not want to return ones that depend on another. Thanks, Tom I've tried Queue = 'General' AND HasMember IS NOT NULL as indicated

Re: [rt-users] monitoring RT

2007-07-24 Thread Tom Lanyon
/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Tom Lanyon Systems Administrator NetSpot Pty Ltd

Re: [rt-users] RT 4

2007-05-24 Thread Tom Lanyon
. -- Tom Lanyon Systems Administrator NetSpot Pty Ltd ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT

Re: [rt-users] RT 4

2007-05-24 Thread Tom Lanyon
On 25/05/2007, at 11:10 AM, Mathew Snyder wrote: - Customer database and the ability to track tickets per customer But this is what RT does anyway RT is currently *not* a customer database, it is a ticketing system. We are getting pressured to move to systems like NetSuite or SugarCRM

Re: [rt-users] RT 4

2007-05-24 Thread Tom Lanyon
On 25/05/2007, at 11:27 AM, Kelly F. Hickel wrote: No, it doesn't. It tracks by a user. Customers (often) have many users. This is (to me) the same thing as discussed in the Customer Centric RT thread recently. For instance, our customers may have several installations of our product, on

Re: [rt-users] Google Summer of Code

2007-03-05 Thread Tom Lanyon
Jan Korbel wrote: Yes, reporting would be fine. J. Ole Craig wrote: On Wed, 2007-02-28 at 16:23 -0500, Matthew Keller wrote: Billing and accounts. O:-) And real reporting, output to PDF or HTML, with the ability to automate scheduled emails of reports to the pointy-haired. I've got on

Re: [rt-users] Errors when using CustomFields

2006-11-13 Thread Tom Lanyon
Tom Lanyon wrote: Hi List, We seem to be having issues with our production RT 3.6.1 instance when using CustomFields. Everything works perfectly if we don't set a value for a custom field, but as soon as you try to create a ticket with a value for one of the custom fields we get a Ticket