Export ODK data to Statistical software (SPSS, STATA, etc) for data validation. What does the community uses for validation in ODK

Hi,

I know this is not implemented, but I want to know what does the ODK
community uses, and if any of ODK devs is reading, whether there is any
plan for implementing such feature because I believe it is vital (and I
know it is hard work).

Data validation is a crucial part of our process but with ODK we are
struggling becuase ODK exports just the values in CSV, and not value
labels, questions, and form logic which then can be reused to perform data
validation and
*then EDIT *the data/answers that are incorrect (after doing the data
validation process). In ODK's CSV this is difficult to perform because even
if know where the error is, you dont have the formatted questionnaire in
front of you to make a judgement.

They tell me, CSPro does this (but cannot use, because ODK is much better
in other things (Aggregate / ODK Collect / Enketo / Open Source)..

Perhaps, showing the submitted questionnaires with ENKETO would be a nice
start?

Best,
piq

1 Like

Hi Piq,

Our team at Nafundi has a codebook generator that you can use while
doing your analysis. It generates a PDF with the variable names,
question text, choices, etc. It's free and you can find it at
http://nafundi.com/blog/posts/nafundi-and-task-force-release-codebook-generator-for-odk.

Another option is odkmeta from Innovations for Poverty Action. It
writes a do-file to import ODK data to Stata, using the metadata from
the survey and choices worksheets of the XLSForm. More at
https://github.com/matthew-white/odkmeta.

The core team relies on the community to build tools like these that
connect to ODK. If this a pain point that existing tools don't solve,
perhaps your organization can help build it...

Yaw

ยทยทยท -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Jul 30, 2015 at 9:17 AM, El Piqo piqoni@gmail.com wrote:

Hi,

I know this is not implemented, but I want to know what does the ODK
community uses, and if any of ODK devs is reading, whether there is any plan
for implementing such feature because I believe it is vital (and I know it
is hard work).

Data validation is a crucial part of our process but with ODK we are
struggling becuase ODK exports just the values in CSV, and not value labels,
questions, and form logic which then can be reused to perform data
validation and
then EDIT the data/answers that are incorrect (after doing the data
validation process). In ODK's CSV this is difficult to perform because even
if know where the error is, you dont have the formatted questionnaire in
front of you to make a judgement.

They tell me, CSPro does this (but cannot use, because ODK is much better in
other things (Aggregate / ODK Collect / Enketo / Open Source)..

Perhaps, showing the submitted questionnaires with ENKETO would be a nice
start?

Best,
piq

--

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.

Hi Yaw,

Thanks a lot for these; they seem helpful. I'll see what I can do.

Best,
piqo

ยทยทยท On Thursday, July 30, 2015 at 4:32:06 PM UTC+2, Yaw Anokwa wrote: > > Hi Piq, > > Our team at Nafundi has a codebook generator that you can use while > doing your analysis. It generates a PDF with the variable names, > question text, choices, etc. It's free and you can find it at > > http://nafundi.com/blog/posts/nafundi-and-task-force-release-codebook-generator-for-odk. > > > Another option is odkmeta from Innovations for Poverty Action. It > writes a do-file to import ODK data to Stata, using the metadata from > the survey and choices worksheets of the XLSForm. More at > https://github.com/matthew-white/odkmeta. > > The core team relies on the community to build tools like these that > connect to ODK. If this a pain point that existing tools don't solve, > perhaps your organization can help build it... > > Yaw > -- > Need ODK services? http://nafundi.com provides form design, server > setup, professional support, and software development for ODK. > > On Thu, Jul 30, 2015 at 9:17 AM, El Piqo <piq...@gmail.com > wrote: > > Hi, > > > > I know this is not implemented, but I want to know what does the ODK > > community uses, and if any of ODK devs is reading, whether there is any > plan > > for implementing such feature because I believe it is vital (and I know > it > > is hard work). > > > > Data validation is a crucial part of our process but with ODK we are > > struggling becuase ODK exports just the values in CSV, and not value > labels, > > questions, and form logic which then can be reused to perform data > > validation and > > then EDIT the data/answers that are incorrect (after doing the data > > validation process). In ODK's CSV this is difficult to perform because > even > > if know where the error is, you dont have the formatted questionnaire in > > front of you to make a judgement. > > > > They tell me, CSPro does this (but cannot use, because ODK is much > better in > > other things (Aggregate / ODK Collect / Enketo / Open Source).. > > > > Perhaps, showing the submitted questionnaires with ENKETO would be a > nice > > start? > > > > Best, > > piq > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >