Oct

10

Import CSV Using Rails Migration

Filed Under (Ruby) by manatarms on 10-10-2007

Tagged Under : , ,

Reposted from Rails Weenie:

Install FasterCSV (’gem install fasterCSV’)

The code to use inside the migration is similar to:

1
2
3
4

FasterCSV.foreach("#{RAILS_ROOT}/lib/symbols_database/security_list.csv", :row_sep => "r") do |row|
    field1,field2,field3 = row
    Foo.create(:field1 => field1, :field2 => field2, :field3 => field3)
end
(3) Comments
Read More