Exporting data from ODK to common statistical software formats

Dear ODKers,

One topic that has come up in a few threads is ODK's ability to export
data from its native storage format (or CSV file from Aggregate) into
the storage format of commonly used statistical software (e.g., Stata,
SAS, SPSS, etc.). In the form of a question: can ODK convert data
into the above-mentioned formats?

From that larger question, two bite-sized questions. First, has
anyone in the user community devised a way to do this--and ideally one
automates the tedious data management steps of creating and applying
value (e.g. for question X, the numerical values 1 and 2 have
associated labels of "Yes" and "No", respectively) and variable labels
(e.g., variable WALL has an associated label "primary building
material of the dwelling's walls") using information that may have
already been coded into the XForm that captured the data?

Second, is this something that ODK developers have plans for
implementing in future?

Best,
Arthur

If anyone has done this work, it would be a great contribution from the
community back into the Aggregate code tree (hint).

If you need to code a selection as a numeric value, you could
write the XForm to have that numeric value as the value string.

This would avoid the first bite-size question. Otherwise, if you are
using more readable textual value strings, an XSLT (an XML
document describing how to transform one XML document into
any other textual representation) should be able to do this transformation.

The second bite-size question is a bit harder. We have been
intrigued by the Excel spreadsheet -to- XForm form construction
tool ( http://xform.childcount.org/ ). If you defined your XForm via
this tool, you would have this reverse mapping available in the Excel
spreadsheet, and could then work backward from that. It is probably
easier than trying to work backward from the XForm itself.

Aggregate would be the logical place for this functionality, either
implemented
as a publication to an external service, or as a bulk download applet
like Briefcase.

Mitch

··· On Tue, Nov 16, 2010 at 9:03 AM, Arthur wrote:

Dear ODKers,

One topic that has come up in a few threads is ODK's ability to export
data from its native storage format (or CSV file from Aggregate) into
the storage format of commonly used statistical software (e.g., Stata,
SAS, SPSS, etc.). In the form of a question: can ODK convert data
into the above-mentioned formats?

From that larger question, two bite-sized questions. First, has
anyone in the user community devised a way to do this--and ideally one
automates the tedious data management steps of creating and applying
value (e.g. for question X, the numerical values 1 and 2 have
associated labels of "Yes" and "No", respectively) and variable labels
(e.g., variable WALL has an associated label "primary building
material of the dwelling's walls") using information that may have
already been coded into the XForm that captured the data?

Second, is this something that ODK developers have plans for
implementing in future?

Best,
Arthur

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer


University of Washington
mitchellsundt@gmail.com

Morning Dear ODK users?

I would like to request support about how to extract data from ODK in SPSS data set. It will be a great support if anyone give me steps to follow .

Thank you

Hi there,

ODK Aggregate exports a CSV, so download and import that CSV into
SPSS. If you get stuck doing that, please let the list know!

https://groups.google.com/forum/#!searchin/opendatakit/spss|sort:relevance
might be of further assistance.

Yaw

··· On Mon, Apr 10, 2017 at 3:24 AM, wrote: > Morning Dear ODK users? > > I would like to request support about how to extract data from ODK in SPSS data set. It will be a great support if anyone give me steps to follow . > > Thank you > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.