Rails export to CSV file

Question

It is partly working. It generates the file but the output is not how I want it.

Controller

@messages = Message.take(2)
  respond_to do |format|
    format.html
    format.csv { send_data @messages.to_csv }
  end

Message.rb

def self.to_csv
    CSV.generate do |csv|
          csv << Message.attribute_names
          Message.all.each do |message|
            csv << message.attributes.values
          end
    end
 end

I get the CSV file downloaded, it contains the records itself but it does not show the columns and values

#<Message:0x007fca7a028338>,#<Message:0x007fca79a6bf58>

I would expect the Message attributes like:

ID,text
1,hello
2,world

sbulat · Accepted Answer · 2017-05-24 10:16:19Z

2

Message.take(2) returns Array. You need ActiveRecord::Relation.

Try Message.limit(2)

edited May 24, 2017 at 10:16

answered Oct 29, 2016 at 20:53

sbulat

1118 bronze badges

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

Collectives™ on Stack Overflow

Rails export to CSV file

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related