<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body ><div><div></div><div>Currently I am writing to mysql</div><div>With all the default fields in the cdr table in the asterisk databas</div><div><br></div><div><br></div><div><div style="font-size:9px;color:#575757">Sent from Samsung Mobile</div></div></div><br><br><div>-------- Original message --------</div><div>From: A J Stiles <asterisk_list@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@lists.digium.com> </div><div>Subject: Re: [asterisk-users] Call rating software </div><div><br></div>On Wednesday 02 Jul 2014, Andrew Colin wrote:<br>> Can you try maybe assist with this, as I have tried for ages and still cant<br>> get it right.<br><br>Firstly, have you got CDR working and writing to some sort of database? We <br>use cdr_mysql; although the more modern recommendation is to use cdr_odbc <br>(which is more generic, and will work with various database types) even if <br>you are using a MySQL database.<br><br><br>If you haven't got your CDR going into a database, then you need to sort that <br>out *first*.<br><br>Once you have CDR working, then it's simply a question of determining what SQL <br>queries you need to generate to produce your report; then writing a program to <br>build up the queries, extract the results and present them in the form you <br>want.<br><br><br>-- <br>AJS<br><br>Note: Originating address only accepts e-mail from list! If replying off-<br>list, change address to asterisk1list at earthshod dot co dot uk .<br><br>-- <br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by http://www.api-digital.com --<br>New to Asterisk? Join us for a live introductory webinar every Thurs:<br> http://www.asterisk.org/hello<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> http://lists.digium.com/mailman/listinfo/asterisk-users<br></body>