i have uploaded two files for you one is the php script that reads Master.csv and loads data in the database you have to change
$locale_db_name = 'databasename'; $locale_db_login = 'user'; $locale_db_pass = 'password'; this how you run the script php /path/cdrmysql.php /var/log/asterisk/cdr-csv/Master.csv path is the location where your cdrmysql.php is located second is the database already truncated for you hope this helps Regards. Kyeyune Bob VOIP Engineer +256 774 702 258 On Wed, Sep 25, 2013 at 5:02 PM, Doug Lytle <[email protected]> wrote: > >> but i do not know how to interface the CDRs. has anyone used this tool > or any other similar tool? > > It expects your CDR to be located in a mysql database. You'll either need > to figure out how to import your .csv into mysql, or have Asterisk send the > CDR directly to the mysql database. > > Doug > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
database.sql
Description: Binary data
<<attachment: cdrmysql.php>>
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
