On Sat, Sep 27, 2008 at 10:43 AM, preetha Ayyappan < preetha.ayyappan@gmail.com> wrote:

Thanks wasim.I have changed the line my $dbh = DBI->connect("DBI:mysql:database=freeswitchdb;host=localhost","freeswitch","1234") in /usr/src/freeswitch/scripts/contrib/wasim/cdrload.pl .then i called an extension.Now the call details are recorded only in master.csv.I am not getting the details updated in database.Anything i have to do further after changing the above line in cdrload.pl ?

You have to run the perl script ... once it works, then you can put it in cron -- wasim h. baig | principal consultant | convergence pk | +92 300 8508070 | as you scope creep, so shall we reap ...

Actually now I can able to save the call detail records in the database through php.But the csv file does not contains the disposition details.How can i get the disposition in csv file? Thanks. On 9/26/08, Anthony Minessale <anthony.minessale@gmail.com> wrote:

you have 2 options in the category of just doing it simple.

1) write a cron job to kill -HUP `cat /usr/local/freeswitch/logs/freeswitch.pid` then when the cdr file rotates parse and insert it into the db. 2) alter the template in cdr_csv.conf.xml so it directly creates sql statements instead of CSV data and do the same as option 1 but a lot easier.

For anything more advanced than that it would take a lot more understanding on your part and explanation on mine.

On Fri, Sep 26, 2008 at 7:27 AM, preetha Ayyappan < preetha.ayyappan@gmail.com> wrote:

...

hi, I am getting the call records saved in the folder cdr-csv.I need to save this cdr details in mysql database.Is it possible to do?If yes please assist me to do this.

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

-- Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/

AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400

_______________________________________________ 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

-- Preetha.A

I dont understand.could you please tell me in brief? On 9/27/08, Wasim Baig <wasim@convergence.pk> wrote:

Sat, Sep 27, 2008 at 2:26 PM, preetha Ayyappan < preetha.ayyappan@gmail.com> wrote:

Actually now I can able to save the call detail records in the database

...

through php.But the csv file does not contains the disposition details.How can i get the disposition in csv file?

the variable is known as HANGUP_CAUSE

-- wasim h. baig | principal consultant | convergence pk | +92 300 8508070 | as you scope creep, so shall we reap ...

_______________________________________________ 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

-- Preetha.A

Everyone thank Yossi for his hard work on the Cluecon Videos. http://files.freeswitch.org/cluecon_2008/ Please check them out. /b On Sep 29, 2008, at 10:31 AM, Yossi Neiman wrote:

I ended up editing the video footage from Cluecon 2008 instead of working on coding. I might be able to work up a direct logger (a revamping of the original mod_cdr) in the near future if all works out well for me time-wise.

-- Yossi Neiman Cartis Solutions, Inc. http://www.cartissolutions.com