Re: [rt-users] Getting RT-Extension-ResetPassword Module

2008-05-28 Thread Glenn Sieb
John BORIS wrote: > I would like to use the Password reminder module from the repository but > I am a bit clueless on how to get the code. Can someone point to > directions on how to get the code or the module so I can install it in > my RT instance? > John, Try: svn export svn://svn.bestpract

[rt-users] SearchBuilder and time intervals

2008-05-28 Thread Brian Gallew
I'm having a problem doing time interval searches in RT. What I want is Owner = '11510' AND Resolved > datesub(curdate(), interval 2 weeks) The above syntax works for MySQL (which is what I'm using). Unfortunately, SearchBuilder doesn't seem to do the right thing with this. I've also not found

Re: [rt-users] Getting RT-Extension-ResetPassword Module

2008-05-28 Thread Ham MI-ID, Torsten Brumm
Hi jesse, You're correct, was a stupid idea :-) Torsten Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Si

Re: [rt-users] RT running slowly... Caused by RTx-Shredder

2008-05-28 Thread Boris Lytochkin
After adding this key: ALTER TABLE CachedGroupMembers Add KEY `SHREDDER_CGM1` (`GroupId`,`MemberId`,`Disabled`); - MemberId & GroupId swapped comparing to original SHREDDER_CGM1 - explain (and query too :) ) is OK. mysql> explain extended SELECT DISTINCT main.* FROM Users main mysql> CROSS JO

Re: [rt-users] RT-Users Digest, Vol 50, Issue 56

2008-05-28 Thread Boris Lytochkin
Really odd. mysql> explain extended SELECT DISTINCT main.* FROM Users main mysql> CROSS JOIN ACL ACL_4 mysql> JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) mysql> JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) mysql> J

Re: [rt-users] Getting RT-Extension-ResetPassword Module

2008-05-28 Thread John BORIS
Jesse, I didn't plan to do that. I stick with what I know how to do. >>> Jesse Vincent <[EMAIL PROTECTED]> 05/28/08 4:36 PM >>> On May 28, 2008, at 4:31 PM, Torsten Brumm wrote: > for the whole svn try svn co svn://svn.bestpractical.com there > you'll find everything :-) > Please don't EVER c

Re: [rt-users] Getting RT-Extension-ResetPassword Module

2008-05-28 Thread Jesse Vincent
On May 28, 2008, at 4:31 PM, Torsten Brumm wrote: for the whole svn try svn co svn://svn.bestpractical.com there you'll find everything :-) Please don't EVER check out the entirety of our Subversion repository all at once. That is a SIGNIFICANT drain on our resources and is much, much

Re: [rt-users] Getting RT-Extension-ResetPassword Module

2008-05-28 Thread John BORIS
I have tried that but there might be issues with our firewall setup. All I want is the one module. >>> "Torsten Brumm" <[EMAIL PROTECTED]> 05/28/08 4:31 PM >>> for the whole svn try svn co svn://svn.bestpractical.com there you'll find everything :-) 2008/5/28 John BORIS <[EMAIL PROTECTED]>: > I

Re: [rt-users] Getting RT-Extension-ResetPassword Module

2008-05-28 Thread Torsten Brumm
for the whole svn try svn co svn://svn.bestpractical.com there you'll find everything :-) 2008/5/28 John BORIS <[EMAIL PROTECTED]>: > I would like to use the Password reminder module from the repository but > I am a bit clueless on how to get the code. Can someone point to > directions on how to

Re: [rt-users] RT Newb Queue/Group Strategy question

2008-05-28 Thread Kenneth Crocker
David, I think that the way YOUR infrastructure is set up is the key. If you have different technical support groups that work on tickets from a specific set of customers OR specific products, then I would create a single queue for either a) each technical support groups that works on

