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 http://stackoverflow.com/questions/1360682/rails-csvexport-to-csv-loop/1361155#1361155 — ADAM, Sep 01 '09 at 08:09
how many times can you ask this damned question, bloody hell — nitecoder, Sep 03 '09 at 23:46

score 2 · Accepted Answer · answered Sep 07 '09 at 12:12

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 07 '09 at 12:12

splattael

806
7
4

score 1 · Answer 2 · answered Aug 31 '09 at 09:47

1

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

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

answered Aug 31 '09 at 09:47

score 1 · Answer 3 · edited Feb 19 '20 at 15:03

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 '20 at 15:03

Nimantha

6,405
6
28
69

answered Aug 31 '09 at 14:20

amitkaz

2,732
1
20
18

Rails - CSV (export to csv)

3 Answers3