I'm trying to import CSV data to my mysql DB but I'm running into an error when I try to upload the file :
no implicit conversion of ActionDispatch::Http::UploadedFile into String
This is what a line in the CSV file looks like :
751,"01/17/2015","11:17:32","60","TDFSRDSK","2","10","-1","0","3","","26","3","","","1","0"
here is the code for the import, in product.rb
def self.import(file)
CSV.foreach(file) do |row|
id, jour, heure, valeur, app, a, b, c, d, e, f, g, h, i, j, k, l = row
userid = current_user.id
product = Product.create(date: jour, valeur: valeur,user_id: userid)
end
end
in product_controller.rb
def import
Product.import(params[:file])
redirect_to_root_url, notice "Products imported"
end
in the index :
<%= form_tag import_products_path, multipart: true do %>
<%= file_field_tag :file %>
<%= submit_tag "Import" %>
<% end %>
and in routes.rb I have:
resources :products do
collection {post :import}
end
Try give params[:file].path
in argument. Like this,
Product.import(params[:file].path)
Checkout this.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With