My boss too wants some reports. Does anyone know of any way to dump the database to an excel spreadsheet or some other format that I could pull out some kind of data from? ========================== (Tickets per Queue, per month) (Time it took to respond to tickets, and time to close 'em) (How much time are technicians taking on things, etc....) ========================== Jake Covert www.jakecovert.com -----Original Message----- From: Moshe Livne (Leibovitch) [mailto:moshe@softlink.com] Sent: Wednesday, October 01, 2003 11:58 AM To: 'otrs@otrs.org' Subject: [otrs] reports Hi, Is there a way to give the customer a monthly (yearly) report or the tickets he opened from the client web interface? If now, is there a way of doing it on scheduled basis on the server? Regards, Moshe (OTRS is working great!) _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
If you can put the data you want into an HTML table, Excel can grab the data from a web page. I do that for an internal product, and it works very well. Just go to Data | Get External Data | New Web Query in Excel 2000. I think it's similar in XP, too. It's not necessarily pretty, but it works. I don't know enough about Perl to drop the data into an HTML file, otherwise I'd already have all this set up and ready to go. -- Chris Salter -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Covert, Jake Sent: October 1, 2003 11:09 AM To: otrs@otrs.org Cc: dev@otrs.org Subject: RE: [otrs] reports My boss too wants some reports. Does anyone know of any way to dump the database to an excel spreadsheet or some other format that I could pull out some kind of data from? ========================== (Tickets per Queue, per month) (Time it took to respond to tickets, and time to close 'em) (How much time are technicians taking on things, etc....) ========================== Jake Covert www.jakecovert.com -----Original Message----- From: Moshe Livne (Leibovitch) [mailto:moshe@softlink.com] Sent: Wednesday, October 01, 2003 11:58 AM To: 'otrs@otrs.org' Subject: [otrs] reports Hi, Is there a way to give the customer a monthly (yearly) report or the tickets he opened from the client web interface? If now, is there a way of doing it on scheduled basis on the server? Regards, Moshe (OTRS is working great!) _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System?
As OTRS is in a SQL database one should be able to query the OTRS database from any database application that has the capability to generate the appropriate SQL flavour queries. (At the moment I am using something called MySQL control centre to test queries on a test copy of our OTRS setup). An alternative is to create your own SQL scripts and queries to perform the appropriate report pre-processing and export the results to file from the MySQL client (if you are running MySQL of course). Given the complexity of the OTRS data structures and relationships I doubt a pure dump of the data to a spreadsheet compatible format would be terribly usable. At the moment I am working on customising the statistics reporting so I can generate a Queue based ticket breakdown which is a current requirement. When started was not too familiar with perl.. and I have been finding learning this language an interesting experience:-).... I am just getting to the testing stage and I was rather wondering whether there was a test framework available that could be used to test the changed modules independently of the full system (or any tips on what would be needed to create one). Prefer to make certain modified modules performs as expected in isolation before plugging it in to main test setup. On Wed, 2003-10-01 at 16:08, Covert, Jake wrote:
My boss too wants some reports.
Does anyone know of any way to dump the database to an excel spreadsheet or some other format that I could pull out some kind of data from?
========================== (Tickets per Queue, per month) (Time it took to respond to tickets, and time to close 'em) (How much time are technicians taking on things, etc....) ==========================
Jake Covert www.jakecovert.com
-----Original Message----- From: Moshe Livne (Leibovitch) [mailto:moshe@softlink.com] Sent: Wednesday, October 01, 2003 11:58 AM To: 'otrs@otrs.org' Subject: [otrs] reports
Hi,
Is there a way to give the customer a monthly (yearly) report or the tickets he opened from the client web interface? If now, is there a way of doing it on scheduled basis on the server?
Regards, Moshe
(OTRS is working great!) _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
participants (4)
-
Chris Salter -
Covert, Jake -
Fernando Schapachnik -
Graham Smith