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
--
October 22, 2013 1:51 PMHi
I've successfully setup SDReporter, FreeSWITCH to export CDRs using cdr_csv with the Asterisk template.
I've setup a cron to "automatically" push the csv file(s) to SDReporter $HOME_DIR/SDReporter/CDRConverter-4.0.8/data/INPUT/Asterisk/1/
I've tried different options in the format of the CDRs ,but no matter what I do I keep getting an " CDRFieldChannelAsterisk(String): wrong Asterisk channel. " ERROR.
I've removed the "${channel_name}","${bridge_channel}" variables, but still I get the above error.
I currently run FreeSWITCH Version 1.5.6b+git~20131018T052734Z~e0054af96f.
Has anyone successfully got SDReporter working with FS?
Thanks for any assistance.
_________________________________________________________________________ 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