[Asterisk-Users] Asterisk PBX Billing

Wed Jul 2 09:07:33 MST 2003

The mysql schema is available in the doc/cdr_mysql.txt file (from the
asterisk source dir)

James

On Thu, 3 Jul 2003, Kim C. Callis wrote:

> You can find the comma delimited file at /var/log/asterisk/cdr-csv or if
> you are looking to do some easy querying on a database, you need to
> create a schema that I am sure someone on the channel has defined
> somewhere. At that point you clean up the /etc/asterisk/cdr_mysql.conf
> file to point to the appropriate database and authentication
> information.
> 
> Kim C. Callis
> 
> -----Original Message-----
> From: Angelo Sampietro [mailto:a.sampietro at niumidia.it] 
> Sent: Wednesday, July 02, 2003 8:07 AM
> To: Kim C. Callis
> Cc: asterisk-users at lists.digium.com
> Subject: Re[4]: [Asterisk-Users] Asterisk PBX Billing
> 
> thanks a lot!
> can you tell me where can i find more info about the CDR?
> probably this will be the better way to give to the company a summary
> with all the phone traffic :)
> 
> Angelo
> 
> 
> 
> Thursday, July 3, 2003, 4:37:32 PM, you wrote:
> 
> KCC> There is a CDR (Call Detail Record) which is accessible in two
> different
> KCC> ways. The first is via a simple comma delimited file which can be
> parsed
> KCC> and fed into whatever database that you want. The second way is to
> dump
> KCC> the CDR directly into MySQL, and extract accordingly. So the only
> trick
> KCC> there is to create a database for billing and create a relationship
> that
> KCC> will extract from the CDR database.
> 
> KCC> Kim C. Callis
> 
> KCC> -----Original Message-----
> KCC> From: asterisk-users-admin at lists.digium.com
> KCC> [mailto:asterisk-users-admin at lists.digium.com] On Behalf Of Angelo
> KCC> Sampietro
> KCC> Sent: Wednesday, July 02, 2003 7:06 AM
> KCC> To: Scott Stingel
> KCC> Cc: asterisk-users at lists.digium.com
> KCC> Subject: Re[2]: [Asterisk-Users] Asterisk PBX Billing
> 
> KCC> i think that the problem could be something more easy:
> 
> KCC> it is possible inside asterisk to log all che calls of all the
> users
> KCC> and know the timing and the number called for each call?
> KCC> if it is possible to do that, could be possible to make a program
> KCC> that takes this files and generate the costs reading the log
> KCC> informations...
> 
> KCC> so for me the real question is: there is a log of all the phone
> call
> KCC> that are made by asterisk?
> 
> KCC> Angelo
> 
> 
> 
> KCC> Wednesday, July 2, 2003, 3:28:22 PM, you wrote:
> 
> SS>> Shepherd-
> 
> SS>> Having designed one of these in the past (in a higher level voice
> SS>> environment), I can tell you that this is not a small undertaking.
> KCC> It's at
> SS>> least as much an SQL job as a voice task.
> 
> SS>> Usually the way to accomplish this is to establish more-or-less a
> KCC> pre-paid
> SS>> phone card system, where the shop prepays an overall amount for
> SS>> international calling access.  Then you have to time each call as
> it
> KCC> is
> SS>> occurring, debiting each account, and the master account, in
> KCC> real-time. This
> SS>> can be a bit complex when you have 20 or 30 calls going at one
> time.
> KCC> You
> SS>> have to cut them off promptly when the money runs out (big
> problem).
> KCC> And
> SS>> you have to provide call detail and charges to them at the end of
> KCC> each call,
> SS>> using their own retail tariff.
> 
> SS>> To add to the complexity, each country has a different tariff from
> KCC> the long
> SS>> distance carrier, and within the country, major cities often have
> KCC> special
> SS>> rates per minute.  Mobiles have a different tariff too.  Phone card
> SS>> platforms usually include a least-cost routing system which chooses
> KCC> a
> SS>> carrier real time based on the call.  Tariffs change weekly and
> must
> KCC> be
> SS>> updated in the system.
> 
> SS>> Anyway, I'm just scratching the surface!  I'll write more when I
> KCC> can!
> 
> SS>> Cheers
> SS>> Scott Stingel
> 
> 
> SS>> Scott M. Stingel 
> SS>> Emerging Voice Technology Inc.
> 
> SS>> Email:          scott at evtmedia.com <mailto:scott at evtmedia.com>   
> SS>> URL:            www.evtmedia.com <http://www.evtmedia.com>   
> 
> 
> 
> >>> -----Original Message-----
> >>> From: asterisk-users-admin at lists.digium.com 
> >>> [mailto:asterisk-users-admin at lists.digium.com] On Behalf Of 
> >>> shepherd fungayi
> >>> Sent: Wednesday, July 02, 2003 10:49 AM
> >>> To: asterisk-users at lists.digium.com
> >>> Subject: [Asterisk-Users] Asterisk PBX Billing
> >>> 
> >>> 
> >>> Hi
> >>> 
> >>> I would like to use the Asterisk PBX as part of a phone shop 
> >>> system instead 
> >>> of the usual PBX plus PC. How can I do the the billing in a 
> >>> way that is 
> >>> convinient to the phone shop attendant?
> >>> 
> >>> Regards
> >>> 
> >>> Shepherd
> >>> 
> >>> _________________________________________________________________
> >>> Add photos to your messages with MSN 8. Get 2 months FREE*. 
> >>> http://join.msn.com/?page=features/featuredemail
> >>> 
> >>> _______________________________________________
> >>> Asterisk-Users mailing list
> >>> Asterisk-Users at lists.digium.com
> >>> http://lists.digium.com/mailman/listinfo/asterisk-users
> >>> 
> >>> 
> 
> 
> 
> SS>> _______________________________________________
> SS>> Asterisk-Users mailing list
> SS>> Asterisk-Users at lists.digium.com
> SS>> http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> 
> 
> 
> 
> 
> -- 
> Angelo Sampietro
> IT Manager
> ARC Interactive
> 
> "After a certain high level of technical skill is achieved, 
> Science and art tend to coalesce in esthetics, plasticity, and form. 
> The greatest scientists are always artists as well."
>  
> Albert Einstein 
> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
>