<html>
<head>
<meta name="generator" content="Windows Mail 17.5.9600.20689">
<style data-externalstyle="true"><!--
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
}
p.MsoNormal, li.MsoNormal, div.MsoNormal {
margin:0in;
margin-bottom:.0001pt;
}
p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst,
p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle,
p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast {
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
line-height:115%;
}
--></style></head>
<body dir="ltr">
<div data-externalstyle="false" dir="ltr" style="font-family: 'Calibri', 'Segoe UI', 'Meiryo', 'Microsoft YaHei UI', 'Microsoft JhengHei UI', 'Malgun Gothic', 'sans-serif';font-size:12pt;"><div>Thanks guys for the suggestions and information.</div><div>I did figure out that variables keep changing after I went through the source code. And it looks like fusionpbx takes a few values from CDR and drops everything else. I guess I can modify fusionpbx’ parser and use that. This should solve my problem.<br></div><div data-signatureblock="true"><div><br></div><div>Sent from Windows Mail</div><div><br></div></div><div style="padding-top: 5px; border-top-color: rgb(229, 229, 229); border-top-width: 1px; border-top-style: solid;"><div><font face=" 'Calibri', 'Segoe UI', 'Meiryo', 'Microsoft YaHei UI', 'Microsoft JhengHei UI', 'Malgun Gothic', 'sans-serif'" style='line-height: 15pt; letter-spacing: 0.02em; font-family: "Calibri", "Segoe UI", "Meiryo", "Microsoft YaHei UI", "Microsoft JhengHei UI", "Malgun Gothic", "sans-serif"; font-size: 12pt;'><b>From:</b> <a href="mailto:david.villasmil@gmail.com" target="_parent">David Villasmil Govea</a><br><b>Sent:</b> Friday, January 2, 2015 3:29 AM<br><b>To:</b> <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_parent">FreeSWITCH Users Help</a></font></div></div><div><br></div><div dir=""><p dir="ltr">I recommend it only you need something very basic. You won't learn anything about freeSWITCH. </p>
<div class="gmail_quote">On Jan 1, 2015 5:27 PM, "Luis Daniel Lucio Quiroz" <<a href="mailto:luis.daniel.lucio@gmail.com" target="_parent">luis.daniel.lucio@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;"><p dir="ltr">Don't waste time, give a look into fusionpbx; it has what you are looking for</p>
<div class="gmail_quote">On Jan 1, 2015 2:32 PM, "David Villasmil Govea" <<a href="mailto:david.villasmil@gmail.com" target="_parent">david.villasmil@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;"><p dir="ltr">There's a very nice php sample somewhere in the git, it parses the XML and you can use it to validate fields, do billing, whatever.</p>
<div class="gmail_quote">On Jan 1, 2015 2:16 PM, "Michael Collins" <<a href="mailto:msc@freeswitch.org" target="_parent">msc@freeswitch.org</a>> wrote:<br><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;"><div dir="ltr"><div>It's also a good idea to validate field data before trying to write to your database. That way you could add fields that don't appear on every single call. <br><br></div>-Michael<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 1, 2015 at 6:04 AM, Avi Marcus <span dir="ltr"><<a href="mailto:avi@avimarcus.net" target="_parent">avi@avimarcus.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;"><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><div dir="ltr">-Avi<br></div></div></div>
<br><div class="gmail_quote"><div><div>On Thu, Jan 1, 2015 at 12:19 PM, Tayyab Atiq <span dir="ltr"><<a href="mailto:tayyabatiq@gmail.com" target="_parent">tayyabatiq@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;"><div><div><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></div></div>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_parent">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_parent">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_parent">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_parent">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_parent">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br></blockquote></div><br></div></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_parent">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_parent">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_parent">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_parent">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_parent">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br></blockquote></div><br></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_parent">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_parent">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_parent">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_parent">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_parent">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br></blockquote></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_parent">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_parent">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_parent">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_parent">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_parent">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br></blockquote></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_parent">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_parent">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_parent">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_parent">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_parent">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_parent">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_parent">http://www.freeswitch.org</a><br></blockquote></div>
</div></div>
</body>
</html>