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:
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