Keith, I am currently using citrus to bill VOIP but not with Asterisk. I do not store the CDR data but I have written a module that takes a CDR import file and assigns the charge to the relevant customers as a total for billing. I have no need for the CDR records in Citrus as there is a web portal for people to check the call records. If you are interested I would be happy to chat to you and modify the module that I have to suits asterisk CDR records.
Cheers. Jeremy. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 1 December 2006 6:10 AM To: citrusdb-users@lists.sourceforge.net Subject: Citrusdb-users Digest, Vol 6, Issue 9 Send Citrusdb-users mailing list submissions to citrusdb-users@lists.sourceforge.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/citrusdb-users or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of Citrusdb-users digest..." Today's Topics: 1. Re: customizing CitrusDB (K. Major) 2. Re: UnCancelling Customers (Paul Yasi) 3. CitrusDB user guide? (Dean Woodbeck) ---------------------------------------------------------------------- Message: 1 Date: Thu, 30 Nov 2006 03:56:27 +0000 From: "K. Major" <[EMAIL PROTECTED]> Subject: Re: [Citrusdb-users] customizing CitrusDB To: citrusdb-users@lists.sourceforge.net Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; format=flowed I found some information at this site. It might help. http://www.voip-info.org/tiki-index.php?page=Asterisk%20billing If anyone else knows anything more or even a consultant that could help set this up in a timely mannor that would be great. Thanks, Keith >From: "Paul Yasi" <[EMAIL PROTECTED]> >Reply-To: For users of CitrusDB discussion ><citrusdb-users@lists.sourceforge.net> >To: "For users of CitrusDB discussion" ><citrusdb-users@lists.sourceforge.net> >Subject: Re: [Citrusdb-users] customizing CitrusDB >Date: Tue, 28 Nov 2006 23:27:16 -0500 > >Are you trying to get data from call detail records into citrus? I'm >interested in that too, though it's not such a pressing need for me >yet. > >I think the general steps for billing based on call detail records would >be: >1. make one time service types for each calling rate, eg: A Call from >the US to Australia for $0.023 with option attributes to hold other >details about the call. >2. convert the CDR into new service imports for citrus with the usage >being the minutes of the call, the options_table holding the other >call details that might be shown on the bill, etc. >3. make something that dumps those new call services into the citrus >mysql database each month. > >Paul > >On 11/28/06, K. Major <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I'm trying to figure out how to customize CitrusDB to work with Asterisk >to > > generate invoices on a monthly basis. CitrusDB is already installed >but, I > > could use a little direction. > > > > Thanks, > > Keith > > > > _________________________________________________________________ > > Experience Live Search from your PC or mobile device today. > > http://www.live.com/?mkt=en-ca > > > > > > >------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share >your > > opinions on IT & business topics through brief surveys - and earn cash > > >http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Citrusdb-users mailing list > > Citrusdb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > > >-- >The CitrusDB Project | http://www.citrusdb.org >Open Source Customer Care & Billing System > >------------------------------------------------------------------------- >Take Surveys. Earn Cash. Influence the Future of IT >Join SourceForge.net's Techsay panel and you'll get the chance to share >your >opinions on IT & business topics through brief surveys - and earn cash >http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >_______________________________________________ >Citrusdb-users mailing list >Citrusdb-users@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/citrusdb-users _________________________________________________________________ Download now! Visit http://www.telusmobility.com/msnxbox/ to enter and see how cool it is to get Messenger with you on your cell phone. http://www.telusmobility.com/msnxbox/ ------------------------------ Message: 2 Date: Thu, 30 Nov 2006 12:15:47 -0500 From: "Paul Yasi" <[EMAIL PROTECTED]> Subject: Re: [Citrusdb-users] UnCancelling Customers To: "For users of CitrusDB discussion" <citrusdb-users@lists.sourceforge.net> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed It should be, but if you don't get it all and have overlapping id numbers from new customers that were previously assigned to test customers that could make things look funny. I'd probably leave it alone unless you made a whole bunch of test data that is taking up valuable space. The tables to remove data from would be the billing table, billing_details, billing_history, any _options tables for services, customer, customer_history, payment_history, tax_exempt, and user_services. Paul On 11/29/06, Morgan Jones <[EMAIL PROTECTED]> wrote: > I have a related question. I have some old fake test customers in my > database - the results of my testing the import customer function and > trying to get all my fields lined up. Is it safe for me to just > remove these entries (and their related billing entries) from the > database entirely (ie, via phpmyadmin or in the mySql console)? > > Or, maybe is there a better way to clean things up? > > Thanks! > > Morgan > > > > > On Nov 28, 2006, at 5:49 PM, Paul Yasi wrote: > > > Just click Edit Customer on their record and remove the Cancel Date > > and Removal Dates, then Save Changes. > > > > Paul > > > > On 11/28/06, Dean Woodbeck <[EMAIL PROTECTED]> wrote: > >> I have a customer, billing status "canceled" who is ordering new > >> service. Is > >> there a way to remove the "canceled" note from their billing status? > >> > >> --------------------------------------------------------------------- > >> ---- > >> Take Surveys. Earn Cash. Influence the Future of IT > >> Join SourceForge.net's Techsay panel and you'll get the chance to > >> share your > >> opinions on IT & business topics through brief surveys - and earn > >> cash > >> http://www.techsay.com/default.php? > >> page=join.php&p=sourceforge&CID=DEVDEV > >> > >> _______________________________________________ > >> Citrusdb-users mailing list > >> Citrusdb-users@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users > >> > >> > >> > > > > > > -- > > The CitrusDB Project | http://www.citrusdb.org > > Open Source Customer Care & Billing System > > > > ---------------------------------------------------------------------- > > --- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to > > share your > > opinions on IT & business topics through brief surveys - and earn cash > > http://www.techsay.com/default.php? > > page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Citrusdb-users mailing list > > Citrusdb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care & Billing System ------------------------------ Message: 3 Date: Thu, 30 Nov 2006 14:34:53 -0500 From: "Dean Woodbeck" <[EMAIL PROTECTED]> Subject: [Citrusdb-users] CitrusDB user guide? To: citrusdb-users@lists.sourceforge.net Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" I need to start training people in our organization on CitrusDB and am going to create a user guide -- a simple step-by-step manual on how to create new customer accounts and dealing with the billing and service frequencies (which I've found are easy to mess up). Has anyone done such a thing that they'd be willing to share? Dean Woodbeck Pasty.NET Calumet MI [EMAIL PROTECTED] -------------- next part -------------- An HTML attachment was scrubbed... URL: http://sourceforge.net/mailarchive/forum.php?forum=citrusdb-users/attachment s/20061130/acf97101/attachment.html ------------------------------ ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ------------------------------ _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users End of Citrusdb-users Digest, Vol 6, Issue 9 ******************************************** -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.6/565 - Release Date: 2/12/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.6/565 - Release Date: 2/12/2006 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
