This is my cdr_csv.conf.xml <configuration name="cdr_csv.conf" description="CDR CSV Format"> <settings> <!-- 'cdr-csv' will always be appended to log-base --> <!--<param name="log-base" value="/var/log"/>--> <param name="default-template" value="sql"/> <!-- This is like the info app but after the call is hung up --> <!--<param name="debug" value="true"/>--> <param name="rotate-on-hup" value="true"/> <!-- may be a b or ab --> <param name="legs" value="ab"/> <!-- Only log in Master.csv --> <param name="master-file-only" value="true"/> </settings> <templates> <template name="sql">INSERT INTO voipcall (prate,pcost,provider,provider_id,pprefix,bleg,price,duration,initialincrement,regularincrement,graceperiod,tariffdesc,prefix,service_charge,cost,username,callingstationid,calledstationid,duration_raw,acctstoptime,acctstarttime,acctsessionid,hangup_cause) values (${prate},(${billsec}+1)/60.00*${prate},'${provider_name}',${provider_id},${pprefix},'${bleg_uuid}',${tux_rate},${t_duration},${in_block},${re_block},${gr_block},'${dest}','${iprefix}',${ser_charge},${tux_total_billed}/100,'${tux_account}','${caller_id_number}', '${dnumber}',(${billsec}+1), '${end_stamp}','${start_stamp}' ,'${uuid}','${hangup_cause}');</template> 2010/11/4 budi wibowo <bwibowo@gmail.com>:
the perl script can parse all cdr and insert to database, but no info about the cost defined in nibblebill.
On Wed, Nov 3, 2010 at 1:52 PM, Dome Charoenyost <dome@tel.co.th> wrote:
2010/11/3 William Suffill <william.suffill@gmail.com>:
You can customize the variables stored by mod cdr_csv to include those set by nibblebill if you rather not have mess with mod_cdr_xml
http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template
I agree :) for my solution i modify nibble bill support many feature initial block , regular block, grace period (30/6 , 1/1 , 60/60), multiple rate (first 2 minute 0.5 usd and next 0.2 usd) .. etc and define channel variable for csv cdr (about 30 columns)
Dome C.
Just define a new template that includes the nibblebill variables and use that instead of the default.
-- W
PS: I would include an example but don't have it handy.
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org