[Asterisk-Users] Asterisk PBX Billing

Thu Jul 3 08:40:40 MST 2003

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 