Otise / opendatakit

Automatically exported from code.google.com/p/opendatakit
0 stars 0 forks source link

PROBLEMS WITH EXPORTING DATA #589

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?
Responses are being misplaced.

What version of the product are you using? On what operating system?
I am using PC, windows 7.  

Please provide any additional information below.

Original issue reported on code.google.com by humphrey...@investinknowledge.org on 5 Jun 2012 at 7:06

Attachments:

GoogleCodeExporter commented 9 years ago
From email:

I have a problem with my odk collect form. The form has been successfully 
converted with the relevant bindings working; however, when using odk briefcase 
to pull and export the data, responses are being seen as being misplaced. This 
happens especially to the last variables and where particular questions had 
been correctly skipped. For example, the response to the automatically 
generated KEY variable could be shifted to another variable inside. The 
instances/submissions forms however have the data in correct order. I am using 
version 1.1.7 of odk collect.

Original comment by wbrune...@gmail.com on 5 Jun 2012 at 4:44

GoogleCodeExporter commented 9 years ago
I actually have tested ODK Briefcase 1.2 just now and have the same issue; data 
which has been correctly recorded in ODK Aggregate online is not being exported 
if there had been  sections with more than two questions skipped. Since we have 
sections being based on the age of a child, I do not get to export data of 
children of a certain age group.

Original comment by sudh...@gmail.com on 26 Jul 2012 at 11:02

GoogleCodeExporter commented 9 years ago
I'll look into this, but this is most likely a problem with the responses 
containing commas or new-lines, and confusing Excel or other tools when being 
imported. We follow this standard: http://tools.ietf.org/html/rfc4180#page-2

But Microsoft Excel is exceedingly stupid...

Original comment by mitchellsundt@gmail.com on 26 Jul 2012 at 4:26

GoogleCodeExporter commented 9 years ago
Thanks, Mitchell.
I normally do not use ODK Aggregate online for a real survey, but offline and 
version 0.9.6 since from 1.x onwards you need to set up MySQL/PostgreSQL and 
Tomcat and that is too technical for most operations I work with. With ODK 
Briefcase built in Aggregate 0.9.6 I do not have the same exporting issue for 
the same form, which is why I only noticed it now, despite having used ODK for 
a while.

Original comment by sudh...@gmail.com on 27 Jul 2012 at 6:43

GoogleCodeExporter commented 9 years ago

Original comment by wbrune...@gmail.com on 29 Jul 2012 at 1:14

GoogleCodeExporter commented 9 years ago
It appears that you were using an older version of ODK Briefcase (this was an 
issue in the ODK Briefcase v1.0.1 production release). When I download the 
latest (v1.2) from here http://code.google.com/p/opendatakit/downloads/list , 
the generated CSV is properly aligned.

Tagging this as a duplicate of 
http://code.google.com/p/opendatakit/issues/detail?id=526

Original comment by mitchellsundt@gmail.com on 31 Jul 2012 at 12:15

GoogleCodeExporter commented 9 years ago
No, sorry, I am having the same issue with Briefcase 1.2 Production release. I 
have tested this version first and then other standalone Briefcase sets (1.1 
and 1.0.x).
In fact, with me it has nothing to do with the CSV not being well aligned, but 
with not extracting all data when there are bigger empty sections (due to skip 
patterns) in the dataset. 
The downloaded CSV will then be empty in the rows after the skips, even though 
the server shows that there is data in the respective columns. I can send you 
screenshots if that helps.

Original comment by sudh...@gmail.com on 31 Jul 2012 at 6:43

GoogleCodeExporter commented 9 years ago
Please attach screen shots and the form in question. If the data files you 
attached earlier exhibit this, then please be specific about what is not 
showing.  I can't see anything missing. If you can, please add me as a Form 
Manager to your AppEngine instance, too.

And note that repeat groups are emitted into separate csv files.

Original comment by mitchellsundt@gmail.com on 31 Jul 2012 at 4:47

GoogleCodeExporter commented 9 years ago
This appears to be due to the downloading of data using ODK Briefcase from a 
pre-1.0.1 version of ODK Aggregate, causing the submission files to be 
incorrect. Subsequent upload or export to CSV then does not work as the nested 
group data cannot be found.

Original comment by mitchellsundt@gmail.com on 1 Aug 2012 at 6:21

GoogleCodeExporter commented 9 years ago
I have collected by ODK some data everything is fine but when I have export ODK 
data by Briefcase but Bengali font problem. 

Original comment by smanw...@gmail.com on 14 Nov 2014 at 1:46

GoogleCodeExporter commented 9 years ago
Please do not add comments to existing issues. 

And please use the opendatakit@ list first, before creating a new issue.

IN this case, if you search the list for CSV and Excel, here is one item that 
comes up:

https://groups.google.com/d/msg/opendatakit/Xh4r6ibFKlE/RZz2E0N-mTQJ

We also address the problems with Excel on our website: 
https://opendatakit.org/use/aggregate/data-transfer/

Original comment by mitchellsundt@gmail.com on 14 Nov 2014 at 9:59