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: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
--
_____________________________________________________________________
-- 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
