[asterisk-users] cdr report
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? Sincerely yours, Aris -- _ -- 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
Re: [asterisk-users] cdr report
Well, the question is, what your secretary wants to do. Only see the CDRs or more? Realtime? One simple method would be to mail her the CSV-File, so she can open it with Excel or Calc (Open Office). Am 23.04.2013 16:35, schrieb aristidis tsitras: 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? Sincerely yours, Aris -- _ -- 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
Re: [asterisk-users] cdr report
That would be nice. is there a way to have it ready in xls? if yes, then i could send it put a cron to send it every night/week/month. On 04/23/2013 05:42 PM, Thorsten Göllner wrote: Well, the question is, what your secretary wants to do. Only see the CDRs or more? Realtime? One simple method would be to mail her the CSV-File, so she can open it with Excel or Calc (Open Office). Am 23.04.2013 16:35, schrieb aristidis tsitras: 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? Sincerely yours, Aris -- _ -- 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-use -- _ -- 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
Re: [asterisk-users] cdr report
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. -- AJS Answers come *after* questions. -- _ -- 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
Re: [asterisk-users] cdr report
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? -- 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
Re: [asterisk-users] cdr report
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 -- _ -- 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
Re: [asterisk-users] cdr report
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 htmlbodytable input.html; while read INPUT ; do echo
trtd${INPUT//,//tdtd}/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
Re: [asterisk-users] cdr report
On Tue, 2013-04-23 at 17:35 +0300, 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? You can have the cdr_odbc or cdr_mysql module loaded and have the cdr in an external database Once in there you can get any report/format you want with minimum programming. The issue is that you need a machine running the database 24/7 Another option is to use the manager interface and an external client to collect the cdr events The manager interface can be setup to output only the cdr events and the resource requirements on the machine running asterisk are minimal. The downside is that you also need an external client running 24/7 to collect them. Stelios smime.p7s Description: S/MIME cryptographic signature -- _ -- 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
Re: [asterisk-users] CDR report
2010/8/5 Dario Quiroz darioqui...@gmail.com Hi all! Are someone using a CDR report? I have an Asterisk 1.6 running perfect but I need a web based report of CDRs. Nothing big, only the basic. Have anybody a how-to or a link? Look for asterisk-stats (or cdr-stats as it has been renamed) : users are rather pleased with it. Thanks in advance!! -- Atenciosamente, --- Dario Quiroz Analista de Suporte (71) 9275-9080 darioqui...@gmail.com --- -- _ -- 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 -- _ -- 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
[asterisk-users] CDR report
Hi all! Are someone using a CDR report? I have an Asterisk 1.6 running perfect but I need a web based report of CDRs. Nothing big, only the basic. Have anybody a how-to or a link? Thanks in advance!! -- Atenciosamente, --- Dario Quiroz Analista de Suporte (71) 9275-9080 darioqui...@gmail.com --- -- _ -- 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
