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