Dear team,
I am gaining experience in creating odk forms for data collection here
in Zomba, Malawi. I have successfully designed and used a couple of
forms. However, when ever I export the data to stata (statistical
package), the responses do not show up the labels but only the values
eg if the the responses were 1 = “Yes” and 2 = “No”; only the numbers
show up and not the string responses, even without hiding them. The
same happens with the variable labels. I include the labels in both
the survey and choices sheets of the excel file when designing. This
problem forces me to create a separate do file to have the labels
indicated.
Is there something that I am missing? I have been using ODK Collect
v1.1.5. Thanks in advance for your help.
Humphreys.
Dear Humphreys,
The labels are not part of the data, thus they never make it to Stata. (If
you look at the exported .csv files, you can see that they include only the
values, not the labels.) As far as I can tell, this is by design.
Since all of the label-value mappings are conveniently located in the
XLSForm choices sheet, I presume that it's not too difficult to copy and
paste the mappings into a .do file and add the appropriate "label"
commands. With the base ODK I think that's the best you can do, but
somebody else may have a more clever idea.
Somebody may have also built an ODK extension that automates this. I may,
in fact, automate this as part of a large set of extensions I'm planning in
the future -- but I suspect I'm not the first to consider such extensions.
Best,
Chris
···
On Wednesday, April 4, 2012, Humphreys Kabota wrote:
Dear team,
I am gaining experience in creating odk forms for data collection here
in Zomba, Malawi. I have successfully designed and used a couple of
forms. However, when ever I export the data to stata (statistical
package), the responses do not show up the labels but only the values
eg if the the responses were 1 = “Yes” and 2 = “No”; only the numbers
show up and not the string responses, even without hiding them. The
same happens with the variable labels. I include the labels in both
the survey and choices sheets of the excel file when designing. This
problem forces me to create a separate do file to have the labels
indicated.
Is there something that I am missing? I have been using ODK Collect
v1.1.5. Thanks in advance for your help.
Humphreys.
--
Post: opendatakit@googlegroups.com <javascript:;>
Unsubscribe: opendatakit+unsubscribe@googlegroups.com <javascript:;>
Options: http://groups.google.com/group/opendatakit?hl=en
If you provide the code to extend XLSForm to generate these .do files
automatically, we should be able to fold those changes into the main
XLSForm tool (XLSForm is written in Python). It would require us
generating a zip instead of just an xml file, but that shouldn't be too
complicated.
Mitch
···
On Wed, Apr 4, 2012 at 7:17 AM, Christopher Robert < chris_robert@hksphd.harvard.edu> wrote:
Dear Humphreys,
The labels are not part of the data, thus they never make it to Stata. (If
you look at the exported .csv files, you can see that they include only the
values, not the labels.) As far as I can tell, this is by design.
Since all of the label-value mappings are conveniently located in the
XLSForm choices sheet, I presume that it's not too difficult to copy and
paste the mappings into a .do file and add the appropriate "label"
commands. With the base ODK I think that's the best you can do, but
somebody else may have a more clever idea.
Somebody may have also built an ODK extension that automates this. I may,
in fact, automate this as part of a large set of extensions I'm planning in
the future -- but I suspect I'm not the first to consider such extensions.
Best,
Chris
On Wednesday, April 4, 2012, Humphreys Kabota wrote:
Dear team,
I am gaining experience in creating odk forms for data collection here
in Zomba, Malawi. I have successfully designed and used a couple of
forms. However, when ever I export the data to stata (statistical
package), the responses do not show up the labels but only the values
eg if the the responses were 1 = “Yes” and 2 = “No”; only the numbers
show up and not the string responses, even without hiding them. The
same happens with the variable labels. I include the labels in both
the survey and choices sheets of the excel file when designing. This
problem forces me to create a separate do file to have the labels
indicated.
Is there something that I am missing? I have been using ODK Collect
v1.1.5. Thanks in advance for your help.
Humphreys.
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
There is also a feature request with sample files for those who wish
to build this at
http://code.google.com/p/opendatakit/issues/detail?id=495
···
On Wed, Apr 4, 2012 at 09:54, Mitch S wrote:
> If you provide the code to extend XLSForm to generate these .do files
> automatically, we should be able to fold those changes into the main XLSForm
> tool (XLSForm is written in Python). It would require us generating a zip
> instead of just an xml file, but that shouldn't be too complicated.
>
> Mitch
>
>
> On Wed, Apr 4, 2012 at 7:17 AM, Christopher Robert wrote:
>>
>> Dear Humphreys,
>>
>> The labels are not part of the data, thus they never make it to Stata. (If
>> you look at the exported .csv files, you can see that they include only the
>> values, not the labels.) As far as I can tell, this is by design.
>>
>> Since all of the label-value mappings are conveniently located in the
>> XLSForm choices sheet, I presume that it's not too difficult to copy and
>> paste the mappings into a .do file and add the appropriate "label" commands.
>> With the base ODK I think that's the best you can do, but somebody else may
>> have a more clever idea.
>>
>> Somebody may have also built an ODK extension that automates this. I may,
>> in fact, automate this as part of a large set of extensions I'm planning in
>> the future -- but I suspect I'm not the first to consider such extensions.
>>
>> Best,
>>
>> Chris
>>
>>
>> On Wednesday, April 4, 2012, Humphreys Kabota wrote:
>>>
>>> Dear team,
>>>
>>> I am gaining experience in creating odk forms for data collection here
>>> in Zomba, Malawi. I have successfully designed and used a couple of
>>> forms. However, when ever I export the data to stata (statistical
>>> package), the responses do not show up the labels but only the values
>>> eg if the the responses were 1 = “Yes” and 2 = “No”; only the numbers
>>> show up and not the string responses, even without hiding them. The
>>> same happens with the variable labels. I include the labels in both
>>> the survey and choices sheets of the excel file when designing. This
>>> problem forces me to create a separate do file to have the labels
>>> indicated.
>>>
>>> Is there something that I am missing? I have been using ODK Collect
>>> v1.1.5. Thanks in advance for your help.
>>> Humphreys.
>>>
>>> --
>>> Post: opendatakit@googlegroups.com
>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
>>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>> --
>> Post: opendatakit@googlegroups.com
>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>
>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitchellsundt@gmail.com
>
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en