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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org