Re: [rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
Ok, Ive recieved this advise from some guys on the exim mailing list. I have to update my Exim config to get this to work... http://lists.exim.org/lurker/message/20080528.191851.4e0c63fd.en.html Is this the only way to achieve email integration with RT? Or are their other methods that wouldnt

Re: [rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
Hi John, Ok, so I added a mailbox for the user rt-general, but as I suspected now when I send mail it just goes into the mailspool area and sits in the "new" folder waiting for someone to read it. I cant understand how the alias file is meant to be actioned (ie the piped command) thanks Andy.

Re: [rt-users] Not understanding initial email config :(

2008-05-28 Thread John BORIS
Andy, The email address has to be valid for it to get to RT. I am no guru when it comes to email but woudn't the emailer try to resolve the email address and then look for the MX record for that address in DNS. If you sent the email from the command line and your log shows that address as unroutabl

[rt-users] Getting RT-Extension-ResetPassword Module

2008-05-28 Thread John BORIS
I would like to use the Password reminder module from the repository but I am a bit clueless on how to get the code. Can someone point to directions on how to get the code or the module so I can install it in my RT instance? TIA John J. Boris, Sr. JEN-A-SyS Administrator Archdiocese of Philadel

Re: [rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
Hi, ok I have proven that I can successfully create a ticket remotely from the Exim server by cat'ing an email into rt-mailgate like this: cat 1172082829.H159040P74283.mx.test.net |/usr/local/rt3/bin/rt-mailgate --queue General --action correspond --url http://rt3.test.net/ But still real em

[rt-users] RT Newb Queue/Group Strategy question

2008-05-28 Thread David Nalley
Hi All, I am a relative newb who has just deployed RT in pilot to replace our aging, inadequate and hated support tool. A little bit of background - my employer, among other things, provides support for a wide range of software and hardware products to several hundred customers. Most of these c

Re: [rt-users] Showing Custom Field in Queue view

2008-05-28 Thread Kenneth Crocker
Andrew, Your description of what you want as a "queue-view" makes me think you might have an incomplete understanding of how a custom field can be seen, used, modified. When a Custom Field is created and then "applied" to a queue, view/use of it can still be manipulated thru rights. I

[rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
Hi, Im new to RT and am trying to configure a pilot system on FreeBSD, using RT 3.6.6. I want to get incoming mail to go to the general queue (creating a new ticket) but from the documentation Im really not understanding how this is meant to work. I have the RT server up and running on one ser

Re: [rt-users] Change the "Modify Ticket" options on blue bar

2008-05-28 Thread Kenneth Crocker
Stephan, Thanks, and good idea. This additional piece of code you gave me will allow me to simplify the use of our new ticket status values. That alone, will make the use of our Approval/Prioritization & QA workflow processes much easier. And after all, that IS the whole point here. T

Re: [rt-users] SearchBuilder problems with sorting by Custom Fields

2008-05-28 Thread Kenneth Crocker
Jesse, Emmanuel, Thanks. Good to hear about 3.6.7. Emmanuel, if yours is working, then maybe my install of 3.6.6 didn't get the latest SearchBuilder. To be honest, the fact that it doesn't work for CF's is NOT a show-stopper. It will be a GREAT asset for administrative reporting when i

Re: [rt-users] SearchBuilder problems with sorting by Custom Fields

2008-05-28 Thread Jesse Vincent
On Wed, May 28, 2008 at 05:54:09PM +0200, Emmanuel Lacour wrote: > On Tue, May 27, 2008 at 12:40:53PM -0700, Kenneth Crocker wrote: > > Jesse, Emmanuel, > > > > > > > > Thanks! I finally got it. Boy, do I need to learn some on this install > > stuff. I now have 3.6.6 up and running. Looks

Re: [rt-users] SearchBuilder problems with sorting by Custom Fields

2008-05-28 Thread Emmanuel Lacour
On Tue, May 27, 2008 at 12:40:53PM -0700, Kenneth Crocker wrote: > Jesse, Emmanuel, > > > > Thanks! I finally got it. Boy, do I need to learn some on this install > stuff. I now have 3.6.6 up and running. Looks great! > I am STILL having trouble getting a search to sort results by a C

Re: [rt-users] Stop outbound emails for a specific queue - [Pork] Email found in subject - [Pork] Email found in subject

2008-05-28 Thread Ben Robson
Thank you both, this worked. -Original Message- From: Mike Peachey [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 May 2008 1:31 AM To: Ben Robson Cc: Emmanuel Lacour; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Stop outbound emails for a specific queue - [Pork] Email found in

Re: [rt-users] Stop outbound emails for a specific queue - [Pork] Email found in subject

2008-05-28 Thread Mike Peachey
Ben Robson wrote: > Firstly, thanks for the reply > > Do you mean templates or scrips? I ask, because it's the scrips that > decide when to send out an email, the template only formats it (doesn't > it). > > Assuming the scrips for the moment.the global scrips don't have any > name, and

Re: [rt-users] Stop outbound emails for a specific queue - [Pork] Email found in subject

2008-05-28 Thread Ben Robson
Firstly, thanks for the reply Do you mean templates or scrips? I ask, because it's the scrips that decide when to send out an email, the template only formats it (doesn't it). Assuming the scrips for the moment.the global scrips don't have any name, and when I create an equivalent scrip

Re: [rt-users] Stop outbound emails for a specific queue

2008-05-28 Thread Emmanuel Lacour
On Thu, May 29, 2008 at 01:17:08AM +1000, Ben Robson wrote: > Greetings again... having solved my previous issue I have a new > question. > > Is there a way to configure RT to not send out emails (to Requestors, > CC's, etc...) for a single queue, but continuing to send for other > queues? > T

[rt-users] Stop outbound emails for a specific queue

2008-05-28 Thread Ben Robson
Greetings again... having solved my previous issue I have a new question. Is there a way to configure RT to not send out emails (to Requestors, CC's, etc...) for a single queue, but continuing to send for other queues? Thanks, BenR ___ http://lists.be

Re: [rt-users] Creation of tickets from CLI - [Pork] Email found in subject

2008-05-28 Thread Ben Robson
Well I am pleased to report I solved my own problem... For future reference, when using multiple lines in the text field, as used in a form submitted for the '-i' rt CLI command, you must make the first character on the extra lines a space. Thanks all. BenR From: [EMAIL PROTECTED] [mailto:[EM

Re: [rt-users] Change the "Modify Ticket" options on blue bar

2008-05-28 Thread Stephen Turner
At 04:04 PM 5/27/2008, you wrote: >Stephen, > > > Thanks for the code example. I used it as the basis for the > code I wanted to add. The "Tabs" layout now shows what I want, but > when I click any of the new options, nothing happens. This is what > my new code looks like: > >if ($args)

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 choo

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

2008-05-28 Thread Stephen Turner
At 03:28 AM 5/26/2008, Tom Lanyon wrote: >List, > >Is there a way to customise Ticket/Create.html on a per-queue basis? > >What we would like to achieve: creating a ticket in QueueA may have a >different layout and/or different fields visible than when creating a >ticket in QueueB. > >Has anyone do

Re: [rt-users] Will not be sent email

2008-05-28 Thread Jesse Vincent
On Wed, May 28, 2008 at 02:20:40PM +0200, Stefan Le Jeune wrote: > Answering my own question for others who might search the archives: > It appears that the users ticked the email the first time to not send > the email and pressed "Save" instead of "update". This creates an > attribute record w

Re: [rt-users] Will not be sent email

2008-05-28 Thread Stefan Le Jeune
Answering my own question for others who might search the archives: It appears that the users ticked the email the first time to not send the email and pressed "Save" instead of "update". This creates an attribute record with a SquelchMailTo attribute. of course the user didn't tell me this and I

Re: [rt-users] Showing Custom Field in Queue view

2008-05-28 Thread Andrew Lewis
> '_CustomField.{cf_name}__' Great, got it working, thanks. :) Is there a way I can make this persistent though? -AL. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support

Re: [rt-users] Showing Custom Field in Queue view

2008-05-28 Thread Emmanuel Lacour
On Wed, May 28, 2008 at 11:32:44AM +0200, Andrew Lewis wrote: > > I don't fully understand what you means by "queue view". > > What you see if you click the name of a queue in "Quick search" > > > But if you talk about the ticket list in a queue, you can modify the > > corresponding > > search t

Re: [rt-users] Showing Custom Field in Queue view

2008-05-28 Thread Andrew Lewis
> I don't fully understand what you means by "queue view". What you see if you click the name of a queue in "Quick search" > But if you talk about the ticket list in a queue, you can modify the > corresponding > search to add the CFs you wan't to display. How? :) I see now that I can go to [Qu

Re: [rt-users] Showing Custom Field in Queue view

2008-05-28 Thread Emmanuel Lacour
On Wed, May 28, 2008 at 10:51:42AM +0200, Andrew Lewis wrote: > > Hi there, > > I want to display a custom field in the queue view. Has anyone done > this?/can give me some pointers on how best to go about doing this? > I don't fully understand what you means by "queue view". But if you talk ab

[rt-users] Showing Custom Field in Queue view

2008-05-28 Thread Andrew Lewis
Hi there, I want to display a custom field in the queue view. Has anyone done this?/can give me some pointers on how best to go about doing this? Best, -AL. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://w