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
>
>
_______________________________________________
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