Top System Posted February 1, 2010 Report Share Posted February 1, 2010 I read lots of topics, where people were asking to store the cdr informations to a SQL database. (mySql, MS Sql) So I decided to write a small windows service to capture the cdr sent by pbxnsip and to store these cdr in a Sql database ( mySQL, MS SQL, Orcacle : depending on your db provider). Not all versions of MS Sql supports SOAP, and there is less informations available in the SOAP cdr format. All the fields described in the simple CDR format or long CDR format can be used in cdr2sql. http://www.pbxnsipsupport.com/index.php?_m...kbarticleid=464 The application is working by receiving the cdr logs on a specific TCPIP port. It's simple to install and there is no latency between the end of the call and the availability of the information in the database. The only think you have to do after installing the application and configuring the credentials to connect the database, is to configure pbxnsip : - to send the cdr to the tcp ip address and port where the cdr2sql service is installed - to adapt the pbx.xml file to the format you like PBXNSIP cdr2sql (screenshots) Quote Link to comment Share on other sites More sharing options...
mattlandis Posted February 1, 2010 Report Share Posted February 1, 2010 That is EXCELLENT. A great solution if it works as advertised. I will test the service if I know where it can be downloaded. This will add incredible value to pbxnsip Call Reporting. Also, I would be glad to write a SQL Reporting report to go with this. Matt Quote Link to comment Share on other sites More sharing options...
shopcomputer Posted February 1, 2010 Report Share Posted February 1, 2010 I read lots of topics, where people were asking to store the cdr informations to a SQL database. (mySql, MS Sql)So I decided to write a small windows service to capture the cdr sent by pbxnsip and to store these cdr in a Sql database ( mySQL, MS SQL, Orcacle : depending on your db provider). Not all versions of MS Sql supports SOAP, and there is less informations available in the SOAP cdr format. All the fields described in the simple CDR format or long CDR format can be used in cdr2sql. http://www.pbxnsipsupport.com/index.php?_m...kbarticleid=464 The application is working by receiving the cdr logs on a specific TCPIP port. It's simple to install and there is no latency between the end of the call and the availability of the information in the database. The only think you have to do after installing the application and configuring the credentials to connect the database, is to configure pbxnsip : - to send the cdr to the tcp ip address and port where the cdr2sql service is installed - to adapt the pbx.xml file to the format you like PBXNSIP cdr2sql (screenshots) Nice I actually hired a programmer to start writing an application like this for me, except he is wring it to work on windows, linux and Mac. Quote Link to comment Share on other sites More sharing options...
mattlandis Posted February 1, 2010 Report Share Posted February 1, 2010 Moishe, We are a Windows shop so the rest aren't quite as important but that is interesting. If we use the cs410 or plug it appears that with Top's solution the cdr can easily be sent to a Windows machine --which is genius. Matt Quote Link to comment Share on other sites More sharing options...
shopcomputer Posted February 1, 2010 Report Share Posted February 1, 2010 Moishe, We are a Windows shop so the rest aren't quite as important but that is interesting. If we use the cs410 or plug it appears that with Top's solution the cdr can easily be sent to a Windows machine --which is genius. Matt Question is what it costs, don't see pricing listed, Windows would be fine for me too. Quote Link to comment Share on other sites More sharing options...
mattlandis Posted March 18, 2010 Report Share Posted March 18, 2010 bump TOP: any progress on this tool? keep me up-to-date. I'll blog/promote it. matt Quote Link to comment Share on other sites More sharing options...
ventodimare70 Posted May 13, 2010 Report Share Posted May 13, 2010 Good morning, I would like to export my cdrs from my PBX to mysqlserver. The pbx version is the 4.0.1.3499 installed on Linux (CentOS 5). My programmers keep saying that the export doesn't work in the last pbx version (4.0.1.3499). Has someone exported successfully the cdrs into mysql table in the 4.0.1.3499 pbx version? Thanks Quote Link to comment Share on other sites More sharing options...
mattlandis Posted June 21, 2010 Report Share Posted June 21, 2010 From another blog post it appears this may have been deprecated in 3499? It wasn't perfectly clear but the arguements were against it. matt Quote Link to comment Share on other sites More sharing options...
Top System Posted June 30, 2010 Author Report Share Posted June 30, 2010 Check this post : Cdr2sql Regards, Regis Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.