VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
andrew at vsave.co.za
Guest
|
 Posted: Tue Jul 01, 2014 1:15 pm Post subject: [asterisk-users] Call rating software |
 |
|
Hi Guys
Does anyone know of any good cdr rating software.
I am looking for something that I can pull reports by extension.
Not a full billing solution like a2billing.
Sent from Samsung Mobile |
|
| Back to top |
|
 |
asterisk_list at earth...
Guest
|
| Posted: Wed Jul 02, 2014 4:15 am Post subject: [asterisk-users] Call rating software |
|
|
On Tuesday 01 Jul 2014, andrew Colin wrote:
| Quote: | Hi Guys
Does anyone know of any good cdr rating software.
I am looking for something that I can pull reports by extension.
Not a full billing solution like a2billing.
|
Have you thought of rolling your own? It's not hard to write a program in
Your Favourite Scripting Language™ to pull the records you want from the
database and create a CSV spreadsheet. And then have it started by cron, to
give you regular automatically-generated reports; either e-mailed directly to
you, or downloadable via a web page.
Alternatively, you could generate your spreadsheet as an .fods (flat XML)
file. This is slightly more effort; but it has the advantage of supporting
styling of table cells, so your report can be made to look pretty.
--
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 |
|
| Back to top |
|
|
sameer at hostnsoft.com
Guest
|
| Posted: Wed Jul 02, 2014 4:41 am Post subject: [asterisk-users] Call rating software |
|
|
Hi,
I am facing issue in bypassing asterisk for audio call
can anyone help in packet to packet bridging I had posted the logs in previous mail
If required again then please let me know
On Wed, Jul 2, 2014 at 2:44 PM, A J Stiles <asterisk_list@earthshod.co.uk (asterisk_list@earthshod.co.uk)> wrote:
| Quote: | On Tuesday 01 Jul 2014, andrew Colin wrote:
| Quote: | Hi Guys
Does anyone know of any good cdr rating software.
I am looking for something that I can pull reports by extension.
Not a full billing solution like a2billing.
|
Have you thought of rolling your own? It's not hard to write a program in
Your Favourite Scripting Language™ to pull the records you want from the
database and create a CSV spreadsheet. And then have it started by cron, to
give you regular automatically-generated reports; either e-mailed directly to
you, or downloadable via a web page.
Alternatively, you could generate your spreadsheet as an .fods (flat XML)
file. This is slightly more effort; but it has the advantage of supporting
styling of table cells, so your report can be made to look pretty.
--
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 |
--
Regards
Sameer Rathod8109413462 |
|
| Back to top |
|
|
asterisk_list at earth...
Guest
|
| Posted: Wed Jul 02, 2014 4:46 am Post subject: [asterisk-users] Call rating software |
|
|
On Wednesday 02 Jul 2014, Sameer Rathod wrote:
| Quote: | Hi,
I am facing issue in bypassing asterisk for audio call
can anyone help in packet to packet bridging I had posted the logs in
previous mail
If required again then please let me know
|
Then why are you replying to a thread which, evidently from its subject line,
is about something else altogether?
Come back when you have learned some manners.
--
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 |
|
| Back to top |
|
|
sameer at hostnsoft.com
Guest
|
| Posted: Wed Jul 02, 2014 5:09 am Post subject: [asterisk-users] Call rating software |
|
|
pardon me sir
I am new to asterisk and no body is replying to any of my thread
I had replied accidentally on this thread
On Wed, Jul 2, 2014 at 3:15 PM, A J Stiles <asterisk_list@earthshod.co.uk (asterisk_list@earthshod.co.uk)> wrote:
| Quote: | On Wednesday 02 Jul 2014, Sameer Rathod wrote:
| Quote: | Hi,
I am facing issue in bypassing asterisk for audio call
can anyone help in packet to packet bridging I had posted the logs in
previous mail
If required again then please let me know
|
Then why are you replying to a thread which, evidently from its subject line,
is about something else altogether?
Come back when you have learned some manners.
--
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
|
--
Regards
Sameer Rathod8109413462 |
|
| Back to top |
|
|
andrew at vsave.co.za
Guest
|
| Posted: Wed Jul 02, 2014 7:56 am Post subject: [asterisk-users] Call rating software |
|
|
Can you try maybe assist with this, as I have tried for ages and still cant get it right.
-----Original Message-----
From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of A J Stiles
Sent: 02 July 2014 11:14 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Call rating software
On Tuesday 01 Jul 2014, andrew Colin wrote:
| Quote: | Hi Guys
Does anyone know of any good cdr rating software.
I am looking for something that I can pull reports by extension.
Not a full billing solution like a2billing.
|
Have you thought of rolling your own? It's not hard to write a program in Your Favourite Scripting Language™ to pull the records you want from the database and create a CSV spreadsheet. And then have it started by cron, to give you regular automatically-generated reports; either e-mailed directly to you, or downloadable via a web page.
Alternatively, you could generate your spreadsheet as an .fods (flat XML) file. This is slightly more effort; but it has the advantage of supporting styling of table cells, so your report can be made to look pretty.
--
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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4592 / Virus Database: 3986/7781 - Release Date: 07/02/14
--
_____________________________________________________________________
-- 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 |
|
| Back to top |
|
|
asterisk_list at earth...
Guest
|
| Posted: Wed Jul 02, 2014 10:51 am Post subject: [asterisk-users] Call rating software |
|
|
On Wednesday 02 Jul 2014, Andrew Colin wrote:
| Quote: | Can you try maybe assist with this, as I have tried for ages and still cant
get it right.
|
Firstly, have you got CDR working and writing to some sort of database? We
use cdr_mysql; although the more modern recommendation is to use cdr_odbc
(which is more generic, and will work with various database types) even if
you are using a MySQL database.
If you haven't got your CDR going into a database, then you need to sort that
out *first*.
Once you have CDR working, then it's simply a question of determining what SQL
queries you need to generate to produce your report; then writing a program to
build up the queries, extract the results and present them in the form you
want.
--
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 |
|
| Back to top |
|
|
andrew at vsave.co.za
Guest
|
| Posted: Wed Jul 02, 2014 11:41 am Post subject: [asterisk-users] Call rating software |
|
|
Currently I am writing to mysql
With all the default fields in the cdr table in the asterisk databas
Sent from Samsung Mobile
-------- Original message --------
From: A J Stiles
Date:02/07/2014 5:50 PM (GMT+02:00)
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Call rating software
On Wednesday 02 Jul 2014, Andrew Colin wrote:
| Quote: | Can you try maybe assist with this, as I have tried for ages and still cant
get it right.
|
Firstly, have you got CDR working and writing to some sort of database? We
use cdr_mysql; although the more modern recommendation is to use cdr_odbc
(which is more generic, and will work with various database types) even if
you are using a MySQL database.
If you haven't got your CDR going into a database, then you need to sort that
out *first*.
Once you have CDR working, then it's simply a question of determining what SQL
queries you need to generate to produce your report; then writing a program to
build up the queries, extract the results and present them in the form you
want.
--
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 |
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
