[rt-users] disclaimer on first comment for a queue. need a more elegant solution

2007-10-10 Thread Ben Weston
Greetings all. What I'm trying to do is this. We want the first comment (when opening a new ticket) to include after the problem info a disclaimer that basically says We reserve the right to dispose of equipment left more than 90 days after service is completed, unless other arrangements

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 09:43:31AM +0200, Emmanuel Lacour wrote: Dear RT users/developpers ;) I'm trying to draw charts grouped by customfield (using the functionnality at the bottom of a search result) and on a customfiled of type select unique value. But the result graph is empty :( It

[rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
Dear RT users/developpers ;) I'm trying to draw charts grouped by customfield (using the functionnality at the bottom of a search result) and on a customfiled of type select unique value. But the result graph is empty :( It works with other group by like status, queue, ... If someone has some

R: R: [rt-users] How to integrate RequestTracker with our web ?

2007-10-10 Thread Gianluca Cecchi
I have a CF named company; with rt show command for a ticket with this field valued, I can see that I get CF-company so the conmand I verified that works in my case in 3.6.5 is this: [EMAIL PROTECTED] ~]# rt edit ticket/59 set CF-company='Peviani' # Ticket 59 updated. you should probably

RE: [rt-users] disclaimer on first comment for a queue. need a moreelegant solution

2007-10-10 Thread Patterson, Craig
I assume you want the automatic reply sent to a user on ticket submission to include your disclaimer. If so, you should only have to change autoreply template. Otherwise, you could look at the correspondence template, but I'm not sure how you could determine if it is the first reply or not.

RE: R: R: [rt-users] How to integrate RequestTracker with our web ?

2007-10-10 Thread fchx
Ok solved. It was a Custom Field's permission problem. rt edit ticket/59 set CF-company='badvalue' works for me. Thanks for your help --- FranCHo Subject: R: R: [rt-users] How to integrate RequestTracker with our web ? Date: Wed, 10 Oct 2007 10:01:48 +0200 From: [EMAIL PROTECTED] To: [EMAIL

[rt-users] Two RT installations spamming each other. Suggestions?

2007-10-10 Thread Palle Girgensohn
Hi, We recommended a customer to start using RT. We use it ourselves, for second line support, and they run first line support. Tickets on their side that require our input are sent to us and creates a ticket in our system, but since every new reply from them only has their ticket#, our

Re: [rt-users] Two RT installations spamming each other. Suggestions?

2007-10-10 Thread Jesse Vincent
Have a look at RT::Extension::ExtractSubjectTokens on CPAN. --- Original message --- From: Palle Girgensohn [EMAIL PROTECTED] Sent: 10-10-'07, 8:33 Hi, We recommended a customer to start using RT. We use it ourselves, for second line support, and they run first line support.

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Jesse Vincent
what shows up in your error logs? --- Original message --- From: Emmanuel Lacour [EMAIL PROTECTED] Sent: 10-10-'07, 3:43 Dear RT users/developpers ;) I'm trying to draw charts grouped by customfield (using the functionnality at the bottom of a search result) and on a customfiled of

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 09:09:58AM -0400, Jesse Vincent wrote: Hi, dear RT primary Author ;) what shows up in your error logs? That's the good question ... sorry I forgot to look here :( There is DBD prepare errors: RT: RT::Handle=HASH(0x8134df1c) couldn't prepare the query 'SELECT

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Jesse Vincent
On Oct 10, 2007, at 9:38 AM, Emmanuel Lacour wrote: On Wed, Oct 10, 2007 at 09:09:58AM -0400, Jesse Vincent wrote: Hi, dear RT primary Author ;) what shows up in your error logs? That's the good question ... sorry I forgot to look here :( I suspect that it has to do with this was

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 09:42:21AM -0400, Jesse Vincent wrote: I suspect that it has to do with this was tested on mysql and pg if only I had power to choose the database Engine ... ;) ___

