RE: [cgiapp] creating a .csv file...

["Jeff MacDonald" <suppressed>]

hi,

why not just make a run mode that generates the excel sheet 
using Spreadsheet:Writeexcel [i think]

then just send the excel mime header and spit the excel out
on STDOUT.

this what i do.

jeff.

> -----Original Message-----
> From: Franki [mailto:suppressed
> Sent: Tuesday, February 11, 2003 2:22 PM
> To: suppressed
> Subject: [cgiapp] creating a .csv file...
> 
> 
> Hi guys,
> 
> I have a rather nice app running now with CGI::App, HTML::temp and
> CGI::Sess...
> 
> It displays fairly large chunks of data from a mysql db. (sometimes up to
> 1500 lines of data.)
> 
> 
> Anyway, I now have a small problem and I was wondering if you guys had a
> suggestion...
> 
> 
> I need to put a link on the DB displays where they can download 
> the data in
> csv format (comma seperated values so the winblows newbies get an 
> excel icon
> appear when the download it.)
> 
> Anyway, I don't want to create the file unless they are gonna use it..
> because it will take resources to create a file that might not be 
> used, and
> its slowish already.. (need to upgrade the server soon.)
> 
> I thought about creating a runmode for the csv that receives the relevant
> query data from the runmode that refered to it... and does the 
> query again,
> this time printing to file while in the fetchrow loop... then print a
> download header and start the download...
> 
> I am thinking there might be an easier way to do this, but not 
> sure what it
> is...
> 
> Does anyone have any suggestions here???
> 
> 
> There are currently ten screens that will require a download link, so I'd
> like to write reusable code so all of them just use the same sub or
> runmode...
> 
> What have you guys done in cases like this???
> 
> 
> rgds
> 
> Frank
> 
> 
> ---------------------------------------------------------------------
> Web Archive:  http://www.mail-archive.com/suppressed/
> To unsubscribe, e-mail: suppressed
> For additional commands, e-mail: suppressed
> 
> 

---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/suppressed/
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed