<br><br><div class="gmail_quote">On Tue, Sep 8, 2009 at 8:50 AM, Hristo Benev <span dir="ltr"><<a href="mailto:foxb@abv.bg">foxb@abv.bg</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br>
<br>
I saw an sql option in mod_cdr_csv.<br>
<br>
For my surprise it wrote sql code in Master.csv file instead of recording to mysql database (already setup as ODBC)<br>
<br>
Is that normal or I'm missing something?<br></blockquote><div><br>The purpose of the SQL template is to create SQL-ready commands that will load your CDRs into a table. It does not perform the operation itself, it merely creates the records in a file on the HDD. <br>
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
I read on the wiki that there is additional perl script to load csv to mysql.<br>
<br>
Should I do it in that way?<br>
<br></blockquote><div><br>That is one way to do it. By dropping the records into a disk file you have a layer of protection for those annoying occasions when your db goes down. <br><br>Other ways to handle CDRs would include the event socket (which Diego mentioned in his post) as well as mod_xml_cdr. They each have their advantages. Using SQL statements in CSV is pretty easy compared to the other options, however the other options will give you much more information about each call. If the CSV records contain all the data you need then I would use them since it's the easiest to implement.<br>
-MC<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Thanks,<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>
</blockquote></div><br>