[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: [EMAIL PROTECTED] -- 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
Re: [Asterisk-Users] Asterisk billing from CDR database
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) [EMAIL PROTECTED] 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: [EMAIL PROTECTED] -- 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 ___ --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
Re: [Asterisk-Users] Asterisk billing from CDR database
-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 [EMAIL PROTECTED] 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- ___ --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
Re: [Asterisk-Users] Asterisk billing from CDR database
Darren Wiebe napisaĆ(a): -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. I've got problem: my telco gives billing info on PRI/E1 linne. Is astpp able to do simple +3% for my clients? -- Krzysztof Drewicz [EMAIL PROTECTED] +48 22 34 54 363 begin:vcard fn:Krzysztof Drewicz n:Drewicz;Krzysztof adr;quoted-printable:;;Wybrze=C5=BCe Gdy=C5=84skie 6C;Warszawa;Mazowieckie;01-531;Polska email;internet:[EMAIL PROTECTED] tel;work:+48 22 34 54 363 tel;cell:+48 606 698 295 x-mozilla-html:TRUE url:http://www.citicom.pl version:2.1 end:vcard ___ --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
Re: [Asterisk-Users] Asterisk billing from CDR database
Darren Wiebe wrote: -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. I don't suppose you could just tell me? -- 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: [EMAIL PROTECTED] -- 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
Re: [Asterisk-Users] Asterisk billing from CDR database
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I didn't want to bore everybody with the details but I'll try. :-) A few questions/comments: 1. Are you wanting invoices to print or email or do you want something that keeps track of a prepaid balance? We can do both. ASTPP itself will handle the second and I've been using OSCommerce for invoice generation and presentation. If needed, we can easily build invoice generation into ASTPP I just haven't gotten that far yet. I have a user who has done it who could probably be prevailed upon to share at least some of the code. 2. Account payments... ASTPP does not have the capability at present to process credit cards or Paypal. This is another which I have been using oscommerce for. You can sign up for a voip account and refill your account using our oscommerce plugin. If I missed something let me know. Darren Wiebe [EMAIL PROTECTED] Chris Mason (Lists) wrote: Darren Wiebe wrote: -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. I don't suppose you could just tell me? -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFEJYso4DADnh+tnOQRAoEvAJ4/rFHbqHIr6XCY6QG8+IeAAMGObgCeLFVX mMfgWkJpwF54w8VEapnPhcc= =orxL -END PGP SIGNATURE- ___ --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