Re: [rt-users] Packagelist for RT38 on RHEL/Centos/SL 5

2008-06-16 Thread Sven Sternberger
Updated Version for 3.8rc1 regards! sven Install Machine without any extra package (minimum) Enable dag and atrpm repository in /etc/yum.repos.d yum install === gcc ntp httpd mod_perl mod_auth_kerb mod_ssl distcache mysql postfix mysql-server perl-TermReadKey perl-libwww-perl perl-HTML

[rt-users] Need to make a report and not sure how to do it

2008-06-16 Thread Greg Evans
Is there a way for me to run a report that would list all users and then group them by # of tickets created and show the subject of each ticket? I am thinking a 3 column table Col1, Cell 1: user1 Col 2, cell 1: all tickets for user1, col 3, cell 1: total# of tix and then sort it by #tix created? G

Re: [rt-users] Need to make a report and not sure how to do it

2008-06-16 Thread Jason Fenner
Greg Evans wrote: > > Is there a way for me to run a report that would list all users and > then group them by # of tickets created and show the subject of each > ticket? I am thinking a 3 column table Col1, Cell 1: user1 Col 2, cell > 1: all tickets for user1, col 3, cell 1: total# of tix and t

Re: [rt-users] Need to make a report and not sure how to do it

2008-06-16 Thread Greg Evans
Thanks, I will try to look into that. Looks like it may be difficult :) Greg Evans Hood Canal Communications (360) 898-2481 ext.212 -Original Message- From: Jason Fenner [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2008 1:07 PM To: Greg Evans Cc: rt-users@lists.bestpractical.com Sub

[rt-users] [Rt-announce] RT 3.6.7

2008-06-16 Thread Jesse Vincent
I'm pleased to announce the latest release of RT 3.6. This update contains important bugfixes, as well as minor functionality improvements. You can download this version of RT at the following URL: http://download.bestpractical.com/pub/rt/release/rt-3.6.7.tar.gz http://download.bestpractical.

Re: [rt-users] new language

2008-06-16 Thread Ruslan Zakirov
On Sun, Apr 6, 2008 at 3:03 PM, Victor Sterpu <[EMAIL PROTECTED]> wrote: > I tranaslated the romanian language. > > Can you add this file in the next versions? > > In the file there are a lot off line marked with NOT FOUND IN SOURCE. Most probably those have been changed a little in the source or g

[rt-users] Sort by DueDate excluding 'not set' tickets

2008-06-16 Thread Tom Lanyon
Hi all, I need to sort tickets by due date ascending to display oldest due dates first. Tickets with no due date should come after as there's no impending timeline. However, because a due date of 'not set' is numerically 0, it sorts before any tickets that have a due date set. Anyone have

[rt-users] How to convert an existing RT from Postgres to MySQL?

2008-06-16 Thread Todd Chapman
Someone wants me to convert their Postgres backed RT to MySQL. Doesn't matter why, they want it. :) Here's what I am thinking. 1. Shut down the web server. 2. Dump the DB data. 3. Reconfigure RT for MySQL. 4. Run initdb 5. Load the data. 6. Restart the RT/web server. Have I covered all my bases?

Re: [rt-users] How to convert an existing RT from Postgres to MySQL?

2008-06-16 Thread Joop
Todd Chapman wrote: > Someone wants me to convert their Postgres backed RT to MySQL. Doesn't > matter why, they want it. :) > > Here's what I am thinking. > > 1. Shut down the web server. > 2. Dump the DB data. > 3. Reconfigure RT for MySQL. > 4. Run initdb > 5. Load the data. > 6. Restart the RT/