Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Ruby on Rails 4 - CSV import - no implicit conversion into string

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
like image 650
dogg Avatar asked May 22 '15 11:05

dogg


1 Answers

Try give params[:file].path in argument. Like this,

Product.import(params[:file].path)

Checkout this.

like image 157
jon snow Avatar answered Oct 19 '22 06:10

jon snow