[rt-users] Error on SetDue

2009-11-23 Thread TONY JOHN - ERS, HCL Tech
Hi,

Please find below the Custom action clean up code for Seting DueDate based on a 
condition:

use strict;
use warnings;
my $date1=$self-TicketObj-FirstCustomFieldValue('CI Valid Till');
my $date2=$self-TicketObj-FirstCustomFieldValue('Date In Gabriel');
my($mm1,$dd1,$1) = split /\//, $date1;
my($mm2,$dd2,$2) = split /\//, $date2;
my $duedate = $1.-.$mm1.-.$dd1. 00:00:00;
$self-TicketObj-SetDue( $duedate-ISO);
return 1;


Why is that the SetDue isnt working? Any help?

Regards,
Tony John

DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is 
strictly prohibited. If you have 
received this email in error please delete it and notify the sender 
immediately. Before opening any mail and 
attachments please check them for viruses and defect.

---
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Error on SetDue

2009-11-23 Thread berrebi

hi,

i don't know if it can help, but i don't use the -ISO on setDue.
$self-TicketObj-SetDue($duedate); // when $duedate = 2009--11-23 
00:00:00;

maybe this can help,
regards,

On 23/11/2009 11:20, TONY JOHN - ERS, HCL Tech wrote:


Hi,

Please find below the Custom action clean up code for Seting DueDate 
based on a condition:


use strict;

use warnings;

my $date1=$self-TicketObj-FirstCustomFieldValue('CI Valid Till');

my $date2=$self-TicketObj-FirstCustomFieldValue('Date In Gabriel');

my($mm1,$dd1,$1) = split /\//, $date1;

my($mm2,$dd2,$2) = split /\//, $date2;

my $duedate = $1.-.$mm1.-.$dd1. 00:00:00;

$self-TicketObj-SetDue( $duedate-ISO);

return 1;

Why is that the SetDue isnt working? Any help?

Regards,

Tony John

DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of
this message without the prior written consent of the author of this e-mail is 
strictly prohibited. If you have
received this email in error please delete it and notify the sender 
immediately. Before opening any mail and
attachments please check them for viruses and defect.

---



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Speeding up CLI RT::Shredder

2009-11-23 Thread Maxwell A. Rathbone
Hello,

I'm in the same boat as many others I've seen post. We have 35k tickets 
in one of our queues that I'm trying to shred(shame on us for not 
automating this previously). I've found the web version of the Shredder 
to be god-awful slow. We're talking 10min+ just to shred ONE ticket. So 
I discovered the command-line /opt/rt3/sbin/rt-shredder utility. I was 
then able to shred ONE ticket in about 5 minutes. I found some 
optimization keys to add to the tables, which allowed me to them shred 
ONE ticket in about a minute. I then discovered(this really should be in 
the documentation!), that if you specify a timeframe with rt-shredder, 
you can get MUCH faster processing. I was able to get it down to 
21seconds for the shredding of ONE ticket.

I noticed it was spitting out warning messages each time it deletes 
something. I honestly do not care about the output as long as it is 
working as expected, so I hunted through the code and was able to 
disable the on-screen logging altogether. I'm now able to shred ONE 
ticket in about 8-10 seconds.

For those who are interested in about a 50% reduction in processing time 
for the CLI Shredder, edit the file:
/opt/rt3/lib/RT/Shredder/Rercord.pm

Look for this line:
$RT::Logger-warning( $msg );

Comment it so it looks like this:
#$RT::Logger-warning( $msg );

a WORLD of difference from the 10 minutes per ticket I originally was 
getting. Now it looks like to shred the 35k might actually take a 
palatable amount of time.

I wanted to share this useful information on the list so it is google 
searchable. I'm SURE others will find this helpful.

BTW, the command I'm using to shred(again, documentation is kinda poor) is:
./rt-shredder --plugin Tickets=query,((status = 'deleted' OR status = 
'rejected') AND 
LastUpdated='2008-10-03');limit,100;with_linked,FALSE;apply_query_to_linked,FALSE
 
--force

Max
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Error on SetDue

2009-11-23 Thread Ken Crocker

Tony,

We have a Custom Field called Need-By Date that we have the customer 
fill out and we use that to set the Due Date of the ticket when they 
create a ticket. It overrides the default due date timing set up for the 
queue. This is the code we use:


