[rt-users] Two queries reg ticket status changes and ownerships

2007-01-12 Thread Sujith Emmanuel
Dear all, I have RT3.6.0 running on AS4. There are two problems i hope someone could help me with. 1) How do you stop ticket requesters from accidentally opening their own tickets? The situation is that user creates a ticket and then after ten minutes sends a mail back when he gets an autore

Re: [rt-users] Best practices - reporting

2007-01-12 Thread Mathew Snyder
Well, there is the reporting tool built into RT. I don't know about older versions but the 3.6 branch has plenty of options. Just not a simple means of building new reports. These can be graphed and exported as needed. I've found that the options provided, while extensive, aren't very useful.

Re: [rt-users] Can't call method "Content"

2007-01-12 Thread rjansen
>> That's an upgrade, then ;) Did you run all the >> database upgrade >> scripts? > > I dont really understand what I am suppose to do > > The machine I'm installing RT on is new but the > database is a remote database that we currently use > with RT 3.4.2. We want to use the current data in

[rt-users] Best practices - reporting

2007-01-12 Thread Michael.J.West
I'm just curious what tools folks use to generate reports from RT. For example, I just want to put together a simple dashboard that a chart of number of tickets opened month-over-month, top ten "departments" (custom field) with the most number of tickets, and perhaps some graphing capabilities. I

Re: [rt-users] Can't call method "Content"

2007-01-12 Thread Brian Pontz
> That's an upgrade, then ;) Did you run all the > database upgrade > scripts? I dont really understand what I am suppose to do The machine I'm installing RT on is new but the database is a remote database that we currently use with RT 3.4.2. We want to use the current data in the database

RE: [rt-users] Order of actions on ticket

2007-01-12 Thread Schultz, Eric
> Also, according to the BP Wiki (but not tested by me), scrips are > executed in alphanumeric order according to the description. > This was a > huge surprise to me when I read it a couple of days ago :-) > So you might > be able to order the scrips by putting numbers in front of them or > s

Re: [rt-users] Generating readable Reports (accent problem/encoding)

2007-01-12 Thread der Mouse
> Whenever there are characters with accents, such as "á" (aacute), my > reports come out with "á". This is probably a conflict between RT, which likes to use UTF-8 for everything, and whatever you're using to display things, which probably uses Latin-1. Whether this is a bug or not can vary. F

[rt-users] Aggregate Functions

2007-01-12 Thread kevinphilp
I am assessing RT for a client. One of his requirements is to run query and work out how much time has been spent on each queue, later on he will need to break this down by queue by month. I can't see how to run aggregate SQL functions in the query forms - can someone point me in the right directi

Re: [rt-users] Can't call method "Content"

2007-01-12 Thread Brian Pontz
> That's an upgrade, then ;) Did you run all the > database upgrade > scripts? hhmmm No. I'll do that and email again if I still have the issue. Brian ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki

Re: [rt-users] Can't call method "Content"

2007-01-12 Thread Jesse Vincent
On Fri, Jan 12, 2007 at 11:35:12AM -0800, Brian Pontz wrote: > New install but using the old database. That's an upgrade, then ;) Did you run all the database upgrade scripts? > Brian ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-u

Re: [rt-users] Can't call method "Content"

2007-01-12 Thread Brian Pontz
New install but using the old database. Brian --- Jesse Vincent <[EMAIL PROTECTED]> wrote: > > > > On Fri, Jan 12, 2007 at 11:13:37AM -0800, Brian > Pontz wrote: > > Hi, > > > > I just installed rt-3.6.3 and got everything setup > ok. > > Everything works but I get this when clicking on > "R

Re: [rt-users] Can't call method "Content"

2007-01-12 Thread Jesse Vincent
On Fri, Jan 12, 2007 at 11:13:37AM -0800, Brian Pontz wrote: > Hi, > > I just installed rt-3.6.3 and got everything setup ok. > Everything works but I get this when clicking on "RT > at a glance" > New install or upgrade? ___ http://lists.bestpracti

Re: [rt-users] upgrade 3.6.1 to 3.6.3

2007-01-12 Thread jmoseley
Yep, it's that easy. However, I like to keep previous installations intact in case any problems come up. So, for example: ./configure --prefix=/usr/local/rt3.6.3 make testdeps make install Copy over the old Site config from /rt3 (or update the new one in /usr/local/rt3.6.3) Then make a symlink

