[Freeswitch-users] SDReporter Integration with FS

[Victor Chukalovskiy]

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
> -- 
>
>
>
>> Deon Vermeulen <mailto:vermeulen.deon at gmail.com>
>> October 22, 2013 1:51 PM
>> Hi
>>
>>
>> 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 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131114/f70ae58a/attachment.html