#
# set new values for Due Date from CF Need-by-Date
#
my $trans = $self-TransactionObj;
my $ticket = $self-TicketObj;
my $cf_date = $ticket-FirstCustomFieldValue('Need-By Date');
# split up the date parts into a temporary array
my @parts = split(/[\/-]/, $cf_date);
# put date parts back together
my $new_date = sprintf(%d-%d-%d, $parts[2], $parts[0], $parts[1]);
# format new date based on RT
my $duedate = RT::Date-new($RT::SystemUser);
$duedate-Set(Format='unknown', Value=$new_date);
$ticket-SetDue($duedate-ISO);
return 1;

This works every time for us. Hope it helps.

Kenn
LBNL

On 11/23/2009 2:20 AM, TONY JOHN - ERS, HCL Tech wrote:


Hi,

 

Please find below the Custom action clean up code for Seting DueDate 
based on a condition:


 


use strict;

use warnings;

my $date1=$self-TicketObj-FirstCustomFieldValue('CI Valid Till');

my $date2=$self-TicketObj-FirstCustomFieldValue('Date In Gabriel');

my($mm1,$dd1,$1) = split /\//, $date1;

my($mm2,$dd2,$2) = split /\//, $date2;

my $duedate = $1.-.$mm1.-.$dd1. 00:00:00;

$self-TicketObj-SetDue( $duedate-ISO);

return 1;

 

 


Why is that the SetDue isnt working? Any help?

 


Regards,

Tony John

DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have 
received this email in error please delete it and notify the sender immediately. Before opening any mail and 
attachments please check them for viruses and defect.


---



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Speeding up CLI RT::Shredder

2009-11-23 Thread Torsten Brumm
Oha, this sounds really useful. Any comment from ruslan if this is save?

I have to shred several houndret thousend tickets from 2002-2007 and we need
also around 2 minutes per ticket, will try it out tomorrow!

Thanks for sharing this

Torsten

2009/11/23 Maxwell A. Rathbone mrathb...@sagonet.com

 Hello,

 I'm in the same boat as many others I've seen post. We have 35k tickets
 in one of our queues that I'm trying to shred(shame on us for not
 automating this previously). I've found the web version of the Shredder
 to be god-awful slow. We're talking 10min+ just to shred ONE ticket. So
 I discovered the command-line /opt/rt3/sbin/rt-shredder utility. I was
 then able to shred ONE ticket in about 5 minutes. I found some
 optimization keys to add to the tables, which allowed me to them shred
 ONE ticket in about a minute. I then discovered(this really should be in
 the documentation!), that if you specify a timeframe with rt-shredder,
 you can get MUCH faster processing. I was able to get it down to
 21seconds for the shredding of ONE ticket.

 I noticed it was spitting out warning messages each time it deletes
 something. I honestly do not care about the output as long as it is
 working as expected, so I hunted through the code and was able to
 disable the on-screen logging altogether. I'm now able to shred ONE
 ticket in about 8-10 seconds.

 For those who are interested in about a 50% reduction in processing time
 for the CLI Shredder, edit the file:
 /opt/rt3/lib/RT/Shredder/Rercord.pm

 Look for this line:
$RT::Logger-warning( $msg );

 Comment it so it looks like this:
 #$RT::Logger-warning( $msg );

 a WORLD of difference from the 10 minutes per ticket I originally was
 getting. Now it looks like to shred the 35k might actually take a
 palatable amount of time.

 I wanted to share this useful information on the list so it is google
 searchable. I'm SURE others will find this helpful.

 BTW, the command I'm using to shred(again, documentation is kinda poor) is:
 ./rt-shredder --plugin Tickets=query,((status = 'deleted' OR status =
 'rejected') AND

 LastUpdated='2008-10-03');limit,100;with_linked,FALSE;apply_query_to_linked,FALSE
 --force

 Max
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com




-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Speeding up CLI RT::Shredder

2009-11-23 Thread Maxwell A. Rathbone
I noticed a typo in probably the most important line in my message. The 
filename is actually:


/opt/rt3/lib/RT/Shredder/Record.pm

The line that I suggest to comment out, calls RT's built in Logger() 
function that basically just writes information either to the log or to 
the screen.


