[asterisk-users] Call rating software

[andrew Colin]

Currently I am writing to mysql
With all the default fields in the cdr table in the asterisk databas


Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: A J Stiles <asterisk_list at earthshod.co.uk> </div><div>Date:02/07/2014  5:50 PM  (GMT+02:00) </div><div>To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com> </div><div>Subject: Re: [asterisk-users] Call rating software </div><div>
</div>On Wednesday 02 Jul 2014, Andrew Colin wrote:
> Can you try maybe assist with this, as I have tried for ages and still cant
> get it right.

Firstly, have you got CDR working and writing to some sort of database?  We 
use cdr_mysql; although the more modern recommendation is to use cdr_odbc  
(which is more generic, and will work with various database types)  even if 
you are using a MySQL database.


If you haven't got your CDR going into a database, then you need to sort that 
out *first*.

Once you have CDR working, then it's simply a question of determining what SQL 
queries you need to generate to produce your report; then writing a program to 
build up the queries, extract the results and present them in the form you 
want.


-- 
AJS

Note:  Originating address only accepts e-mail from list!  If replying off-
list, change address to asterisk1list at earthshod dot co dot uk .

-- 
_____________________________________________________________________
-- 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/20140702/fab2b1b5/attachment.html>