<div dir="ltr">Mod_xml_cdr gives you <i>all </i>the channel variables that you set, so it changes all the time.<div><br><div>If you want to save everything, you can't stuff that into columns in mysql/postgres...</div><div><br></div><div>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.</div><div><br></div></div><div class="gmail_extra"><div><div class="gmail_signature"><div dir="ltr">-Avi<br></div></div></div>
<br><div class="gmail_quote">On Thu, Jan 1, 2015 at 12:19 PM, Tayyab Atiq <span dir="ltr"><<a href="mailto:tayyabatiq@gmail.com" target="_blank">tayyabatiq@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span style="font-size:13px">Hi.</span><div style="font-size:13px"><br></div><div style="font-size:13px">I have recently been trying to process CDR from mod_xml_cdr and store it in a db</div><div style="font-size:13px">I first parsed and wrote all the information in a file, then designed a database based on the fields that appeared in the file.</div><div style="font-size:13px">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.</div><div style="font-size:13px"><br></div><div style="font-size:13px">Is there a way to figure out all the possible fields that might appear in the xml sent by mod_xml_cdr?<br></div></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div></div>