Re: [phpesp-general] Zero-length downloads

[Matthew G. <mat...@gm...>]

The export code is a mess.  An unfortunate legacy of the code base.  I do
however have a few large surveys with 1000+ responses that export without a
problem using phpESP 1.8.  I think it is a combination of question types in
the survey + a "large" number of responses and possibly some interaction
with php 5.x/mysql 5.x that is the issue.  Anyone willing to rewrite/fix th=
e
export code would be much appreciated.  Sounds like the XSLT routine you
have is a start.   Patches against current CVS would be graciously accepted=
.


On 3/1/06, Peter Flynn <pe...@si...> wrote:
>
> Thanks to Aaron Axelsen, who tested a survey on my server, I have
> ascertained that a minimal survey (three questions, one response)
> *will* download a CSV file when you try to extract the data.
>
> I am now thinking that the problem is simply size: the survey
> that won't download is 75 questions and 924 responses. Is this
> perhaps just too big for phpESP to handle?
>
> If so, what's the way to split the download into chunks?
>
> I looked a bit harder at the code for survey_export_csv.inc
> and it appears to try and do the job by creating an array.
> Surely it's not trying to dynamically stuff an array with the
> entire results of a survey?
>
> I really hate bugging an author about this kind of thing, but
> I'm BCCing this to the author's name in the script in case he
> can shed any light on the problem.
>
> In the meantime, anyone else stuck with this problem can look
> at the routine I wrote to dump out all the data and rewrite it
> as CSV (two bash scripts and an XSLT routine):
>
> http://silmaril.ie/downloads/software/phpESP_csv-via-xml.tar.gz
>
> ///Peter
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>



--
D'oh!