Ruby parse CSV file to print out the rows

Question

I have a file upload in my Rails application and I want to parse the CSV file assuming the upload went okay. You can see the comment below that indicates where I would like to read the rows of the CSV file. How can I do this? I used carrierwave for the file upload.

I mounted it as such

mount_uploader :file, LCFileUploader

Here is the code I currently have

require 'CSV'
class LCFilesController < ApplicationController
    def new
        authorize! :create, :lc_file
        @lc_file = LCFile.new
    end

    def create
        authorize! :create, :lc_file
        puts params
        @lc_file = LCFile.new(params[:lc_file])
        @lc_file.user_id = current_user.id
        if @lc_file.save

            #PARSE CSV HERE TO PRINT OUT THE ROWS OF THE CSV FILE
            CSV.foreach(@lc_file.file.path) do |row|
                puts row
            end

            redirect_to lc_path, :notice => 'New lc created!'
        else
            render :new
        end
    end
end

and I get this error:

undefined method `find_all_by_team_id' for #<Class:0x007fe14c40d848>

(question should be closed. error I had was unrelated to what was posted or asked in this question) — CodeGuy
– CodeGuy, Commented Apr 1, 2013 at 20:56

deviousdodo · Accepted Answer · 2013-04-01 20:30:37Z

1

You can use the CSV class:

puts CSV.read(@lc_file.file.path)

or one row at a time:

CSV.foreach(@lc_file.file.path) do |row|
  puts row
end

Besides CSV generation there are a few more issues:

the redirect will not work after you send send some output. But even if it did, the output would not be seen, since you're redirecting.
the path you are redirecting to is incorrect (I believe that's why you get that error). I suppose you want something like lcfiles_path or lcfile_path(@lc_file). Run rake routes (the same way you ran rails console) to see a list of all available routes.

Now if you still have issues, I suggest posting another question, as this one was mainly about CSV generation and that should be solved using the code I posted at the start of this answer.

edited Apr 1, 2013 at 20:30

answered Apr 1, 2013 at 19:55

deviousdodo

9,1722 gold badges32 silver badges35 bronze badges

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

10 Comments

CodeGuy Over a year ago

That gave me a undefined method `find_all_by_team_id' for #<Class:0x007fe14c2c4658>

deviousdodo Over a year ago

Does your upload actually work? If yes, how do you access the file? Did you replace the file I used with the mounted uploader column?

CodeGuy Over a year ago

See update for how I mounted. Yes, the upload actually works. I'm not sure how to access the file. As of now, it saves when the upload is executed using the code above.

deviousdodo Over a year ago

Can you say what's the output of LCFile.last.file.path if you run it from the rails console? (I assume you have at least one file uploaded)

CodeGuy Over a year ago

sorry...but how do I do that? I'm on Mac using terminal to start my server

|

Collectives™ on Stack Overflow

Ruby parse CSV file to print out the rows

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related