RE: Re[4]: [Asterisk-Users] Asterisk PBX Billing

2003-07-02 Thread James Golovich 
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:[EMAIL PROTECTED] 
> Sent: Wednesday, July 02, 2003 8:07 AM
> To: Kim C. Callis
> Cc: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> KCC> [mailto:[EMAIL PROTECTED] On Behalf Of Angelo
> KCC> Sampietro
> KCC> Sent: Wednesday, July 02, 2003 7:06 AM
> KCC> To: Scott Stingel
> KCC> Cc: [EMAIL PROTECTED]
> 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:  [EMAIL PROTECTED]    
> SS>> URL:www.evtmedia.com    
> 
> 
> 
> >>> -Original Message-
> >>> From: [EMAIL PROTECTED] 
> >>> [mailto:[EMAIL PROTECTED] On Behalf Of 
> >>> shepherd fungayi
> >>> Sent: Wednesday, July 02, 2003 10:49 AM
> >>> To: [EMAIL PROTECTED]
> >>> 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
> >>> [EMAIL PROTECTED]
> >>> http://lists.digium.com/mailman/listinfo/asterisk-users
> >>> 
> >>> 
> 
> 
> 
> S

RE: Re[4]: [Asterisk-Users] Asterisk PBX Billing

2003-07-02 Thread Kim C. Callis 
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:[EMAIL PROTECTED] 
Sent: Wednesday, July 02, 2003 8:07 AM
To: Kim C. Callis
Cc: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
KCC> [mailto:[EMAIL PROTECTED] On Behalf Of Angelo
KCC> Sampietro
KCC> Sent: Wednesday, July 02, 2003 7:06 AM
KCC> To: Scott Stingel
KCC> Cc: [EMAIL PROTECTED]
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:  [EMAIL PROTECTED]    
SS>> URL:www.evtmedia.com    



>>> -Original Message-
>>> From: [EMAIL PROTECTED] 
>>> [mailto:[EMAIL PROTECTED] On Behalf Of 
>>> shepherd fungayi
>>> Sent: Wednesday, July 02, 2003 10:49 AM
>>> To: [EMAIL PROTECTED]
>>> 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
>>> [EMAIL PROTECTED]
>>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>> 
>>> 



SS>> ___
SS>> Asterisk-Users mailing list
SS>> [EMAIL PROTECTED]
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