Christian Stredicke
CEO of Vodia Networks

One frequent question of snom ONE administrators is how to get the call data records (CDR) out of the system. In version 5.0.8, we have added another answer to that question.

The new version supports JSON-based CDR. JSON is the new darling of the IT industry and stands for “JavaScript Object Notation” and is simple the way you initialize an object in JavaScript. The big advantage is obviously that you can write very simple JavaScript code that eats JSON text. In the web world, that is a huge advantage compared to competing standards like XML.

Because of this, most tools today support JSON. For example, PHP also supports JSON and also makes it very easy to parse JSON text. On the Wiki page http://wiki.snomone.com/index.php?title=JSON_CDR we have put an example on how to take the JSON CDR and write them into a MySQL database. Once in a database, customers can write their own PHP code that generates the reports that clients need. Because the CVR are written directly after the call terminates, reports can be very much up-to-date.

But the JSON CDR is not limited to MySQL and PHP. First of all, PHP supports all sorts of database front-ends. Secondly, other frameworks like ASP.NET also support JSON extensively. Using these frameworks, it also becomes easy to take incoming requests and put them into database.