[Freeswitch-users] mod_nibblebill cdr

Dome Charoenyost dome at tel.co.th
Wed Nov 3 20:37:13 PDT 2010


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 at 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 at tel.co.th> wrote:
>>
>> 2010/11/3 William Suffill <william.suffill at 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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>



More information about the FreeSWITCH-users mailing list