Hi Victor I used V6 but it was patched to CDRConverter (4.0.12). Find attached the exact layout and notes I got directly from TransNexus. I got confirmation that V7 will support basic FreeSWITCH CDRs. No QOS stats though. But at least it is a good start. Kind Regards
Victor Chukalovskiy <mailto:victor.chukalovskiy@gmail.com> November 14, 2013 8:56 PM Hi, did you use SDReporter version 6? Also, are there specs for CDR format it expects?
On 13-10-23 05:08 PM, Deon Vermeulen wrote:
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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 Deon Vermeulen <mailto:vermeulen.deon@gmail.com> October 23, 2013 11:08 PM I manage to get CDRs imported into SDReporter.
This is what my cdr_csv.conf.xml file looks like.
<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="sdreporter"/> <!-- This is like the info app but after the call is hung up --> <param name="debug" value="false"/> <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="sdreporter">"${accountcode}","${caller_id_number}","${destination_number}","${context}","${caller_id}","SIP/${sip_from_host}-${call_uuid}","SIP/${sip_gateway_name}_${sip_to_user}","${last_app}","${last_arg}","${start_stamp}","${progress_media_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${accountname}","${uuid}","${userfield}"</template> </templates> </configuration>
The "default" asterisk profile does not work. SDReporter is very specific in the format of the CDR and especially with the Channel, so I had to "normalize" to Asterisk equivalent.
Now off to getting the QoS variable outputs into SDReporter.
Kind Regards