[rt-users] Can't call method "Content"

2007-01-12 Thread Brian Pontz
Hi, I just installed rt-3.6.3 and got everything setup ok. Everything works but I get this when clicking on "RT at a glance" error: Can't call method "Content" on an undefined value at /opt/rt3/share/html/Admin/Global/MyRT.html line 50. context: ... 46: my ( $conf, $pane

Re: [rt-users] Translation to Swedish

2007-01-12 Thread Jesse Vincent
On Wed, Jan 03, 2007 at 11:59:46AM +0100, Brian Kjelin Olsen wrote: > Hi > > > > It appears that RT exists in all the Scandinavian languages except Swedish. > We found that RT is translated to Norwegian, Finnish and Danish. > > We have therefore decided to translate RT to Swedish, but befo

Re: [rt-users] Duplicating strings in subject

2007-01-12 Thread Jesse Vincent
On Fri, Jan 12, 2007 at 02:30:05PM +0300, wrote: > Hi all. > Sorry for poor english. :) You never need apologize for communicating in a language that's not your native tongue. You, and many, many other rt users do far better in English than I'd manage in Russian or Spanish, both of which I st

[rt-users] Generating readable Reports (accent problem/encoding)

2007-01-12 Thread Mario Gomide
I´m using RT3.4 with MySQL 5.0.30 and Perl 5.8.8. I´ve got a serious problem with encoding. I want to generate reports by using iReport 1.3.0 in PDF format. The problem is that the data that I get from the database is not with the correct encoding. Whenever there are characters with accents, su

[rt-users] upgrade 3.6.1 to 3.6.3

2007-01-12 Thread joey
Hey there, is it that easy? 1. ./configure --prefix=/usr/local/rt3/ <- found that in the old config.log of rt-3.6.1 source as "Invocation command line was" 2. make testdeps 3. make upgrade 4. Update etc/RT_SiteConfig.pm ? Greetings, Joey ___ http:

[rt-users] A working MyDay.html - patch included

2007-01-12 Thread Chris Hobbs
It looks like MyDay.html has been in the Tools area forever, but incomplete - it displayed a terrific looking form but didn't actually act on the Submit button - talk about a let-down :). I have a very crude but working fix for this. I'd like feedback on what else needs to be done to make it s

Re: [rt-users] vanished lines in rt 3.6.1 reply

2007-01-12 Thread Sven Sternberger
Hello! I upgraded the perl module Text::Quoted to the version 1.8, but the problem is still the same > I tried to track down the problem, it only happens when I made a reply > to an transaction, a reply to the ticket is always ok. > The weird thing is that sometimes the first reply > is okay but

RE: [rt-users] CustomFieldValues vs ObjectCustomFieldValues

2007-01-12 Thread Stephen Turner
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Mathew Snyder > Sent: Friday, January 12, 2007 2:25 AM > To: RT Users > Subject: [rt-users] CustomFieldValues vs ObjectCustomFieldValues > > According to the RT book, CustomFieldValues holds the li

Re: [rt-users] CustomFieldValues vs ObjectCustomFieldValues

2007-01-12 Thread Matthew Keller
ObjectCustomFieldValues table holds the actual values for the ticket, as you said. So if you want to see what someone SET a value to, for a ticket, you want to check the CustomField, which will be the 'id' of the field.. and Content, which is the value someone set. The 'ObjectId' in that table, re

[rt-users] Duplicating strings in subject

2007-01-12 Thread Валерий Харьков
Hi all. Sorry for poor english. :) I ve got some problem with RT 3.6. When i'am replyig or comments ticket, subject is changes to Re: [SMTH #100] Text. And when i'am reply to it several times, subject will be - [SMTH #100] Re: [SMTH #100] Re: [SMTH #100] Re: [SMTH #100] Text. How can i fix it

Re: [rt-users] Date.pm small query

2007-01-12 Thread Roy El-Hames
Yes, that was exactly what I did, discovered I had a typo and managed to sort it just before Ruslan reply .. Thanks to your self and Ruslan for you replies; Roy Jesse Vincent wrote: On Thu, Jan 11, 2007 at 05:31:36PM +, Roy El-Hames wrote: Sorry to be a pain Ruslan, but now I need to kn