[asterisk-users] CDR Billing
Network Configurations Block D, Surrey Park, Barham Road, Westville, 3610 Helpdesk: (086) 163-8266 Tel: (031) 266-1563 Fax: (031) 266-4206 Hi everyone. I'm looking for a postpaid billing application that will pull call records either from the cvs file or from a mysql table (something like ASTERISK : CDR ANALYSER http://www.areski.net/asterisk-stat-v2/about.php but just with billing). Ideally it mustn't modify any .conf files, we don't need it to control or activate/suspend SIP accounts, just report on their usage and bill accordingly with the destinations dialed. We do fairly complex call routing in our extensions.conf file based on what SIP dialed what SIP and the status of the termination of the dial app and where to route unsuccessful calls based on the SIP id. So I wouldn't like it to modify these, but if it has to then so be it. I'm not interested in the price however oss does appeal more to me. The closest one I have found so far is MOR from http://www.kolmisoft.com/index.php?option=com_frontpage&Itemid=1 however it doesn't seem to support mISDN (using the B410P BRI cards). Does anyone have any experience with these or others? Regards, Richard. . Best Regards Richard Soderblom Network Configurations Cell: E-Mail: [EMAIL PROTECTED] Number of Attachments: 0 This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] CDR Billing
Hello there I have a small php script that Originates a call, it looks like this: Action: login Events: off Username: strUser Secret: strSecret Action: originate; Channel: SIP/SIP04DK/59119994; WaitTime: 30; CallerId: ANYthing; Exten: 27289955; Context: Mycontext; Priority: 1; Action: Logoff; Mycontext looks like this: exten => _.,1,Answer exten => _.,2,Wait(1) exten => _.,3,Background(pls-wait-connect-call) exten => _.,4,Macro(dialout-trunk,2,${EXTEN},) Everything is working My phone at 59119994 rings and I hear a "please wait while I connect your call" then my mobile rings. What I dont get is why nothing is written in the db. If I would like that both calls is charged to one user/extension how do I do that ? My box is a trixbox, with freePBX. What I can see from the Reports page is: 1. 2006-06-14 23:07:06 SIP/SIP04D... 27289955 "ANYthing" <27289955> 27289955ANSWERED00:21 Hope that someone can point me in the right direction Daya ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] CDR Billing Question.
I have three servers and I want to be able to bill a call going from one through all of the serves. The problem is that I am unable to link or pull the data from each server cdr record and have a common bill. I have been looking on google, but anyhelp would be great Regards Paul Dracevich ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] CDR Billing issues
Hi I am using asterisk 1.6.1.1 ,and trying to do cdr billing.But the problem is when I do transfers,callforward,callparking cdr records are not proper.Below is example 'A' called pstn number and 'A' transfer the call to 'B',In this case cdr is genrating as 1 . caller - A ,Callee - PSTN ,uniqueid=923479129.234 2. Caller -A , Callee -C uniqueid = 939389037.343 There is no link between these 2 records,and I need to generating bill to user A for PSTN call using both records . how do I link these two records? .Same type of records are creating when we do forward,call parking , Anyone have a solution on this. And anyone knows how to use accoutcode and amaflags to solve this problem. Thanks Nikhil. -- _ -- 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 Billing Question.
Hi Paul, You can specify central SQL database with cdr_. Application and put all records into one table or one database. The records will be stored imediately after call, you could do even on-line billing R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dracevich Sent: Wednesday, April 27, 2005 11:41 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] CDR Billing Question. I have three servers and I want to be able to bill a call going from one through all of the serves. The problem is that I am unable to link or pull the data from each server cdr record and have a common bill. I have been looking on google, but anyhelp would be great Regards Paul Dracevich ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] CDR Billing Question.
Are you talking about tracking a single call through three servers, or are your wanting to track all calls made to (through) individual servers and bill a single customer based on ANI? James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DracevichSent: Wednesday, April 27, 2005 4:41 PMTo: asterisk-users@lists.digium.comSubject: [Asterisk-Users] CDR Billing Question. I have three servers and I want to be able to bill a call going from one through all of the serves. The problem is that I am unable to link or pull the data from each server cdr record and have a common bill. I have been looking on google, but anyhelp would be great Regards Paul Dracevich ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] CDR Billing Question.
Yes that’s it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jltaylor Sent: Thursday, April 28, 2005 10:28 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: RE: [Asterisk-Users] CDR Billing Question. Are you talking about tracking a single call through three servers, or are your wanting to track all calls made to (through) individual servers and bill a single customer based on ANI? James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Dracevich Sent: Wednesday, April 27, 2005 4:41 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] CDR Billing Question. I have three servers and I want to be able to bill a call going from one through all of the serves. The problem is that I am unable to link or pull the data from each server cdr record and have a common bill. I have been looking on google, but anyhelp would be great Regards Paul Dracevich ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] CDR Billing Question.
Wanting to track all calls made to (through) individual servers and bill a single customer based on ANI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dracevich Sent: Thursday, April 28, 2005 10:08 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] CDR Billing Question. Yes that’s it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jltaylor Sent: Thursday, April 28, 2005 10:28 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: RE: [Asterisk-Users] CDR Billing Question. Are you talking about tracking a single call through three servers, or are your wanting to track all calls made to (through) individual servers and bill a single customer based on ANI? James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Dracevich Sent: Wednesday, April 27, 2005 4:41 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] CDR Billing Question. I have three servers and I want to be able to bill a call going from one through all of the serves. The problem is that I am unable to link or pull the data from each server cdr record and have a common bill. I have been looking on google, but anyhelp would be great Regards Paul Dracevich ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] CDR Billing Question.
Really looks like having a central SQL server is the best way. Run it on a separate, dedicated machine with an IP address all of the others can see. James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DracevichSent: Wednesday, April 27, 2005 5:11 PMTo: 'Asterisk Users Mailing List - Non-Commercial Discussion'Subject: RE: [Asterisk-Users] CDR Billing Question. Wanting to track all calls made to (through) individual servers and bill a single customer based on ANI -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul DracevichSent: Thursday, April 28, 2005 10:08 AMTo: 'Asterisk Users Mailing List - Non-Commercial Discussion'Subject: RE: [Asterisk-Users] CDR Billing Question. Yes that’s it. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jltaylorSent: Thursday, April 28, 2005 10:28 AMTo: Asterisk Users Mailing List - Non-Commercial DiscussionSubject: RE: [Asterisk-Users] CDR Billing Question. Are you talking about tracking a single call through three servers, or are your wanting to track all calls made to (through) individual servers and bill a single customer based on ANI? James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DracevichSent: Wednesday, April 27, 2005 4:41 PMTo: asterisk-users@lists.digium.comSubject: [Asterisk-Users] CDR Billing Question. I have three servers and I want to be able to bill a call going from one through all of the serves. The problem is that I am unable to link or pull the data from each server cdr record and have a common bill. I have been looking on google, but anyhelp would be great Regards Paul Dracevich ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] CDR Billing Question.
Thanks J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jltaylor Sent: Thursday, April 28, 2005 11:29 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: RE: [Asterisk-Users] CDR Billing Question. Really looks like having a central SQL server is the best way. Run it on a separate, dedicated machine with an IP address all of the others can see. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Dracevich Sent: Wednesday, April 27, 2005 5:11 PM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] CDR Billing Question. Wanting to track all calls made to (through) individual servers and bill a single customer based on ANI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dracevich Sent: Thursday, April 28, 2005 10:08 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] CDR Billing Question. Yes that’s it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jltaylor Sent: Thursday, April 28, 2005 10:28 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: RE: [Asterisk-Users] CDR Billing Question. Are you talking about tracking a single call through three servers, or are your wanting to track all calls made to (through) individual servers and bill a single customer based on ANI? James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Dracevich Sent: Wednesday, April 27, 2005 4:41 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] CDR Billing Question. I have three servers and I want to be able to bill a call going from one through all of the serves. The problem is that I am unable to link or pull the data from each server cdr record and have a common bill. I have been looking on google, but anyhelp would be great Regards Paul Dracevich ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users