SDReporter Integration with FS
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. -- Kind Regards
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@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.
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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@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
Hi Deon, Thank you for the feedback! I'm in touch with Jim regarding the new release and they promised to keep me posted. In a mean-time, running into the Asterisk channel error just like you had. Would you mind sharing the 4.0.12 patch off-list? Many thanks, -Victor On 13-11-15 02:23 AM, Deon Vermeulen wrote:
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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (3)
-
Avi Marcus
-
Deon Vermeulen
-
Victor Chukalovskiy