[rt-users] Email Error with 'Reply' only

2007-10-10 Thread matt wells
When I create a ticket for a user they get an email. When I close the ticket they get an email. When I hit Reply in the ticket it shows and outgoing email but they do not get it. Nor does it get send to sendmail. ___

[rt-users] Doubts about Merge into functionality

2007-10-10 Thread Gianluca Cecchi
Situation: User1 sends an e-mail that creates ticket #1 with subject I have problem 1 into the queue General I am a master of ticket mgmt, so that in a few seconds I take in charge the ticket, open it, assign to it the queue hw and CF company1 After a few minutes User2 sends an e-mail that

[rt-users] Info about REJECTED status notification

2007-10-10 Thread Gianluca Cecchi
When I reject a ticket, the requestor only receives an e-mail with Subject: [Peviani #72] problem with printer And inside the body what I decided to write + the original reference I think it would be useful to have for example the word REJECTED inserted into the subject line for more

[rt-users] Bug in Chart fonts handling

2007-10-10 Thread Emmanuel Lacour
I played with chart module and found that the fonts settings are incorrect. In share/html/Search/Chart, the only font setting is made by set_legend_font, but there is no legends on graphs so ... not very usefull. Instead it would be better to use one or every of the followings: For bars:

[rt-users] Re: Email Error with 'Reply' only

2007-10-10 Thread matt wells
So I've tested some more. All of my CCs get emails and all of my BCCs get emails. The requestor is the only one that does not know that his/her ticket has been acted on. I have a global Scrip that is below. Scrip Description - Condition - On Correspond Action - Notify Requestors and Ccs Template

Re: [rt-users] Info about REJECTED status notification

2007-10-10 Thread JavaCupiX
I can't remember what transaction type it is so you will have to figure that out (docs) but here is what I use for another thing and you should be able to use as a conditionnal statement if (($self-TransactionObj-Type eq Type i can't remember) and ($self-TicketObj-Status eq rejected)) {

Re: R: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 05:46:31PM +0200, Gianluca Cecchi wrote: Sorry main was an alias for Tickets table If I use the same query on mysql 9without the comma...) I get: ERROR 1054 (42S22): Unknown column 'ObjectCustomFieldValues_1.Content' in 'field list' And the oracle error 904

Re: [rt-users] Re: Email Error with 'Reply' only

2007-10-10 Thread JavaCupiX
I had the same problem and created a dedicated scrip for it Condition: On correspond Action:Autoreply To Requestors added to your existing scrip it should work out... but it will send two separated emails (what a mess...) On 10/10/07, matt wells [EMAIL PROTECTED] wrote: So I've tested some

Re: [rt-users] new users

2007-10-10 Thread Gene LeDuc
Hi Timothy, When a new user submits a ticket (via e-mail), RT sets up an account for them. The account username is their e-mail address and there is no password. Regards, Gene At 11:53 AM 10/9/2007, Timothy A. Holmes wrote: Content-class: urn:content-classes:message Content-Type:

Re: [rt-users] Re: Email Error with 'Reply' only

2007-10-10 Thread matt wells
Still not working. I changed it like yours but to no avail. On 10/10/07, JavaCupiX [EMAIL PROTECTED] wrote: I had the same problem and created a dedicated scrip for it Condition: On correspond Action:Autoreply To Requestors added to your existing scrip it should work out... but it will

[rt-users] Email error trying to setup email to a Helpdesk queue

