Rails 3，activerecord-import gem，CSV

Question

在阅读了this question之后，我有了这个rake任务：

desc "Import sales" 
task :import_sales => :environment do
  sales = File.open(Rails.root.join("public", "system", "xmls", "3", "original", "first.csv"),"r").map do |line|
    isbn, date, quantity, value, channel = line.split("\,")
    Importsale.new(:isbn => isbn, :date => date, :quantity => quantity, :value => value, :channel => channel)
  end
  Importsale.import sales
end

一些csv数据如下所示：

9780953893201,30/5/10,4,25.6,UK Home
9780953893201,25/6/10,3,19.2,UK Home
9780953893201,30/7/10,6,95.94,UK Home
9780953893201,27/8/10,1,15.99,Export
9780953893201,27/8/10,13,207.87,UK Home
9780953893201,27/8/10,1,6.4,UK Home
9780953893201,24/9/10,14,223.86,UK Home
9780953893201,24/9/10,5,32,UK Home

但是rake任务并没有拆分CSV文件--我导入了一条记录，最后一个通道包含。

UK Home
9780953893201

map的使用是否将csv解析停止为行？如果我使用each或each_line，我会得到一个“无效参数”错误。

Answer 1

因为没有人来写答案...

File.readlines(...).map do |line|
    ...
end