Rails - CSV (export to csv)

Question

i am exporting data to csv,

while exporting i want to split by every 50 records, instead of exporting all together.

(i.e, if i click "Export to CSV" it should export first 50 records, later again on clicking "Export to csv" it should export next 50 records and so on)

please, provide me some code to solve this problem.

thanks

answer is here stackoverflow.com/questions/1360682/rails-csvexport-to-csv-loop/… — ADAM
– ADAM, Commented Sep 1, 2009 at 8:09
how many times can you ask this damned question, bloody hell — nitecoder
– nitecoder, Commented Sep 3, 2009 at 23:46

splattael · Accepted Answer · 2009-09-07 12:12:56Z

2

If pagination is not required you could try AR#find_in_batches.

Record.find_in_batches(:batch_size => 50) do |records|
  export_to_csv(records) # max 50 records
end

answered Sep 7, 2009 at 12:12

splattael

8467 silver badges4 bronze badges

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

Comments

lutz · Accepted Answer · 2009-08-31 09:47:24Z

1

records = ModelClass.find(:limit => 50, ...)
# convert records to CSV

# later:
records = ModelClass.find(:limit => 50, :offset => 50, ...)

answered Aug 31, 2009 at 9:47

lutz

Comments

Nimantha · Accepted Answer · 2020-02-19 15:03:35Z

1

Looks like you want pagination (you do a 50 record per page).

There's a plugin for that: will_paginate

Then you do: Model.paginate :page => params[:page], :per_page => 50

Then just add 1 to your page every time.

edited Feb 19, 2020 at 15:03

Nimantha

6,5156 gold badges32 silver badges78 bronze badges

answered Aug 31, 2009 at 14:20

amitkaz

2,7222 gold badges21 silver badges18 bronze badges

Collectives™ on Stack Overflow

Rails - CSV (export to csv)

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related