<html><head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
</head><body style="font-family: Calibri; font-size: 11pt;"
bgcolor="#FFFFFF" text="#000000"><div style="font-size:
11pt;font-family: Calibri;">I manage to get CDRs imported into
SDReporter.<br><br>This is what my cdr_csv.conf.xml file looks like.<br><br><span><span
style="font-family: Calibri;"><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="sdreporter"/><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="true"/><br> <!-- may be a b or ab --><br>
<param name="legs" value="ab"/><br> <!-- Only log in
Master.csv --><br> <param name="master-file-only"
value="true"/><br> </settings><br> <templates><br>
<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><br>
</templates><br></configuration></span></span><br><br>The
"default" asterisk profile does not work.<br>SDReporter is very specific
in the format of the CDR and especially with the Channel, so I had to
"normalize" to Asterisk equivalent.<br><br>Now off to getting the QoS
variable outputs into SDReporter.<br><br><br>Kind Regards<br><div
class="moz-signature">-- <span><span style="background-color: rgba(255,
255, 255, 0);"></span></span><br>
<br>
</div><br><br><blockquote style="border: 0px none;"
cite="mid:526666D6.6010901@gmail.com" type="cite"><div
style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true" href="mailto:vermeulen.deon@gmail.com"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Deon Vermeulen</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">October 22, 2013
1:51 PM</span></font></div></div></div><div
style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody">
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<div style="font-size: 11pt;font-family: Calibri;"><span
style="font-family: Calibri;">Hi<br><br><br>I've successfully setup
SDReporter, FreeSWITCH to export CDRs using cdr_csv with the Asterisk
template.<br>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/<br><br>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.<br>I've removed the </span><span><span style="font:
13.0px Arial">"${channel_name}","${bridge_channel}"</span>
variables, but still I get the above error.<br><br>I currently run
FreeSWITCH Version 1.5.6b+git~20131018T052734Z~e0054af96f.<br><br>Has
anyone successfully got SDReporter working with FS?<br><br><br>Thanks
for any assistance.</span><span style="font-family: Calibri;"><br><br></span></div>
</div></blockquote></div></body></html>