Menu
▾
▴
phpesp-general
|
From: James O'M. <ja...@pa...> - 2002-04-20 01:18:07
|
I noticed that you made some changes in the survey_export_csv.inc code after we went back and forth on March 26th. I'm still having the same problems with exporting data though. And now on top of that I can't force the survey_export_csv.inc to use another delimiter other than the comma. I've tried importing checkbox data (multiple answers in one field) in gnumeric, openoffice, staroffice, and kspread and they all shift cells upon import. If I want to modify the delimiters, where would I find them now (am thinking either tab or ^ for delimiter)? The two join statements in survey_export_csv.inc don't seem to do the trick. (hehe, I don't comment my code either). Perhaps, I'm going about this all wrong... go back to the beginning. If I want to look at the data by respondant (as in tabular form), how would I do that? Is anybody else out there got a fancy schmancy query tool that will build web-tables of the data or whatnot? It's got so much cool relational table stuff I'm not sure the whole structure and relationship will fit in my head inside of a month or two... must stop babbling and upgrade my CPU *knocks head*. Thanks for any info you can provide. -- _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ James O'Malley Altamente.com +1(787)296-1540 _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ |
|
From: Matthew G. <gr...@mu...> - 2002-04-20 14:43:35
|
This works fine for me. Or it could be I don't understand the problem :-) I created a test survey, 2 questions. First one "text box", second one a "check box" with 3 questions. I randomly answered the survey several times with multiple answer in the "check boxes". Exported the results, opened the exported file in: Gnumeric(1.0.6) Kspread(2.2.2) OpenOffice(current build) they all imported perfectly. With 2 columns, first is the "text box", second is the "check box" data. On Fri, Apr 19, 2002 at 09:15:50PM -0400, James O'Malley wrote: > I noticed that you made some changes in the survey_export_csv.inc code after > we went back and forth on March 26th. I'm still having the same problems > with exporting data though. And now on top of that I can't force the > survey_export_csv.inc to use another delimiter other than the comma. I've > tried importing checkbox data (multiple answers in one field) in gnumeric, > openoffice, staroffice, and kspread and they all shift cells upon import. > > If I want to modify the delimiters, where would I find them now (am thinking > either tab or ^ for delimiter)? The two join statements in > survey_export_csv.inc don't seem to do the trick. (hehe, I don't comment my > code either). > > Perhaps, I'm going about this all wrong... go back to the beginning. If I > want to look at the data by respondant (as in tabular form), how would I do > that? Is anybody else out there got a fancy schmancy query tool that will > build web-tables of the data or whatnot? It's got so much cool relational > table stuff I'm not sure the whole structure and relationship will fit in my > head inside of a month or two... must stop babbling and upgrade my CPU > *knocks head*. > > Thanks for any info you can provide. > -- brought to you by, Matthew Gregg... one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: James O'M. <ja...@pa...> - 2002-04-22 14:30:19
|
> This works fine for me. Or it could be I don't understand the problem > :-) > > I created a test survey, 2 questions. First one "text box", second one > a "check box" with 3 questions. I randomly answered the survey several > times with multiple answer in the "check boxes". Exported the results, > opened the exported file in: > Gnumeric(1.0.6) > Kspread(2.2.2) > OpenOffice(current build) > they all imported perfectly. With 2 columns, first is the "text box", > second is the "check box" data. > No, the problem is when there are checkboxs (that is, possibly multiple answers for individual questions - arrays). James is putting them into the mix seperated by commas and an extra set of quotes (I think). For some reason I can't get it to import properly. I've been manually trying to fix the text, but I keep breaking it worse. The other issue is a text area issue where the respondant puts in a carriage return and screws up the formating (interpretes ^M as a new record and starts a new row, thereby throwing off the rest of that said record). On top of it all one of the question's data is being repeated. The form is faily complicated and I'm having a tough time finding out where the error is. Is it the code, the form, of the export? James, if you have the time and inclination (I'm sure you're super busy... but if it will possibly help others...), I can give you admin access to the CVS export and you can see what I'm talking about for yourself (maybe it'll be more obvious to you) I'm trying to help out this non-profit (Giving New England). I set them up for them and they've been busily setting up forms and doing surveys about charity and foundation budget constraints (amounts donated, solicited, trends etc.) and it's working out great for them... much better than they'd hoped. The only thing is now that they are having trouble with the export. I've been doing my best to help them, but I can't seem to find where things are going wrong, and I also don't quite understand the data structures (how the tables inter-relate etc). It'll take some time to figure it all out, but for now, I'm lost. That didn't sound like whining did it? God, I hope not ;) 'cause I love phpESP. T-shirt slogan maybe: "All your surveys are belong to us." -- _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ James O'Malley Altamente.com +1(787)296-1540 _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ |
|
From: James O'M. <ja...@pa...> - 2002-04-22 14:30:46
|
> This works fine for me. Or it could be I don't understand the problem > :-) > > I created a test survey, 2 questions. First one "text box", second one > a "check box" with 3 questions. I randomly answered the survey several > times with multiple answer in the "check boxes". Exported the results, > opened the exported file in: > Gnumeric(1.0.6) > Kspread(2.2.2) > OpenOffice(current build) > they all imported perfectly. With 2 columns, first is the "text box", > second is the "check box" data. > No, the problem is when there are checkboxs (that is, possibly multiple answers for individual questions - arrays). James is putting them into the mix seperated by commas and an extra set of quotes (I think). For some reason I can't get it to import properly. I've been manually trying to fix the text, but I keep breaking it worse. The other issue is a text area issue where the respondant puts in a carriage return and screws up the formating (interpretes ^M as a new record and starts a new row, thereby throwing off the rest of that said record). On top of it all one of the question's data is being repeated. The form is faily complicated and I'm having a tough time finding out where the error is. Is it the code, the form, of the export? James, if you have the time and inclination (I'm sure you're super busy... but if it will possibly help others...), I can give you admin access to the CVS export and you can see what I'm talking about for yourself (maybe it'll be more obvious to you) I'm trying to help out this non-profit (Giving New England). I set them up for them and they've been busily setting up forms and doing surveys about charity and foundation budget constraints (amounts donated, solicited, trends etc.) and it's working out great for them... much better than they'd hoped. The only thing is now that they are having trouble with the export. I've been doing my best to help them, but I can't seem to find where things are going wrong, and I also don't quite understand the data structures (how the tables inter-relate etc). It'll take some time to figure it all out, but for now, I'm lost. That didn't sound like whining did it? God, I hope not ;) 'cause I love phpESP. T-shirt slogan maybe: "All your surveys are belong to us." -- _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ James O'Malley Altamente.com +1(787)296-1540 _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ |
|
From: Matthew G. <gr...@mu...> - 2002-04-22 15:37:03
|
Well I'm stumped.... At least for small surveys/data sets I think James is handling and exporting check boxes and essays correctly. It could be that something is breaking on the large surveys/data that you have. What version of phpESP are you using? My example surveys data export looks like this: TEST,TEST_CHECK "blah","no,yes" "asdasd","maybeso,no" "adsffg4e","maybeso,no,yes" "hhhh","maybeso,yes" "hhhh","no" "hhhh","yes" "hhhh","maybeso" When imported into one of the before mentioned applications, the results looks like this(if my formating doesn't get destroyed by the listserv): TEST TEST_CHECK ----- --------- blah no,yes asdasd maybeso,no adsffg4e maybeso,no,yes hhhh maybeso,yes hhhh no etc.... This is the correct behavior. Also... I added a "essay" question to my test survey. I added several "carriage returns" to my responses then exported again. Gnumeric opened the file correctly. TEST TEST_CHECK TEST_ESSAY ----- --------- --------- dsfgdfg yes,maybeso this is a test of the emergency broadcast system On Sun, Apr 21, 2002 at 11:21:26PM -0400, James O'Malley wrote: > > This works fine for me. Or it could be I don't understand the problem > > :-) > > > > I created a test survey, 2 questions. First one "text box", second one > > a "check box" with 3 questions. I randomly answered the survey several > > times with multiple answer in the "check boxes". Exported the results, > > opened the exported file in: > > Gnumeric(1.0.6) > > Kspread(2.2.2) > > OpenOffice(current build) > > they all imported perfectly. With 2 columns, first is the "text box", > > second is the "check box" data. > > > > No, the problem is when there are checkboxs (that is, possibly multiple > answers for individual questions - arrays). James is putting them into the > mix seperated by commas and an extra set of quotes (I think). For some > reason I can't get it to import properly. I've been manually trying to fix > the text, but I keep breaking it worse. > > The other issue is a text area issue where the respondant puts in a carriage > return and screws up the formating (interpretes ^M as a new record and > starts a new row, thereby throwing off the rest of that said record). > > On top of it all one of the question's data is being repeated. The form is > faily complicated and I'm having a tough time finding out where the error > is. Is it the code, the form, of the export? James, if you have the time > and inclination (I'm sure you're super busy... but if it will possibly help > others...), I can give you admin access to the CVS export and you can see > what I'm talking about for yourself (maybe it'll be more obvious to you) > > I'm trying to help out this non-profit (Giving New England). I set them up > for them and they've been busily setting up forms and doing surveys about > charity and foundation budget constraints (amounts donated, solicited, > trends etc.) and it's working out great for them... much better than they'd > hoped. The only thing is now that they are having trouble with the export. > I've been doing my best to help them, but I can't seem to find where things > are going wrong, and I also don't quite understand the data structures (how > the tables inter-relate etc). It'll take some time to figure it all out, > but for now, I'm lost. > > That didn't sound like whining did it? God, I hope not ;) 'cause I love > phpESP. T-shirt slogan maybe: "All your surveys are belong to us." > -- brought to you by, Matthew Gregg... one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: James O'M. <ja...@pa...> - 2002-04-22 16:03:12
|
> Well I'm stumped.... > > At least for small surveys/data sets I think James is handling and > exporting check boxes and essays correctly. It could be that > something is breaking on the large surveys/data that you have. > > What version of phpESP are you using? > Latest CVS, but it was doing it from 1.4 forward. Didn't check with 1.3. You're right, it works on other survey's that I created and outputted, but for some reason on these large complex surveys it's screwing up. I'll keep digging and if I ever figure it out, I'll let you know. Maybe it's a special case that can be fixed. -- _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ James O'Malley Altamente.com +1(787)296-1540 _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ |
|
From: James E. F. <jf...@ac...> - 2002-04-22 16:32:56
|
Could you do one of the following: 1) duplicate the problem on the phpesp demo site 2) send me a mysql dump of the survey & data? I will try to write a small script that will dump a particular survey in a bit. -James (who has 3 weeks of work to do in the last week of the semester) On Mon, 22 Apr 2002, James O'Malley wrote: > > Well I'm stumped.... > > > > At least for small surveys/data sets I think James is handling and > > exporting check boxes and essays correctly. It could be that > > something is breaking on the large surveys/data that you have. > > > > What version of phpESP are you using? > > > > Latest CVS, but it was doing it from 1.4 forward. Didn't check with 1.3. > > You're right, it works on other survey's that I created and outputted, but > for some reason on these large complex surveys it's screwing up. > > I'll keep digging and if I ever figure it out, I'll let you know. Maybe > it's a special case that can be fixed. > > |
|
From: James E. F. <jf...@ac...> - 2002-04-22 18:47:33
|
Download this: http://phpesp.sf.net/files/debug_dump.inc and put it in .../phpESP/admin/include/where/ then go to: http://yourhost/.../manage.php?where=debug_dump&sid=XX then save the output and email it to me off list. -James On Mon, 22 Apr 2002, James E. Flemer wrote: > Could you do one of the following: > > 1) duplicate the problem on the phpesp demo site > 2) send me a mysql dump of the survey & data? > > I will try to write a small script that will dump a > particular survey in a bit. > > -James (who has 3 weeks of work to do in the last week of > the semester) > > On Mon, 22 Apr 2002, James O'Malley wrote: > > > > Well I'm stumped.... > > > > > > At least for small surveys/data sets I think James is handling and > > > exporting check boxes and essays correctly. It could be that > > > something is breaking on the large surveys/data that you have. > > > > > > What version of phpESP are you using? > > > > > > > Latest CVS, but it was doing it from 1.4 forward. Didn't check with 1.3. > > > > You're right, it works on other survey's that I created and outputted, but > > for some reason on these large complex surveys it's screwing up. > > > > I'll keep digging and if I ever figure it out, I'll let you know. Maybe > > it's a special case that can be fixed. > > > > > > > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X