Olivier
2013-Jan-11 10:22 UTC
[asterisk-users] Which tool to edit custom reports from CDR and queues logs ?
Hi, I would like to edit reports showing how fast operator and users answer incoming calls. Users are spread over 6 locations, each with its own asterisk instance. Operator is on main site. Users have "casual" extension but operator logs as queue agent. I've read or/and tried Star2Billing's CDR-Stats and A2Billing, Asternic Call center Stats,. I'm wondering if using a BI tool such as Jasper Reports would be preferable. Which tool would you suggest to build custom reports ? Regards -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130111/5cb44d0e/attachment.htm>
Danny Nicholas
2013-Jan-11 14:53 UTC
[asterisk-users] Which tool to edit custom reports from CDR and queues logs ?
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Olivier Sent: Friday, January 11, 2013 4:22 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] Which tool to edit custom reports from CDR and queues logs ? Hi, I would like to edit reports showing how fast operator and users answer incoming calls. Users are spread over 6 locations, each with its own asterisk instance. Operator is on main site. Users have "casual" extension but operator logs as queue agent. I've read or/and tried Star2Billing's CDR-Stats and A2Billing, Asternic Call center Stats,. I'm wondering if using a BI tool such as Jasper Reports would be preferable. Which tool would you suggest to build custom reports ? Regards My exposure to these tools seems to indicate that they are all SQL/MYSQL based engines. To combine the data from six sites my inclination would be to use something like Crystal Reports or Perl to "roll my own" (or possibly even as "low tech" as Excel). -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130111/08690b38/attachment.htm>
Ron Wheeler
2013-Jan-11 15:52 UTC
[asterisk-users] Which tool to edit custom reports from CDR and queues logs ?
We are just delivering version 2 of our ADTransform data connector. It would allow your to read in your CDR files, manipulate them, validate them and put out JasperReports based on the data. It has a plug-in based workflow engine so that file transfers, input,transformation, validation, logging, reporting and automated report/file delivery steps can be added as required. Out of the box it supports CSV and Excel files for input and output and other connectors such as JBDC, OBDC, webservices, extraction using custom APIs can be added as plug-ins. It supports JasperReports out of the box. It supports FTP for getting and sending data and e-mail for sending reports, logs and data. I am guessing that you might want to suck in all of the CDRs, apply some mappings to add location or user specific information for reporting and then run a series of JasperReports to provide summary and detail reports, possibly extract data for billing/chargeback and the deliver the data and reports through e-mail to the appropriate recipients. It is a pure Java application that is OS agnostic. We are looking at Raspberry support as part of version 3. The original motivation for the product was the LMS market where data needs to be integrated from Payroll and HRIS to be feed into the LMS and certification and other training history data needs to be extracted to go to work scheduling or HRIS systems. As a small Asterisk user, I think that I can understand where your requirement is coming from. http://www.artifact-software.com/?page_id=929 is the website link if you want more info. A short brochure is available. If anyone wants one, please contact me off-list. Ron On 11/01/2013 5:22 AM, Olivier wrote:> Hi, > > I would like to edit reports showing how fast operator and users > answer incoming calls. > Users are spread over 6 locations, each with its own asterisk instance. > Operator is on main site. > Users have "casual" extension but operator logs as queue agent. > > I've read or/and tried Star2Billing's CDR-Stats and A2Billing, > Asternic Call center Stats,. > I'm wondering if using a BI tool such as Jasper Reports would be > preferable. > > Which tool would you suggest to build custom reports ? > > Regards > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users-- Ron Wheeler President Artifact Software Inc email: rwheeler at artifact-software.com skype: ronaldmwheeler phone: 866-970-2435, ext 102 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130111/7d494e77/attachment.htm>