EastCDR is a Asterisk call detail report generator.
It is for systems that use FreePBX.
Currently it is a php cli program.
Web version to come.
Download here eastcdr.gz
I had a client that needed to run a report. The current reporting tools that come with FreePBX took to long and required multiple runs. So a great old friend Chris Estes helped me with the coding. It has a lot of logic.
It outputs to two csv files with the following info:
| Mode: | incoming, outgoing, all |
| Name: | user name associated with extension |
| Extension: | device extension |
| Completed Calls: | Call Count - Missed Calls |
| Completed Call Time Seconds: | Billable Seconds - Missed Call Time Seconds |
| Completed Call Time Minutes: | Billable Minutes - Missed Call Time Minutes |
| Date: | date range of the report |
| First Call Time: | self explanatory |
| Last Call Time: | self explanatory |
| Time Between First and Last Call: | self explanatory |
| Call Count: | How many calls for a ext |
| Billable Seconds: | Time of the calls in seconds |
| Billable Minutes: | Time of the calls in minutes |
| Missed Calls: | Call count for missed calls, this is the sum of the count of calls that have a value in the disposition field that shows no answer these are normally incoming calls that go to voicemail if they have a time value. |
| Missed Call Time Seconds: | Time of the calls in seconds |
| Missed Call Time Minutes: | Time of the calls in minutes |
| Call counts are for each way then summend for the all call report | |
It will work out of the box with current PBX in a Flash. You may need to edit the variables. Variables are commented. The output file location is defined in a variable so you will at least want to set that. Save the file to /user/local/bin or any location really. Either call it with php -f eastcdr or you can add the excute bit, chmod +x eastcdr, to the file and it will run eastcdr as a shell script. If your php cli is at another location you will need to change the top "!#/usr/bin/php" to where ever your php is.
? Go to PBXinaflash forum and look for user newranman or eastcdr
A sourceforge project has been created it is slowly being setup.
# EastCDR
#
# Copyright (C) 2011 Ongoingtech, Randy Newman and Chris Estes
#
# EastCDR is licensed under the GPL2 license
#
# For a copy of license, visit http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
#