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
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
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
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.
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: rwheeler at artifact-software.com skype: ronaldmwheeler phone: 866-970-2435, ext 102
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
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 folderecho "<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
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 -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/x-pkcs7-signature Size: 5709 bytes Desc: not available URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130423/75f74866/attachment.bin>