[asterisk-users] Which tool to edit custom reports from CDR and queues logs ?

2013-01-11 Thread Olivier 
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

Re: [asterisk-users] Which tool to edit custom reports from CDR and queues logs ?

2013-01-11 Thread Danny Nicholas 
From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@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).

--
_
-- 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

Re: [asterisk-users] Which tool to edit custom reports from CDR and queues logs ?

2013-01-11 Thread Ron Wheeler 

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: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

--
_
-- 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