Re: [rt-users] RT email EX_TEMPFAIL looping problem

2009-12-21 Thread Venkateswaran, Subbaraman
Can someone please help with this issue? We are seeing this problem in
production and end up clearing the email from the mail queue manually
everytime we see this problem. Thanks for your help.

Thanks
Subba Venkateswaran 
AT - App Eng - SEG
609 282 7015


 _ 
 From: Venkateswaran, Subbaraman  
 Sent: Friday, December 18, 2009 10:09 AM
 To:   rt-users@lists.bestpractical.com
 Subject:  RT email EX_TEMPFAIL looping problem
 
 
 Platform/Env:
 RT 3.6.4, MySQL 5.1.34, Linux 2.6.9-42.ELsmp
 
 Problem:
 We are experiencing sporadic email looping problem. From the mail
 relay server, emails bound for RT are aliased and piped to rt-mailgate
 and recorded as correspondence into certain queues. For some emails,
 rt-mailgate gets a return code EX_TEMPFAIL and the mail server does
 not remove the email from its queue. This results in repetitive
 posting and email flooding and finally we have to delete this email
 from the queue to stop multiple posting.
 
 Mail server aliases entry:
 rt: | path-to/rt-mailgate --url http://rt-server.com --queue general
 --action correspond
 
 Even though rt-mailgate gets a return code EX_TEMPFAIL, the email
 seems to have recorded fine in RT and we could see the ticket and
 attachments created fine in RT.  
 
 Please help us out with this problem and we are trying to understand
 if this is any data inconsistency problem in RT or something else?
 
 Some log entries from the RT server during this email looping. These
 logs maynot be relevant to the problem, but I would like to present it
 anyway if it might be helpful.
 
 Access log:
 172.16.72.205 - - [10/Dec/2009:06:19:16 -0500] POST
 /REST/1.0/NoAuth/mail-gateway HTTP/1.1 500 622 -
 libwww-perl/5.800 1792
 172.16.72.205 - - [10/Dec/2009:07:02:28 -0500] POST
 /REST/1.0/NoAuth/mail-gateway HTTP/1.1 500 622 -
 libwww-perl/5.800 20992
 
 Error log:
 [Thu Dec 10 06:29:16 2009] [error] [client 172.16.72.205] FastCGI:
 comm with server mason_handler.fcgi aborted: idle timeout (600 sec)
 [Thu Dec 10 07:12:28 2009] [error] [client 172.16.72.205] FastCGI:
 comm with server mason_handler.fcgi aborted: idle timeout (600 sec)
 
 FastCGI: incomplete headers (0 bytes) received from server
 mason_handler.fcgi
 
 [error]: couldn't load cf {$value} || $value }
 (lib/RT/Action/ExtractCustomFieldValues.pm:86)
 
 
 Thanks
 Subba Venkateswaran 
 
 

THIS MESSAGE AND ANY ATTACHMENTS ARE CONFIDENTIAL, PROPRIETARY, AND MAY BE 
PRIVILEGED.  If this message was misdirected, BlackRock, Inc. and its 
subsidiaries, (BlackRock) does not waive any confidentiality or privilege.  
If you are not the intended recipient, please notify us immediately and destroy 
the message without disclosing its contents to anyone.  Any distribution, use 
or copying of this e-mail or the information it contains by other than an 
intended recipient is unauthorized.  The views and opinions expressed in this 
e-mail message are the author's own and may not reflect the views and opinions 
of BlackRock, unless the author is authorized by BlackRock to express such 
views or opinions on its behalf.  All email sent to or from this address is 
subject to electronic storage and review by BlackRock.  Although BlackRock 
operates anti-virus programs, it does not accept responsibility for any damage 
whatsoever caused by viruses being passed.


   ___
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 email EX_TEMPFAIL looping problem

2009-12-18 Thread Venkateswaran, Subbaraman

Platform/Env:
RT 3.6.4, MySQL 5.1.34, Linux 2.6.9-42.ELsmp

Problem:
We are experiencing sporadic email looping problem. From the mail relay
server, emails bound for RT are aliased and piped to rt-mailgate and
recorded as correspondence into certain queues. For some emails,
rt-mailgate gets a return code EX_TEMPFAIL and the mail server does not
remove the email from its queue. This results in repetitive posting and
email flooding and finally we have to delete this email from the queue
to stop multiple posting.

Mail server aliases entry:
rt: | path-to/rt-mailgate --url http://rt-server.com --queue general
--action correspond

Even though rt-mailgate gets a return code EX_TEMPFAIL, the email seems
to have recorded fine in RT and we could see the ticket and attachments
created fine in RT.  

Please help us out with this problem and we are trying to understand if
this is any data inconsistency problem in RT or something else?

Some log entries from the RT server during this email looping. These
logs maynot be relevant to the problem, but I would like to present it
anyway if it might be helpful.

Access log:
172.16.72.205 - - [10/Dec/2009:06:19:16 -0500] POST
/REST/1.0/NoAuth/mail-gateway HTTP/1.1 500 622 - libwww-perl/5.800
1792
172.16.72.205 - - [10/Dec/2009:07:02:28 -0500] POST
/REST/1.0/NoAuth/mail-gateway HTTP/1.1 500 622 - libwww-perl/5.800
20992

Error log:
[Thu Dec 10 06:29:16 2009] [error] [client 172.16.72.205] FastCGI: comm
with server mason_handler.fcgi aborted: idle timeout (600 sec)
[Thu Dec 10 07:12:28 2009] [error] [client 172.16.72.205] FastCGI: comm
with server mason_handler.fcgi aborted: idle timeout (600 sec)

FastCGI: incomplete headers (0 bytes) received from server
mason_handler.fcgi

[error]: couldn't load cf {$value} || $value }
(lib/RT/Action/ExtractCustomFieldValues.pm:86)


Thanks
Subba Venkateswaran 



THIS MESSAGE AND ANY ATTACHMENTS ARE CONFIDENTIAL, PROPRIETARY, AND MAY BE 
PRIVILEGED.  If this message was misdirected, BlackRock, Inc. and its 
subsidiaries, (BlackRock) does not waive any confidentiality or privilege.  
If you are not the intended recipient, please notify us immediately and destroy 
the message without disclosing its contents to anyone.  Any distribution, use 
or copying of this e-mail or the information it contains by other than an 
intended recipient is unauthorized.  The views and opinions expressed in this 
e-mail message are the author's own and may not reflect the views and opinions 
of BlackRock, unless the author is authorized by BlackRock to express such 
views or opinions on its behalf.  All email sent to or from this address is 
subject to electronic storage and review by BlackRock.  Although BlackRock 
operates anti-virus programs, it does not accept responsibility for any damage 
whatsoever caused by viruses being passed.


   ___
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 web request timeout

2009-09-16 Thread Venkateswaran, Subbaraman
Can someone suggest a way we could set a time out for web request to RT?
The main problem is that we do not want to allow external applications
accessing RT over http beyond a certain specific time. Due to these long
running process, RT crawls and eventually runs extremely slow.

What we are thinking is to set a time limit for the Mason Web Handler
and kill the process if it exceeds a n seconds. The FastCGIServer
appConnTimeout and idle-timeout does help with this requirement but they
kind of kill abruptly. We want to kill the process gracefully by doing a
proper handler cleanrequests.

Appreciate your help here.

Thanks
Subba Venkateswaran 
AT - App Eng - SEG
609 282 7015


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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 Bounce emails

2009-08-18 Thread Venkateswaran, Subbaraman

Hello everyone,

We have been getting these RT thinks this message may be a bounce
emails, whenever some emails are sent out with a header sample like
below:

From: pf...@blackrock.com
To:   r...@blackrock.com
CC:   pf...@blackrock.com
Reply-To: r...@blackrock.com, pf...@blackrock.com

Any help would be appreciated. Is it because the From address is also
there in CC (pf...@blackrock.com) ?

Thanks
Subba Venkateswaran 
AT - App Eng - SEG
609 282 7015


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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 data size maintenance

2009-07-30 Thread Venkateswaran, Subbaraman
Could someone please help with an approach to delete all attachments in
RT database earlier than an year (or so)? We are max'ing out RT database
size and would like to perform some cleanup. Or if there is a better way
to do these type of maintenance, please do let us know. Appreciate your
help.

Thanks
Subba Venkateswaran 
AT - App Eng - SEG
609 282 7015


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] RT data size maintenance

2009-07-30 Thread Venkateswaran, Subbaraman
Our requirements say that we should not ever delete historical RT tickets. So 
we would appreciate the best possible way to delete attachments of size  1MB 
(for e.g.). Btw, we are running RT 3.6.4. Thanks for your time.
 

Thanks 
Subba Venkateswaran 
AT - App Eng - SEG 
609 282 7015 

 



From: Brumm, Torsten / Kuehne + Nagel / Ham MI-ID 
[mailto:torsten.br...@kuehne-nagel.com] 
Sent: Thursday, July 30, 2009 9:59 AM
To: Venkateswaran, Subbaraman; rt-users@lists.bestpractical.com
Subject: AW: [rt-users] RT data size maintenance


Hi,
 
be very, very, very careful doing this on DB level, you should give 
RTx-Shredder a try, but touching the DB directly is not a good Idea!
 
Torsten



Kühne + Nagel (AG  Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), 
Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, 
Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer 
Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 
812773878, Persönlich haftende Gesellschaft: Kühne  Nagel A.G., Sitz: 
Contern/Luxemburg, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne 




Von: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Venkateswaran, 
Subbaraman
Gesendet: Donnerstag, 30. Juli 2009 14:18
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] RT data size maintenance



Could someone please help with an approach to delete all attachments in RT 
database earlier than an year (or so)? We are max'ing out RT database size and 
would like to perform some cleanup. Or if there is a better way to do these 
type of maintenance, please do let us know. Appreciate your help.

Thanks 
Subba Venkateswaran 
AT - App Eng - SEG 
609 282 7015 


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] Spam filtering in RT

2009-07-06 Thread Venkateswaran, Subbaraman
Hello everyone,

Would like to understand what's the best strategy to stop spam emails
creating tickets in RT ? Thanks for your time.

Thanks
Subba Venkateswaran 
AT - App Eng - SEG
609 282 7015


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] Search page Owners drop-down

2009-06-01 Thread Venkateswaran, Subbaraman
I verified the permission of OwnTicket and it is not assigned to
Everyone group. Is there any other perms/location I should look into?
Thanks.
 

Thanks 
Subba Venkateswaran 
AT - App Eng - SEG 
609 282 7015 

 



From: Ken Crocker [mailto:kfcroc...@lbl.gov] 
Sent: Wednesday, May 20, 2009 12:58 PM
To: Venkateswaran, Subbaraman
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search page Owners drop-down


Subb,

Most likely, you have a very Liberal application of the
OwnTicket right. For example, if you let just about anyone create a
ticket AND you have given the OwnTicket right to Everyone Globally,
then guess what? Every ticket that exists in every queue will most
likely have a REALLY long list of possible owners. This will also kick
your Query/search speed into granny low. Try breaking down the
privileges you have into something with more granularity.

Kenn
LBNL

On 5/19/2009 6:17 AM, Venkateswaran, Subbaraman wrote: 

Can someone please explain why we see all kinds of emails, junk
in addition to Login IDs in the Owners drop-down in RT search page? Is
there a way we can control or maintain this, please?  This is screwing
up people's RT search on tickets based on owners.

Thanks a lot. 


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY
BE PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM
DISCLOSURE. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution, copying or
use of this message and any attachment is strictly prohibited. If you
have received this message in error, please notify us immediately by
replying to the message and permanently delete it from your computer and
destroy any printout thereof.





___
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


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] Search page Owners drop-down

2009-05-19 Thread Venkateswaran, Subbaraman
Can someone please explain why we see all kinds of emails, junk in
addition to Login IDs in the Owners drop-down in RT search page? Is
there a way we can control or maintain this, please?  This is screwing
up people's RT search on tickets based on owners.

Thanks a lot.

THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] Upgrading DBIx::SearchBuilder

2009-04-01 Thread Venkateswaran, Subbaraman
Can someone please share your experience on this upgrade? Thanks a lot.

 _ 
 From: Venkateswaran, Subbaraman  
 Sent: Friday, March 27, 2009 9:53 AM
 To:   rt-users@lists.bestpractical.com
 Subject:  Upgrading DBIx::SearchBuilder
 
 Hello everyone,
 
 We are working on a plan to upgrade DBIx::SearchBuilder to improve
 performance mainly on our extensive reporting on RT platform. Do we
 have any upgrade path with any compatibility chart for upgrading the
 SearchBuilder module?
 Our env is RT 3.6.4/GNU Linux/MySQL 5.0.21
 
 Thanks for your time,
 Subba
 

THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] Upgrading DBIx::SearchBuilder

2009-03-27 Thread Venkateswaran, Subbaraman
Hello everyone,

We are working on a plan to upgrade DBIx::SearchBuilder to improve
performance mainly on our extensive reporting on RT platform. Do we have
any upgrade path with any compatibility chart for upgrading the
SearchBuilder module?
Our env is RT 3.6.4/GNU Linux/MySQL 5.0.21

Thanks for your time,
Subba


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] Transferring CustomField Values from old to new on all tickets in a queue

2009-03-26 Thread Venkateswaran, Subbaraman
Ken Thanks for your suggestions. Just thought of sharing the path we
took to fix this issue...
 
1. Basically we identified that one unique CF that we want across all
queues
2. Added it to the Queue
3. Ran a script to copy data from the old CF to the new CF on all
tickets in this queue. This we did it using a template that we found in
RT wiki
http://wiki.bestpractical.com/view/ImportCustomFieldValues
and basically used the HasEntry, AddCustomFieldValue methods from
objectcustomfieldvalues to accomplish this.
4. Detached the old CF from the Queue.
 
What we are planning is to do the same for all dup'ed CFs on all the
queue. Many one time effort but could pay us in long run on ease of
maintenance.
 
Thanks
Subba
 



From: Ken Crocker [mailto:kfcroc...@lbl.gov] 
Sent: Friday, March 20, 2009 2:21 PM
To: Venkateswaran, Subbaraman
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Transferring CustomField Values from old to new
on all tickets in a queue


Subbaraman,


Yes. I've been thru this several times. Each time I found a better
way to do it. First off, you have to decide what the CF name will be for
ALL the queues that will be using it. Secondly, you have to have a
consensus on the values you will allow. Third, you create the NEW CF and
it's values. Now, if you have a CF that already exists and you want to
use it, then you still need to set up all the values. The last step is
to APPLY this particular CF to all the queues that will be using it.
Once that is done, set up some scripts (NOT scrips) that detail which
OLD CFs should be WHAT VALUE for the NEW CF. Once that is done, you
execute each of those scripts for EACH queue by running a query to pull
ALL tickets of each queue (1 queue at a time) and use the bulk update
feature to set the new value for the new CF based on the
script/selection criteria for the OLD CF.
For example. Let's say I have 3 CF's that are similar. I take CF1
and set up all the values I want it to have. If there are any values I
want to get rid of, I add the news ones first, then run a Search/Bulk
Update to change the values I want to get rid of to the new values.
Select all tickets where CF1 value = X. Bulk Update the results to be
CF1 value = Y. This would be the basic routine you walk thru for EACH
and EVERY value of CF2 and CF3 for Each Queue that uses CF2 and CF3, 1
Queue at a time.
That should do it. There are no real shortcuts that I know of for
this kind of thing. You COULD use SQL and do this DIRECTLY to the
DataBase, but that get REAL messy and I do NOT recommend it.
Hope this helps.


Kenn
LBNL

On 3/20/2009 7:42 AM, Venkateswaran, Subbaraman wrote: 

We are using RT 3.6.4 and what we are trying to do is to
synchronize custom field across all queues and basically have one unique
custom field and type. Currently we have some CFs with the same name and
different types dupe'ed across all the queues. Is there a way we can
script around to move all the values from oldCF to new CF on all tickets
in a Queue ?

For e.g.: 
CF Name XYZ, Type: Enter multiple values 
CF Name XYZ, Type: Text 
Move all the values on XYZ(enter multiple values) to the CF
XYZ(Text) on all tickets in a Queue. 

Once this is done we will disconnect the old CF XYZ(Enter
multiple values) from the Queue. 

Thanks for your help 


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY
BE PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM
DISCLOSURE. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution, copying or
use of this message and any attachment is strictly prohibited. If you
have received this message in error, please notify us immediately by
replying to the message and permanently delete it from your computer and
destroy any printout thereof.





___
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


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
http://lists.bestpractical.com/cgi-bin

[rt-users] Show Custom Field Text

2009-03-24 Thread Venkateswaran, Subbaraman
We use rt 3.6.4 and trying to do text wrapping on ticket display for a
custom field of type text. We noticed that we do not have
html/Elements/ShowCustomFieldText and have only ShowCustomFieldWikitext.

Any help would be appreciated. Thanks.


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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] Transferring CustomField Values from old to new on all tickets in a queue

2009-03-20 Thread Venkateswaran, Subbaraman
We are using RT 3.6.4 and what we are trying to do is to synchronize
custom field across all queues and basically have one unique custom
field and type. Currently we have some CFs with the same name and
different types dupe'ed across all the queues. Is there a way we can
script around to move all the values from oldCF to new CF on all tickets
in a Queue ?

 For e.g.: 
 CF Name XYZ, Type: Enter multiple values
 CF Name XYZ, Type: Text
 Move all the values on XYZ(enter multiple values) to the CF XYZ(Text)
 on all tickets in a Queue.
 
 Once this is done we will disconnect the old CF XYZ(Enter multiple
 values) from the Queue.
 
 Thanks for your help
 

THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
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