What is the difference between Lite and Pro versions?

FAQ

Asternic PRO updates data in real time (As soon as it is logged), while the LITE version uses a cron job to incorporate new data at scheduled intervals. PRO version includes several more reports, has access control and levels, search, agent reports, custom formulas, etc. The Lite version is free, licensed under GPL3, while the PRO version is commercial software. For a more in depth list of difference see this table


What benefits do I have on buying the PRO version?

FAQ

State of the art reporting for your Asterisk Call Center! You will gain insights about your call/contact center operations. It also includes one year of software upgrades and priority support from the day you buy it.


Can I use my license in different servers?

FAQ

The PRO license is to be used on one server only. You cannot use it on many different servers simultaneously. If you want to move your license from one server to a different one use the revoke procedure. The Devel license allows you to install it up to 5 servers into the same organization.


I have a trial license and I want to activate with my purchased code. How do I do it?

FAQ

If you have a trial license, you must revoke it first by login in as an admin and selecting Setup => License, where you will see a Revoke button. Alternatively you can delete or rename the asterniclic.php file located into the Call Center Stats PRO web root directory, usually located in /var/www/html/stats/asterniclic.php. Then browse the software main page and it will ask you for a registration code again, put the one you received via email when you bought the license.


How much does the PRO version cost?

FAQ

It costs u$s500 per server. There is no per seat license. That means that you can have unlimited queues, agents and users with it.


Can I monitor outbound campaigns or calls?

FAQ

Yes. Asterisk call queues are inherently inbound, however, depending on the dialer you use, or even by creative use of the Asterisk dialplan you can monitor outbound calls, even by placing dialer calls inside a queue to be delivered to available agents, or by modifying your outbound calls context to add fake events to the queue_log whenever an outbound call is placed. We provide such context for Issabel or FreePBX based systems, and a generic README on how to use the same idea on any Asterisk installation.


Can I monitor Ring Groups?

FAQ

No. Asternic Call Center Stats reports on Queues activities by means of the asterisk queue_log file. Ring groups do not log activity in the queue_log file.


I would like to test the Pro version features, is it possible?

FAQ

Yes. Just follow the installation guide and fill the “Request Trial” form once installed. It will automatically retrieve a trial license file so you can test drive the software.


I use Trixbox/Elastix/Issabel/FreePBX and I see numbers instead of queue names?

FAQ

FreePBX and Issabel use numbers for queue names internally, the reports display the real data. If you want to change that, the Pro version has dictionaries for queues or agent names.


I have a multi tenant environment, how does licensing work?

FAQ

Asternic Call Center Stats PRO has a non nonsense license. You need only one license per server. That means that you can monitor multiple queues and agents, and have unlimited users accessing the reports.


Change names to queues and agents

Screencast

Method to change names to Queues and/or Agents. Sometimes queue names and agent names needs to be changed to be more human readable. This video will teach you how to do that in Call Center Stats PRO. (Full screen and 720p recommended)


Activate Spy/Whisper in realtime

Screencast

Asternic has a realtime dashboard that lets you launch some actions. Here is how:


Changing text via Translation

Screencast

This screencast will show you the best way to use the translation tool to change the language or even specific phrases or words to configure the interface. (Full screen and 720p recommended)


Changing charts using Report Designer

Screencast

This screencast help you understand how to edit and modify the charts in Call Center Stats PRO 2. (Full screen and 720p recommended)


Modify a report using Report Designner

Screencast

This screencast help you understand how to edit and modify the reports in Call Center Stats PRO 2. (Full screen and 720p recommended)


How to repair tables after a MySQL crash

Howto

Sometimes MySQL crashes. The most usual case is a hard disk getting full. When that happens, you will have database tables marked as crashed and Asternic won’t work correctly (or it will not update data), even after you make room on your hard disk again. To find out if some your tables are marked as crashed you can run these commands: mysql -u root -p qstats -e "select * from queue_stats limit 10" mysql -u root -p qstats -e "select * from queue_stats_mv limit 10" mysql -u root -p qstats -e "select * from recordings limit 10" If any of those returns an error saying that the table is marked as “crashed”, then you must repair them with the following commands:


How to track outbound calls on a FreePBX/Issabel based system

Howto

