[rt-users] Customer Integration

2009-03-13 Thread Jnaneshwar Bantanur
Hi All, Can any buddy please help me out.How to use RT customer Integration.Can I try this way ! I will create a new queue for each customer.And the assigned internal users will be same for all the queues and permissions etc remains the same.Even I want provide a login for each customer

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-13 Thread Kenneth Marshall
On Fri, Mar 13, 2009 at 12:42:11AM +, Kristian Davies wrote: On Thu, Mar 12, 2009 at 1:51 PM, Kenneth Marshall k...@rice.edu wrote: On Thu, Mar 12, 2009 at 08:44:23AM -0500, Kenneth Marshall wrote: Kristian, I think the problem is in SearchBuilder/Handle.pm in the function

[rt-users] new release for RTx::Calendar and RTx::EmailCompletion

2009-03-13 Thread Nicolas Chuche
I've just upload on cpan new version of those two RT plugins. See below for changes. As I no longer work as a sysadmin, I no longer work daily with RT (but I enjoy the SelfService access :)). I will try to maintain thoses modules but with far less time to do that so if someone is interessed in

[rt-users] Adding Custom fields to RT at a Glance

2009-03-13 Thread Simon Dray
RT Version 3.8.2 I would like to be able to display in Highest priority tickets (RT at a Glance) a custom filed (Severity) I have looked at the work done by others but nothings seems to be upto date with 3.8.2, does anyone have a recipe or code to do this please. Regards Simon

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-13 Thread Kristian Davies
It does sound like something is missing because I am running PostgreSQL 8.3.5 and did not have to make these changes. I do have a question, why are you converting your RT instance to MySQL? Is there a particular problem you are trying to address? No technical reason, we are a essentially a

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-13 Thread Kenneth Marshall
On Fri, Mar 13, 2009 at 02:10:08PM +, Kristian Davies wrote: It does sound like something is missing because I am running PostgreSQL 8.3.5 and did not have to make these changes. I do have a question, why are you converting your RT instance to MySQL? Is there a particular problem you

[rt-users] Search results being filtered after they are generated?

2009-03-13 Thread Jon Baker
This may be already addressed but I can't find it in the archives and it's driving the heck out of me, especially as we expand RT into more departments and fine tune access restrictions. The most obvious place it seems to happen is on the X newest unowned tickets - this list appears to be

Re: [rt-users] Search results being filtered after they are generated?

2009-03-13 Thread Ruslan Zakirov
UseSQLForACLChecks On Fri, Mar 13, 2009 at 5:45 PM, Jon Baker jba...@wgm.us wrote: This may be already addressed but I can't find it in the archives and it's driving the heck out of me, especially as we expand RT into more departments and fine tune access restrictions. The most obvious place

Re: [rt-users] Search results being filtered after they are generated?

2009-03-13 Thread Jon Baker
Ok, this at first appeared to work - but after a few minutes I got a call that the quick search wasn't working as expected. I have users defined in groups for AdminCC's of some queues. Before, the quick search list correctly showed, let's say, 15 open tickets in the IT queue. Of those 15

Re: [rt-users] Search results being filtered after they are generated?

2009-03-13 Thread Ruslan Zakirov
How ShowTicket right is assigned to AdminCc? Is it global or it's on queue? Can you list all points where ShowTicket right is assigned, so I can try to reproduce it locally? On Fri, Mar 13, 2009 at 7:28 PM, Jon Baker jba...@wgm.us wrote: Ok, this at first appeared to work - but after a few

Re: [rt-users] Search results being filtered after they are generated?

2009-03-13 Thread Jon Baker
ShowTicket is assigned only at global:AdminCc. There are no rights assigned at the queue level. On Mar 13, 2009, at 11:38 AM, Ruslan Zakirov wrote: How ShowTicket right is assigned to AdminCc? Is it global or it's on queue? Can you list all points where ShowTicket right is assigned, so I

Re: [rt-users] How to get tickets with nested SQL select statement

2009-03-13 Thread Simon Lane
I must be doing something wrong. My initial query manually returns: ID -- 4346 4359 4486 4534 4535 4600 4346 4359 4486 4534 When I run the code as follows, I don't seem to get anything: my $sth =

Re: [rt-users] How to get tickets with nested SQL select statement

2009-03-13 Thread Ruslan Zakirov
SimpleQuery does binding for you, -SimpleQuery(... WHERE x = ? ..., $binding, $another_one_binding); So sth you get is ready for fetching. If sth is not true value then it's an error. On Fri, Mar 13, 2009 at 7:52 PM, Simon Lane sl...@cedvalinfo.com wrote: I must be doing something wrong.  My

Re: [rt-users] Search results being filtered after they are generated?

2009-03-13 Thread Ruslan Zakirov
What about other ways people get ShowTicket right? Also very important thing. Have you used rt-validator with --resolve option enabled on this DB? If yes then delete user from group, add back, restart server and test. There is bug that may delete required records from CGM table in rt-validator.

[rt-users] using custom field value in scrip condition

2009-03-13 Thread Paul Vlaar
I'm trying to make an autoreply trigger by a custom field value that applies to a Queue, not a ticket, as I want this value to be the same on all newly created tickets. This is what I've tried so far, but it's not being triggered: Condition: User Defined Action: Autoreply To Requestors Template:

[rt-users] Advice for New Machine

2009-03-13 Thread Kenneth F Crocker
To all (especially Jesse and Ruslan), I have been given the opportunity to have a new development zone created for RT. I was asked if I wanted the new zone to be Linux or Solaris based. So, all you gurus out there, what's best? I know that most of this stuff was designed for Solaris, but

Re: [rt-users] using custom field that applies to group as custom scrip condition

2009-03-13 Thread Paul Vlaar
I've used your example Kenneth, with slight alternations, but this doesn't trigger: my $trans = $self-TransactionObj; my $ticket = $self-TicketObj; if ($trans-Type eq 'CustomField') { my $cf = new RT::CustomField($RT::SystemUser); $cf-LoadByName(Queue = $ticket-QueueObj-id, Name =

Re: [rt-users] using custom field that applies to group as custom scrip condition

2009-03-13 Thread Paul Vlaar
On Fri Mar 13 2009 19:58:17 GMT+0100 (CET), Paul Vlaar wrote: my $trans = $self-TransactionObj; my $ticket = $self-TicketObj; if ($trans-Type eq 'CustomField') { my $cf = new RT::CustomField($RT::SystemUser); $cf-LoadByName(Queue = $ticket-QueueObj-id, Name = Contract);

[rt-users] scrip for tickets

2009-03-13 Thread Hossein Rafighi
Hi, Is there a way to move tickets between queues via email? We can open, reply, resolve/close them via email, but I don't know of any ways to move them between queues except through CLI and web interface. Thanks in advance for your reply, -- and cheers, Hossein -- _ _ _ _

[rt-users] weirdness in scrip

2009-03-13 Thread jul
Hi, How do I return a Result when refusing a transaction so that user know what they did wrong (in my case, I just check that a customField is not null is selected Queue) Condition : OnResolve Action: User Defined Stage:Transaction Create. # Only do it for certain queues. my @queues =

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Ken Crocker
John, Thanks. That's sounds like a good thing to keep in mind. Anyone else? Kenn LBNL On 3/13/2009 12:25 PM, John Arends wrote: I have a bias towards Linux for this purpose. RT seems to be pushing the envelope with bleeding edge everything, and Solaris and bleeding edge don't mix.

Re: [rt-users] using custom field that applies to group as custom scrip condition

2009-03-13 Thread Ken Crocker
Paul, Are yosaying it NEVER triggered? If so, then I suggest you look at your logs. Also, double check your values. Everything is case-sensitive. If the value you are checking for doesn't exist in the Custom Field EXACTLY as what you are checking for, it won't trigger. Otherwise, the

Re: [rt-users] using custom field value in scrip condition

2009-03-13 Thread Paul Vlaar
Well, it looks like it was just a typo after all (forgot the opening { ) and this code just works: if ( $self-TicketObj-QueueObj-FirstCustomFieldValue('Contract') eq expiring ) { return 1; } else { return 0; } On Fri Mar 13 2009 19:30:54 GMT+0100 (CET), Paul Vlaar wrote: I'm trying to make

Re: [rt-users] Advice for New Machine

2009-03-13 Thread jul
Ken Crocker a écrit : John, Thanks. That's sounds like a good thing to keep in mind. Anyone else? Yes : 3 servers : 1) for RT ; 2) one for the DB (if you plan postgres or oracle) (I recommend Pg) so that you can tune it easily (sysctl in kernel will impact all the processes, and that's

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Gary Greene
-Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of jul Sent: Friday, March 13, 2009 12:56 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Advice for New Machine Ken Crocker a écrit :

[rt-users] Fuller search results

2009-03-13 Thread Jerrad Pierce
Any ideas on how to pull in requestor details as part of the results in a ticket search? This would be very handy in exposing information to RT-phobes. -- Cambridge Energy Alliance: Save money. Save the planet. ___

Re: [rt-users] using custom field value in scrip condition

2009-03-13 Thread Ken Crocker
Paul, Great. I didn't see that either. Hope it's helpful. Kenn LBNL On 3/13/2009 12:53 PM, Paul Vlaar wrote: Well, it looks like it was just a typo after all (forgot the opening { ) and this code just works: if ( $self-TicketObj-QueueObj-FirstCustomFieldValue('Contract') eq expiring ) {

Re: [rt-users] Advice for New Machine

2009-03-13 Thread John Arends
Gary Greene wrote: I would go CentOS for the machine if you're a RH person, since it is practically the same thing, and there are more than a few of us CentOS users running RT with our own RPMs. What version of RT are you running on top of CentOS? With 3.8.2 there are so many

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Ken Crocker
John, We are currently running 3.6.4, but DESPERATELY want to upgrade to 3.8.2. Hence the desire to get this new zone set up right FIRST, before trying to upgrade. We are an Oracle house, so that's not on the table. So far, I'm leaning toward Linux, but I haven't heard from Jesse or

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Sean
On Fri, 2009-03-13 at 15:16 -0500, John Arends wrote: Gary Greene wrote: I would go CentOS for the machine if you're a RH person, since it is practically the same thing, and there are more than a few of us CentOS users running RT with our own RPMs. What version of RT are you

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Ken Crocker
Sean, Can I assume your voting for Linux? Kenn On 3/13/2009 1:26 PM, Sean wrote: On Fri, 2009-03-13 at 15:16 -0500, John Arends wrote: Gary Greene wrote: I would go CentOS for the machine if you're a RH person, since it is practically the same thing, and there are more than a

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Potla, Ashish Bassaliel
I am in the process of upgrading RT 3.6.5 to RT 3.8.2 . In fact I have it set up in Dev arena and waiting for user testing before I move it to production by the end of the month probably.. hopefully I use Solaris , Apache2 with mod_perl2 and DB on Oracle. Doesnt seem too bad :) -Ashish

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Tom Lahti
I am running RT 3.8.2 on Slackware 12.0. I originally installed 3.6.mumble and upgraded to 3.8.0 and then 3.8.2. The original install was perfectly clean; no mess, no fuss. Upgrades were equally simple, once I figured to actually do all of the upgrade and not just part of it. -- --

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Sean
Can I assume your voting for Linux? Within the context of RT I don't understand what voting for Linux is supposed to mean. RT doesn't care about what kernel is running. It only cares about the supporting software, which itself is also independent of the kernel. Based on my experience, I

Re: [rt-users] Search results being filtered after they are generated?

2009-03-13 Thread Ruslan Zakirov
Jon, Thank you for help debugging this. Looks like I missed one thing in this code. If right is granted globally to a role and this roles assigned to a user on queue level then such thing is missed, for example ShowTicket is granted to global AdminCc role and user is AdminCc of a queue. I'm not

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Gary Greene
-Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of John Arends Sent: Friday, March 13, 2009 1:16 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Advice for New Machine Gary Greene

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Joop van de Wege
Ken Crocker wrote: John, We are currently running 3.6.4, but DESPERATELY want to upgrade to 3.8.2. Hence the desire to get this new zone set up right FIRST, before trying to upgrade. We are an Oracle house, so that's not on the table. So far, I'm leaning toward Linux, but I haven't

Re: [rt-users] Advice for New Machine

2009-03-13 Thread Gary Greene
-Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Gary Greene Sent: Friday, March 13, 2009 2:44 PM To: John Arends; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Advice for New Machine

[rt-users] RT::Extension::QuickDelete

2009-03-13 Thread Tim Cutts
Has anyone else tried the QuickDelete extension? I've been trying it on my 3.8.2 dev instance, and for the most part it seems to be working; I get a Delete tab on the ticket reply page, at least. But from looking at the code, it seems that the intention was that a Delete link should also

[rt-users] reply with attachment

2009-03-13 Thread Mchugh, Sean
I'm looking for a quick and easy template that can add a variety of attachments to an email response. The purpose is to email customers legal forms and documents that need to be filled out as part of particular requests before the request can be worked on. Anyone done this yet ?

Re: [rt-users] reply with attachment

2009-03-13 Thread Tom Lahti
Mchugh, Sean wrote: I'm looking for a quick and easy template that can add a variety of attachments to an email response. The purpose is to email customers legal forms and documents that need to be filled out as part of particular requests before the request can be worked on. Anyone done