CODEWITHSUNDEEP
mysqlruby-on-railsrubycsv
dogg
dogg

Reputation: 127

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

Upvotes: 9

Views: 7160

Answers (2)

jon snow
jon snow

Reputation: 3072

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

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

Checkout this.

Upvotes: 20

Arup Rakshit
Arup Rakshit

Reputation: 118289

You need to do as :

CSV.foreach(file.path)

Your file is holding an instance of ActionDispatch::Http::UploadedFile class. To know the path, use #path method.

Upvotes: 3

Related Questions