- config/application.rb
require 'csv'
- view:index.html.erb
<h2>Import Products</h2>
<%= form_tag import_products_path, multipart: true do %>
<%= file_field_tag :file %>
<%= submit_tag "Import" %>
<% end %>
- config/routes.rb
Store::Application.routes.draw do
resources :products do
collection { post :import }
end
root to: 'products#index'
end
- controller:controllers/products_controller.rb
def import
Product.import(params[:file])
redirect_to root_url, notice: "Products imported."
end
- model: product.rb
def self.import(file)
CSV.foreach(file.path, headers: true) do |row|
Product.create! row.to_hash
end
end
如果想实现修改原来数据的功能,import方法可以写为:def self.import(file)
CSV.foreach(file.path, headers: true) do |row|
product = find_by_id(row["id"]) || new
product.attributes = row.to_hash.slice(*accessible_attributes)
product.save!
end
end
参考链接: http://railscasts.com/episodes/396-importing-csv-and-excel?view=asciicast
源代码:http://media.railscasts.com/assets/episodes/sources/396-importing-csv-and-excel.zip