Re: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR?
Thank you! On Thu, Apr 11, 2013 at 11:47 AM, Asghar Mohammad asghar...@gmail.comwrote: hi, it is not difficult in php and mysql i have created a simple billing system for my wholesale postpay clients without any AGI. it report ACD ASR all calls ANSWERD calls filter by date by callerid etc. do billing as soon as call end. for billing i am using mysql trigger. report live calls. 2 interfaces 1 for admin and other for clients, every client can login with his accountcode and password and can see live calls cdr report billing etc. i am still working on this so codes are not clean. if someone need to create a new interface i can help. On Wed, Apr 10, 2013 at 11:22 PM, Daniel - Asterisk earohua...@gmail.comwrote: Hello Brynjolfur Thorvardsson, Can I take a look at you CDR reporting tool? I'm planning on using it on Postgresql but MySQL could be used too. Thank you! Elder D. Arohuanca dCAP Lima - Peru On Fri, Feb 10, 2012 at 11:55 AM, asterisk jobs asteriskcod...@gmail.com wrote: No, that doesn't do the job I specifically asked and installation instructions are all over the place... Thanks though. On Fri, Feb 10, 2012 at 11:36 AM, Tim Nelson tnel...@rockbochs.comwrote: - Original Message - Yes, this is exactly what I am looking for - hopefully in English :-) Date or range selection would make this perfect. I have been looking for something like this for quite a while but there is none. I would really appreciate it if you share this with me. Question here, does the .php code read from database and displays or does it analyse the custom-cdr.csv file? Don't forget about the ever-popular Asterisk-stat and the newly revised cdr-stats projects, both web based, proven, and work fantastic: http://www.areski.net/areski/index.php?option=com_contenttask=viewid=22Itemid=54 http://www.cdr-stats.org/ --Tim -- _ -- 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 -- _ -- 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
Re: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR?
hi, it is not difficult in php and mysql i have created a simple billing system for my wholesale postpay clients without any AGI. it report ACD ASR all calls ANSWERD calls filter by date by callerid etc. do billing as soon as call end. for billing i am using mysql trigger. report live calls. 2 interfaces 1 for admin and other for clients, every client can login with his accountcode and password and can see live calls cdr report billing etc. i am still working on this so codes are not clean. if someone need to create a new interface i can help. On Wed, Apr 10, 2013 at 11:22 PM, Daniel - Asterisk earohua...@gmail.comwrote: Hello Brynjolfur Thorvardsson, Can I take a look at you CDR reporting tool? I'm planning on using it on Postgresql but MySQL could be used too. Thank you! Elder D. Arohuanca dCAP Lima - Peru On Fri, Feb 10, 2012 at 11:55 AM, asterisk jobs asteriskcod...@gmail.comwrote: No, that doesn't do the job I specifically asked and installation instructions are all over the place... Thanks though. On Fri, Feb 10, 2012 at 11:36 AM, Tim Nelson tnel...@rockbochs.comwrote: - Original Message - Yes, this is exactly what I am looking for - hopefully in English :-) Date or range selection would make this perfect. I have been looking for something like this for quite a while but there is none. I would really appreciate it if you share this with me. Question here, does the .php code read from database and displays or does it analyse the custom-cdr.csv file? Don't forget about the ever-popular Asterisk-stat and the newly revised cdr-stats projects, both web based, proven, and work fantastic: http://www.areski.net/areski/index.php?option=com_contenttask=viewid=22Itemid=54 http://www.cdr-stats.org/ --Tim -- _ -- 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 -- _ -- 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] Is there a php script to analyse and show call detail reports from Asterisk CDR?
Hello Brynjolfur Thorvardsson, Can I take a look at you CDR reporting tool? I'm planning on using it on Postgresql but MySQL could be used too. Thank you! Elder D. Arohuanca dCAP Lima - Peru On Fri, Feb 10, 2012 at 11:55 AM, asterisk jobs asteriskcod...@gmail.comwrote: No, that doesn't do the job I specifically asked and installation instructions are all over the place... Thanks though. On Fri, Feb 10, 2012 at 11:36 AM, Tim Nelson tnel...@rockbochs.comwrote: - Original Message - Yes, this is exactly what I am looking for - hopefully in English :-) Date or range selection would make this perfect. I have been looking for something like this for quite a while but there is none. I would really appreciate it if you share this with me. Question here, does the .php code read from database and displays or does it analyse the custom-cdr.csv file? Don't forget about the ever-popular Asterisk-stat and the newly revised cdr-stats projects, both web based, proven, and work fantastic: http://www.areski.net/areski/index.php?option=com_contenttask=viewid=22Itemid=54 http://www.cdr-stats.org/ --Tim -- _ -- 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
Re: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR?
Hi, I'm working on a small php program for just this. I guess from your question that you have Asterisk writing to a CDR database table, in which case you should be able to use my .php code fairly easily. It's nothing fancy but does give me a graphical presentation of calls/15minute segments. Attached is a screenshot of a graph, I have 1,5+ million entries in the table but there is no noticeable lag in refreshing the graph. At the moment it refreshes only when the button is pressed (the text is in Danish ...) but changing it to refresh automatically every 15 minutes wouldn't be a major problem. I'm working on adding the option of selecting date ranges, it's all still a work in progress! Regards Binni Fra: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] På vegne af asterisk jobs Sendt: 9. februar 2012 16:36 Til: Asterisk Users Mailing List - Non-Commercial Discussion Emne: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR? Hi everyone, I have tons of CDR from an Asterisk with a PRI connection. I want to know som extra details about the calls like the maximum number of calls in peak hours, etc...so I am looking for a php or other type of script that would show this to me in a GUI graphica format. Ideally, it would amazing to feed the asteriskcdrdb table to the program and get back the results without installing anything on the Asterisk server as I don't want to tamper with the server. Is there such a tool? Thanks, attachment: graph.gif-- _ -- 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] Is there a php script to analyse and show call detail reports from Asterisk CDR?
Hi, I forgot to add that you are free to use my code, I'll mail it later today. Fra: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] På vegne af Brynjolfur Thorvardsson Sendt: 10. februar 2012 09:47 Til: Asterisk Users Mailing List - Non-Commercial Discussion Emne: Re: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR? Hi, I'm working on a small php program for just this. I guess from your question that you have Asterisk writing to a CDR database table, in which case you should be able to use my .php code fairly easily. It's nothing fancy but does give me a graphical presentation of calls/15minute segments. Attached is a screenshot of a graph, I have 1,5+ million entries in the table but there is no noticeable lag in refreshing the graph. At the moment it refreshes only when the button is pressed (the text is in Danish ...) but changing it to refresh automatically every 15 minutes wouldn't be a major problem. I'm working on adding the option of selecting date ranges, it's all still a work in progress! Regards Binni Fra: asterisk-users-boun...@lists.digium.commailto:asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] På vegne af asterisk jobs Sendt: 9. februar 2012 16:36 Til: Asterisk Users Mailing List - Non-Commercial Discussion Emne: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR? Hi everyone, I have tons of CDR from an Asterisk with a PRI connection. I want to know som extra details about the calls like the maximum number of calls in peak hours, etc...so I am looking for a php or other type of script that would show this to me in a GUI graphica format. Ideally, it would amazing to feed the asteriskcdrdb table to the program and get back the results without installing anything on the Asterisk server as I don't want to tamper with the server. Is there such a tool? Thanks, -- _ -- 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] Is there a php script to analyse and show call detail reports from Asterisk CDR?
Hi Brynjolfur, Yes, this is exactly what I am looking for - hopefully in English :-) Date or range selection would make this perfect. I have been looking for something like this for quite a while but there is none. I would really appreciate it if you share this with me. Question here, does the .php code read from database and displays or does it analyse the custom-cdr.csv file? Best, On Fri, Feb 10, 2012 at 4:10 AM, Brynjolfur Thorvardsson bi...@itanet.nuwrote: Hi, I forgot to add that you are free to use my code, I’ll mail it later today. ** ** *Fra:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *På vegne af *Brynjolfur Thorvardsson *Sendt:* 10. februar 2012 09:47 *Til:* Asterisk Users Mailing List - Non-Commercial Discussion *Emne:* Re: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR? ** ** Hi, I’m working on a small php program for just this. I guess from your question that you have Asterisk writing to a CDR database table, in which case you should be able to use my .php code fairly easily. It’s nothing fancy but does give me a graphical presentation of calls/15minute segments. ** ** Attached is a screenshot of a graph, I have 1,5+ million entries in the table but there is no noticeable lag in refreshing the graph. At the moment it refreshes only when the button is pressed (the text is in Danish ...) but changing it to refresh automatically every 15 minutes wouldn’t be a major problem. I’m working on adding the option of selecting date ranges, it’s all still a work in progress! ** ** Regards ** ** Binni ** ** *Fra:* asterisk-users-boun...@lists.digium.com [ mailto:asterisk-users-boun...@lists.digium.comasterisk-users-boun...@lists.digium.com] *På vegne af *asterisk jobs *Sendt:* 9. februar 2012 16:36 *Til:* Asterisk Users Mailing List - Non-Commercial Discussion *Emne:* [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR? ** ** Hi everyone, ** ** I have tons of CDR from an Asterisk with a PRI connection. I want to know som extra details about the calls like the maximum number of calls in peak hours, etc...so I am looking for a php or other type of script that would show this to me in a GUI graphica format. Ideally, it would amazing to feed the asteriskcdrdb table to the program and get back the results without installing anything on the Asterisk server as I don't want to tamper with the server. ** ** Is there such a tool? ** ** Thanks, -- _ -- 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
Re: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR?
- Original Message - Yes, this is exactly what I am looking for - hopefully in English :-) Date or range selection would make this perfect. I have been looking for something like this for quite a while but there is none. I would really appreciate it if you share this with me. Question here, does the .php code read from database and displays or does it analyse the custom-cdr.csv file? Don't forget about the ever-popular Asterisk-stat and the newly revised cdr-stats projects, both web based, proven, and work fantastic: http://www.areski.net/areski/index.php?option=com_contenttask=viewid=22Itemid=54 http://www.cdr-stats.org/ --Tim -- _ -- 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] Is there a php script to analyse and show call detail reports from Asterisk CDR?
No, that doesn't do the job I specifically asked and installation instructions are all over the place... Thanks though. On Fri, Feb 10, 2012 at 11:36 AM, Tim Nelson tnel...@rockbochs.com wrote: - Original Message - Yes, this is exactly what I am looking for - hopefully in English :-) Date or range selection would make this perfect. I have been looking for something like this for quite a while but there is none. I would really appreciate it if you share this with me. Question here, does the .php code read from database and displays or does it analyse the custom-cdr.csv file? Don't forget about the ever-popular Asterisk-stat and the newly revised cdr-stats projects, both web based, proven, and work fantastic: http://www.areski.net/areski/index.php?option=com_contenttask=viewid=22Itemid=54 http://www.cdr-stats.org/ --Tim -- _ -- 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
