CSV Download

[Simon Harris]

Hi All,

I have created a script which connects to a SQL DB, runs a query, writes the
results out to a file (Using FSO) then presents the user with a link to
download the CSV.
As the file contains sensitive data, I dont want to leave the file on the
server, and I dont want to rely on the user to delete the file after every
export.

Does anyone have any suggestions?

Thanks,
Simon.

 

[Manohar Kamath]

Why not stream the contents of the file, instead of creating a file and
letting the user download it? So, instead of writing using FSO, you write it
out to the response object. Just make sure you change the content type to
reflect the CSV download:

<%
Response.ContentType = "text/csv"
%>

 

[Ray Costanzo [MVP]]

Yes, do not ever create the file! :]

<%
set oADO = CreateObject("ADODB.Connection")
oADO.Open YourConnectionSTring

Set oRS = oADO.Execute("Your query")
sCSV = oRS.GetString(2,,",",vbCrLf,"")
oRS.Close : Set oRS = Nothing
oADO.Close : Set oADO = Nothing

Response.ContentType = "Simon's CSV File"
Response.AddHeader "Content-Disposition","attachment;
filename=sensitiveData.csv"
Response.Write sCSV
%>

Ray at work

 

[Simon Harris]

Thanks Manohar, sounds like a good idea - I guess I would create the CSV in
memory by building a string, then pump it all to the browser?