Best way for sending file to user

HI, I’m currently using the FasterCSV library to pull a bunch of data
from my database and send a .csv file to the user. Currently i start off
with

FasterCSV.open(“app/models/” + @assessment.assessment + “.csv”, “w”) do
|csv|

write all the info to it, then i use

send_file (‘app/models/’ + @assessment.assessment + ‘.csv’)

to send it. It saves the csv file on the server and then sends that file
to the user. Is there any way to send the csv file without saving it to
the server? Or is there a command i can use to delete the file after it
sends? I couldnt quite find any answers to what I’m trying to do yet.
Thanks alot if anyone has input :slight_smile:

On Feb 7, 2008, at 2:44 PM, Mark Mr wrote:

send_file (‘app/models/’ + @assessment.assessment + ‘.csv’)

to send it. It saves the csv file on the server and then sends that
file
to the user. Is there any way to send the csv file without saving it
to
the server?

Yes, if you can easily hold the data in memory. You could use
FasterCSV.generate() to get the data in a String. The use send_data()
instead of send_file() to dump it to the client.

Or is there a command i can use to delete the file after it
sends?

Sure, use the standard Tempfile library to allocate a file, write to
it, and then feed it to send_file().

James Edward G. II

On Fri, Feb 08, 2008 at 05:44:51AM +0900, Mark Mr wrote:

to send it. It saves the csv file on the server and then sends that file
to the user. Is there any way to send the csv file without saving it to
the server? Or is there a command i can use to delete the file after it
sends? I couldnt quite find any answers to what I’m trying to do yet.
Thanks alot if anyone has input :slight_smile:

Use FasterCSV.new instead.

csv_buffer = StringIO.new
FasterCSV.new(csv_buffer) do |fcsv|
    fcsv << row
end

send_buffer_to_user(csv_buffer.string)

enjoy,

-jeremy

James G. wrote:

Yes, if you can easily hold the data in memory. You could use
FasterCSV.generate() to get the data in a String. The use send_data()
instead of send_file() to dump it to the client.

Thanks, I used the generate option to get it to work, never used
send_data before so thanks for letting me know about that one :slight_smile:

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs