[Freeswitch-users] Designing a schema for CDRs

Avi Marcus avi at avimarcus.net
Thu Jan 1 17:04:28 MSK 2015

Mod_xml_cdr gives you *all *the channel variables that you set, so it
changes all the time.

If you want to save everything, you can't stuff that into columns in

You can pull out "common" fields for your schema, and then save the rest
(if you want) as an XML or json object... or use a nosql DB so you don't
need a schema.


On Thu, Jan 1, 2015 at 12:19 PM, Tayyab Atiq <tayyabatiq at gmail.com> wrote:

> Hi.
> I have recently been trying to process CDR from mod_xml_cdr and store it
> in a db
> I first parsed and wrote all the information in a file, then designed a
> database based on the fields that appeared in the file.
> But it seems that FS adds/removes fields sometimes. This causes my query
> to fail as my program tries to insert columns that do not exist.
> Is there a way to figure out all the possible fields that might appear in
> the xml sent by mod_xml_cdr?
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.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/20150101/15df9334/attachment.html 

Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list