Re: [rt-users] Both 'subject' and 'body' of an email ticket searchable via RT's web interface?

2013-02-04 Thread Thomas Sibley
On 02/04/2013 08:00 PM, Subin wrote: > I just searched the documentation on how to do this. I'm not able to find > any other than a brief description about RT::Search::Googleish here: > > http://bestpractical.com/rt/docs/4.0/RT/Search/Googleish.html For this customization, you'll need to grok th

Re: [rt-users] Both 'subject' and 'body' of an email ticket searchable via RT's web interface?

2013-02-04 Thread Subin
On Tuesday 05 February 2013 05:21 AM, Thomas Sibley wrote: On 02/04/2013 03:36 PM, Subin wrote: I'd like to fulltext search for patterns/words both in the 'subject' and 'body'of an email ticket from the RT's web interface 'Search' box. Is it possible with the above configs of sql_query

Re: [rt-users] Both 'subject' and 'body' of an email ticket searchable via RT's web interface?

2013-02-04 Thread Thomas Sibley
On 02/04/2013 03:36 PM, Subin wrote: >I'd like to fulltext search for patterns/words both in the 'subject' and > 'body'of an email ticket >from the RT's web interface 'Search' box. Is it possible with the above > configs of sql_query*? If >not please let me know what more should I nee

Re: [rt-users] Debian package status / Full text indexing failure (invalid byte sequence for encoding "UTF8")

2013-02-04 Thread Thomas Sibley
-- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T On 02/04/2013 03:43 PM, Ben Poliakoff wrote: > Thanks for the replies Alex and Dominic. I'll plan on updating to > 4.07-4 soon, looking forward to 4.0.9! And 4.0.10 is out now. :)

Re: [rt-users] Debian package status / Full text indexing failure (invalid byte sequence for encoding "UTF8")

2013-02-04 Thread Ben Poliakoff
* Dominic Hargreaves [20130202 08:13]: > On Fri, Feb 01, 2013 at 08:36:22PM -0500, Alex Vandiver wrote: > > On Fri, 2013-02-01 at 17:03 -0800, Ben Poliakoff wrote: > > > We're currently running RT 4.0.5-3~bpo60+1 (from Debian backports) with > > > Postgresql 8.4.12-0squeeze1. > > > > This is fixe

[rt-users] Both 'subject' and 'body' of an email ticket searchable via RT's web interface?

