Thanks everyone for the suggestions. Interesting that nothing already exists that is open source. Bell wants several thousand dollars to license it. You'd think there would be demand.
From: Mike Ashton [mailto:[EMAIL PROTECTED] Sent: August-09-07 5:01 PM To: [email protected] Subject: Re: [on-asterisk] Free/Open CDR Software for BCM? Chuck, I've never added records to my cdr table but this shld be very easy to do. Few things you need to do: Check how/if the BCM data would map to the Astersk CDR data. I have no idea what the BCM data looks like. Here is the format of the CDR table mysql> show columns from cdr; +-------------+--------------+------+-----+---------------------+------- + | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------------------+------- + | calldate | datetime | | | 0000-00-00 00:00:00 | | | clid | varchar(80) | | | | | | src | varchar(80) | | | | | | dst | varchar(80) | | | | | | dcontext | varchar(80) | | | | | | channel | varchar(80) | | | | | | dstchannel | varchar(80) | | | | | | lastapp | varchar(80) | | | | | | lastdata | varchar(80) | | | | | | duration | int(11) | | | 0 | | | billsec | int(11) | | | 0 | | | disposition | varchar(45) | | | | | | amaflags | int(11) | | | 0 | | | accountcode | varchar(20) | | | | | | uniqueid | varchar(32) | | | | | | userfield | varchar(255) | | | | | +-------------+--------------+------+-----+---------------------+------- + 16 rows in set (0.00 sec) To find out your mysql connection parameters to CDR access look in /etc/asterisk/cdr_mysql.conf What I usually use to load flat file data into a database is a perl CGI, that allows you to upload the file. Then load the data into a temporary db table, and either import it into the main table or do some further manipulation before importing into the main table if required. These Perl modules will make this pretty easy: CGI - HTTPD Interface Text::Delimited - or parsing delimited text files DBI - Database interface DBD::mysql - mysql database driver Hope this helps a bit, Mike -- Mike Ashton Quality Track Intl Ph: 647-722-2092 x 301 Cell: 416-527-4995 Fax: 416-352-6043 QTI CONFIDENTIAL AND PROPRIETARY INFORMATION The contents of this material are confidential and proprietary to Quality Track International, Inc. and may not be reproduced, disclosed, distributed or used without the express permission of an authorized representative of QTI. Use for any purpose or in any manner other than that expressly authorized is prohibited. If you have received this communication in error, please immediately delete it and all copies, and promptly notify the sender.
