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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Sampietro Sent: Wednesday, July 02, 2003 7:06 AM To: Scott Stingel Cc: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> SS> URL: www.evtmedia.com <http://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 _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users