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] <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
