Hi Michael, I don't have any experience with scripting CDR billing, but a few thoughts...
1) You can enable CDR Call Logging with SQL using the file /mnt/kd/cdr-sqlite3/cdr-odbc.sqlite3 CDR Call Logging with SQL http://doc.astlinux.org/userdoc:tt_asterisk-odbc#cdr_call_logging_with_sql Nuf said for the benefits of this. :-) 2) Possibly when a call completes a shell script is called in the background to generate a transaction via 'curl' to another system. Possibly there is some way to generate a comment or such in their hotel management system, such that at checkout the phone charges could be added from the comment data. 3) Simplify the Phone billing, charge only per call at a fixed price ($1 or so) and block expensive international calls. Here in the US phone calls were once a revenue source for hotels before the advent of cell phones. I suspect they are mostly for in-house calls now. Here $1 per US call and block all international calls would probably work out. A cron job could email the number of outbound calls / room once a day. 4) Don't charge for inexpensive phone calls and block expensive calls, provide that as a service, and forget CDR's :-) To get a very accurate tally you need the cdr-odbc.sqlite3 plus the checkin-checkout times which are on a different system. Lonnie On May 30, 2015, at 12:06 AM, Michael Knill <michael.kn...@ipcsolutions.com.au> wrote: > Gosh so much searching with very little progress. Im very tempted to add more > functionality to the existing cdrlog.php. > > Regards > Michael Knill > > > > > On 30 May 2015, at 12:36 pm, Michael Knill > <michael.kn...@ipcsolutions.com.au> wrote: > > Hi group > > On a different subject, it looks like I am going to pick up a small hotel > which I will be installing Astlinux. > Although their requirements are pretty basic, I am concerned about the CDR > Billing system for charging out calls to their customers. > > Does anyone have any recommendations here? > > Regards > Michael Knill ------------------------------------------------------------------------------ _______________________________________________ Astlinux-users mailing list Astlinux-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/astlinux-users Donations to support AstLinux are graciously accepted via PayPal to pay...@krisk.org.
