thx, i will try that.<div>other opinion, i found </div><div><div>2010-11-11 04:03:18.503474 [DEBUG] mod_dingaling.c:1350 CHANNEL LOOPBACK</div><div>2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:572 Received request via SESSION_HEARTBEAT!</div>
<div>2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:433 Attempting to bill at $0.03 per minute to account 1000</div><div>2010-11-11 04:03:18.505460 [INFO] mod_nibblebill.c:485 Beginning new billing on <b>93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf</b></div>
<div>2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:491 0 seconds passed since last bill time of 2010-11-11 04:03:18</div><div>on debug mode. </div><div><br></div><div>93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf can be found on cdr , how to insert this info and call cost to new table?</div>
<div><br></div><div><br></div><div>regards</div><div><br></div><div>budi</div><div><br></div><br><div class="gmail_quote">On Thu, Nov 4, 2010 at 10:37 AM, Dome Charoenyost <span dir="ltr"><<a href="mailto:dome@tel.co.th">dome@tel.co.th</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">This is my cdr_csv.conf.xml<br>
<br>
<configuration name="cdr_csv.conf" description="CDR CSV Format"><br>
<settings><br>
<!-- 'cdr-csv' will always be appended to log-base --><br>
<!--<param name="log-base" value="/var/log"/>--><br>
<param name="default-template" value="sql"/><br>
<!-- This is like the info app but after the call is hung up --><br>
<!--<param name="debug" value="true"/>--><br>
<param name="rotate-on-hup" value="true"/><br>
<!-- may be a b or ab --><br>
<param name="legs" value="ab"/><br>
<!-- Only log in Master.csv --><br>
<param name="master-file-only" value="true"/><br>
</settings><br>
<templates><br>
<template name="sql">INSERT INTO voipcall<br>
(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)<br>
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}',<br>
'${dnumber}',(${billsec}+1), '${end_stamp}','${start_stamp}'<br>
,'${uuid}','${hangup_cause}');</template><br>
<br>
<br>
<br>
2010/11/4 budi wibowo <<a href="mailto:bwibowo@gmail.com">bwibowo@gmail.com</a>>:<br>
<div><div></div><div class="h5">> the perl script can parse all cdr and insert to database, but no info about<br>
> the cost defined in nibblebill.<br>
><br>
> On Wed, Nov 3, 2010 at 1:52 PM, Dome Charoenyost <<a href="mailto:dome@tel.co.th">dome@tel.co.th</a>> wrote:<br>
>><br>
>> 2010/11/3 William Suffill <<a href="mailto:william.suffill@gmail.com">william.suffill@gmail.com</a>>:<br>
>> > You can customize the variables stored by mod cdr_csv to include those<br>
>> > set by nibblebill if you rather not have mess with mod_cdr_xml<br>
>> ><br>
>> > <a href="http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template" target="_blank">http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template</a><br>
>> ><br>
>> I agree :)<br>
>> for my solution i modify nibble bill support many feature initial<br>
>> block , regular block, grace period (30/6 , 1/1 , 60/60), multiple<br>
>> rate (first 2 minute 0.5 usd and next 0.2 usd) .. etc<br>
>> and define channel variable for csv cdr (about 30 columns)<br>
>><br>
>> Dome C.<br>
>><br>
>><br>
>><br>
>> > Just define a new template that includes the nibblebill variables and<br>
>> > use that instead of the default.<br>
>> ><br>
>> > -- W<br>
>> ><br>
>> > PS: I would include an example but don't have it handy.<br>
>> ><br>
>> > _______________________________________________<br>
>> > FreeSWITCH-users mailing list<br>
>> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>><br>
>> _______________________________________________<br>
>> FreeSWITCH-users mailing list<br>
>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
> _______________________________________________<br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br></div>