Re: [rt-users] Crystal Reports

2007-01-04 Thread Mathew Snyder
Or simply have CR connect directly to the database and run the reports itself, yes? Mathew Todd Chapman wrote: > The problem is that you would have to build the intelligence > of the RT API into Crystal. The relations between some of > the RT tables and not straightforward. Also crytsal would >

Re: [rt-users] Crystal Reports

2007-01-04 Thread Todd Chapman
The problem is that you would have to build the intelligence of the RT API into Crystal. The relations between some of the RT tables and not straightforward. Also crytsal would not enforce RT's permissions. You would be better off to do the reporting in Perl and output to HTML, PDF, or something un

[rt-users] Crystal Reports

2007-01-04 Thread Mathew Snyder
Has anyone successfully used Crystal Reports with their RT installation? I don't know much about it myself so I'm curious about how it would interface. Would it have to be run separately or is there a way to include it in the reports interface? We have a new license here at work and I've been ask

[rt-users] Displaying Work Phone in RT 3.6.3

2007-01-04 Thread Zachary Fortna
I want to display the WorkPhone for ticket owners and Requestors. I changed ShowUserEntry to display WorkPhone instead of EmailAddress. My ShowUserEntry now looks like: <%$User->RealName%> <<%$User->WorkPhone%>> <%ARGS> $User => undef $Ticket => undef This works great for the Ticket Owner,

[rt-users] Problems with email relay

2007-01-04 Thread Guillermo Vega
Im running RT 3.0.12, and i need to change the time intervals that emailrelay uses to send notifications. Right now, it's set to 4 minutes, so if a requestors address is mistyped say instead of .com the typed .cm, the RT start building corresondances under the ticket(each correspondance is of a ma

[rt-users] Trouble with AutoReply

2007-01-04 Thread Gentgeen
As noted in my earlier post, I have been testing out RT over the last month or so. I changed the AutoReply template, to try and use the AutoReply with password feature. Now NO autoreplys go out. Regular correspondance will go out (and come in) but the auto reply to create is not working. The o

[rt-users] Custom Fields when Replying/Commenting

2007-01-04 Thread Zachary Fortna
I'd like have the custom fields viewable when a ticket is commented/replied to. I see in the Update.html code below that there is an if statement that would appear to allow it to be displayed. I'm just not sure how to get the if statement to trigger properly. % if (my $TxnCFs = $TicketObj

Re: [rt-users] Performance problems on upgrade from 3.0 to 3.4 or 3.6.1

2007-01-04 Thread Jesse Vincent
On Thu, Jan 04, 2007 at 06:42:54PM +0200, Theo Kramer wrote: > Hi > > So I thought I would spend the silly season upgrading our system from > RT3.0 to R3.4 after having resolved a previous performance problem but > no luck. > > System Details as follows > > O/S: Ubuntu Dapper > Database: MySQ

[rt-users] Performance problems on upgrade from 3.0 to 3.4 or 3.6.1

2007-01-04 Thread Theo Kramer
Hi So I thought I would spend the silly season upgrading our system from RT3.0 to R3.4 after having resolved a previous performance problem but no luck. System Details as follows O/S: Ubuntu Dapper Database: MySQL 5.0.22 Architecture: intel Pentium 3GHz RAM: 2GByte uname -a: Linux rtfm 2.6.15-27

Re: [rt-users] DBD::Pg 1.41...MISSING

2007-01-04 Thread Vivek Khera
On Jan 4, 2007, at 10:48 AM, Flynn, Timothy J wrote: it was installed. Forced an install and it seemed to work. Still no luck. So I downloaded 1.49 and installed it manually. RT still thinks it is missing. Ideas? you have more than one version of perl installed, and the one you're u

Re: [rt-users] DBD::Pg 1.41...MISSING

2007-01-04 Thread Mathew
If you have AT LEAST that version you should be fine. Many dependencies are "hard coded" to look for a particular version when, in fact, any version beyond it will work. Mathew Flynn, Timothy J wrote: > I cloned my production RT box and upgraded the db to PG 8.2. When I > tried to restore the d

[rt-users] More about "Username"

2007-01-04 Thread John Arends
I set up a test 3.6.1 instance, and am now working towards a production version running 3.6.3. In my test version of RT, tickets would have a section that said "More about *username*" but for some reason in my new 3.6.3 instance, that entire more about box is just missing. Can anyone think o

[rt-users] DBD::Pg 1.41...MISSING

2007-01-04 Thread Flynn, Timothy J
I cloned my production RT box and upgraded the db to PG 8.2. When I tried to restore the db I got the error "DBD::Pg 1.41...MISSING". I ran make fixdeps and it was still missing. I ran cpan and it reported that it was installed. Forced an install and it seemed to work. Still no luck. So I dow

Re: [rt-users] Change Default Queue For "New Ticket In"

2007-01-04 Thread Peterson, Erik
On 1/4/07 9:59 AM, "Zachary Fortna" <[EMAIL PROTECTED]> wrote: > I'd like to change the default Queue for new ticket creation from the first in > the list to that third queue in the list. I'm running RT 3.6.3. How would i > go about doing this. Hi Zachary, Here's an almost brute force method. Y

[rt-users] Change Default Queue For "New Ticket In"

2007-01-04 Thread Zachary Fortna
I'd like to change the default Queue for new ticket creation from the first in the list to that third queue in the list. I'm running RT 3.6.3. How would i go about doing this. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Communit

Re: [rt-users] Adding Requestors/CC

2007-01-04 Thread Roy El-Hames
Adam; Anyone that emails RT and as a result a ticket is created then by default the sender's email address will be added as the requester and any should receive future updates .. If the problem you are having is that a ticket is not created , then you need to check from Global/Group Rights tha

[rt-users] Set Requestor automatically

2007-01-04 Thread Diego Chaparro
Hi all, Sorry if it's a very simple question but i'm new on RT. Is it possible to set the requestor automatically to his own when a non privileged user puts a ticket with the "New ticket" form? And also, is it possible to limit the requestor field in order that each user only can assign the r

Re: [rt-users] Who can see the tickets?

2007-01-04 Thread Diego Chaparro
Mensaje citado por "Jason A. Diegmueller" <[EMAIL PROTECTED]>: > > If you granted CreateTicket and ShowTicket rights to Everyone or > Unprivileged, yes, that would be expected behavior. > > It sounds like what you possibly want is: > * Everyone: CreateTicket > * Requestor (ie, themselves, if the

Re: [rt-users] Default Global AutoReply Template

2007-01-04 Thread Toby Darling
Hi Kevin So I am hoping someone can either send me theirs, or point me in the right direction to find the default AutoReply Template so I can start over and figure out my mistake. I don't have the default anymore but something like: 8< cut Subject: AutoReply: {$Ticket->Subject} Yo