[rt-users] Fwd: Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]

[Ruslan Zakirov]

On Fri, Apr 27, 2012 at 14:09, Alex Rhys-Hurn <alex at itworx.co.ke> wrote:
> 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?

We have a branch that improves situation with TimeTaken in
transactions table. It can be used with RT 4.0. It will be in RT 4.2.

> or do you have any example SQL queries for reporting on Time worked in RT?
>
> Thanks so much,
>
> Alex
>
> ________________________________
> From: "Benjamin Boksa" <mailinglists at boksa.de>
> To: "Albert Shih" <Albert.Shih at obspm.fr>
> Cc: rt-users at 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: jas at obspm.fr
>> Heure local/Local time:
>> jeu 26 avr 2012 21:25:37 CEST
>>
>
>
>



-- 
Best regards, Ruslan.