ActiveRecord::Base.establish_connection(
        :adapter => 'mysql',
        :database => 'asteriskcdrdb',
        :username => 'root',
        :password => '',
        :host => 'localhost'
)

class Cdr < ActiveRecord::Base
        set_table_name :cdr
end

from = DateTime.parse('2011-09-09 12:19:50')
to = DateTime.now
created = 0

CSV.foreach('Master.csv') do |r|
        date = DateTime.parse(r[9])

        next if date < from
        created +=1
        Cdr.create(
                :calldate => date,
                :duration => r[12].to_i,
                :billsec => r[13].to_i,
                :amaflags => r[15],
                :disposition => r[14],
                :src => r[1],
                :dst => r[2],
                :dcontext => r[3],
                :channel => r[5],
                :dstchannel => r[6],
                :lastapp => r[7],
                :lastdata => r[8],
                :accountcode => r[0],
                :userfield => '',
                :clid => r[4],
                :uniqueid => 'xxx'
        )
#exit
end

puts "Imported #{created} calls from #{from} to #{to}"