[Catalyst] Data export question

[Frank Schwach]

I guess you already have the controller to get the data for presentation 
in a website, so what this really is is another view of the data. 
Consequently, I would write a View class that spits out an Excel file 
for the browser to download. In fact, there already is a View module on 
CPAN called Catalyst::View::Excel::Template::Plus but I haven't used it, 
so can't comment on it. Your Controller action could then simply take an 
argument that decides whether to return HTML or an Excel file, i.e. to 
set the correct View.

Frank


On 02/07/12 20:08, Kenneth S Mclane wrote:
> I already have some rough code for Spreadsheet::WriteExcel. I just 
> need to figure out how to pass it the data. I created a new controller 
> just to do the Excel piece, I think I should be able to pass the same 
> resultset to the export routine as I do to the stash for the template 
> code. Just not sure of the logistics, but I need to do this for 
> multiple pages.
>
> I'm thinking I can pass the same $rs I place in the stash to the 
> export function, have it stuff it into an excel file and return a uri 
> which I can redirect the browser to.
>
> Maybe.
>
> Len Jaffe <lenjaffe at jaffesystems.com> wrote on 07/02/2012 01:54:28 PM:
>
> > From:
> >
> > Len Jaffe <lenjaffe at jaffesystems.com>
> >
> > To:
> >
> > The elegant MVC web framework <catalyst at lists.scsys.co.uk>
> >
> > Date:
> >
> > 07/02/2012 01:56 PM
> >
> > Subject:
> >
> > Re: [Catalyst] Data export question
> >
> >
>
> > On Mon, Jul 2, 2012 at 1:45 PM, Kenneth S Mclane 
> <ksmclane at us.ibm.com> wrote:
> > It will just be a dump of the current query results, possibly a
> > whole table, so It will need to create new tabs when they reach 65K
> > since most of my users are still on office 2003. I guess I could use
> > Spreadsheet::WriteExcel, I just need to figure out the mechanics of
> > getting the data into the sheetand something to keep track of the
> > number of rows and create new tabs as needed.
>
> >
> > # psuedocode
> >
> > $ss = open_spreadsheet()
> > $i = 0;
> > $tab = undef;
> > foreach $row (@rows) {
> >   if ($i % 65000 == 0) {
> >     $tab = $ss.new_tab()
> >   }
> >   add_to_spreadsheet($row, $tab)
> >   $i += 1
> > }
> > close_spreadsheet()
> >
> >
> > L.
> > --
> > lenjaffe at jaffesystems.com   614-404-4214 www.volunteerable.net
> > Proprietor: http://www.theycomewithcheese.com/- An Homage to Fromage
> > Greenbar: Grubmaster: 2012-2009, Grub Asst: 2008, Trained: 2007.
> >
> > _______________________________________________
> > List: Catalyst at lists.scsys.co.uk
> > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> > Searchable archive: 
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> > Dev site: http://dev.catalyst.perl.org/
>
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.