[Asterisk-Users] Asterisk PBX Billing

[Kim C. Callis]

There is a CDR (Call Detail Record) which is accessible in two different
ways. The first is via a simple comma delimited file which can be parsed
and fed into whatever database that you want. The second way is to dump
the CDR directly into MySQL, and extract accordingly. So the only trick
there is to create a database for billing and create a relationship that
will extract from the CDR database.

Kim C. Callis

-----Original Message-----
From: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com] On Behalf Of Angelo
Sampietro
Sent: Wednesday, July 02, 2003 7:06 AM
To: Scott Stingel
Cc: asterisk-users at lists.digium.com
Subject: Re[2]: [Asterisk-Users] Asterisk PBX Billing

i think that the problem could be something more easy:

it is possible inside asterisk to log all che calls of all the users
and know the timing and the number called for each call?
if it is possible to do that, could be possible to make a program
that takes this files and generate the costs reading the log
informations...

so for me the real question is: there is a log of all the phone call
that are made by asterisk?

Angelo



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.
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
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
is
SS> occurring, debiting each account, and the master account, in
real-time. This
SS> can be a bit complex when you have 20 or 30 calls going at one time.
You
SS> have to cut them off promptly when the money runs out (big problem).
And
SS> you have to provide call detail and charges to them at the end of
each call,
SS> using their own retail tariff.

SS> To add to the complexity, each country has a different tariff from
the long
SS> distance carrier, and within the country, major cities often have
special
SS> rates per minute.  Mobiles have a different tariff too.  Phone card
SS> platforms usually include a least-cost routing system which chooses
a
SS> carrier real time based on the call.  Tariffs change weekly and must
be
SS> updated in the system.

SS> Anyway, I'm just scratching the surface!  I'll write more when I
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