[Freeswitch-users] Designing a schema for CDRs

[Avi Marcus]

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
mysql/postgres...

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.

-Avi

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