Hi All; Anyone advise for a free (open source) reporting to be used for asterisk call center? Regards Bilal
Robert Huddleston
2011-Sep-09 18:23 UTC
[asterisk-users] Reporting for Asterisk Call Center
www.buildityourself.org :) -----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of bilal ghayyad Sent: Friday, September 09, 2011 2:14 PM To: asterisk-users at lists.digium.com Subject: [asterisk-users] Reporting for Asterisk Call Center Hi All; Anyone advise for a free (open source) reporting to be used for asterisk call center? Regards Bilal -- _____________________________________________________________________ -- 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
There are a lot of reporting tools. I have used: Asternic: http://www.asternic.biz/ QueueMetrics: http://queuemetrics.com/index.jsp On Fri, Sep 9, 2011 at 1:13 PM, bilal ghayyad <bilmar_gh at yahoo.com> wrote:> Hi All; > > Anyone advise for a free (open source) reporting to be used for asterisk > call center? > > Regards > Bilal > > -- > _____________________________________________________________________ > -- 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110909/5f4595bb/attachment.htm>
On Fri, Sep 09, 2011 at 01:28:28PM -0500, Gerardo Barajas wrote:> There are a lot of reporting tools. > I have used: > > Asternic: http://www.asternic.biz/ > QueueMetrics: http://queuemetrics.com/index.jspNon of those are Free (Open Source). -- Tzafrir Cohen icq#16849755 jabber:tzafrir.cohen at xorcom.com +972-50-7952406 mailto:tzafrir.cohen at xorcom.com http://www.xorcom.com iax:guest at local.xorcom.com/tzafrir
if you provide what kind of reporting you need it would be easier to point a few pointers? either you can build it yourself.. or try the Call Center module from Elastix.. can be a good tool Tarek Sawah Information Technology ?Adviser Integrated Digital Systems CCNP, MCSE, RHCE, TELECOM USA: +1 386 492 9993> Date: Sat, 10 Sep 2011 10:28:00 +0300 > From: tzafrir.cohen at xorcom.com > To: asterisk-users at lists.digium.com > Subject: Re: [asterisk-users] Reporting for Asterisk Call Center > > On Fri, Sep 09, 2011 at 01:28:28PM -0500, Gerardo Barajas wrote: > > There are a lot of reporting tools. > > I have used: > > > > Asternic: http://www.asternic.biz/ > > QueueMetrics: http://queuemetrics.com/index.jsp > > Non of those are Free (Open Source). > > -- > Tzafrir Cohen > icq#16849755 jabber:tzafrir.cohen at xorcom.com > +972-50-7952406 mailto:tzafrir.cohen at xorcom.com > http://www.xorcom.com iax:guest at local.xorcom.com/tzafrir > > -- > _____________________________________________________________________ > -- 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
Dear Tariq; Thanks for replying and helping. A reporting for call center that showing the agents utilization, the queues utilization and to have a dashboard to know how many call are currently existed and the queuing. About Elastix: where I can find it? Does it has reporting that is working with Asterisk call center. Regards Bilal --------------> > if you provide what kind of reporting you need it would be > easier to point a few pointers? > either you can build it yourself.. or try the Call Center > module from Elastix.. can be a good tool > > > > Tarek Sawah > > Information Technology ?Adviser > > Integrated Digital Systems > > CCNP, MCSE, RHCE, TELECOM > > USA: +1 386 492 9993 > >
those reports can be easiely extracted from the MYSQL database my friend.. and you can add the Flash Operator Panel if you want to monitor live activities like how many in queue and how many ON CALL .. etc anyway the Elastix is a stand alone distribution you can find more info and downloads at : http://elastix.org/ regards Tarek Sawah Information Technology Adviser Integrated Digital Systems CCNP, MCSE, RHCE, TELECOM USA: +1 386 492 9993> Date: Mon, 12 Sep 2011 05:14:08 -0700 > From: bilmar_gh at yahoo.com > To: asterisk-users at lists.digium.com > Subject: Re: [asterisk-users] Reporting for Asterisk Call Center > > Dear Tariq; > > Thanks for replying and helping. > > A reporting for call center that showing the agents utilization, the queues utilization and to have a dashboard to know how many call are currently existed and the queuing. > > About Elastix: where I can find it? Does it has reporting that is working with Asterisk call center. > > Regards > Bilal > > > > -------------- > > > > > if you provide what kind of reporting you need it would be > > easier to point a few pointers? > > either you can build it yourself.. or try the Call Center > > module from Elastix.. can be a good tool > > > > > > > > Tarek Sawah > > > > Information Technology ?Adviser > > > > Integrated Digital Systems > > > > CCNP, MCSE, RHCE, TELECOM > > > > USA: +1 386 492 9993 > > > > > > > -- > _____________________________________________________________________ > -- 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-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110912/ae85932c/attachment.htm>
On Friday 09 September 2011, bilal ghayyad wrote:> Hi All; > > Anyone advise for a free (open source) reporting to be used for asterisk > call center? > > Regards > BilalProblem is, reporting is such a nebulous thing, about the only thing that will give you the required level of "generality of purpose" is a programming language. So you might find it simplest just to roll your own. Assuming you have set up CDR using some kind of database backend, then all you really need to do is devise a set of queries which will provide the information you want to present in your reports; then write a script in your favourite language to make a CSV file (which will load into any modern spreadsheet program) and e-mail it to whoever needs it. Lastly, put an entry in your crontab to run the report whenever required. Note that OpenOffice.org calc will treat an entry in a CSV starting with an = sign as a formula, so you can insert things such as "${name}",${ext},${answd},${busy},${unobtain},=C${row}+D${row}+E${row} and then column F in each row will contain the total of columns C, D and E in that row (assuming you are properly updating $row as you go along .....) My own preference is to use the spreadsheet program to evaluate formulae rather than hard-code the answer into the spreadsheet. That way, if you edit a cell, you will not throw everything else out. I know from past experience that Microsoft Excel will happily accept CSV files with an XLS extension (N.B. it might need \r\n for line endings); however, I am unable to test whether or not it will accept formulae as above, as I do not have access to a machine with Windows and Excel. -- AJS -- AJS Answers come *after* questions.
Dear Tareq; I am not using mysql, the configuration on the text configuratoin files and the logs are existed under the directory (/var/log/asterisk). Well, to use mysql: then it means the configuration will be also in the database or I can use mysql only for reporting? What is the Flash Operator? By the way, I have another question if you can help me if you used the database with sql, actually I was facing one time a case and maybe the Database usage will help me if you can advise me: If I have multiple Asterisk servers are running, and I need them to work centralized (I mean from one configuration) so to work as one system, then if I have database for configuration, I can acheive this by making all the servers read and write the configuration from the database server? Thanks for your help Tareq. Regards Bilal ---------------> > those reports can be easiely extracted from the MYSQL > database my friend.. and you can add the Flash Operator > Panel if you want to monitor live activities like how many > in queue and how many ON CALL .. etc > > anyway the Elastix is a stand alone distribution you can > find more info and downloads at : http://elastix.org/ > regards > > > Tarek Sawah > > Information Technology? Adviser > > Integrated Digital Systems > > CCNP, MCSE, RHCE, TELECOM > > USA: +1 386 492 9993 > > >