Export labels with the CSV file

Support
1

Hello,

I would like to know how I can export the label along with the variable
names on a csv file and stata? This would save time from labelling all the
variables one by one on again. I found a 2012 thread on this topic but
could not find any resolution. I would be very thankful if anyone could hep
with this

Thanks,
Rubana

2

This depends on the server you are using, which server are u using (online
or offline?)

··· On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: > > Hello, > > I would like to know how I can export the label along with the variable > names on a csv file and stata? This would save time from labelling all the > variables one by one on again. I found a 2012 thread on this topic but > could not find any resolution. I would be very thankful if anyone could hep > with this > > Thanks, > Rubana >
3

Rubana,

Try https://github.com/PovertyAction/odkmeta

Yaw

··· On Tue, Apr 25, 2017 at 2:27 AM, EDWIN SIMPLE wrote: > This depends on the server you are using, which server are u using (online > or offline?) > > > On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: >> >> Hello, >> >> I would like to know how I can export the label along with the variable >> names on a csv file and stata? This would save time from labelling all the >> variables one by one on again. I found a 2012 thread on this topic but could >> not find any resolution. I would be very thankful if anyone could hep with >> this >> >> Thanks, >> Rubana > > -- > -- > 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.
4

Hi Edwin,
I am using an online server. I tried the odkmeta command that Yaw mentioned
below, but cannot make it work. Do you have any sugestions?

··· On Tuesday, April 25, 2017 at 7:27:38 PM UTC+10, EDWIN SIMPLE wrote: > > This depends on the server you are using, which server are u using (online > or offline?) > > On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: >> >> Hello, >> >> I would like to know how I can export the label along with the variable >> names on a csv file and stata? This would save time from labelling all the >> variables one by one on again. I found a 2012 thread on this topic but >> could not find any resolution. I would be very thankful if anyone could hep >> with this >> >> Thanks, >> Rubana >> >
5

Hi Yaw,

I have tried using the odkmeta command:

odkmeta using import.do, csv("ODKexample.csv")
survey("survey.csv",name(name)) choices("choices.csv",name(name))

But got error messages as below:

column header label not found

invalid label() suboption

invalid survey() option

··· On Wednesday, April 26, 2017 at 1:20:11 AM UTC+10, Yaw Anokwa wrote: > > Rubana, > > Try https://github.com/PovertyAction/odkmeta > > Yaw > > On Tue, Apr 25, 2017 at 2:27 AM, EDWIN SIMPLE <chide...@gmail.com > wrote: > > This depends on the server you are using, which server are u using > (online > > or offline?) > > > > > > On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: > >> > >> Hello, > >> > >> I would like to know how I can export the label along with the variable > >> names on a csv file and stata? This would save time from labelling all > the > >> variables one by one on again. I found a 2012 thread on this topic but > could > >> not find any resolution. I would be very thankful if anyone could hep > with > >> this > >> > >> Thanks, > >> Rubana > > > > -- > > -- > > 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. >
6

Hi Rubana,

If you have questions about odkmeta, submit a GitHub issue at
https://github.com/PovertyAction/odkmeta/issues or e-mail
researchsupport@poverty-action.org.

Also, please understand that support on this list is provided by
volunteers working in their free time. If you'd like help, you need to
provide a lot more information so the person who is trying to help you
can try to replicate the issue.

All this to say, when you post "I am using an online server...but
cannot make it work" to Edwin, you've made Edwin's task impossible.

What is the name of the online server? What specific steps did you
take? What specific error messages did you get? What did you do
yourself to try to solve the problem? What were the results of those
things you tried?

I understand that it's hard to know what level of detail to provide,
but my advice is to provide enough detail that a clever five year old
could replicate your problem. If you can do that, you'll get help a
lot faster :slight_smile:

Yaw

