jonrlists at comcast.net
Tue Jun 8 12:43:59 MST 2004
I used something like this...
LOAD DATA INFILE '/tmp/cdr.csv' INTO TABLE cdr FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n' (accountcode, src, dst, dcontext,
clid, channel, dstchannel, lastapp, lastdata, calldate, pickup, hangup,
duration, billsec, disposition, amaflags);
I had to add the pickup and hangup columns to get it to import. I'm sure
there was a way around this, but I'm not very good with SQL. I used the
same format as used for the calldate column. I then dropped the pickup and
hangup columns once the data was imported.
For information on how to setup the DB go here.
From: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com] On Behalf Of Christopher Wall
Sent: Tuesday, June 08, 2004 3:07 PM
To: asterisk-users at lists.digium.com
Subject: [Asterisk-Users] MySQL
I have been lookin for someplace to lean how to dump all of the call
transactions into a sql database. Can anyone provide me any assistance?
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
To UNSUBSCRIBE or update options visit:
More information about the asterisk-users