lamrin Pn wrote:
> in Export to CSV, i have overall 2500 records, and while exporting it
> takes long time to export all records, so, i have decided to export in
> the form of 1st 50 students,and, 2nd 50 students,so on. I have tried
> the below code. but it could able to fetch only 1st 50 students.
>
> please, guide me how to solve the problem
>
>
> @student_count = Student.find(:all)
> @count1 = @student_count.count
> st_per_file = 50
> count = 0
> unless @count1==count
> students = Student.find(:all, :order => 'name', :limit =>
> st_per_file, :offset => (st_per_file*count))
> count = count + 1
> end
filename = 'students.csv'
headers.merge!(
'Content-Type' => 'text/csv',
'Content-Disposition' => "attachment; filename=\"#{filename}\"",
'Content-Transfer-Encoding' => 'binary'
)
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