··· On Sat, Apr 29, 2017 at 2:27 AM, Rubana Islam wrote: > Hi Yaw, > > I have tried using the odkmeta command: > > odkmeta using import.do, csv("ODKexample.csv") > survey("survey.csv",name(name)) choices("choices.csv",name(name)) > > > But got error messages as below: > > column header label not found > > invalid label() suboption > > invalid survey() option > > > On Wednesday, April 26, 2017 at 1:20:11 AM UTC+10, Yaw Anokwa wrote: >> >> Rubana, >> >> Try https://github.com/PovertyAction/odkmeta >> >> Yaw >> >> On Tue, Apr 25, 2017 at 2:27 AM, EDWIN SIMPLE wrote: >> > This depends on the server you are using, which server are u using >> > (online >> > or offline?) >> > >> > >> > On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: >> >> >> >> Hello, >> >> >> >> I would like to know how I can export the label along with the variable >> >> names on a csv file and stata? This would save time from labelling all >> >> the >> >> variables one by one on again. I found a 2012 thread on this topic but >> >> could >> >> not find any resolution. I would be very thankful if anyone could hep >> >> with >> >> this >> >> >> >> Thanks, >> >> Rubana >> > >> > -- >> > -- >> > 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. > > -- > -- > 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.
7

Hi Rubana,

Thank you for understanding.

What server are you using (e.g., Aggregate, SurveyCTO, Ona)?

Yaw

··· On Sun, Apr 30, 2017 at 3:13 AM, Rubana Islam wrote: > Hi Yaw, > > I understand that volunteers are trying to help here and appreciate it very > much because I am a medical doctor with no orientation to programming > whatsoever and trying to work with DK for my PhD research meaning I do not > have a team of team experts who can help me resolve these issues. So in my > case when I am posting a problem I am not aware what additional details need > to go with it; so I just answered what Edwin asked. > > Right about now I am regretting going with the ODK collect option over > paper-based questionnaires. Anyway, will try to keep your advice in mind in > future posts hoping that I myself know what is to be reported. > > Rubana > > On Sunday, April 30, 2017 at 12:18:53 AM UTC+10, Yaw Anokwa wrote: >> >> Hi Rubana, >> >> If you have questions about odkmeta, submit a GitHub issue at >> https://github.com/PovertyAction/odkmeta/issues or e-mail >> researc...@poverty-action.org. >> >> Also, please understand that support on this list is provided by >> volunteers working in their free time. If you'd like help, you need to >> provide a lot more information so the person who is trying to help you >> can try to replicate the issue. >> >> All this to say, when you post "I am using an online server...but >> cannot make it work" to Edwin, you've made Edwin's task impossible. >> >> What is the name of the online server? What specific steps did you >> take? What specific error messages did you get? What did you do >> yourself to try to solve the problem? What were the results of those >> things you tried? >> >> I understand that it's hard to know what level of detail to provide, >> but my advice is to provide enough detail that a clever five year old >> could replicate your problem. If you can do that, you'll get help a >> lot faster :) >> >> Yaw >> >> On Sat, Apr 29, 2017 at 2:27 AM, Rubana Islam wrote: >> > Hi Yaw, >> > >> > I have tried using the odkmeta command: >> > >> > odkmeta using import.do, csv("ODKexample.csv") >> > survey("survey.csv",name(name)) choices("choices.csv",name(name)) >> > >> > >> > But got error messages as below: >> > >> > column header label not found >> > >> > invalid label() suboption >> > >> > invalid survey() option >> > >> > >> > On Wednesday, April 26, 2017 at 1:20:11 AM UTC+10, Yaw Anokwa wrote: >> >> >> >> Rubana, >> >> >> >> Try https://github.com/PovertyAction/odkmeta >> >> >> >> Yaw >> >> >> >> On Tue, Apr 25, 2017 at 2:27 AM, EDWIN SIMPLE wrote: >> >> > This depends on the server you are using, which server are u using >> >> > (online >> >> > or offline?) >> >> > >> >> > >> >> > On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: >> >> >> >> >> >> Hello, >> >> >> >> >> >> I would like to know how I can export the label along with the >> >> >> variable >> >> >> names on a csv file and stata? This would save time from labelling >> >> >> all >> >> >> the >> >> >> variables one by one on again. I found a 2012 thread on this topic >> >> >> but >> >> >> could >> >> >> not find any resolution. I would be very thankful if anyone could >> >> >> hep >> >> >> with >> >> >> this >> >> >> >> >> >> Thanks, >> >> >> Rubana >> >> > >> >> > -- >> >> > -- >> >> > 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. >> > >> > -- >> > -- >> > 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. > > -- > -- > 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.
8

I am using Aggregate on a private server. I have written to poverty action
about getting the error message on running the odkmeta command and awaiting
their response.

