Just a thought.
Why not have a simple bit of PHP that lives on the PBX that does the cdr searching for you and then simply have Excel pull the results into a workbook ready to format, Graph and print as you desire. Or you could do all the formatting in Php and simply print the web page as normal. Or find a PDF creator and bolt that in as well.
Too many options.
I have done this recently and now use the same approach to see 7 day history of concurrent calls, duration, wait times along with extension use and estimated bill based on a lookup with a rates table.
I think the problem with having Freepbx present an output suitable for everyones needs is a never ending project in itself but there is always a way to get the results you desire using the current tools and some imagination.
If you are familiar with ODBC objects and Excel, you can import the data into Excel yourself from the MySQL database “asteriskcdrdb” table “cdr”. This way, you don’t have to mess with the code in FreePBX and don’t need to attach to the PBX management website to perform whatever reporting you are trying to accomplish.
Yep, what that fella said.
Cynjut hit it on the head for the fastest approach.
mine started off as a web based thing for other reasons and excel was just used to graph the output.
I shall tidy up the php later and make it available if wanted.
It was not any Modification,
it was a standalone page that simply querys the cdr table.
Nothing to do with Freepbx directly apart from it sitting on the same box,
although that is not required if you wanted to keep things separate.
It would still need some understanding on what you want to query and the php changing accordingly although you could pass the query string on the fly so it may be unwanted complication.
But best to setup the ODBC connection as Dave mentioned and then you are rocking.
If you want the php then give me a quick idea of what output you want to see,
ie: the answer to your query, and I shall do my best to tinker with it to give you useful starting point. or if you know SQL then just paste your query here and I shall make the page give you the output desired.
Well I extracted some of the useful parts from my cdr page.
I also wrapped up a simple excel workbook that may or may not work.
I find excel very funkey with this sort of data collection.
But hey it is quick and dirty and good stepping stones to a final product.
I hope that the powers that be are happy with me posting a link here,
time will tell I guess. http://hiddenvision.co.uk/fpbx
Ahh watch out it may open the page in this window.
I do not want to take you away from the forum
so right click and open in a new tab/window OR
CTRL + Click if preferred.
excuse the format, it was only a hack and paste from an existing page.
If there are any questions then start a new thread rather than hijack this one.