Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]
wow! Awesome. I am going to try this immediately. Thanks so much for the quick reply too. Alex - Original Message - From: Benjamin Boksa mailingli...@boksa.de To: Alex Rhys-Hurn a...@itworx.co.ke Sent: Friday, 27 April, 2012 1:24:03 PM Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)] Hi Alex, the cool thing about my integration toolkit is, that it does not use SQL at all. It uses the REST Interface (see Ticket Search) described here: http://requesttracker.wikia.com/wiki/REST Among other data you get the TimeWorked field already calculated ;-) The Queries used in Jasper are written in RTRIQL which itself is a superset of the Query Builder Query Language (which means you can use any Query Builder query from RT you already have). Looking forward to you feedback Benjamin Am 27.04.2012 um 12:09 schrieb Alex Rhys-Hurn: Dear Benjamin, Thanks for all the hard work. I have in fact played with Jasper and RT before. I gave up as the reports I was trying to generate were to do with time worked. RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated. Does your integration of Jasper with RT make this clearer / easier? or do you have any example SQL queries for reporting on Time worked in RT? Thanks so much, Alex - Original Message - From: Benjamin Boksa mailingli...@boksa.de To: Albert Shih albert.s...@obspm.fr Cc: rt-users@lists.bestpractical.com Sent: Thursday, 26 April, 2012 10:59:37 PM Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)] Hi Albert, you can generate any kind of reports supported by JasperReports Server. RT-Jasper provides the DataSource necessary to query RT for tickets (the ticket's data can be used in the reports). Regarding your questions: 1) See the private mail I sent you. 2) No. If you have further questions just let me know. Greetings from Cologne Benjamin Am 26.04.2012 um 21:28 schrieb Albert Shih: Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit Hi. it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration: RT-REST: http://projects.boksa.de/RT-REST/ RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface. RT-Jasper: http://projects.boksa.de/RT-Jasper/ RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer. Feel free to give the components a try and let me know what you think :-) I have chosen to drop full installation instructions in favor of a demo system (see the RT-Jasper page for more information) and I assume you already have a RT installation to play with. To learn how to install JasperReports Server please refer to http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download . To help you with your questions I'll try to be around in #rt on irc.perl.org . I am really curious to see what you will say about my work and I hope there will be enough users using it to ensure a constant flow of great ideas and improvements. Enjoy the rest of your weekends :-) Big thanks for your works. Two questions before I spend lot of time to understand your works : 1/ What kind of reports can we have (I never heard of jasper, only the city in Canada ...;-) ). I didn't find your demo jasperserver ...:-( 2/ Is they are anything to modify on the RT server ? thanks again. Regards. -- Albert SHIH DIO bâtiment 15 Observatoire de Paris 5 Place Jules Janssen 92195 Meudon Cedex Téléphone : 01 45 07 76 26/06 86 69 95 71 xmpp: j...@obspm.fr Heure local/Local time: jeu 26 avr 2012 21:25:37 CEST
Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]
(Only sent out a private answer before, reposting to rt-users) Hi Alex, the cool thing about my integration toolkit is, that it does not use SQL at all. It uses the REST Interface (see Ticket Search) described here: http://requesttracker.wikia.com/wiki/REST Among other data you get the TimeWorked field already calculated ;-) The Queries used in Jasper are written in RTRIQL which itself is a superset of the Query Builder Query Language (which means you can use any Query Builder query from RT you already have). I have also updated the installation instructions on http://projects.boksa.de/RT-Jasper after some feedback (Thx Marco!). Looking forward to you feedback Benjamin Am 27.04.2012 um 12:09 schrieb Alex Rhys-Hurn: Dear Benjamin, Thanks for all the hard work. I have in fact played with Jasper and RT before. I gave up as the reports I was trying to generate were to do with time worked. RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated. Does your integration of Jasper with RT make this clearer / easier? or do you have any example SQL queries for reporting on Time worked in RT? Thanks so much, Alex From: Benjamin Boksa mailingli...@boksa.de To: Albert Shih albert.s...@obspm.fr Cc: rt-users@lists.bestpractical.com Sent: Thursday, 26 April, 2012 10:59:37 PM Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working,anyone interested?)] Hi Albert, you can generate any kind of reports supported by JasperReports Server. RT-Jasper provides the DataSource necessary to query RT for tickets (the ticket's data can be used in the reports). Regarding your questions: 1) See the private mail I sent you. 2) No. If you have further questions just let me know. Greetings from Cologne Benjamin Am 26.04.2012 um 21:28 schrieb Albert Shih: Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit Hi. it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration: RT-REST: http://projects.boksa.de/RT-REST/ RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface. RT-Jasper: http://projects.boksa.de/RT-Jasper/ RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer. Feel free to give the components a try and let me know what you think :-) I have chosen to drop full installation instructions in favor of a demo system (see the RT-Jasper page for more information) and I assume you already have a RT installation to play with. To learn how to install JasperReports Server please refer to http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download . To help you with your questions I'll try to be around in #rt on irc.perl.org . I am really curious to see what you will say about my work and I hope there will be enough users using it to ensure a constant flow of great ideas and improvements. Enjoy the rest of your weekends :-) Big thanks for your works. Two questions before I spend lot of time to understand your works : 1/ What kind of reports can we have (I never heard of jasper, only the city in Canada ...;-) ). I didn't find your demo jasperserver ...:-( 2/ Is they are anything to modify on the RT server ? thanks again. Regards. -- Albert SHIH DIO bâtiment 15 Observatoire de Paris 5 Place Jules Janssen 92195 Meudon Cedex Téléphone : 01 45 07 76 26/06 86 69 95 71 xmpp: j...@obspm.fr Heure local/Local time: jeu 26 avr 2012 21:25:37 CEST
Re: [rt-users] User could not be created: Could not set user info
On Fri, Apr 27, 2012 at 08:44:46AM +0200, Adrian Stel wrote: yes I use ExternalAuth and I read about this issues, when I # this plugin I will be able to add new user, question is, is there any possibility to create user with RT-Authen-ExternalAuth ON ?? We are using RT-Authen-ExternalAuth (mysql) Yes, there's a config option for it. If you don't spot it in the sample config, post your config and someone will flag it for you. -kevin 2012/4/26 Kevin Falcone falc...@bestpractical.com: On Wed, Apr 25, 2012 at 10:27:30AM +0200, Adrian Stel wrote: I have a problem with creating users: User could not be created: Could not set user info Is this user in your LDAP server? If not, have you configured RT-Authen-ExternalAuth to allow users not in your LDAP server to be created? pgpGlUsOBlrkT.pgp Description: PGP signature
Re: [rt-users] Add a group as cc: watcher during ticket creation possible ?
On Fri, Apr 27, 2012 at 03:09:51PM +0200, Michael Polenske wrote: I try to add a group as watcher-cc: during ticket creation (via webinterface). It seems not possible, I have to open the ticket afterwards and add the group manually. Is there a way to enable this ? Unfortunately, the Requestor/Cc/AdminCc fields are passed through an email address parser which restricts what can be passed in there. -kevin pgp5oUbzelJbp.pgp Description: PGP signature
Re: [rt-users] Add a group as cc: watcher during ticket creation possible ?
:( Ok, I expected this already. Thanks for your info ! Cheers - Michael -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Freitag, 27. April 2012 15:46 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Add a group as cc: watcher during ticket creation possible ? On Fri, Apr 27, 2012 at 03:09:51PM +0200, Michael Polenske wrote: I try to add a group as watcher-cc: during ticket creation (via webinterface). It seems not possible, I have to open the ticket afterwards and add the group manually. Is there a way to enable this ? Unfortunately, the Requestor/Cc/AdminCc fields are passed through an email address parser which restricts what can be passed in there. -kevin
Re: [rt-users] Can you Retain Quoted Text Formatting in Reply?
I take it from the lack of response that this is impossible at the current time. From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Lawson, Joseph Sent: Tuesday, April 24, 2012 12:02 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Can you Retain Quoted Text Formatting in Reply? Hello Everyone, When replying to an email in RT, the editor strips all formatting from the quoted message. Is there any way to toggle RT to retain the formatting of the previous message. Currently it appears to only quote as plain text. I am able to send HTML formatted replies just fine.
[rt-users] Non-Privileged User can create requestors for other users
Good Evening, I was experimenting with RT (4.0.5) last night and found that it was possible for a non-privileged user to create tickets via the web interface for another user regardless of if they exist or not. Once the ticket is created the user gets a no permissions to view this ticket message so some security is going on. Would someone be so kind as to answer a few questions about this: 1) Is what I've said correct and if so is it possible to stop it without custom coding? I'd like to restrict users to only creating tickets for themselves, not anyone else. No problem if I do have to code something but wanted if there was an easier solution. 2) How can I stop random new users being created when they are added as requestors ? I'd prefer if only users I manually create are able to create tickets. There were a few older threads (from 2003 - http://www.gossamer-threads.com/lists/rt/users/17680) that referred to external Auth or removing the create ticket right from both Unprivileged and Everyone but this is already setup by default from what I can tell. If this can't be done I guess an OnCreate scrip that would auto-close the ticket with some kind of message template informing the request why would do the trick. Thanks in advance Lee