Thanks,
Rubana

··· On Monday, May 1, 2017 at 6:05:10 AM UTC+10, Yaw Anokwa wrote: > > Hi Rubana, > > Thank you for understanding. > > What server are you using (e.g., Aggregate, SurveyCTO, Ona)? > > Yaw > > > On Sun, Apr 30, 2017 at 3:13 AM, Rubana Islam wrote: > > Hi Yaw, > > > > I understand that volunteers are trying to help here and appreciate it > very > > much because I am a medical doctor with no orientation to programming > > whatsoever and trying to work with DK for my PhD research meaning I do > not > > have a team of team experts who can help me resolve these issues. So in > my > > case when I am posting a problem I am not aware what additional details > need > > to go with it; so I just answered what Edwin asked. > > > > Right about now I am regretting going with the ODK collect option over > > paper-based questionnaires. Anyway, will try to keep your advice in mind > in > > future posts hoping that I myself know what is to be reported. > > > > Rubana > > > > On Sunday, April 30, 2017 at 12:18:53 AM UTC+10, Yaw Anokwa wrote: > >> > >> Hi Rubana, > >> > >> If you have questions about odkmeta, submit a GitHub issue at > >> https://github.com/PovertyAction/odkmeta/issues or e-mail > >> researc...@poverty-action.org. > >> > >> Also, please understand that support on this list is provided by > >> volunteers working in their free time. If you'd like help, you need to > >> provide a lot more information so the person who is trying to help you > >> can try to replicate the issue. > >> > >> All this to say, when you post "I am using an online server...but > >> cannot make it work" to Edwin, you've made Edwin's task impossible. > >> > >> What is the name of the online server? What specific steps did you > >> take? What specific error messages did you get? What did you do > >> yourself to try to solve the problem? What were the results of those > >> things you tried? > >> > >> I understand that it's hard to know what level of detail to provide, > >> but my advice is to provide enough detail that a clever five year old > >> could replicate your problem. If you can do that, you'll get help a > >> lot faster :) > >> > >> Yaw > >> > >> On Sat, Apr 29, 2017 at 2:27 AM, Rubana Islam wrote: > >> > Hi Yaw, > >> > > >> > I have tried using the odkmeta command: > >> > > >> > odkmeta using import.do, csv("ODKexample.csv") > >> > survey("survey.csv",name(name)) choices("choices.csv",name(name)) > >> > > >> > > >> > But got error messages as below: > >> > > >> > column header label not found > >> > > >> > invalid label() suboption > >> > > >> > invalid survey() option > >> > > >> > > >> > On Wednesday, April 26, 2017 at 1:20:11 AM UTC+10, Yaw Anokwa wrote: > >> >> > >> >> Rubana, > >> >> > >> >> Try https://github.com/PovertyAction/odkmeta > >> >> > >> >> Yaw > >> >> > >> >> On Tue, Apr 25, 2017 at 2:27 AM, EDWIN SIMPLE wrote: > >> >> > This depends on the server you are using, which server are u using > >> >> > (online > >> >> > or offline?) > >> >> > > >> >> > > >> >> > On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: > >> >> >> > >> >> >> Hello, > >> >> >> > >> >> >> I would like to know how I can export the label along with the > >> >> >> variable > >> >> >> names on a csv file and stata? This would save time from > labelling > >> >> >> all > >> >> >> the > >> >> >> variables one by one on again. I found a 2012 thread on this > topic > >> >> >> but > >> >> >> could > >> >> >> not find any resolution. I would be very thankful if anyone could > >> >> >> hep > >> >> >> with > >> >> >> this > >> >> >> > >> >> >> Thanks, > >> >> >> Rubana > >> >> > > >> >> > -- > >> >> > -- > >> >> > 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. > >> > > >> > -- > >> > -- > >> > 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. > > > > -- > > -- > > 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. >
9

Hi Rubana,

It sounds like you are on the right track!

Once you have the CSV from ODK Aggregate, using odkmeta is the best
way to get data into Stata. Hopefully, the folks at IPA will be able
to help you use their tool.

Yaw

