From: Jeremy Hinegardner <jeremy@...>
Date: 2008-02-08T06:31:50+09:00
Subject: Re: Best way for sending file to user

On Fri, Feb 08, 2008 at 05:44:51AM +0900, Mark Mr wrote:
> 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 :)

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

-- 
========================================================================
 Jeremy Hinegardner                              jeremy@hinegardner.org