[Freeswitch-users] SDReporter Integration with FS

[Deon Vermeulen]

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 at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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 at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131115/45901ebb/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2013-11-15 at 9.21.34 AM.png
Type: image/png
Size: 134111 bytes
Desc: not available
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131115/45901ebb/attachment-0001.png