Can anybody help me in exporting data from ODK aggregate server with
labels/text (Captions) not with the id/values like (a,b,c...)
Example. In the gender question below, i want to export the data with
the captions/ labels/text (i.e. male of female) not with the values/
code (i.e. a or b)
Name Caption
a Male
b Female
This isn't supported at this time.
If you are using XLSForm to generate your form definition, you have the
mapping from value to display string.
You could then, with some Excel spreadsheet manipulations, provide a
calculated field that translates back to the caption.
Others have requested that XLSForm emit stata files to do this.
It would be difficult to do this in Aggregate, as it discards all question
text and captions, and all translations of those. Note that your answer
values can be strings up to 255 characters long, so you could have the
values be "male" and "female". This would move the numeric coding step to
prior to importing into stata or similar packages, but allows for easier
quality assurance and verification of the data by us humans through casual
examination.
As always, code contributions are welcome.
Mitch
Can anybody help me in exporting data from ODK aggregate server with
labels/text (Captions) not with the id/values like (a,b,c...)Example. In the gender question below, i want to export the data with
the captions/ labels/text (i.e. male of female) not with the values/
code (i.e. a or b)Name Caption
a Male
b Female
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com