Chris Mason (Lists)
2006-Mar-25 07:55 UTC
[Asterisk-Users] Asterisk billing from CDR database
I am copying the Master.csv file to another server and importing to mysql. I am looking for a simple billing application that will produce a bill for a give account code for a give period, based on a rate table. Is this available? -- Chris Mason NetConcepts (264) 497-5670 Fax: (264) 497-8463 Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271 Cell: 264-235-5670 Yahoo IM: netconcepts_anguilla@yahoo.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
First of all... why don't you either load cdr_ODBC or cdr_MYSQL and save yourself the stress of loading the .csv file into a database. Now that that is done.. it's pretty trivial to write something to interface with your billing software that will look at minutes used and bill the customer. That is what we did... wrote our own. On 3/25/06, Chris Mason (Lists) <lists@masonc.com> wrote:> I am copying the Master.csv file to another server and importing to > mysql. I am looking for a simple billing application that will produce a > bill for a give account code for a give period, based on a rate table. > Is this available? > > -- > Chris Mason > NetConcepts > (264) 497-5670 Fax: (264) 497-8463 > Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271 > Cell: 264-235-5670 > Yahoo IM: netconcepts_anguilla@yahoo.com > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Disclaimer: astpp is my software. :-) It's quite easy to do this with astpp. Depending on exactly what you want, there are a few ways to do it. Drop a note on the astpp forum (www.astpp.org/forum) or on the astpp mailling list if you're interested. Darren Wiebe darren@aleph-com.net Chris Mason (Lists) wrote:> I am copying the Master.csv file to another server and importing to > mysql. I am looking for a simple billing application that will > produce a bill for a give account code for a give period, based on > a rate table. Is this available? >-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFEJXC64DADnh+tnOQRAsiJAJ4wdn0PDP8ac0tyt92kxYwI2eE2qgCeIP5e /FOvPyAut5Psfk54Xqc1bag=JftS -----END PGP SIGNATURE-----