<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi, did you use SDReporter version 6?
Also, are there specs for CDR format it expects?<br>
<br>
On 13-10-23 05:08 PM, Deon Vermeulen wrote:<br>
</div>
<blockquote cite="mid:52683ABC.2060202@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a class="moz-txt-link-freetext" href="http://www.cudatel.com">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
</body>
</html>