RE: [rt-users] CommandByMail and Custom Fields

2006-12-11 Thread Stephen Turner
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Edmunds Sent: Sunday, December 10, 2006 1:27 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] CommandByMail and Custom Fields I've done a bit more research on this, and to

RE: [rt-users] Adding custom field values from Perl script.

2006-12-11 Thread Jacob Helwig
That $dbh is for a separate database for storing feedback forms sent out to people that have used our help desk. Any changes to the RT database, I am doing through the RT interface. my $sth = $dbh-prepare(SELECT * FROM new_survey(?,?,?)); actually inserts into the feedback database, and returns

[rt-users] migrating a part of rt database

2006-12-11 Thread Subredu Manuel
Hi, we have a RT 3.6 installed on our server and 8 queues. Each queue is project specific. Now, I have to install another RT instance and move all the tickets from one of the queues, into the other RT instance. Is there any way to do this using the RT command line tools ?

RE: [rt-users] Adding custom field values from Perl script.

2006-12-11 Thread Stephen Turner
That $dbh is for a separate database for storing feedback forms sent out to people that have used our help desk. Any changes to the RT database, I am doing through the RT interface. my $sth = $dbh-prepare(SELECT * FROM new_survey(?,?,?)); actually inserts into the feedback database, and

[rt-users] RTFM howto modify the way how articles are inserted ?

2006-12-11 Thread Jodok Ole Muellers
Hello, We created a custom field for RTFM Articles called Description which is an textarea that usually contains an HOWTO that gets replied from our helpdesk to the requestors. It will be inserted like this in the ticket: 1 #9: HOWTO request a password reset. 2

Re: [rt-users] CommandByMail and Custom Fields

2006-12-11 Thread Keith Edmunds
On Mon, 11 Dec 2006 10:15:28 -0500 Stephen Turner [EMAIL PROTECTED] wrote: The fact that the X2 line doesn't get logged indicates that there are no CF objects in $custom_fields. A couple of reasons why this might be true: the queue has no ticket custom fields defined or it could be a

RE: [rt-users] Adding custom field values from Perl script.

2006-12-11 Thread Jacob Helwig
Found the error. I had an unnessicary set of curly braces around the params for AddCustomFieldValue. Changed: $ticket-AddCustomFieldValue({ Field = 7, Value = $surveyid[0] }) To: $ticket-AddCustomFieldValue( Field = 7, Value = $surveyid[0] ) Now it's all working. -Original

RE: [rt-users] RTFM howto modify the way how articles are inserted ?

2006-12-11 Thread Norton, Ian
Hi Jodok, We created a custom field for RTFM Articles called Description which is an textarea that usually contains an HOWTO that gets replied from our helpdesk to the requestors. It will be inserted like this in the ticket: 1 #9: HOWTO request a password reset. 2

[rt-users] Using rt-crontool w/ MySQL date and time functions.

2006-12-11 Thread Frances Albemuth
Hi, I've been building cron jobs for automated auditing of ticket status in my organization similar to what's described in the TimedNotifications article in the Wiki. Because the 3 days nomenclature for the query seems to be incorrect and doesn't produce results (any longer? Using RT 3.6.1), I

Re: [rt-users] RTFM howto modify the way how articles are inserted ?

2006-12-11 Thread Jesse Vincent
On Mon, Dec 11, 2006 at 04:37:30PM +0100, Jodok Ole Muellers wrote: Hello, We created a custom field for RTFM Articles called Description which is an textarea that usually contains an HOWTO that gets replied from our helpdesk to the requestors. Give the latest RTFM 2.2RC a shot. It has

[rt-users] RE: RT-Users Digest, Vol 33, Issue 21

2006-12-11 Thread Harald Kapper
-- Message: 1 Date: Fri, 8 Dec 2006 19:27:51 +0200 From: Niko Tyni [EMAIL PROTECTED] Subject: Re: [rt-users] RT 3.6.1 stops sending out emails To: rt-users@lists.bestpractical.com Message-ID: [EMAIL PROTECTED]

[rt-users] bounce handling

2006-12-11 Thread Vivek Khera
I'm trying to figure out how to append bounce notices to tickets. Basically, if a bounce comes in to my return-path address, I want to scan it for evidence of a bounce from RT. If it finds it, append the message (or just the DSN report part if it is a DSN) to the offending ticket. Has

[rt-users] Tracking requestors by type?

2006-12-11 Thread Bill
Hi, I have a feeling I know the answer to this already, but thought I would ask around a bit. We have a bunch of people who e-mail into RT for support. We'd like to be able to query and report on three different kinds of users - basically students, staff and teachers. We can accept doing

Re: [rt-users] Tracking requestors by type?

2006-12-11 Thread taan
If you allow Tickets to be created in a queue by Everyone, an unprivileged user account is created when RT receives an email from a new user, hence you should be able to use custom fields. Taan Bill wrote: Hi, I have a feeling I know the answer to this already, but thought I would ask

Re: [rt-users] displaying custom field in RT at a glance?

2006-12-11 Thread Mathew
Dan Parsons wrote: I need to display the value of a custom field for each ticket shown on the RT at a glance page, which shows a predefined search named Search - My Tickets. I see how to add/remove columns, that part is easy, but my custom field isn't one of the choices. What am I doing wrong?

Re: [rt-users] displaying custom field in RT at a glance?

2006-12-11 Thread Dan Parsons
Yes, and it's granted to me, along with everything else. Dan Parsons Sr. Systems Administrator Luxtera, Inc. On Dec 11, 2006, at 3:18 PM, Mathew wrote: Dan Parsons wrote: I need to display the value of a custom field for each ticket shown on the RT at a glance page, which shows a

Re: [rt-users] bounce handling

2006-12-11 Thread Mathew
We have database at work that has all of our customer contacts. We have a script which polls it regularly and builds a procmail ruleset based on all of those contact email addresses. If an incoming email is directed at the queue to which the procmail ruleset belongs and the address is not found

Re: [rt-users] bounce handling

2006-12-11 Thread Mathew
I should note that this has literally eliminated all spam in our customer ticket queue. In order to manage the spam received by way of our other public facing queue I have the owner of the queue assign all tickets to me and open them. I then have a script which accesses the page via

Re: [rt-users] Tracking requestors by type?

2006-12-11 Thread Bill
Okay, I am doing something wrong then... I cannot get the user custom fields to display. I thought it was just with the unpriv users, but it does not display for the others either. I've restarted apache Insured rights to view, set, etc on the field... Nobody can see the field Nothing helps.

Re: [rt-users] No mail to CC's using On Correspond Notify Requestors, Ccs and AdminCcs with template Correspondence scrip

2006-12-11 Thread taan
Correspond refers to Replies only - not Comments. Taan Jeremy Randall wrote: Hi folks, I have a queue that is not sending mail to the CC addresses, but everything else is working as expected. The queue has the following scrips: On Resolve Notify AdminCcs with template On Create

RE: [rt-users] No mail to CC's using On Correspond Notify Requestors, Ccs and AdminCcs with template Correspondence scrip

2006-12-11 Thread Jeremy Randall
Ah, discovered the manual-entry CC field is considered Other Recipients. Please disregard! From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Randall Sent: Monday, December 11, 2006 9:38 PM To: rt-users@lists.bestpractical.com Subject: