Re: [rt-users] RT::Client::REST
Got it working a treat, but I need to be able to disable accounts and re-enable them, is this possible with RT::Client::REST? If we look at next page [1], it is not possible. I tried to several actions in a custom program for working with users, and I was not able to do. If not, how would one do it? You could do using MySQL queries. [1]: http://wiki.bestpractical.com/view/REST Best regards, -- Alberto Villanueva Industria __ ALTRAN C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53 www.altran.es Antes de imprimir este mensaje, asegúrate de que es necesario. Proteger el medio ambiente está también en tu mano. En cumplimiento de la Ley Orgánica 15/1999, con fecha 13 de diciembre, de Protección de Datos de Carácter Personal, y la Ley 34/2002, con fecha 11 de julio, de Servicios de la Sociedad de la Información y de comercio electrónico, le comunicamos que su dirección de correo electrónico forma parte de un fichero del que es responsable Altran España, y que garantiza la confidencialidad y seguridad de sus datos. Tiene usted derecho al acceso, rectificación y cancelación de sus datos en los términos establecidos en la Ley Orgánica 15/1999 de Protección de Datos de Carácter Personal y demás normativa concordante, dirigiéndose a nuestra dirección anteriormente señalada o por medio de correo electrónico: comunicac...@altran.es mailto:comunicac...@altran.es. AVISO LEGAL: Este mensaje, junto con cualquier fichero adjunto, está dirigido a su destinatario y es confidencial. Cualquier distribución, uso o reproducción sin consentimiento del remitente está estrictamente prohibido. Si ha recibido este mensaje por error, por favor proceda a ponerlo en conocimiento del remitente por e-mail y a borrarlo de su sistema sin realizar copias. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT::Client::REST
Alberto Villanueva wrote: Got it working a treat, but I need to be able to disable accounts and re-enable them, is this possible with RT::Client::REST? If we look at next page [1], it is not possible. I tried to several actions in a custom program for working with users, and I was not able to do. If not, how would one do it? You could do using MySQL queries. I was trying to avoid talking to the RT DB directly - the other option is to change the name to name.disabled (or some random string) as I am tracking the numeric ID, so that would be a solution. I guess the other option is to disable the internal auth and use my DB for auth (which it's already doing, I just haven't disabled the internal one.) For information only, I'm running a separate DB which provides authentication into other systems, and RT will use it and fall back to it's own. I'm currently merging the 2 so that the account creation and update in my DB will replicate the changes to the old RT installation and have a 'verify email' before making active function in my DB. I wanted to disable the account in RT if they changed their email until such time as they verified it. Michelle Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Include a template from a template
Hello, In our RT installation we are working with HTML templates that always include a sidebar with quick access to the RT system and some quick information (like ID, Status, Owner etc). Currently I copy and paste the code for the sidebar into all templates, which is quite cumbersome. Can I from a template execute some perl code and include another template? This would really reduce the time it takes to customize the templates. Thanks, Tobias Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Passing parameters to mail and sending two different mails
Hi, everyone, I have two questions for you. In our RT instance we want to automatically process some incident reports with well defined structure. Receiving and parsing is easy but I am lost on how to 1) pass the parsed data to mail template. I know that I could create custom fields for each piece of data and then retrieve it from template, but I find it quite cumbersome - more than 70% of tickets would have custom fields they are not going to use. Unless I make it some generic custom field that can store any string and keep the entire mail there, which would kind of defeat the purpose of a template. 2) send two different mails One mail is an automatic reply to the requestor and the other one is a mail to an admin responsible for handling the incident. I could make two scrips with the same condition to send mails or to use/extend RT::Action::SendMail. Which option would you prefer? Or is there a third or fourth one? Thank you for your answers Regards Martin -- Mgr. Martin Drasar dra...@ics.muni.cz CSIRT-MU, Network Security Department http://www.muni.cz/csirt Institute of Computer Science, Masaryk University, Brno, Czech Republic PGP Key ID: 0x944BC925 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Error on a new RT install
Hello everyone, After going through the configuration and installation, I'm getting this error anytime I try to click on any link within RT: Component path given to Interp-load must be absolut Has anyone received this error in the past? I'm sure it's just a config or httpd.conf issue but I'm scratching my head trying to figure it out. Any help would be greatly appreciated. -Jeff Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT::Client::REST
On Tue, Jul 13, 2010 at 10:09:31AM +0200, Michelle Sullivan wrote: Alberto Villanueva wrote: Got it working a treat, but I need to be able to disable accounts and re-enable them, is this possible with RT::Client::REST? If we look at next page [1], it is not possible. I tried to several actions in a custom program for working with users, and I was not able to do. If not, how would one do it? You could do using MySQL queries. I was trying to avoid talking to the RT DB directly - the other option is to change the name to name.disabled (or some random string) as I am tracking the numeric ID, so that would be a solution. I guess the other option is to disable the internal auth and use my DB for auth (which it's already doing, I just haven't disabled the internal one.) For information only, I'm running a separate DB which provides authentication into other systems, and RT will use it and fall back to it's own. I'm currently merging the 2 so that the account creation and update in my DB will replicate the changes to the old RT installation and have a 'verify email' before making active function in my DB. I wanted to disable the account in RT if they changed their email until such time as they verified it. You can certainly use the RT perl API to disable/enable users. RT-Authen-ExternalAuth can also manage passwords/enable|disable users from an external sql db, but it only checks when a user tries to log in. -kevin pgpu2KRyJ9qwk.pgp Description: PGP signature Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Passing parameters to mail and sending two different mails
On Tue, Jul 13, 2010 at 01:44:53PM +0200, Martin Drasar wrote: 1) pass the parsed data to mail template. I know that I could create custom fields for each piece of data and then retrieve it from template, but I find it quite cumbersome - more than 70% of tickets would have custom fields they are not going to use. Unless I make it some generic custom field that can store any string and keep the entire mail there, which would kind of defeat the purpose of a template. You can make a single custom field and not grant normal users SeeCustomField and only manage it from Scrips 2) send two different mails One mail is an automatic reply to the requestor and the other one is a mail to an admin responsible for handling the incident. I could make two scrips with the same condition to send mails or to use/extend RT::Action::SendMail. Which option would you prefer? Or is there a third or fourth one? Sounds like you just want On Create Autoreply to Requestors with your custom template On Create Notify AdminCcs with another custom template Since both of those scrips exist, you'd just make custom templates for them -kevin pgpy17lC1alkp.pgp Description: PGP signature Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Page Not Found error in 3.8.8 install
Hi, I just upgraded last night from 3.4.6. to 3.8.8 and the install went mostly OK. I'm experiencing an error in the Home view, though. If I click on the Subject in the 10 highest priority tickets I own box, I get a Page Not Found error. In the 10 Newest Unowned Tickets, I don't get an error when clicking on the Subject. Clicking on the # works in both boxes. I seem to recall a similar error being discussed in the group a couple years ago, but I can't find the thread. Any ideas? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Scrips and Recipients section not picking up TransactionBatch scrips - 3.8.8
Justin, I hate to ask, but did you make sure your configuration setting is for Batch? Kenn LBNL On Tue, Jul 13, 2010 at 8:03 AM, Justin Hayes justin.ha...@openbet.comwrote: I've noticed that the 'Scrips and Recipients' section of the Ticket update page doesn't pick up scrips that are TransactionBatch. Only TransactionCreate ones are shown. I use TransactionBatch a lot of the time (I'm seem to remember their being good reasons for this) and so I can't actually see who's going to be sent mails. Does anyone know if this is a known bug/issue or deliberate? I've not found anything on the wiki Thanks, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.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] How to convert ObjectCustomFieldValue content from free form to date
Alberto,
Thanks. I'll check it out.
Kenn
LBNL
2010/7/12 Alberto Villanueva alberto.villanu...@altran.es
Hi Kenn,
My system uses Oracle 10g.
Has anyone gone thru this type of data conversion before where the data
was in MM/DD/ format and you made it -MM-DD?
You could test next links where it has useful information:
- http://www.oracle-dba-online.com/sql/date_operators_functions.htm
- http://psoug.org/reference/convert_func.html
- http://psoug.org/reference/date_func.html#dftr
An example could be useful:
select to_date('your_date_MM/DD/', '-MM-DD') from dual;
Thanks.
Best regards,
--
Alberto Villanueva
Industria
__
ALTRAN
C/Campezo, 1, Edificio 1, Planta 4
28022 Madrid, Spain
Tel : + 34 91 550 41 00
Fax: + 34 91 415 61 53
www.altran.es
Antes de imprimir este mensaje, asegúrate de que es necesario. Proteger
el medio ambiente está también en tu mano.
En cumplimiento de la Ley Orgánica 15/1999, con fecha 13 de diciembre,
de Protección de Datos de Carácter Personal, y la Ley 34/2002, con fecha
11 de julio, de Servicios de la Sociedad de la Información y de comercio
electrónico, le comunicamos que su dirección de correo electrónico forma
parte de un fichero del que es responsable Altran España, y que
garantiza la confidencialidad y seguridad de sus datos. Tiene usted
derecho al acceso, rectificación y cancelación de sus datos en los
términos establecidos en la Ley Orgánica 15/1999 de Protección de Datos
de Carácter Personal y demás normativa concordante, dirigiéndose a
nuestra dirección anteriormente señalada o por medio de correo
electrónico: comunicac...@altran.es mailto:comunicac...@altran.es.
AVISO LEGAL: Este mensaje, junto con cualquier fichero adjunto, está
dirigido a su destinatario y es confidencial. Cualquier distribución,
uso o reproducción sin consentimiento del remitente está estrictamente
prohibido. Si ha recibido este mensaje por error, por favor proceda a
ponerlo en conocimiento del remitente por e-mail y a borrarlo de su
sistema sin realizar copias.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.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] Scrips and Recipients section not picking up TransactionBatch scrips - 3.8.8
Is that this one Kenn? RT_Config.pm:Set($UseTransactionBatch, 1); Cheers, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 13 Jul 2010, at 16:52, Kenneth Crocker wrote: Justin, I hate to ask, but did you make sure your configuration setting is for Batch? Kenn LBNL On Tue, Jul 13, 2010 at 8:03 AM, Justin Hayes justin.ha...@openbet.com wrote: I've noticed that the 'Scrips and Recipients' section of the Ticket update page doesn't pick up scrips that are TransactionBatch. Only TransactionCreate ones are shown. I use TransactionBatch a lot of the time (I'm seem to remember their being good reasons for this) and so I can't actually see who's going to be sent mails. Does anyone know if this is a known bug/issue or deliberate? I've not found anything on the wiki Thanks, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.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] Page Not Found error in 3.8.8 install
I was reading some old threads and found some similar reports. Michael James mja...@stonebridgebank.com 7/13/2010 11:29 AM Hi, I just upgraded last night from 3.4.6. to 3.8.8 and the install went mostly OK. I'm experiencing an error in the Home view, though. If I click on the Subject in the 10 highest priority tickets I own box, I get a Page Not Found error. In the 10 Newest Unowned Tickets, I don't get an error when clicking on the Subject. Clicking on the # works in both boxes. I seem to recall a similar error being discussed in the group a couple years ago, but I can't find the thread. Any ideas? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Shredder SQL dump file without execution of shredder.
Is there any relatively simple way to generate the SQL dump file Shredder generates without actually shredding anything? Or would the best way to do it be shredding something, getting the SQL dump, and just running the queries in the dump to put it back? Jonah Hirsch --- Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Page Not Found error in 3.8.8 install
On Tue, Jul 13, 2010 at 02:24:26PM -0400, Michael James wrote: I was reading some old threads and found some similar reports. Go read the Format for your search, sounds an awful lot like you've hardcoded a URL in there. Edit - Edit this search - Advanced -kevin Michael James mja...@stonebridgebank.com 7/13/2010 11:29 AM Hi, I just upgraded last night from 3.4.6. to 3.8.8 and the install went mostly OK. I'm experiencing an error in the Home view, though. If I click on the Subject in the 10 highest priority tickets I own box, I get a Page Not Found error. In the 10 Newest Unowned Tickets, I don't get an error when clicking on the Subject. Clicking on the # works in both boxes. I seem to recall a similar error being discussed in the group a couple years ago, but I can't find the thread. Any ideas? pgpORwkfK9f2w.pgp Description: PGP signature Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