Asternic CCStats will report queue based activity. That means that only inbound calls that go into queues will be reported. However, there is a method to enable outbound call tracking by using a custom dialplan that intercepts outbound trunks calls under FreePBX and updates the queue_log file with their activity. The included dialplan will only track calls for extensions that have an account code set inside FreePBX preferences. If you use the pinset module, or any other module that uses account codes, it will conflict with the included outbound track dialplan.


How to change the log rotation policy on FreePBX

Howto

FreePBX© distro has a poor log rotation policy by default: it will rotate the file daily and keep only 30 days worth of data. That means that whenever you install any queue stats or metrics package you will only have 30 days worth of data to analyse. It also means that you won’t have the source logs as backups if anything wrong happens to your database. Our advise is to use a more sensitive log rotation policy: monthly rotation, leaving 36 months worth of data.


How to remove plus signs from CallerID in FreePBX

Howto

Many times Incoming phone calls (especially on SIP trunks) will contain a “+” on the CallerID. This can be annoying for users who try to call back numbers from their call history on their phones. The following solution fixes this problem at the root. Edit /etc/asterisk/extensions_custom.conf and add the following custom context to it: [from-trunk-remove-plus] exten => _X!,1,GotoIf($["${CALLERID(num):0:2}" != "+1"]?noplusatstart) exten => _X!,n,Set(CALLERID(num)=${CALLERID(num):1}) exten => _X!,n(noplusatstart),Goto(from-trunk,${EXTEN},1) By default. Incoming phone calls that are coming from some sort of trunk are going to be placed inside the “from-trunk” context.


How to load the realtime view automatically for a wallboard display

Howto

Sometimes you want to setup a special display or monitor to show realtime activity as a wallboard in a room. In those cases, the computer will start a browser automatically, with no human interaction. Asternic can load a page using GET parameters directly, so you can use it as the initial URL in a browser configuration, so it loads realtime with no intervention. The URL should be similar to this:


How to change a report cell format based on its value

Howto

Sometimes you might want to change the display format of a value in a report based on its contents or data. For example, in the realtime queue summary report, you might want to show abandoned calls in bold/red when they reach certain limit. This can be achieved via report designer and a little bit of programming. Report Designer You can define a format via report designer with the value being a php function call, something like this:


How to send an email when a call is abandoned or times out

Howto

Since Asternic Stats PRO version 2.1.0, there is a new option in the asterniclog service to run custom scripts whenever the queue_log file is updated. This can be useful if you want to perform some task whenever a certain event is recorded in queue_log. The command line option for specifying that script is -t and should be followed by the full path of your custom script. That script will be executed any time something is written in the queue_log file, you can add logic into that script to perform any kind of action like sending an email.


How to remove data older than certain date?

Howto

With time, stats database can grow large and you might want to clean it up because is data you no longer need and makes your queries slow. You can write a cron job that will run every day and removes entries older than a year. Create a file named /etc/cron.daily/cleanqstats with this content: #!/bin/bash mysql -u qstatsUser -pqstatsPassw0rd qstats -e "DELETE FROM queue_stats WHERE datetime < DATE_SUB(CURDATE(), INTERVAL 12 MONTH);" mysql -u qstatsUser -pqstatsPassw0rd qstats -e "DELETE FROM queue_stats_mv WHERE datetime < DATE_SUB(CURDATE(), INTERVAL 12 MONTH);" mysql -u qstatsUser -pqstatsPassw0rd qstats -e "DELETE FROM agent_activity WHERE datetime < DATE_SUB(CURDATE(), INTERVAL 12 MONTH);" Then be sure to give execute permissions to it:


How to reset/purge Asternic Call Center Stats tables to zero

Howto

If you want to reset the statistics on some installation and start from zero, you will need to perform a couple of steps: First of all, you want to tell Asterisk to start a new queue activity log file (as it might have that old data you do not want to see). You can do that by rotating the logs, using this command: asterisk -rx "logger reload" Once your log file is clean, it is time to work on the Asternic side of things.


How to report dialed numbers by Elastix Dialer

Howto

