Ruby on rails, reading and showing csv-file doesn't work?

Question

I am implementing in Ruby on Rails and I just want something easy to do, i just want to read a csv file and then show the output in a view. I have some code which seems good to me, but i always get the errror : can't convert Tempfile into String This is my controller:

def match
file = params[:file]

@original_filename = file.original_filename
tmpfile = Tempfile.new("redmine_project_importer")
if tmpfile
    tmpfile.write(file.read)
    tmpfile.close
    tmpfilename = File.basename(tmpfile.path)
      if !$tmpfiles
        $tmpfiles = Hash.new
      end
      $tmpfiles[tmpfilename] = tmpfile
    else
      flash[:error] = "Cannot save import file."
      return
    end
 session[:importer_tmpfile] = tmpfilename
sample_count = 5
i = 0
@samples = []
FasterCSV.open(file, "r") do |row|       
        @samples[i] = row
        i += 1
        if i > sample_count
            break
        end
    end

and my view is just:

<% form_tag({:action => 'result'}, {:multipart => true}) do %>
<table>  

<% @samples.each do |sample| %>
  <tr>
     <td>sample</td>    
  </tr>
<% end %>
</table>

Someone who can help me out? Greetz

Leonid Shevtsov · Accepted Answer · 2011-10-26 19:12:10Z

1

1) FasterCSV.open() requires a String filename, and you're passing a File object to it.

2) It's FasterCSV.foreach(filename) if you want to iterate lines. Or FasterCSV.open().each

But in your case, if you have an uploaded File parameter, you're better off with

FasterCSV.new(params[:file]).each do |line|

et cetera

answered Oct 26, 2011 at 19:12

Leonid Shevtsov

14.3k9 gold badges56 silver badges86 bronze badges

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

1 Comment

Ruben Over a year ago

I've done this, I do not have an error anymore. But i still don't have any output. Just like @samples is empty, how come this?

Wahaj Ali · Accepted Answer · 2011-10-26 18:55:13Z

0

I haven't worked with FasterCSV, but I think you should give Spreadsheet a look - http://spreadsheet.ch/

You should be able to read a csv file as simply as this:

book = Spreadsheet.open path_to_file
sheet  = book.worksheet 0

You could then iterate through the rows and perform whatever action you want:

sheet.each do |row|
  #code
end

answered Oct 26, 2011 at 18:55

Wahaj Ali

4,1133 gold badges26 silver badges36 bronze badges

Collectives™ on Stack Overflow

Ruby on rails, reading and showing csv-file doesn't work?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related