As with anytime you modify defaults, I make no claims other than what it 
had for me. :) I'm actually seeing slightly better than 50% improvement 
with that line disabled/commented out.


I hope others are able to confirm similar experiences. Look forward to 
reading about it.


Max

Torsten Brumm wrote:

Oha, this sounds really useful. Any comment from ruslan if this is save?

I have to shred several houndret thousend tickets from 2002-2007 and 
we need also around 2 minutes per ticket, will try it out tomorrow!


Thanks for sharing this

Torsten

2009/11/23 Maxwell A. Rathbone mrathb...@sagonet.com 
mailto:mrathb...@sagonet.com


Hello,

I'm in the same boat as many others I've seen post. We have 35k
tickets
in one of our queues that I'm trying to shred(shame on us for not
automating this previously). I've found the web version of the
Shredder
to be god-awful slow. We're talking 10min+ just to shred ONE
ticket. So
I discovered the command-line /opt/rt3/sbin/rt-shredder utility. I was
then able to shred ONE ticket in about 5 minutes. I found some
optimization keys to add to the tables, which allowed me to them shred
ONE ticket in about a minute. I then discovered(this really should
be in
the documentation!), that if you specify a timeframe with rt-shredder,
you can get MUCH faster processing. I was able to get it down to
21seconds for the shredding of ONE ticket.

I noticed it was spitting out warning messages each time it deletes
something. I honestly do not care about the output as long as it is
working as expected, so I hunted through the code and was able to
disable the on-screen logging altogether. I'm now able to shred ONE
ticket in about 8-10 seconds.

For those who are interested in about a 50% reduction in
processing time
for the CLI Shredder, edit the file:
/opt/rt3/lib/RT/Shredder/Rercord.pm

Look for this line:
   $RT::Logger-warning( $msg );

Comment it so it looks like this:
#$RT::Logger-warning( $msg );

a WORLD of difference from the 10 minutes per ticket I originally was
getting. Now it looks like to shred the 35k might actually take a
palatable amount of time.

I wanted to share this useful information on the list so it is google
searchable. I'm SURE others will find this helpful.

BTW, the command I'm using to shred(again, documentation is kinda
poor) is:
./rt-shredder --plugin Tickets=query,((status = 'deleted' OR status =
'rejected') AND

LastUpdated='2008-10-03');limit,100;with_linked,FALSE;apply_query_to_linked,FALSE
--force

Max
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
mailto:sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com




--
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Scrip to remove requestors based on group membership

2009-11-23 Thread Torsten Brumm
Hi,
have a look onto your code:

1. Condition:


==Condition==
my @exceptionGroups = ('no-reply');

my $principalobj = RT::Principal-new($RT::
SystemUser);
$principalobj-Load($self-TransactionObj-CreatorObj-Id);

my $transactionType = $self-TransactionObj-Type;
if ($transactionType eq 'Create') {
   foreach (@exceptionGroups) {
   my $groupobj = RT::Group-new($RT::SystemUser);
   $groupobj-LoadUserDefinedGroup($_);
   if ($groupobj-HasMemberRecursively($principalobj)) {
   return 1;
   }
   }
}
return 0;

I think, if you use the default condition (OnCreate) and do the rest inside
a userdefined action, this will work.

Torsten


2009/11/20 darthmarth37 darthma...@gmail.com

 I'm trying to write a scrip that removes the requestor of a new ticket
 if the requestor's email address is in a specific no-reply group in
 RT (for things like Nagios messages that don't need replies), and I
 think I'm getting confused when trying to make it work.  What I have
 so far (below) doesn't have any effect on new tickets.  Any ideas what
 I'm messing up?

 ==Condition==
 my @exceptionGroups = ('no-reply');

 my $principalobj = RT::Principal-new($RT::SystemUser);
 $principalobj-Load($self-TransactionObj-CreatorObj-Id);

 my $transactionType = $self-TransactionObj-Type;
 if ($transactionType eq 'Create') {
foreach (@exceptionGroups) {
my $groupobj = RT::Group-new($RT::SystemUser);
$groupobj-LoadUserDefinedGroup($_);
if ($groupobj-HasMemberRecursively($principalobj)) {
return 1;
}
}
 }
 return 0;

 ==Action==
 my $principalobj = RT::Principal-new($RT::SystemUser);
 $principalobj-Load($self-TransactionObj-CreatorObj-Id);

 my ($status, $msg) = $self-TicketObj-DeleteWatcher(Type =
 Requestor, PrincipalId = $principalobj);
 return $status;
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com




-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Backup a queue question

2009-11-23 Thread Torsten Brumm
Have a look onto RTx-Shredder at cpan, this will help you!

Torsten

2009/11/9 PF phan...@gmail.com

 I need to backup everything in 2 queues but nothing else.  I'm a database
 .. well I'm poor at it.  I've looked through
 site:bestpractical.com (keywords)
 but not really found anything on single queues.
 Is this possible?

 If not I can take a full dump and delete all the queues but need assurances
 that the queues and tickets I delete are purged.

 Thanks for you help!

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com




-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] [Rt-announce] 2010 RT Training Sessions

2009-11-23 Thread Cassandra Phillips-Sears
Best Practical Solutions provides unparalleled instruction in how to
get the most out of RT. We've been teaching users and administrators
how to get the most out of RT since 2001. Since 2003, we've offered
intensive one-day RT administrator training sessions to the general
public.

2010 will bring four different training sessions for RT, with training  
split across two days. The first day starts off with a tour of RT's  
web interface and continues with a detailed exploration and  
explanation of RT's functionality, workflows and configurability.  
We'll touch on basic administration, but concentrate largely on  
helping you and your team get the most out of your RT instance.

The second day of training picks up with basic RT administration and
covers everything from point-and-click configuration to installation
of RT, development best practices and database tuning.

It goes without saying that you'll get the most out of training if you
attend both days of the course, but we've designed the material so
that you can step out after the first day with a dramatically improved
understanding of how to use RT or show up on the second day and get
quickly up to speed on how to make RT do your bidding.

A spot at either day costs $995 USD for US Training / 695 EUR for  
European Training. You can save 25% if you attend both days of  
training. That's just $1495 USD / 1042.50 EUR!

If you reserve before January 20th for the San Francisco session,   
February 15th for the Dublin session, March 5th for the Boston  
session, or September 20th for the Washington DC session, you can save  
an additional 20% by mentioning the discount code ANNOUNCE10. If you  
buy online, we'll automatically apply the discount.

Each class includes a morning snack, coffee/tea, and an afternoon  
snack, as well as all training materials.

Day 1 - RT User Training

This intensive day-long tutorial about RT starts with basic day-to-day
use and continues with detailed training about advanced RT features
including saved searches, dashboards, data analysis and options for
automating your workflow.

This session will cover:

  * The purpose and general use of RT
  * New features in RT 3.8
  * Saved Searches and customizing searches
  * RT's Dashboards feature
  * Customizing RT's workflow to match your own
  * Automating common procedures
  * How to make simple custom reports based on RT's data
  * A short intro to RTFM, the RT FAQ Manager
  * General QA Session

Day 2 - RT Administration and Development

   This intensive day-long session aimed at RT administrators and
developers covers everything from installation to backups, interface
and backend customizations. You'll learn how to customize RT to meet
your organization's unique needs and how to make sure that RT stays
fast, reliable and flexible.

This session will cover:

  * New features in RT 3.8 RT's system architecture
  * A guided tour of the RT source code
  * Extension mechanisms you can use to customize RT
  * RT Installation, including the basics of Configuration
  * Examples of how to optimize RT for your organization
  * How to tie RT into your existing authentication infrastructure
  * Building your own tools that talk to the RT backend
  * Customizing RT's workflow to match your own
  * Automating common procedures
  * How to write custom reports based on RT's data
  * Custom coding, modifications, and callback creation
  * A brief preview of RT4
  * General QA Session

These sessions will be offered in:

San Francisco, CA, USA - February 22  23 2010
Dublin, Ireland - March 15  16 2010
Boston, MA, USA - April 5  6 2010
Washington DC, USA - Oct 25  26 2010

If you can't make it to these cities, please drop us a line to
request a public training in your area. We haven't yet scheduled
training for 2011; your feedback will help us decide
where to offer additional sessions.

Private Training
We also offer private training sessions tailored to your organization's
needs. For more information about on-site training for your
organization, please drop us a line at train...@bestpractical.com.

Reservations
We like to keep class sizes relatively intimate. Please register soon or
we may not be able to guarantee you a seat.

When you register, please tell us which date(s) you are registering  
for, and whether you'd like to register for the whole training session  
or for only a single day.

If you'd like to pay via credit card, please visit Best Practical's  
online store at https://shop.bestpractical.com/

If you'd prefer to reserve a seat and have us bill you, please write to
us at train...@bestpractical.com. Be sure to include the full names  
and email addresses of all attendees you'd like to register for  
training.
--
Cassandra Phillips-Sears
cassan...@bestpractical.com

Office Manager
Best Practical Solutions, LLC
http://www.bestpractical.com

___

[rt-users] Tracking changes to queue structure

2009-11-23 Thread gordon
RT provides an excellent history log of all activities relating to a 
ticket. This provides an unchangeable record which auditors love when 
reviewing tickets.

However we occasionally make changes to a queue such as adding a new 
custom field. This does not get filled in for historical tickets (too 
many) only new ones. When reviewing the old tickets auditors ask why the 
fields were not filled in correctly.

We handle this by keeping a separate log of changes we make to queues 
and when they were made.

My question is: does anyone else keep track of the changes they make to 
queues, and if so, how do you do it? Is there any way to do this within 
RT - I would love to do so but have no idea where to begin.

thanks
Gordon
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread Ken Crocker
Gordon,

RT has a Bulk Update feature which would allow you to add whatever 
value to specific Custom Fields on tickets in specific Queues as well as 
add comments to specific tickets in a queue. By specific, I mean 
whatever criteria you use for selecting the ticket you want to update.

Kenn
LBNL

On 11/23/2009 3:01 PM, gor...@cryologic.com wrote:
 RT provides an excellent history log of all activities relating to a 
 ticket. This provides an unchangeable record which auditors love when 
 reviewing tickets.

 However we occasionally make changes to a queue such as adding a new 
 custom field. This does not get filled in for historical tickets (too 
 many) only new ones. When reviewing the old tickets auditors ask why the 
 fields were not filled in correctly.

 We handle this by keeping a separate log of changes we make to queues 
 and when they were made.

 My question is: does anyone else keep track of the changes they make to 
 queues, and if so, how do you do it? Is there any way to do this within 
 RT - I would love to do so but have no idea where to begin.

 thanks
 Gordon
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

   
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] RT installed in a subdirectory (without a RT specific virtual host)

2009-11-23 Thread [ ravi ]
Hello all,

this question appears in the archive but the suggested answer does not  
quite work; I am hoping some of you will be able to suggest solutions.  
My problem is that I am trying to install RT on an existing web server  
(Apache 2.x with mod_perl2 on Ubuntu8), in a sub-directory. I went  
through the configure/install steps, installing RT into /tools/pkgs/ 
rt-3.8.6. Now in trying to configure the web interface I hit various  
snags.

Say my site is http://example.com; and I want RT to be at 
http://example.com/rt 
. I configured RT_SiteConfig and set WebPath to /rt. I changed /etc/ 
apache2/sites-enabled/000-default and added:

Alias /rt /tools/pkg/rt/share/html

Location /rt/
 SetHandler perl-script
 PerlHandler RT::Mason
/Location

(where /tools/pkg/rt is a symlink to /tools/pkg/rt-3.8.6)

The problem now is that I have to add:

PerlRequire /tools/pkg/rt/bin/webmux.pl

and according to some docs, also:

PerlModule Apache::DBI

These directives are permitted only at the global or server context,  
so given my sub-directory based RT setup (rather than a RT dedicated  
virtualhost) I have to add them to the top/global configuration. Or is  
there a way around?

When I do add these to the global config, I still get errors:

Can't locate /tools/pkg/rt/bin/webmux.pl in @INC (@INC contains: / 
tools/pkgs/rt/bin /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/ 
perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/ 
share/perl/5.8 /usr/local/lib/site_perl . /etc/apache2)

Apache/mod_perl config seems to restrict loading of PerlRequires from  
only @INC. I have started reading through the mod_perl docs to find  
out how to relax this, especially for an absolute path as above for  
webmux.pl. But perhaps someone here knows the way to fix this already?

I would greatly appreciate any solutions or pointers to solutions for  
both issues above.

Regards,

--ravi

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread gordon
Thanks Ken,

I use this feature for some fields but others require information 
specific to a ticket (eg description of product design change). Also, 
reviewers of historical tickets can still ask the question: why wasn't 
the field filled in when the ticket was active?

Gordon


Ken Crocker wrote:
 Gordon,
 
 RT has a Bulk Update feature which would allow you to add whatever 
 value to specific Custom Fields on tickets in specific Queues as well as 
 add comments to specific tickets in a queue. By specific, I mean 
 whatever criteria you use for selecting the ticket you want to update.
 
 Kenn
 LBNL
 
 On 11/23/2009 3:01 PM, gor...@cryologic.com wrote:
 RT provides an excellent history log of all activities relating to a 
 ticket. This provides an unchangeable record which auditors love when 
 reviewing tickets.

 However we occasionally make changes to a queue such as adding a new 
 custom field. This does not get filled in for historical tickets (too 
 many) only new ones. When reviewing the old tickets auditors ask why the 
 fields were not filled in correctly.

 We handle this by keeping a separate log of changes we make to queues 
 and when they were made.

 My question is: does anyone else keep track of the changes they make to 
 queues, and if so, how do you do it? Is there any way to do this within 
 RT - I would love to do so but have no idea where to begin.

 thanks
 Gordon
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread Nick Kartsioukas
On Tue, 24 Nov 2009 10:35:31 +1100, gor...@cryologic.com said:
 I use this feature for some fields but others require information 
 specific to a ticket (eg description of product design change). Also, 
 reviewers of historical tickets can still ask the question: why wasn't 
 the field filled in when the ticket was active?

I would do this:
1) Create the new custom field, and add any selection values to it that
you'll need (if it's not a fill-in-the-blank type CF)
2) Also add a selection value of Field not available at time of ticket
creation
3) Using Bulk Update, set that CF value to Field not available at time
of ticket creation for all existing tickets
4) Go back to the custom field settings, delete the value Field not
available at time of ticket creation as an option
5) Explain to the auditors that new fields are added every so often, and
explain the procedure you went through to set that value, emphasizing
that by removing that particular value as an option, users are unable to
set any new ticket custom field to that value.

That should hopefully be sufficient to satisfy everyone...
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Tracking changes to queue structure

2009-11-23 Thread gordon
Nice idea, I like it!

thanks
Gordon


Nick Kartsioukas wrote:
 On Tue, 24 Nov 2009 10:35:31 +1100, gor...@cryologic.com said:
 I use this feature for some fields but others require information 
 specific to a ticket (eg description of product design change). Also, 
 reviewers of historical tickets can still ask the question: why wasn't 
 the field filled in when the ticket was active?
 
 I would do this:
 1) Create the new custom field, and add any selection values to it that
 you'll need (if it's not a fill-in-the-blank type CF)
 2) Also add a selection value of Field not available at time of ticket
 creation
 3) Using Bulk Update, set that CF value to Field not available at time
 of ticket creation for all existing tickets
 4) Go back to the custom field settings, delete the value Field not
 available at time of ticket creation as an option
 5) Explain to the auditors that new fields are added every so often, and
 explain the procedure you went through to set that value, emphasizing
 that by removing that particular value as an option, users are unable to
 set any new ticket custom field to that value.
 
 That should hopefully be sufficient to satisfy everyone...
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Is SQLite no longer supported?

2009-11-23 Thread Todd Chapman
I just checked RT out of git and ran:

./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite

But the database type is set to 'mysql' in RT_Config.pm.

What gives? The schema.SQLite file still exists.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Is SQLite no longer supported?

2009-11-23 Thread Jesse Vincent



On Mon, Nov 23, 2009 at 10:33:16PM -0500, Todd Chapman wrote:
 I just checked RT out of git and ran:
 
 ./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite

It helps if you don't misspell '--with-db-type'


 
 But the database type is set to 'mysql' in RT_Config.pm.
 
 What gives? The schema.SQLite file still exists.
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
 

-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Is SQLite no longer supported?

