Re: [Catalyst] Generating a large XML document (KML file) from a database

2012-11-26 Thread Francisco Obispo
Use the -write() methos in catalyst and XML::Witer Sent from my iPhone On Nov 26, 2012, at 8:58 AM, Robert Rothenberg rob...@gmail.com wrote: I need to output a large XML file (actually, a KML file of points) from a database. I can't find any documentation for

Re: [Catalyst] Generating a large XML document (KML file) from a database

2012-11-26 Thread Lukas Thiemeier
I once had a similar problem, and solved it by using an ordinary TT View which rendered the XML, and stashing the required resultset. It worked fine for me, but my xml structure was very simple. It just contained lots of data. I don't know if this is an option for you. If your xml is very complex

Re: [Catalyst] Generating a large XML document (KML file) from a database

2012-11-26 Thread Francisco Obispo
XML::Writer Sent from my iPhone On Nov 26, 2012, at 9:23 AM, Francisco Obispo fobi...@isc.org wrote: Use the -write() methos in catalyst and XML::Witer Sent from my iPhone On Nov 26, 2012, at 8:58 AM, Robert Rothenberg rob...@gmail.com wrote: I need to output a large XML file

Re: [Catalyst] Generating a large XML document (KML file) from a database

2012-11-26 Thread Francisco Obispo
Ok, Now that I'm on my computer, I can write a decent response: I had a similar problem with generating a fairly large CSV file. you don't want to store this in a stash entry because it can get very large, and even it you were using a temp file to write the data to, the user would have to wait

Re: [Catalyst] Generating a large XML document (KML file) from a database

2012-11-26 Thread Robert Rothenberg
Thanks. I guessed that was something I needed to do. One note: when initializing a new XML::Writer object, you can pass $c-res as the OUTPUT, and XML::Writer will do the right thing, apparently, since it has a print method. Also, sending an empty string to body $c-res-body() is enough. On

Re: [Catalyst] Generating a large XML document (KML file) from a database

2012-11-26 Thread Francisco Obispo
Great! I'll see if I can do the same with the CSV module that I wrote. regards, Francisco Obispo Director of Applications and Services - ISC email: fobi...@isc.org Phone: +1 650 423 1374 || INOC-DBA *3557* NOC PGP KeyID = B38DB1BE On Nov 26, 2012, at 11:05 AM, Robert Rothenberg