<div dir="ltr"><div><div><div><div><div><div><div><div>Hi everyone,<br></div>i am using <br><b>FreeSWITCH Version 1.5.1b+git~20130515T182820Z~37d109b107 (git 37d109b 2013-05-15 18:28:20Z)</b><br></div>on CentOS and for the mod_cdr_csv my conf. is as:<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="example"/><br> <!-- This is like the info app but after the call is hung up --><br> <param name="debug" value="false"/><br>
<param name="rotate-on-hup" value="false"/><br> <!-- may be a b or ab --><br> <param name="legs" value="a"/><br> <!-- Only log in Master.csv --><br>
<param name="master-file-only" value="true"/><br> </settings><br></div></div> <templates><br> <template name="sql">INSERT INTO cdr VALUES ("${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}");</template><br>
<template name="example">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}","${accountcode}","${read_codec}","${write_codec}"</template><br>
<template name="snom">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}","${read_codec}","${write_codec}","${sip_user_agent}","${call_clientcode}","${sip_rtp_rxstat}","${sip_rtp_txstat}","${sofia_record_file}"</template><br>
<template name="linksys">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}","${accountcode}","${read_codec}","${write_codec}","${sip_user_agent}","${sip_p_rtp_stat}"</template><br>
<template name="asterisk">"${accountcode}","${caller_id_number}","${destination_number}","${context}","${caller_id}","${channel_name}","${bridge_channel}","${last_app}","${last_arg}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${amaflags}","${uuid}","${userfield}"</template><br>
<template name="opencdrrate">"${uuid}","${signal_bond}","${direction}","${ani}","${destination_number}","${answer_stamp}","${end_stamp}","${billsec}","${accountcode}","${userfield}","${network_addr}","${regex('${original_caller_id_name}'|^.)}","${sip_gateway_name}"</template><br>
</templates><br></configuration><br><br></div>but the issue is that when i use <b>cdr_csv rotate</b> on fs_cli then sometime it not works and also the cdr data is not added in the csv file sometimes <br><br>
</div>any suggestions is highly appreciated<br><br></div>Regards<br><br></div>Shahzad Bhatti<br></div>