When originating calls from the Elastix Dialer, the dialed number is not registered in the queue_log file, thus is not available on Asternic generated reports. The attached patch will modify the dialer so it sets the CallerID to the dialed number, in this way the queue_log will reflect the callerid and Asternic will be able to show it. --- DialerProcess.class.php.original 2012-07-16 18:46:14.000000000 -0300 +++ DialerProcess.class.php 2012-07-16 18:58:11.000000000 -0300 @@ -1165,7 +1165,7 @@ $sCanalTrunk, NULL, NULL, NULL, "Wait" , "5" , NULL, - (isset($datosTrunk['CID']) ?


Pause queue members patch for FreePBX versions (>=2.11)

Howto

Sympton Even if you pause members on FreePBX by dialing feature codes, you do not see those pauses reported on Asternic. Reason Some FreePBX versions, for some odd reason, use device states to ‘pause’ queue members, without issuing an actual queue pause state in the queue application. How to fix this? If you use FreePBX and builtin feature codes to pause/unpause members, but they do not show on Asternic reports or realtime view, then this might help you.


How to reparse old or unprocessed queue_log files?

Howto

By default, the asterniclog log parser will skip processing for log entries that are older than the last event available in the database. This is done for performance reasons, as you do not want the computer wasting CPU time trying to insert data that was already inserted before. But sometimes a table gets corrupted and some entries are not parserd/incorporated, and you want to process old log files to incorporate that information into the database.


How to install/use Asternic Call Center Stats with a Yeastar MyPBX Box

Howto

If you have a Yeastar MyPBX embeded machine for your telephony solution, you can still use Asternic Call Center Stats to have good reporting on your queue activity. The only catch is that you must install Asternic on a separate Linux server as the little box does not have a robust and large enough permanent storage for the data. So, first of all, you must have a Linux box ready with Apache, PHP and MySQL installed.


How to remove agents or queues from Reports

Howto

Asternic Call Center Stats is a reporting application. As such, anything that gets logged as activity for your queues will have its place on the reports, and it will stay there for historic reasons. That means that you can have an agent today taking calls, but that agent might be gone next month. However, that agent and all data associated will remain in the reports even when the agent is not part of your organization anymore.


How to recreate the queue_log file from database data

Howto

The following MySQL query can be used to generate a queue_log file based on the data stored in Asternic MySQL tables, this is useful if you want to upgrade to a new version, or move Asternic to another server when you cannot dump the complete database, or passing the data from lite to pro versions. The query to run in Asternic Lite and Asternic PRO versions older than 2.0.0: SELECT unix_timestamp(datetime),uniqueid,queue,agent,event,info1,info2,info3,info4 FROM queue_stats q INNER JOIN qname ON qname = qname.


How to block incorrect login attempts (dictionary attacks) using Fail2Ban

Howto

If your Asternic CCStats installation is exposed to the public Internet, your server will be the target for multiple atacks, including possible password dictionary attacks. You can use Fail2Ban on your server to proactively deny access to those attempting multiple bad login attempts, by creating some special configurations into it. On a standard Fail2Ban installation on Centos/Redhat based systems, you should do the following: Create the file /etc/fail2ban/filter.d/asternic.conf With this content:


How to move an Asternic license from one server to another

Howto

Revoke your Call Center Stats PRO license In order to migrate your Call Center Stats PRO license from one server to another, you have to revoke the license on the original server, so your activation code becomes available to be used on the new server/installation. To revoke your current installation license, log in as admin and go to Setup => License Once in the license administration page you will be given the option to revoke the license.


Setting MySQL to display foreign character sets

Howto

If your language uses characters outside of the ASCII table, then you must be sure that all tools are configured to use UTF-8 so you can display different characters, like accented letters, or wide characters for hebrew, chinese, cyrilic, etc. As configuration is stored in MySQL, one of the tools that needs to be configured to handle UTF-8 correctly is the database engine. You can configure MySQL to use UTF-8 Characters by setting the my.


How to Integrate external data into Call Center Stats PRO

Howto

Call Center Stats PRO is powerfull cause of their flexibility, one important feature is that you can integrate external data from other tables or MySQL / MariaDB based databases. The process require a minimum knowledge about this engine and how the JOIN functions may be usefull to integrate external database information. Although the options and parameters are documented in the software as well, we owed you the detailed explanation of how to access and process that possibility so let’s start!


Call Center Stats Lite Installation

Guide

Description Asternic Call Center Stats Lite is on open source queue reporting solution for the Asterisk© PBX. In order to use the software you must have a working Asterisk PBX, and you should be using queues with it. These install instructions apply to the Lite version. If you want to install the PRO version, please follow this guide instead. Requirements In order to correctly use the software, you must have a Linux server with MySQL, PHP and a web server with the corresponding PHP modules or hooks installed.