[asterisk-users] cdr report

Tue Apr 23 11:33:07 CDT 2013

On 23/04/2013 11:42 AM, aristidis tsitras wrote:
> On 04/23/2013 06:23 PM, Ron Wheeler wrote:
>> On 23/04/2013 11:09 AM, A J Stiles wrote:
>>> On Tuesday 23 April 2013, aristidis tsitras wrote:
>>>> Hi. i am running asterisk in a low powered machine (alix2d13 from
>>>> pcengines) without any gui. the machine works fine to route all my 
>>>> calls
>>>> for the office. the problem is the management of the CDRs. i can 
>>>> see the
>>>> master.csv file, but it is not very friendly for the secretary of this
>>>> office to manage the calls.
>>>> is there a way to have a nice way to see the CDRs?Since the machine is
>>>> very small on CPU, it has to be as low on CPU/RAM consumption as 
>>>> possible.
>>>> any ideas?
>>> CSV files can be opened with any spreadsheet software  (such as 
>>> OpenOffice.org
>>> calc or Numbers).
>>>
>>> Alternatively, you can have the CDR using a database.  This can be 
>>> on another
>>> server.  Note if you are using MySQL, you will have to enable this 
>>> yourself;
>>> this is because not all of Asterisk is covered by the GPL, and the 
>>> MySQL CDR
>>> code ends up unredistributable.  (But it works as well as 
>>> anything).  Then
>>> write a Web app on the database server to display wanted CDR entries.
>>>
>> What about a script to convert the CSV to HTML and ftp the html file 
>> to a web server where it can be accessed as a browser page?
>>
>>
>
> is it possible to have the script to convert to html? i will send it 
> to a folder
echo "<html><body><table>" >input.html; while read INPUT ; do echo 
"<tr><td>${INPUT//,/</td><td>}</td></tr>" >>input.html ; done < 
input.csv ; echo "</table></body></html>" >>input.html

This Linux shell script will take your log after being copied to 
input.csv and make it into an ugly web page called input.html.

You can add more HTML to add a css style sheet and some column headings 
to make it look nice.

You probably want to fix the file names to reflect the date.

Ron

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

-- 
Ron Wheeler
President
Artifact Software Inc
email: rwheeler at artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102