Here is my php code and sql. I tried to cut out code that does other things.<br><br><a href="http://wiki.freeswitch.org/wiki/User:Stephen_c01">http://wiki.freeswitch.org/wiki/User:Stephen_c01</a><br><br clear="all">Thanks,<br>
Stephen C<br>-All of my email addresses go to the same place<br>-Save Paper, think before you print<br><br>
<br><br><div class="gmail_quote">On Thu, Sep 23, 2010 at 3:06 PM, Nyamul Hassan <span dir="ltr"><<a href="mailto:mnhassan@usa.net">mnhassan@usa.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
That's a neat idea! Would you like to share the SQL Schema of your database?<br>
<br>
Regards<br>
<font color="#888888">HASSAN<br>
</font><div><div></div><div class="h5"><br>
<br>
<br>
On 2010-09-24, stephen at stephenjc <<a href="mailto:stephen@stephenjc.com">stephen@stephenjc.com</a>> wrote:<br>
> i used mod_xml_cdr and keep the whole XML in a db and just pull out only<br>
> data i need into fields. Its easy to dump sql into a CSV if you need it<br>
> later.<br>
><br>
> Thanks,<br>
> Stephen C<br>
> -All of my email addresses go to the same place<br>
> -Save Paper, think before you print<br>
><br>
><br>
><br>
> On Thu, Sep 23, 2010 at 1:54 PM, Nyamul Hassan <<a href="mailto:mnhassan@usa.net">mnhassan@usa.net</a>> wrote:<br>
><br>
>> And mod_xml_cdr is by far the most flexible CDR module on any<br>
>> switching platform I have seen to date. It has complete record of what<br>
>> went in the call, including details of applications that ran, the<br>
>> arguments that were passed, and the SDP headers.<br>
>><br>
>> FreeSWITCH rocks!<br>
>><br>
>> Regards<br>
>> HASSAN<br>
>><br>
>><br>
>> On 2010-09-23, Sergey Okhapkin <<a href="mailto:sos@sokhapkin.dyndns.org">sos@sokhapkin.dyndns.org</a>> wrote:<br>
>> > You can have both mod_xml_cdr and mod_cdr_csv loaded.<br>
>> ><br>
>> > On Thursday 23 September 2010, <a href="mailto:covici@ccs.covici.com">covici@ccs.covici.com</a> wrote:<br>
>> >> Because I do not have a cgi script and have not looked at mod_xml_cdr<br>
>> >> yet, and I found this nice simple perl program. Also, I do want to<br>
>> >> keep<br>
>> >> the plain text csv file, it comes in handy.<br>
>> >><br>
>> >> Darren Wiebe <<a href="mailto:darren@aleph-com.net">darren@aleph-com.net</a>> wrote:<br>
>> >> > Why not do it using mod_xml_cdr and posting to a cgi script.<br>
>> &nbsp;That<br>
>> >> > sure makes it flexible.<br>
>> >> ><br>
>> >> > -- Darren Wiebe<br>
>> >> > Sent from my Palm Pre<br>
>> >> > On 23 Sep 2010 5:36 a.m., <a href="mailto:covici@ccs.covici.com">covici@ccs.covici.com</a><br>
</div></div><div class="im">>> >> > &<a href="mailto:lt%3Bcovici@ccs.covici.com">lt;covici@ccs.covici.com</a> <<a href="mailto:lt%253Bcovici@ccs.covici.com">lt%3Bcovici@ccs.covici.com</a>>&gt; wrote:<br>
>> >> ><br>
>> >> > I would like to insert the cdr information when the call hangsup,<br>
>> >> ><br>
>> >> > rather than some kron job or something -- is there a way I can use<br>
>> >> ><br>
>> >> > hangup_api_hook to execute the perl code, or is this too early for<br>
>> >> ><br>
>> >> > cdr_csv to have populated the variables?<br>
>> >> ><br>
>> >> ><br>
>> >> ><br>
>> >> > Thanks.<br>
>> >><br>
>> ><br>
>> ><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>
>> ><br>
>><br>
>> --<br>
>> Sent from my mobile device<br>
>><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>
>><br>
><br>
<br>
</div>--<br>
<div><div></div><div class="h5">Sent from my mobile device<br>
<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>
</div></div></blockquote></div><br>