2009-11-23 Thread Todd Chapman
On Mon, Nov 23, 2009 at 10:35 PM, Jesse Vincent je...@bestpractical.com wrote:



 On Mon, Nov 23, 2009 at 10:33:16PM -0500, Todd Chapman wrote:
 I just checked RT out of git and ran:

 ./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite

 It helps if you don't misspell '--with-db-type'


Crap. Thanks Jesse!



 But the database type is set to 'mysql' in RT_Config.pm.

 What gives? The schema.SQLite file still exists.
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com


 --

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Database upgrade failing 3.8.4 to 3.8.6

2009-11-23 Thread Arends, John
When upgrading from 3.8.4 to 3.8.6 I'm getting this error when running  
bin/rt-setup-database --dba rt_user --prompt-for-dba-password --action  
upgrade

[Tue Nov 24 04:23:47 2009] [crit]: Can't locate RT/FM.pm in @INC (@INC  
contains: /root/rt-3.8.6/sbin/../local/lib /root/rt-3.8.6/sbin/../lib / 
usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/ 
site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/ 
5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/ 
lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi / 
usr/lib/perl5/5.8.8 .) at /root/rt-3.8.6/sbin/../lib/RT.pm line 627,  
STDIN line 4. (/root/rt-3.8.6/sbin/../lib/RT.pm:377)
Can't locate RT/FM.pm in @INC (@INC contains: /root/rt-3.8.6/sbin/../ 
local/lib /root/rt-3.8.6/sbin/../lib /usr/lib/perl5/site_perl/5.8.8/ 
i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/ 
site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi / 
usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/ 
perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /root/ 
rt-3.8.6/sbin/../lib/RT.pm line 627, STDIN line 4.

I have an RT test system that is configured the same as this machine  
and the database upgrade went fine.

I'm making sure to do this inside the rt-3.8.6 directory, and not in / 
opt/rt3 since /opt/rt3 does not have the necessary upgrade files  
inside etc.

Any ideas?
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] QuickSearch Too Slow - rt-3.6.0

2009-11-23 Thread Umasankar Pandurangan
Hi,

I am using RT v3.6.0 on RHEL AS 3 with Oracle 9i as the back-end database on a 
Pentium server with 1GB of RAM. This RT instance is hosting two business 
applications and there are close to 1200 queues on it.

I am facing an issue with the QuickSearch widget on the RT web interface. It 
was too slow to load causing user login delays and sometimes it doesn't load at 
all. So I removed it from the RT at a glance page and made it available under 
a custom section I created on the left side menu. This addressed the login 
slowness issue much to the delight of most of the end users. However, some 
users who tend to use QuickSearch actively for getting an overview of ticket 
statistics on queues relevant to them complain that QuickSearch is too slow 
;-)

I am looking for some ways to quicken up (and to justify the nomenclature to 
the end users :) ) this widget. Any ideas/suggestions would be appreciated.

Thanks.

PS: I did a search in wiki and lists but didn't find a case matching the 
problem I am facing. That's why I am writing to this list.

Regards,

Umasankar P

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] QuickSearch Too Slow - rt-3.6.0

2009-11-23 Thread Emmanuel Lacour
On Tue, Nov 24, 2009 at 01:01:39PM +0530, Umasankar Pandurangan wrote:
 Hi,
 
 I am using RT v3.6.0 on RHEL AS 3 with Oracle 9i as the back-end
 database on a Pentium server with 1GB of RAM. This RT instance is
 hosting two business applications and there are close to 1200 queues
 on it.
 
 I am facing an issue with the QuickSearch widget on the RT web
 interface. It was too slow to load causing user login delays and
 sometimes it doesn't load at all. So I removed it from the RT at a
 glance page and made it available under a custom section I created on
 the left side menu. This addressed the login slowness issue much to
 the delight of most of the end users. However, some users who tend to
 use QuickSearch actively for getting an overview of ticket
 statistics on queues relevant to them complain that QuickSearch is
 too slow ;-)
 
 I am looking for some ways to quicken up (and to justify the
 nomenclature to the end users :) ) this widget. Any ideas/suggestions
 would be appreciated.
 
 Thanks.
 
 PS: I did a search in wiki and lists but didn't find a case matching
 the problem I am facing. That's why I am writing to this list.
 


Look here:

http://www.gossamer-threads.com/lists/rt/users/75763?search_string=quicksearch%20slow;#75763

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com