[asterisk-users] cdr viewer for csv

[binary dreamer]

really nice. but could tell me the way, play?


On Thu, Apr 24, 2014 at 3:37 PM, Josh Metzger <joshdmetzger at gmail.com>wrote:

> With such a low amount of calls per month and with the extreme memory
> limitations, it might be easier to write a script to pull out the data and
> generate a static html page.  Run it daily / weekly / whenever you need it.
>
>
>
> On Thu, Apr 24, 2014 at 8:28 AM, binary dreamer <dreamer.binary at gmail.com>wrote:
>
>> already logrotate is doing the file split every month.
>> how do you serve it in a webpage and which CGI script?
>>
>>
>> On Thu, Apr 24, 2014 at 3:18 PM, A J Stiles <
>> asterisk_list at earthshod.co.uk> wrote:
>>
>>> On Thursday 24 Apr 2014, binary dreamer wrote:
>>> > hello everyone.
>>> > I am running asterisk and all of my CDRs are in the default csv.
>>> > the system is so limited to ram (only 256) and I cannot run MySQL or
>>> any
>>> > other program to give CDRs a fancy view.
>>> > at the moment the only other software running is nginx for a static
>>> webpage
>>> > with guidance on the system.
>>> > I do now want to move to sql or similar databases because the machine
>>> > cannot handle it (I have already tried and it wastes ram from calls).
>>> >
>>> >
>>> > is there a way to present to a webpage the CDRs from the csv, please?
>>>
>>> If you can't stretch to a separate machine to run a database  (even a
>>> scrapper
>>> will do for this)  and you can't increase the RAM in your Asterisk
>>> machine,
>>> then you will have to resort to manipulating the CSV file.
>>>
>>> Use a cron job to rotate the master CDR daily or weekly, to keep it from
>>> becoming unmanageably large.  This needs to be done at a time when you
>>> are not
>>> expecting any incoming calls.  You really need to stop Asterisk while
>>> you do
>>> this and restart it afterwards.  The whole operation  (cp Master.csv
>>> cdr_$DATE.csv; echo -n "" > Master.csv)  should be over within a few
>>> ringing
>>> periods; so even if a call does come through in the meantime, Asterisk
>>> ought
>>> to just pick it up as soon as it restarts.
>>>
>>> Then write a simple CGI script to serve up the cdr*.csv files.  As long
>>> as you
>>> send the appropriate content-type, then it ought just to open straight
>>> up in
>>> OpenOffice.org calc.
>>>
>>>
>>> --
>>> AJS
>>>
>>> Note:  Originating address only accepts e-mail from list!  If replying
>>> off-
>>> list, change address to asterisk1list at earthshod dot co dot uk .
>>>
>>> --
>>> _____________________________________________________________________
>>> -- 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
>>
>
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140424/1290e386/attachment.html>