From: Roman Y. <Ro...@ss...> - 2003-11-06 14:56:10
|
Update: Had a chance to talk to Matthew (thanks to IRC) and he had a very simple and brilliant idea! I think we've figured out what is happening. When I designed this questionnaire, I let phpESP fill in the question names for me. The problem is that I had some question that were worded similarly, i.e. had different endings with the same beginnings. Don't ask me why, I didn't come up with this questionnaire, but I can image some standardized surveys being like that. This became a problem when the names got trimmed to 30 characters and I tried to export data to CSV. Anyhow, I think this is what happed. I haven't had a chance to look at the part of the code that does the naming trick. I thought I would keep you up-to-date, so you won't be looking in a wrong place. All the best, Roman -----Original Message----- From: Roman Yashin [mailto:Ro...@ss...] Sent: Thursday, November 06, 2003 12:06 PM To: php...@li... Subject: RE: [phpesp-dev] CVS export possible bug I think I found it! (Haven't fixed it yet tho'). It's in espresponse.inc, response_select_name() function. The problem is in returning $nam array (see line ~651). It's being created couple of lines before with $nam[$key] = $val. I've done the following tests: First: count ($nam,COUNT_RECURSIVE) for $nam[$key] = $val // where $key = question name/label Second: count ($nam,COUNT_RECURSIVE) for $nam[] = $val // notice no variable for index The two arrays have different size, which I believe is incorrect. BTW, the second array has correct data for CSV export. Something happens when we use question names for indexes in the array. I hope all these make sense. I am afraid this behavior might surface somewhere else. James, Kon and others I don't know: What do you guys think about it? Cheers, Roman -----Original Message----- From: Roman Yashin [mailto:ro...@ss...] Sent: Monday, November 03, 2003 7:06 PM To: Matthew Gregg Cc: php...@li... Subject: Re: [phpesp-dev] CVS export possible bug Matthew, I know of Rank type behavior, I'm not talking about that. In my case, I am suing Radio Buttons and only two out of 50+ questions getting messed up! Thanks for your help tho' Roman On Monday, November 3, 2003, at 06:10 PM, Matthew Gregg wrote: > Your problem might be related to this bug: > http://sourceforge.net/tracker/ > index.php?func=detail&aid=827824&group_id=8956&atid=108956 > > Try taking that "off by one" bug into account and see if the > frequencies > work out. > > On Mon, 2003-11-03 at 10:08, Roman Yashin wrote: >> Hi, >> >> >> >> I think there is a possible bug in CSV export function. There is >> always a chance that my dataset is messed up, but I don't think so. >> I'm doing more tests to eliminate that possibility. Meanwhile, has >> anyone experience the following: >> >> >> >> The frequencies for question choices on the report page DO NOT >> correspond to the frequencies for the same question when you analyze >> it in SPSS or Excel? >> >> >> >> Example: >> >> Question: I believe there could a bug in CSV Export function. >> >> >> >> In ESP Report you get: >> >> Strongly Agree 8.8% (13) >> >> Agree 59.9% (88) >> >> Disagree 29.9% (44) >> >> Strongly Disagree 1.4% (2) >> >> TOTAL 100.0% 147 >> >> >> >> In CSV file you get (SPSS and Excel): >> >> Strongly Agree (16) >> >> Agree (78) >> >> Disagree (52) >> >> Strongly Disagree (1) >> >> TOTAL 100.0% 147 >> >> >> >> I should've probably made sure it is a bug before bothering you all, >> but I figured if somebody has experienced something similar it will >> save me a great deal of time. >> >> >> >> Cheers, >> >> >> >> Roman >> >> > -- > mcg > ------------------------------------- > The IT Lab (http://www.itlab.musc.edu) ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ phpESP-devel mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-devel |