Ruby on Rails CSV upload&import - File name too long

Question

I want to let admins import contacts via csv files into the database. Therefore I am using the ruby csv library and the following code snippet:

 if request.post? && params[:file].present?
     inputFile = params[:file].read
     CSV.foreach(inputFile) do |row|
         #save row here
     end
 end

However in CSV.foreach(inputFile) do |row| I get an "Errno::ENAMETOOLONG - File name too long"-error and the error message shows me that it uses the whole csv file as file name.

Does anyone know why it does that?

BTW: The csv file is using ',' and '/n' as delimiters.

irruputuncu · Accepted Answer · 2013-09-05 08:35:20Z

11

Thanks to the input of the other answers I found the solution myself. The problem is that .read turns the file into a string with the contents, but CSV.foreach() expects a filename or path . Using .path instead solves the problem:

 if request.post? && params[:file].present?
     inputPath = params[:file].path
     CSV.foreach(inputPath) do |row|
         #save row here
     end
 end

answered Sep 5, 2013 at 8:35

irruputuncu

1,4901 gold badge11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

challeng · Accepted Answer · 2013-09-04 17:56:26Z

1

It could have to do with the .read call on line 2. Somehow inputFile is turning into the contents of the csv and not the name of the file itself. That would lead me to believe there is a problem with you setting the inputFile variable. My guess is that .read is not working in the way you intended it to.

answered Sep 4, 2013 at 17:56

challeng

1751 silver badge8 bronze badges

Comments

lhdv · Accepted Answer · 2013-09-04 18:02:25Z

0

Try to just remove the .read when you are getting the value from params. Then the variable inputFile may have the path of file to pass to CSV.foreach

answered Sep 4, 2013 at 18:02

lhdv

1561 silver badge6 bronze badges

1 Comment

irruputuncu Over a year ago

Just removing the .read results in this error: "no implicit conversion of ActionDispatch::Http::UploadedFile into String". But if I add .path everything finally works :)

Collectives™ on Stack Overflow

Ruby on Rails CSV upload&import - File name too long

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related