2013-02-04 Thread Subin
Hello all, I usedthe default sphinx.conf generatedwhere the 'sql_query' to fetch data for indexing: /*sql_query = \ SELECT a.id, a.content FROM Attachments a \ JOIN Transactions txn ON a.TransactionId = txn.id AND txn.ObjectType = 'RT::Ticket' \ JOIN Tickets t ON txn.ObjectId = t.id \ WHERE

Re: [rt-users] how to make updates to already existing tickets or records reflected into indexes quickly

2013-02-04 Thread Subin
On Monday 04 February 2013 11:53 PM, Thomas Sibley wrote: On 02/04/2013 08:58 AM, Subin wrote: If an edit/update happens to an *"existing"* ticket/document/row in the source database, how will this change get updated into indexes quickly? So according to this config, we will need to wait until t

Re: [rt-users] Modify ticket 'body' after extracting custom fields?

2013-02-04 Thread Dan Madere
The way I handle this is, a scrip finds the email address and message body using regular expressions. It then sets the requestor to the given email address and makes an additional comment on the ticket with just the message body so it's easy to read and quote. We also exclude these web form ticke

Re: [rt-users] Modify ticket 'body' after extracting custom fields?

2013-02-04 Thread Roy McMorran
On 2/4/13 2:52 PM, Kevin Falcone wrote: On Wed, Jan 30, 2013 at 11:31:05AM -0500, Roy McMorran wrote: I'm receiving incoming tickets from a web form. Certain required form fields (e.g. operating system, asset tag, etc.) are being extracted into custom fields, and that's working well. I'd like

Re: [rt-users] Modify ticket 'body' after extracting custom fields?

2013-02-04 Thread Kevin Falcone
On Wed, Jan 30, 2013 at 11:31:05AM -0500, Roy McMorran wrote: > I'm receiving incoming tickets from a web form. Certain required > form fields (e.g. operating system, asset tag, etc.) are being > extracted into custom fields, and that's working well. > > I'd like to transform the ticket 'body' on

Re: [rt-users] Recommended Upgrade Path

2013-02-04 Thread Kevin Falcone
On Sat, Feb 02, 2013 at 07:44:53AM -1000, Camron W. Fox wrote: > As all of the equipment is new, I would like to, if at all possible, to > install 4.0.9 from scratch on one of the new machines and import the DB > data from the old 3.6.6 installation. > > I'd rather not migrate the 3.6.

Re: [rt-users] Approval in rt4

2013-02-04 Thread Kevin Falcone
On Fri, Feb 01, 2013 at 09:31:53AM -0700, Don Beethe wrote: >Is there a way to set up approvals on a per ticket basis in rt4? We have a > variety of tickets >coming to our sysadmin queue. Some are for accounts on servers which > require management >approval. We need to request approva

Re: [rt-users] RT: Scrip IsApplicable died?

2013-02-04 Thread Kevin Falcone
On Fri, Feb 01, 2013 at 09:53:52AM +, Thomas Lau wrote: > How could I tell? Which one is the core problem? Plugins would be wrong in your RT_SiteConfig.pm, look there. Permissions you would check with standard unix tools like ls. -kevin > -Original Message- > From: ruslan.zaki...@gma

Re: [rt-users] rt-dump-metadata and XML::Simple

2013-02-04 Thread Kevin Falcone
On Fri, Feb 01, 2013 at 12:57:46AM +0100, Christoph Badura wrote: > This week I tried to invoke rt-dump-metadata but it complained about > XML::Simple not being available. That wasn't found by > "make testdeps/fixdeps". Is that intentional? rt-dump-metadata isn't really used that often in practi

Re: [rt-users] Default dashboard?

2013-02-04 Thread Kevin Falcone
On Wed, Jan 30, 2013 at 10:30:49PM +, Jonah Hirsch wrote: >Is there a way to make a pre-built dashboard the default dashboard for a > user or group? There is no built in solution for this, but folks have used Callbacks to rewrite the Home link for certain groups, or to issue a redirect at

Re: [rt-users] Quietly comment on a ticket?

2013-02-04 Thread Kevin Falcone
On Wed, Jan 30, 2013 at 11:13:17AM -0500, Jeff Blaine wrote: > Is there a way to quietly update a ticket with a note without having > to uncheck each one of our ~30 "Bcc" people at the bottom of the > 'Comment' page? > > Short of their being a way, an "Uncheck all" would be very welcome > in a fut

Re: [rt-users] Weird right problem

2013-02-04 Thread Kevin Falcone
On Wed, Jan 30, 2013 at 01:07:35PM +0200, Manuel Subredu wrote: > we have a RT (4.0.8) && RT::IR (latest) instance that's functional and > running. Our staff can create, reply, comment, etc. But, when we make a > comment on one Incident and add an external email address in Cc, when > the user that

Re: [rt-users] how to make updates to already existing tickets or records reflected into indexes quickly

2013-02-04 Thread k...@rice.edu
On Mon, Feb 04, 2013 at 12:56:38PM -0600, k...@rice.edu wrote: > On Mon, Feb 04, 2013 at 10:50:05PM +0530, Subin wrote: > > Hi Ken, > > > > Sorry I may not have got you. So isn't there a workaround for the > > issue with **existing* *records? I think I need not change DB since > > I've already com

Re: [rt-users] how to make updates to already existing tickets or records reflected into indexes quickly

2013-02-04 Thread k...@rice.edu
On Mon, Feb 04, 2013 at 10:50:05PM +0530, Subin wrote: > Hi Ken, > > Sorry I may not have got you. So isn't there a workaround for the > issue with **existing* *records? I think I need not change DB since > I've already compiled MySQL with 'sphinxse'. It is the sphinx > configuration I'm concerned

Re: [rt-users] how to make updates to already existing tickets or records reflected into indexes quickly

2013-02-04 Thread Thomas Sibley
On 02/04/2013 08:58 AM, Subin wrote: > If an edit/update happens to an *"existing"* ticket/document/row in > the source database, how will this change get updated into indexes > quickly? So according to this config, we will need to wait until > the next time the 'main' is reindexed again, right? If

Re: [rt-users] Notify Requestor of Queue change

2013-02-04 Thread Thomas Sibley
On 02/04/2013 02:36 AM, globo wrote: > Hi, > I am trying to get a script to notify the requester when there ticket gets > moved to another queue. > > Does anyone know how to do this ? > > I have setup the following script setup but it does not work > > Condition : On queue change > Action

Re: [rt-users] how to make updates to already existing tickets or records reflected into indexes quickly

2013-02-04 Thread Subin
Hi Ken, Sorry I may not have got you. So isn't there a workaround for the issue with **existing* *records? I think I need not change DB since I've already compiled MySQL with 'sphinxse'. It is the sphinx configuration I'm concerned with. Thanks, On Monday 04 February 2013 10:33 PM, k...@rice.e

Re: [rt-users] how to make updates to already existing tickets or records reflected into indexes quickly

2013-02-04 Thread k...@rice.edu
On Mon, Feb 04, 2013 at 10:28:23PM +0530, Subin wrote: > Hello all, > > Thanks to Arkadiusz Miskiewicz for sharing his knowledge here: > > http://lists.fsck.com/pipermail/rt-users/2011-August/072464.html > > My question is based exactly on this config which I find is good. > > "As per my unders

[rt-users] how to make updates to already existing tickets or records reflected into indexes quickly

2013-02-04 Thread Subin
Hello all, Thanks to Arkadiusz Miskiewicz for sharing his knowledge here: http://lists.fsck.com/pipermail/rt-users/2011-August/072464.html My question is based exactly on this config which I find is good. "As per my understanding" the 'delta' index makes newly created rows/records available by

Re: [rt-users] Modify ticket 'body' after extracting custom fields?

2013-02-04 Thread Roy McMorran
On 2/4/13 6:54 AM, Christian Loos wrote: Am 30.01.2013 17:31, schrieb Roy McMorran: Greetings, I'm receiving incoming tickets from a web form. Certain required form fields (e.g. operating system, asset tag, etc.) are being extracted into custom fields, and that's working well. I'd like to tra

Re: [rt-users] Modify ticket 'body' after extracting custom fields?

2013-02-04 Thread Christian Loos
Am 30.01.2013 17:31, schrieb Roy McMorran: > Greetings, > > I'm receiving incoming tickets from a web form. Certain required form > fields (e.g. operating system, asset tag, etc.) are being extracted into > custom fields, and that's working well. > > I'd like to transform the ticket 'body' on cr

[rt-users] Notify Requestor of Queue change

2013-02-04 Thread globo
Hi, I am trying to get a script to notify the requester when there ticket gets moved to another queue. Does anyone know how to do this ? I have setup the following script setup but it does not work Condition : On queue change Action : Auto reply to requestors Template : My own Stage : Tra