From: zwjunk <zw...@sb...> - 2006-02-16 00:39:36
|
I installed phpesp on a Windows system but couldn't get it working. Using var_dump(), I found that there are problems with various path constants mixing back-slashes (\) and forward slashes (/). I then installed on a Linux box. Got things "sort of working" despite the lack of any real documentation. I entered the URL, which got redirected to a maint logon form, at which point I could go no further. I tried the name and password used for the database grant, but that didn't work. There was nothing in the docs that said what to use for the initial logon. So 1) What am I supposed to use for the initial logon? 2) Is phpesp still being actively developed? 3) Is there any other open source survey software? Thanks much! zach -- zw...@sb... |
From: Aaron A. <li...@fr...> - 2006-02-17 14:34:58
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 1) username: root, password: esp (Can be seen from the mysql_populat.sql file) 2) I know some work is still going on, but like all open source projects, its usually the 2nd priority for the developers 3) I personally have not found any other decent open source survey packages. - -- Aaron Axelsen li...@fr... Great hosting, low prices. Modevia Web Services LLC -- http://www.modevia.com zwjunk wrote: > I installed phpesp on a Windows system but couldn't get it working. > Using var_dump(), I found that there are problems with various path > constants mixing back-slashes (\) and forward slashes (/). > > I then installed on a Linux box. Got things "sort of working" > despite the lack of any real documentation. I entered the URL, > which got redirected to a maint logon form, at which point I could > go no further. I tried the name and password used for the database > grant, but that didn't work. There was nothing in the docs that > said what to use for the initial logon. > > So > > 1) What am I supposed to use for the initial logon? 2) Is phpesp > still being actively developed? 3) Is there any other open source > survey software? > > Thanks much! > > zach -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFD9d8PuucONIvD0AMRAiZWAJ0a8ilrtGxMsd1Tgks1jOId5L7K6ACfVgs6 hVeASiwA/pOlNt4Z+ZzcGEU= =J8T7 -----END PGP SIGNATURE----- |
From: Peter F. <pe...@si...> - 2006-02-17 21:12:09
|
Aaron Axelsen wrote: > 3) I personally have not found any other decent open source survey > packages. I agree completely. But I hit a snag yesterday: a user called to say her survey was complete but when she tried to download the CSV data, all she got was a null file. I tried, and got the same result, both when downloading and when saving to /tmp on the server. A different user was able to get all of her data downloaded without a problem. Are there any known problems that might cause this? I opened up the database and it all looks fine, I was able to do a dump of the data and there's no sign of any obvious corruption. However, the user (a semi-knowledgeable IT novice) had created several copies of her survey in the process, eg foo_copy, foo_copy_copy and so on. Obviously this shouldn't affect anything, but does it? ///Peter |
From: Aaron A. <li...@fr...> - 2006-02-17 22:24:20
|
I recently experienced a problem of not being able to download exports. So far i have tracked it down to only happening in Internet Explorer. In other browsers like firefox it seems to work fine. When i get a chance i'm going to see if I can figure out why its not working in IE. Does your same problem happen in firefox and IE? -- Aaron Peter Flynn wrote: > Aaron Axelsen wrote: >> 3) I personally have not found any other decent open source survey >> packages. > > I agree completely. But I hit a snag yesterday: a user called to say her > survey was complete but when she tried to download the CSV data, all she > got was a null file. I tried, and got the same result, both when > downloading and when saving to /tmp on the server. A different user was > able to get all of her data downloaded without a problem. Are there any > known problems that might cause this? I opened up the database and it > all looks fine, I was able to do a dump of the data and there's no sign > of any obvious corruption. However, the user (a semi-knowledgeable IT > novice) had created several copies of her survey in the process, eg > foo_copy, foo_copy_copy and so on. Obviously this shouldn't affect > anything, but does it? > > ///Peter > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > -- Aaron Axelsen li...@fr... Great hosting, low prices. Modevia Web Services LLC -- http://www.modevia.com |
From: Peter F. <pe...@si...> - 2006-02-17 22:35:53
|
Aaron Axelsen wrote: > I recently experienced a problem of not being able to download exports. > So far i have tracked it down to only happening in Internet Explorer. > In other browsers like firefox it seems to work fine. When i get a > chance i'm going to see if I can figure out why its not working in IE. > Does your same problem happen in firefox and IE? Unfortunately not. The user has Windows and IE and I'm using Linux and Firefox. Identical problem in both. ///Peter |
From: Peter F. <pe...@si...> - 2006-02-21 20:36:51
|
Matthew Gregg wrote: > Could PHP limits(memory/execution time) be stopping the user from > exporting? I certainly hope not. It's a 40-question survey with 700 responses. If there are limits on that, then PHP was the wrong language to use for implementing a survey system! I exported the whole database and wrote a routine to piece together the data for this survey and output it in CSV as the user wanted. Useful exercise but not something I want to do every time a user does a survey. Can limits in PHP be overridden? ///Peter > On 2/17/06, *Peter Flynn* <pe...@si... <mailto:pe...@si...>> > wrote: > > Aaron Axelsen wrote: > > I recently experienced a problem of not being able to download > exports. > > So far i have tracked it down to only happening in Internet Explorer. > > In other browsers like firefox it seems to work fine. When i get a > > chance i'm going to see if I can figure out why its not working > in IE. > > Does your same problem happen in firefox and IE? > > Unfortunately not. The user has Windows and IE and I'm using Linux and > Firefox. Identical problem in both. > > ///Peter |
From: Peter F. <pe...@si...> - 2006-02-22 23:08:01
|
Matthew Gregg wrote: > Check the PHP documentation for memory and execution time settings. > The settings are located in you system php.ini file. Thanks..I'm not a PHP person, so the only thing I'd ever checked in there was to make sure register_globals was off. I bumped the max script time up to 120sec and the memory max to 12Mb but it still writes a zero-length file. I bumped the memory max to 64Mb but still no luck. The Export Data function ends in less than a minute (ie goes to the Go Back To Management Interface screen) so it doesn't seem to be running up against a limit. Is there anywhere it logs its internal actions, and can this be turned on? I'd like to try and find where it's dying. ///Peter > On 2/21/06, *Peter Flynn* < pe...@si... > <mailto:pe...@si...>> wrote: > > Matthew Gregg wrote: > > Could PHP limits(memory/execution time) be stopping the user from > > exporting? > > I certainly hope not. It's a 40-question survey with 700 responses. > If there are limits on that, then PHP was the wrong language to use > for implementing a survey system! > > I exported the whole database and wrote a routine to piece together the > data for this survey and output it in CSV as the user wanted. Useful > exercise but not something I want to do every time a user does a survey. > > Can limits in PHP be overridden? > > ///Peter > > > On 2/17/06, *Peter Flynn* < pe...@si... > <mailto:pe...@si...> <mailto:pe...@si... > <mailto:pe...@si...>>> > > wrote: > > > > Aaron Axelsen wrote: > > > I recently experienced a problem of not being able to > download > > exports. > > > So far i have tracked it down to only happening in > Internet Explorer. > > > In other browsers like firefox it seems to work > fine. When i get a > > > chance i'm going to see if I can figure out why its not > working > > in IE. > > > Does your same problem happen in firefox and IE? > > > > Unfortunately not. The user has Windows and IE and I'm using > Linux and > > Firefox. Identical problem in both. > > > > ///Peter > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through > log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642> > _______________________________________________ > phpESP-general mailing list > php...@li... > <mailto:php...@li...> > https://lists.sourceforge.net/lists/listinfo/phpesp-general > > > > > -- > D'oh! |
From: Peter F. <pe...@si...> - 2006-02-23 01:21:42
|
Matthew Gregg wrote: > With the execution time and memory limits increased, does the export > work with Firefox? No, it always generates a zero-length file no matter what. I don't think it has anything to do with browsers, as it generates a zero-length file both as a download and when done to the server disk. ///Peter > On 2/22/06, *Peter Flynn* <pe...@si... <mailto:pe...@si...>> > wrote: > > Matthew Gregg wrote: > > Check the PHP documentation for memory and execution time settings. > > The settings are located in you system php.ini file. > > Thanks..I'm not a PHP person, so the only thing I'd ever checked in > there was to make sure register_globals was off. I bumped the max > script time up to 120sec and the memory max to 12Mb but it still > writes a zero-length file. I bumped the memory max to 64Mb but still > no luck. The Export Data function ends in less than a minute (ie goes > to the Go Back To Management Interface screen) so it doesn't seem to > be running up against a limit. > > Is there anywhere it logs its internal actions, and can this be > turned on? I'd like to try and find where it's dying. > > ///Peter > > > On 2/21/06, *Peter Flynn* < pe...@si... > <mailto:pe...@si...> > > <mailto:pe...@si... <mailto:pe...@si...>>> wrote: > > > > Matthew Gregg wrote: > > > Could PHP limits(memory/execution time) be stopping the > user from > > > exporting? > > > > I certainly hope not. It's a 40-question survey with 700 > responses. > > If there are limits on that, then PHP was the wrong language > to use > > for implementing a survey system! > > > > I exported the whole database and wrote a routine to piece > together the > > data for this survey and output it in CSV as the user wanted. > Useful > > exercise but not something I want to do every time a user > does a survey. > > > > Can limits in PHP be overridden? > > > > ///Peter > > > > > On 2/17/06, *Peter Flynn* < pe...@si... > <mailto:pe...@si...> > > <mailto: pe...@si... <mailto:pe...@si...>> > <mailto:pe...@si... <mailto:pe...@si...> > > <mailto:pe...@si... <mailto:pe...@si...>>>> > > > wrote: > > > > > > Aaron Axelsen wrote: > > > > I recently experienced a problem of not being able to > > download > > > exports. > > > > So far i have tracked it down to only happening in > > Internet Explorer. > > > > In other browsers like firefox it seems to work > > fine. When i get a > > > > chance i'm going to see if I can figure out why its > not > > working > > > in IE. > > > > Does your same problem happen in firefox and IE? > > > > > > Unfortunately not. The user has Windows and IE and I'm > using > > Linux and > > > Firefox. Identical problem in both. > > > > > > ///Peter > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: Splunk Inc. Do you grep > through > > log files > > for problems? Stop! Download the new AJAX search engine > that makes > > searching your log files as easy as surfing > the web. DOWNLOAD SPLUNK! > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642> > > < > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642>> > > _______________________________________________ > > phpESP-general mailing list > > php...@li... > <mailto:php...@li...> > > <mailto:php...@li... > <mailto:php...@li...>> > > https://lists.sourceforge.net/lists/listinfo/phpesp-general > > > > > > > > > > -- > > D'oh! > > > > ------------------------------------------------------- > 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=lnk&kid=110944&bid=241720&dat=121642 > <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642> > _______________________________________________ > phpESP-general mailing list > php...@li... > <mailto:php...@li...> > https://lists.sourceforge.net/lists/listinfo/phpesp-general > > > > > -- > D'oh! |
From: Peter F. <pe...@si...> - 2006-03-01 23:07:39
|
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 |
From: Aaron A. <li...@fr...> - 2006-03-02 15:43:22
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Peter, In my phpesp install (1.8), I have a survey that has 588 responses, and the survey itself has only 17 questions though. I wonder if anyone else have ever had a survey of your size that they have tried to export? It very well sounds like it could be timing out php just because of the amount of time it could take the script to run. Have you tried the "Save to server" option? What does that result produce? - -- Aaron Axelsen li...@fr... Great hosting, low prices. Modevia Web Services LLC -- http://www.modevia.com Peter Flynn 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=lnk&kid=110944&bid=241720&dat=121642 > > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEBxKTuucONIvD0AMRAkAJAKCrlNeZHY01ijK7qySKeOTyu/nQFwCgsys+ XVrTbEPnDL+y/OUiRuGRQzM= =COIv -----END PGP SIGNATURE----- |
From: Peter F. <pe...@si...> - 2006-03-02 21:48:37
|
Aaron Axelsen wrote: > In my phpesp install (1.8), I have a survey that has 588 responses, > and the survey itself has only 17 questions though. I wonder if > anyone else have ever had a survey of your size that they have tried > to export? It very well sounds like it could be timing out php just > because of the amount of time it could take the script to run. Could be...but what would be making PHP time out? Surely it will simply carry on processing until it's finished: it shouldn't be entering any wait states. > Have you tried the "Save to server" option? What does that result > produce? Exactly the same: a null file in /tmp ///Peter |
From: Matthew G. <mat...@gm...> - 2006-03-03 20:00:13
|
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! |
From: Peter F. <pe...@si...> - 2006-03-05 19:05:22
|
Matthew Gregg wrote: > The export code is a mess. An unfortunate legacy of the code base. Aaaaah. *Now* we're getting somewhere near :-) > 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 The one in question had one open text, two binary questions and all the rest were radiobutton choices. Not very complex. Maybe it just doen't cope well with a lot of radiobutton questions. > possibly some interaction with php 5.x/mysql 5.x that is the issue. > Anyone willing to rewrite/fix the export code would be much > appreciated. I did post recently asking if anyone could suggest where I could set breakpoints in the code, and what statement to put in there to log the program's presence at each breakpoint (to a file in /tmp, for example). I don't know PHP but I'd be capable of adding the relevant code if someone can suggest it. > Sounds like the XSLT routine you have is a start. It's a bit slow, but it does at least allow me to see what it's doing. > Patches against current CVS would be graciously accepted. Maybe I can find a PHP hacker here who'd be interested. ///Peter |
From: Aaron A. <li...@fr...> - 2006-03-07 17:45:33
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 >> Patches against current CVS would be graciously accepted. > > Maybe I can find a PHP hacker here who'd be interested. I think the main problem is finding someone who has time :). - -- Aaron -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEDca6uucONIvD0AMRAv0+AJ90PpWHi4Ld6qoHibXcJV6WfQtJjACeNc67 i9VSNo73rRBYQ+NYR3uX8G8= =uyq3 -----END PGP SIGNATURE----- |