Menu
▾
▴
[phpesp-dev] [ phpesp-Bugs-1945462 ] incorrectly data when exporting
|
From: SourceForge.net <no...@so...> - 2010-01-22 13:10:15
|
Bugs item #1945462, was opened at 2008-04-18 09:48 Message generated for change (Comment added) made by liedekef You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1945462&group_id=8956 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL Group: v2.0.2 >Status: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: Artur Kusmierek (arturmail) Assigned to: Nobody/Anonymous (nobody) Summary: incorrectly data when exporting Initial Comment: I've noticed that exported data from larger surveys are different from data generated by "View Results from a Survey" and data received via submission e-mails! The only way to get the proper data from MySql database is to export data directly from MySql database (i.e. phpMyAdmin) and sort them in i.e. MS Excel firstly by "response_id" field and secondly by "choice_id". It is not an issue when the survey has 1 or 2 to answers (I can't repeat this error on small group of answered surveys). Maybe it is connected with save survey sessions (getting back later to finish, the "choice_id" field is not set one after another from one person's answer). -- Regards, Artur ---------------------------------------------------------------------- >Comment By: Franky Van Liedekerke (liedekef) Date: 2010-01-22 14:10 Message: I never really found a problem here, so unless the original reporter provides a better script of reproducing this, I'm closing this. ---------------------------------------------------------------------- Comment By: Artur Kusmierek (arturmail) Date: 2008-04-18 12:43 Message: Logged In: YES user_id=2066340 Originator: YES I tried to attach screenshots as a file but looks messy to me. This particual responce id is 91. I'm not an expert but in simple words for me it looks like when tha data is gathering via www and e-mail it is sorted by responce_id and choice_id (don't sure about question_id if it can get tricky). But when the data is being exported it is sorted only by responce_id and question_id (not choice_id) which causes unsorted answers within particular questions. File Added: Rysunek1.jpg ---------------------------------------------------------------------- Comment By: Artur Kusmierek (arturmail) Date: 2008-04-18 12:00 Message: Logged In: YES user_id=2066340 Originator: YES File Added: email.jpg ---------------------------------------------------------------------- Comment By: Artur Kusmierek (arturmail) Date: 2008-04-18 11:59 Message: Logged In: YES user_id=2066340 Originator: YES File Added: www.jpg ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2008-04-18 09:55 Message: Logged In: YES user_id=109671 Originator: NO Hi, could you tell me what you mean by differences? An example would be great to track down the problem ... I will see what the save survey sessions do for now and see if I can detect a problem there. Franky ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1945462&group_id=8956 |