2007-10-10 Thread Jim GLutting
HI, I have installed RT 3.6.4 on Rhel 4.0 and the web interface works OK on port 8080. I am using Postfix as the MTA and Postgresql for the database. I have added a new queue named HelpDesk. I have created the 2 mail aliases for this queue (from the Wiki page (RTsFinallyInstalledNowWhat):

Re: [rt-users] Two RT installations spamming each other. Suggestions?

2007-10-10 Thread Gene LeDuc
Jesse, I couldn't find this on CPAN. The closest match I came up with is RT::Extension::ExtractSubjectTagOnTransaction, but there's no documentation so without downloading and examining the source, I can't tell what it does. Gene At 06:09 AM 10/10/2007, Jesse Vincent wrote: Have a look at

Re: [rt-users] Re: Email Error with 'Reply' only

2007-10-10 Thread matt wells
Different people. I've attached the 'Outgoing email about a comment recorded' Correct me where I'm wrong but shouldn't a 'To' field exist? Subject: [Example.com #11308] [Comment] Dogs can't get into the kitchen to eat. From: Bob Vila via RT [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]

RE: [rt-users] Re: Email Error with 'Reply' only

2007-10-10 Thread Barry Byrne
Matt, Is the person who acts on the ticket the same email address as the requestor of the ticket. I had this same issue when I first tried testing RT - I sent a test mail as myself and then logged in to RT as myself - RT doesn't seem to forward mail if the person who makes the change is the same

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Joop van de Wege
Jesse Vincent wrote: I suspect that it has to do with this was tested on mysql and pg Any oracle folks see what we're doing wrong with that SQL? There is DBD prepare errors: RT: RT::Handle=HASH(0x8134df1c) couldn't prepare the query 'SELECT COUNT(main.id) AS id,

Re: [rt-users] E-mail not going to ticket owner!

2007-10-10 Thread Fábio M. Catunda
As I can see this is an old problem, but I still have no answer for it. I googled a little based on those messages that I got from syslog: No recipients found. Not sending. Scrip 4,5,6 and 7 generates this message all the time, but I have no idea why. Any idea how to solve it? Thanks.

Re: R: [rt-users] Chart grouped by customfield

2007-10-10 Thread Joop van de Wege
Emmanuel Lacour wrote: On Wed, Oct 10, 2007 at 05:46:31PM +0200, Gianluca Cecchi wrote: Sorry main was an alias for Tickets table If I use the same query on mysql 9without the comma...) I get: ERROR 1054 (42S22): Unknown column 'ObjectCustomFieldValues_1.Content' in 'field list' And

RE: [rt-users] new users

2007-10-10 Thread Aaron Bartlett
Hello, Timothy! In RT's default configuration, it creates an account for the user without any password. If you want to change this behavior, check the following page on the RT Wiki about changing the default AutoReply template (note that this is also in the RT Essentials book on pp 88-89):

[rt-users] Reminders for nobody

2007-10-10 Thread Kenneth Crocker
To all, Awhile back I thought I saw an inquiry about how to get rid of reminders that had Nobody as the owner. I didn't see any resolutions on that. Did someone come up with one? I have, but I don't want to be redundant. Kenn LBNL ___

Re: [rt-users] Email error trying to setup email to a Helpdesk queue

2007-10-10 Thread Jim GLutting
HI, Best Practical solved my issue. Apparently the MIME::Parser changed and removed tmp_recycling, so this was fixed on RT 3.6.5, so I did the upgrade and all is well. Jim Glutting I.T. Consultant Continental Services, Inc. 248-310-7400 Jim GLutting wrote: HI, I have installed RT

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Jesse Vincent
On Oct 10, 2007, at 10:03 AM, Emmanuel Lacour wrote: On Wed, Oct 10, 2007 at 09:42:21AM -0400, Jesse Vincent wrote: I suspect that it has to do with this was tested on mysql and pg if only I had power to choose the database Engine ... ;) It should work on everything. The fact that it

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Kenneth Crocker
To all, We are on Oracle 10g and we have the same problems with custom fields when it comes to charts from query results or sorting by them as well. Kenn LBNL On 10/10/2007 1:25 PM, Jesse Vincent wrote: On Oct 10, 2007, at 10:03 AM, Emmanuel Lacour wrote: On Wed, Oct 10, 2007 at

Re: [rt-users] Two RT installations spamming each other. Suggestions?

2007-10-10 Thread Jesse Vincent
On Oct 10, 2007, at 11:15 AM, Gene LeDuc wrote: Jesse, I couldn't find this on CPAN. The closest match I came up with is RT::Extension::ExtractSubjectTagOnTransaction, but there's no documentation so without downloading and examining the source, I can't tell what it does. That's the

Re: [rt-users] Bug in Chart fonts handling

2007-10-10 Thread Jesse Vincent
On Oct 10, 2007, at 10:47 AM, Emmanuel Lacour wrote: I played with chart module and found that the fonts settings are incorrect. In share/html/Search/Chart, the only font setting is made by set_legend_font, but there is no legends on graphs so ... not very usefull. Instead it would be

[rt-users] Can I deselect a Global Scrip on a per queue basis?

2007-10-10 Thread David Hobley
Hello, We have been using RT for a while and are very happy with it (once we got our users trained up to the right level of geekyness). We have approximately 25 queues currently for various problem areas with 9 or so global scrips which apply to all queues and for the most part, this works

Re: [rt-users] Can I deselect a Global Scrip on a per queue basis?

2007-10-10 Thread Kenneth Crocker
David, Alas, I don't believe there is an easy way. The only way I know of is to make the scrips queue based. Kenn LBNL On 10/10/2007 3:43 PM, David Hobley wrote: Hello, We have been using RT for a while and are very happy with it (once we got our users trained up to the right level of

Re: [rt-users] Bug in Chart fonts handling

2007-10-10 Thread Ruslan Zakirov
Actually the changes Jesse's talking about are in 3.6.5 :) On 10/11/07, Jesse Vincent [EMAIL PROTECTED] wrote: On Oct 10, 2007, at 10:47 AM, Emmanuel Lacour wrote: I played with chart module and found that the fonts settings are incorrect. In share/html/Search/Chart, the only font

Re: [rt-users] Who can resolve Reminders which are owned by nobody?

2007-10-10 Thread Jesse Vincent
On Oct 8, 2007, at 9:53 AM, Dirk Pape wrote: Hello, We have rt 3.6.5; someone here has created a reminder which is owned by Nobody. This is visible for all Watchers of this Queue on RT at a glance (widget, which shows reminders). But I don't see how this reminder can be resolved by

Re: [rt-users] Minor patch

2007-10-10 Thread Jesse Vincent
Ok. Applied :) On Oct 9, 2007, at 1:35 AM, Brian Gallew wrote: Jesse Vincent wrote: Thanks for the patch. That looks like a kind of strange place to put that skip. Is there a reason it's not at the start of the loop? Because I backtracked to the first place that looked reasonable. 8-)

Re: R: [rt-users] Chart grouped by customfield

2007-10-10 Thread Ruslan Zakirov
It's an experimental and untested patch that may help. When a query has a group by part we really don't want to make it distinct as I don't see any way it can have not unique entries in the result set. Patch is for DBIx::SearchBuilder, to try it use the following steps: 1) untar DBIx::SB's

Re: [rt-users] Can I deselect a Global Scrip on a per queue basis?

2007-10-10 Thread David Hobley
Looking through the Mail archives, Dirk Pape has an extension for this, but all links point to his page which appears to no longer exist. Anyone have a link to the latest version of this extension? The link I have from the Wiki is: http://page.mi.fu-berlin.de/~pape/rt3screenshots/ Cheers,

Re: [rt-users] Reminders for nobody

2007-10-10 Thread Dirk Pape
Hello, --Am 10. Oktober 2007 11:41:15 -0700 schrieb Kenneth Crocker [EMAIL PROTECTED]: Awhile back I thought I saw an inquiry about how to get rid of reminders that had Nobody as the owner. I didn't see any resolutions on that. Did someone come up with one? I have, but I don't want