search

getodk / aggregate

ODK Aggregate is a Java server that stores, analyzes, and presents survey data collected using ODK Collect. Contribute and make the world a better place! ✨🗄✨
https://docs.opendatakit.org/aggregate-intro/
Other
74 stars 227 forks source link

Better export for statistics tools #31

Open getodk-bot opened 7 years ago

getodk-bot commented 7 years ago

Issue by mitchellsundt Thursday Jul 09, 2015 at 18:37 GMT Originally opened as https://github.com/opendatakit/opendatakit/issues/496 (10 comment(s))

Originally reported on Google Code with ID 495

I am also severely missing a possibility to export data to statistical programmes such
as Stata or R including variable labels and value labels, i.e. essentially the underlying
logic of the questionnaire. Before, we were using pencil paper questionnaires and the
free (but not open source) CSPro as data entry tool. It was possible to directly export
to Stata, which was extremely handy. Any change in the questionnaire was immediately
and correctly reflected in the Stata export. As any digital questionnaire includes
the information of (a) the question, (b) variable name, (c) answer categories in words
and (d) associated values in numbers. As far as I understood, (a)-(c) would be lost
in ODK .csv export and only (d) is kept. Is that correct? IMHO, this would mean much
(error-prone) duplication of work. 

How difficult is it to include (a)-(c) and to develop an export to statistical programmes?
Has already anyone started to write an export filter to one of these statistical programmes?

--Gerry

Reported by yanokwa on 2012-01-06 00:01:02

getodk-bot commented 7 years ago

Comment by mitchellsundt Thursday Jul 09, 2015 at 18:37 GMT

For us to implement this we would have to go research the proper formats. You could
help us with this by filing an issue with links to the format specification and a couple
of examples (can contain fake data) that show the original xform used to gather data,
the original csv export along with a file that shows what the desired output format
that combined them. The issue tracker allows you to attach files.

-- Waylon

Reported by yanokwa on 2012-01-06 00:02:36

getodk-bot commented 7 years ago

Comment by mitchellsundt Thursday Jul 09, 2015 at 18:37 GMT

Thank you very much for opening this issue in order to have an export of data to statistical
programmes, such as Stata or R, including variable and value labels.

I contacted the Stata developers and they were sending me the links to the specification
of the Stata .dta file format:
* 8/9:   http://www.stata.com/help.cgi?dta_113
* 10/11: http://www.stata.com/help.cgi?dta_114
* 12:    http://www.stata.com/help.cgi?dta

Thanks for looking into it.
--Gerry

Reported by gerry.treppel on 2012-01-08 12:57:04

ggalmazor commented 6 years ago

Attention! We're housekeeping! This issue will automatically be closed if no feedback is received in one week.

If this issue is important to you or you can provide more information about it, please, do so as soon as possible :)