Sometimes MySQL crashes. The most usual caise 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 yo...

Asternic CCStats will report queue based activity. That means that only...

The 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 if you install any queue stats or metrics package, you will only have 30 days worth of data to...

Introduction 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...

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 par...

Change cell format based on value 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 bo...

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 queu...

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

How to install/use Asternic Call Center Stats with a Yeastar MyPBX Box 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. T...

Back in the day, when AgentCallbackLogin was deprecated, it was replaced by the AddQueueMember application that got a series of enhancements to mimic what was available with the old method. Among those was the option to set a member name for a d...

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 comple...

To upgrade you need to replace all the files in the web application and sometimes the log parser. Web Files Just to be cautious, we suggest to install the new html directory over a new location in your web server, so you c...

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

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

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 yo...

Method to change names to Queues and/or Agents. Sometimes queue names and agent names needs to ...

You can enable Spy and Whisper to any user in the interface, learn here how to configure them. A...

This screencast will show you the best way to use the translation tool to change the language...

Call center staffing level is designed to respond to calls within a set timeframe, or Service level, expressed as the percentage of calls that are answered within a predefined time threshold, for instance 90% of the calls must be answered within 2...

 Requirements PHP >= 5.1 MySQL >= 5.0 Asterisk >= 1.2 Adobe Flash Player on th...

Recent FreePBX versions, for some odd reason, use only device states to 'pause' members, losing the builtin functionality in Asterisk queues to log pauses and reasons so they can be reported. If you use FreePBX and built...

How to 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 us...

  Asternic Call Center Stats PRO is a networked application. As such it can be installed on the same server where Asterisk resides, or...

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.<br><br>The attached patch will modify the diale...

Change cell format based on value 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 bo...

If you installed Asternic from version 2.1.0 , then queue_stats_mv will be populated already by means of an insertion trigger, so this process is not needed. However, if you installed an older Asternic version and want to upgrade to a newe...

REST API This is a quick run down on things you can try in browser directly via the REST interface. Results are returned in JSON format. Realtime To see re...

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, e...

IMPORTANT: This guide is for Asternic Call Center Stats Lite. It does *not* apply to Call Center Stats PRO. After installing Asternic Call Center Stats Lite you open the reports with your browser, and to ...

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

Indeed Yeastar company documented the steps to get CCStats PRO working with their S series. Here is the link: ...

How to integrate external table data into Call Center Stats PRO Call Center Stats PRO is powerfull cause of their flexibility, one important feature is...

In short, to reset the password of the user admin and change it to the factory one.You must execute the following command in the linux shell of the server where you have installed the software (more precisely the software database):...

In the latest weeks we found out a common problem to people with FreePBX. We believe the issue starts after upgrading modules on FreePBX (dont know which exactly). The thing is that the queue_log file rotation is not being rot...

How you can add a second PBX for reporting in Call Center Stats PRO.ServerA = server where you have CCStats PRO/Devel installed and working. ServerB = PBX you want to add to the reporting information. First of all,...