··· On Mon, May 1, 2017 at 2:34 AM, Rubana Islam wrote: > I am using Aggregate on a private server. I have written to poverty action > about getting the error message on running the odkmeta command and awaiting > their response. > > Thanks, > Rubana > > > On Monday, May 1, 2017 at 6:05:10 AM UTC+10, Yaw Anokwa wrote: >> >> Hi Rubana, >> >> Thank you for understanding. >> >> What server are you using (e.g., Aggregate, SurveyCTO, Ona)? >> >> Yaw >> >> >> On Sun, Apr 30, 2017 at 3:13 AM, Rubana Islam wrote: >> > Hi Yaw, >> > >> > I understand that volunteers are trying to help here and appreciate it >> > very >> > much because I am a medical doctor with no orientation to programming >> > whatsoever and trying to work with DK for my PhD research meaning I do >> > not >> > have a team of team experts who can help me resolve these issues. So in >> > my >> > case when I am posting a problem I am not aware what additional details >> > need >> > to go with it; so I just answered what Edwin asked. >> > >> > Right about now I am regretting going with the ODK collect option over >> > paper-based questionnaires. Anyway, will try to keep your advice in mind >> > in >> > future posts hoping that I myself know what is to be reported. >> > >> > Rubana >> > >> > On Sunday, April 30, 2017 at 12:18:53 AM UTC+10, Yaw Anokwa wrote: >> >> >> >> Hi Rubana, >> >> >> >> If you have questions about odkmeta, submit a GitHub issue at >> >> https://github.com/PovertyAction/odkmeta/issues or e-mail >> >> researc...@poverty-action.org. >> >> >> >> Also, please understand that support on this list is provided by >> >> volunteers working in their free time. If you'd like help, you need to >> >> provide a lot more information so the person who is trying to help you >> >> can try to replicate the issue. >> >> >> >> All this to say, when you post "I am using an online server...but >> >> cannot make it work" to Edwin, you've made Edwin's task impossible. >> >> >> >> What is the name of the online server? What specific steps did you >> >> take? What specific error messages did you get? What did you do >> >> yourself to try to solve the problem? What were the results of those >> >> things you tried? >> >> >> >> I understand that it's hard to know what level of detail to provide, >> >> but my advice is to provide enough detail that a clever five year old >> >> could replicate your problem. If you can do that, you'll get help a >> >> lot faster :) >> >> >> >> Yaw >> >> >> >> On Sat, Apr 29, 2017 at 2:27 AM, Rubana Islam wrote: >> >> > Hi Yaw, >> >> > >> >> > I have tried using the odkmeta command: >> >> > >> >> > odkmeta using import.do, csv("ODKexample.csv") >> >> > survey("survey.csv",name(name)) choices("choices.csv",name(name)) >> >> > >> >> > >> >> > But got error messages as below: >> >> > >> >> > column header label not found >> >> > >> >> > invalid label() suboption >> >> > >> >> > invalid survey() option >> >> > >> >> > >> >> > On Wednesday, April 26, 2017 at 1:20:11 AM UTC+10, Yaw Anokwa wrote: >> >> >> >> >> >> Rubana, >> >> >> >> >> >> Try https://github.com/PovertyAction/odkmeta >> >> >> >> >> >> Yaw >> >> >> >> >> >> On Tue, Apr 25, 2017 at 2:27 AM, EDWIN SIMPLE wrote: >> >> >> > This depends on the server you are using, which server are u using >> >> >> > (online >> >> >> > or offline?) >> >> >> > >> >> >> > >> >> >> > On Tuesday, April 25, 2017 at 8:51:31 AM UTC+1, Rubana Islam wrote: >> >> >> >> >> >> >> >> Hello, >> >> >> >> >> >> >> >> I would like to know how I can export the label along with the >> >> >> >> variable >> >> >> >> names on a csv file and stata? This would save time from >> >> >> >> labelling >> >> >> >> all >> >> >> >> the >> >> >> >> variables one by one on again. I found a 2012 thread on this >> >> >> >> topic >> >> >> >> but >> >> >> >> could >> >> >> >> not find any resolution. I would be very thankful if anyone could >> >> >> >> hep >> >> >> >> with >> >> >> >> this >> >> >> >> >> >> >> >> Thanks, >> >> >> >> Rubana >> >> >> > >> >> >> > -- >> >> >> > -- >> >> >> > 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. >> >> > >> >> > -- >> >> > -- >> >> > 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. >> > >> > -- >> > -- >> > 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. > > -- > -- > 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.