thx, i will try that. other opinion, i found 2010-11-11 04:03:18.503474 [DEBUG] mod_dingaling.c:1350 CHANNEL LOOPBACK 2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:572 Received request via SESSION_HEARTBEAT! 2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:433 Attempting to bill at $0.03 per minute to account 1000 2010-11-11 04:03:18.505460 [INFO] mod_nibblebill.c:485 Beginning new billing on *93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf* 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 on debug mode. 93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf can be found on cdr , how to insert this info and call cost to new table? regards budi On Thu, Nov 4, 2010 at 10:37 AM, Dome Charoenyost <dome@tel.co.th> wrote:
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
_______________________________________________ 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