[ODK Community] How do I know refer to a repeat item?

Dear all,

I am developing a xlsform for a household survey in odk collect and have
used a repeat to capture household member, i now want to go to the repeat
and loop through checking the age of the member for a question that is
relevant to children between 3 and 18 year. Does anyone have an idea of how
this can be done.

With much regards,
Karani.

··· On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia wrote:

Thank you so much Waylon, am just from testing it and it has worked very
well!

Regards from Indepth Research Services, Nairobi, Kenya.

Karani.

On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette wbrunette@gmail.com wrote:

To get the repeats into CSV please use ODK Briefcase to download the
Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for
repeated data.

Cheers,
Waylon

On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia <ken@indepthresearch.org wrote:

Dear All,

We have developed a form with repeats in ODK and are using it for a
survey that is currenty ongoing. However when we try to download data from
aggregate (exporting) we do not get the repeats and multiple responses. Any
idea on how to go about this will be most welcome. The application is
hosted on apps engine.

Best regards,

--

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/groups/opt_out.

--

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/groups/opt_out.

--

--

You can follow the exact same way of referring, as long as it's in your
repeat loop.

Trung.

··· On Sunday, April 7, 2013 5:21:29 PM UTC+7, Kennedy Macharia wrote: > > Dear all, > > I am developing a xlsform for a household survey in odk collect and have > used a repeat to capture household member, i now want to go to the repeat > and loop through checking the age of the member for a question that is > relevant to children between 3 and 18 year. Does anyone have an idea of how > this can be done. > > With much regards, > Karani. > > > On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia <k...@indepthresearch.org wrote: > >> Thank you so much Waylon, am just from testing it and it has worked very >> well! >> >> Regards from Indepth Research Services, Nairobi, Kenya. >> >> Karani. >> >> >> On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette <wbru...@gmail.com wrote: >> >>> To get the repeats into CSV please use ODK Briefcase to download the >>> Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for >>> repeated data. >>> >>> Cheers, >>> Waylon >>> >>> >>> On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia < k...@indepthresearch.org > wrote: >>> >>>> Dear All, >>>> >>>> We have developed a form with repeats in ODK and are using it for a >>>> survey that is currenty ongoing. However when we try to download data from >>>> aggregate (exporting) we do not get the repeats and multiple responses. Any >>>> idea on how to go about this will be most welcome. The application is >>>> hosted on apps engine. >>>> >>>> Best regards, >>>> >>>> >>>> -- >>>> -- >>>> 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/groups/opt_out. >>>> >>>> >>>> >>> >>> -- >>> -- >>> 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/groups/opt_out. >>> >>> >>> >> >> >> >> -- >> > > > > -- >

Dear Trung,

Thank you so much for your reply. My question is how to implement the
looping in xlsform is there a function for instance that i can use to index
particular element in the repeat. eg variablename(i).

Hope my explanation is now clear.

Regards,
Karani.

··· On Sun, Apr 7, 2013 at 5:02 PM, Trung Dang Le wrote:

You can follow the exact same way of referring, as long as it's in your
repeat loop.

Trung.

On Sunday, April 7, 2013 5:21:29 PM UTC+7, Kennedy Macharia wrote:

Dear all,

I am developing a xlsform for a household survey in odk collect and have
used a repeat to capture household member, i now want to go to the repeat
and loop through checking the age of the member for a question that is
relevant to children between 3 and 18 year. Does anyone have an idea of how
this can be done.

With much regards,
Karani.

On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Thank you so much Waylon, am just from testing it and it has worked very
well!

Regards from Indepth Research Services, Nairobi, Kenya.

Karani.

On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette wbru...@gmail.com wrote:

To get the repeats into CSV please use ODK Briefcase to download the
Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for
repeated data.

Cheers,
Waylon

On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Dear All,

We have developed a form with repeats in ODK and are using it for a
survey that is currenty ongoing. However when we try to download data from
aggregate (exporting) we do not get the repeats and multiple responses. Any
idea on how to go about this will be most welcome. The application is
hosted on apps engine.

Best regards,

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.com

Options: http://groups.google.com/**group/opendatakit?hl=enhttp://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/**groups/opt_outhttps://groups.google.com/groups/opt_out
.

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.com

Options: http://groups.google.com/**group/opendatakit?hl=enhttp://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/**groups/opt_outhttps://groups.google.com/groups/opt_out
.

--

--

--

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/groups/opt_out.

--

I guess you want to reference the index of a repeat loop (for example, to
assign a code using the index). I think it's impossible for now but maybe
someone has a workaround.

··· On Monday, April 8, 2013 2:29:41 PM UTC+7, Kennedy Macharia wrote: > > Dear Trung, > > Thank you so much for your reply. My question is how to implement the > looping in xlsform is there a function for instance that i can use to index > particular element in the repeat. eg variablename(i). > > Hope my explanation is now clear. > > Regards, > Karani. > > On Sun, Apr 7, 2013 at 5:02 PM, Trung Dang Le <trung...@gmail.com wrote: > >> You can follow the exact same way of referring, as long as it's in your >> repeat loop. >> >> Trung. >> >> On Sunday, April 7, 2013 5:21:29 PM UTC+7, Kennedy Macharia wrote: >> >>> Dear all, >>> >>> I am developing a xlsform for a household survey in odk collect and >>> have used a repeat to capture household member, i now want to go to the >>> repeat and loop through checking the age of the member for a question that >>> is relevant to children between 3 and 18 year. Does anyone have an idea of >>> how this can be done. >>> >>> With much regards, >>> Karani. >>> >>> >>> On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia < k...@indepthresearch.org> wrote: >>> >>>> Thank you so much Waylon, am just from testing it and it has worked >>>> very well! >>>> >>>> Regards from Indepth Research Services, Nairobi, Kenya. >>>> >>>> Karani. >>>> >>>> >>>> On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette wrote: >>>> >>>>> To get the repeats into CSV please use ODK Briefcase to download the >>>>> Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for >>>>> repeated data. >>>>> >>>>> Cheers, >>>>> Waylon >>>>> >>>>> >>>>> On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia < k...@indepthresearch.org> wrote: >>>>> >>>>>> Dear All, >>>>>> >>>>>> We have developed a form with repeats in ODK and are using it for a >>>>>> survey that is currenty ongoing. However when we try to download data from >>>>>> aggregate (exporting) we do not get the repeats and multiple responses. Any >>>>>> idea on how to go about this will be most welcome. The application is >>>>>> hosted on apps engine. >>>>>> >>>>>> Best regards, >>>>>> >>>>>> >>>>>> -- >>>>>> -- >>>>>> 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/**groups/opt_out >>>>>> . >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>>> -- >>>>> 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/**groups/opt_out >>>>> . >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> >>> >>> >>> >>> -- >>> >> -- >> -- >> 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/groups/opt_out. >> >> >> > > > > -- >

Dear Trung,

Thanks alot. I hope someone has a workaround this in the forum.

Regards,
Karani.

··· On Mon, Apr 8, 2013 at 12:30 PM, Trung Dang Le wrote:

I guess you want to reference the index of a repeat loop (for example, to
assign a code using the index). I think it's impossible for now but maybe
someone has a workaround.

On Monday, April 8, 2013 2:29:41 PM UTC+7, Kennedy Macharia wrote:

Dear Trung,

Thank you so much for your reply. My question is how to implement the
looping in xlsform is there a function for instance that i can use to index
particular element in the repeat. eg variablename(i).

Hope my explanation is now clear.

Regards,
Karani.

On Sun, Apr 7, 2013 at 5:02 PM, Trung Dang Le trung...@gmail.com wrote:

You can follow the exact same way of referring, as long as it's in your
repeat loop.

Trung.

On Sunday, April 7, 2013 5:21:29 PM UTC+7, Kennedy Macharia wrote:

Dear all,

I am developing a xlsform for a household survey in odk collect and
have used a repeat to capture household member, i now want to go to the
repeat and loop through checking the age of the member for a question that
is relevant to children between 3 and 18 year. Does anyone have an idea of
how this can be done.

With much regards,
Karani.

On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Thank you so much Waylon, am just from testing it and it has worked
very well!

Regards from Indepth Research Services, Nairobi, Kenya.

Karani.

On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette wbru...@gmail.com wrote:

To get the repeats into CSV please use ODK Briefcase to download the
Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for
repeated data.

Cheers,
Waylon

On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Dear All,

We have developed a form with repeats in ODK and are using it for a
survey that is currenty ongoing. However when we try to download data from
aggregate (exporting) we do not get the repeats and multiple responses. Any
idea on how to go about this will be most welcome. The application is
hosted on apps engine.

Best regards,

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.**com

Options: http://groups.google.com/group/opendatakit?hl=enhttp://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/groups/opt_outhttps://groups.google.com/groups/opt_out
.

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.**com

Options: http://groups.google.com/group/opendatakit?hl=enhttp://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/groups/opt_outhttps://groups.google.com/groups/opt_out
.

--

--

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://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/**groups/opt_outhttps://groups.google.com/groups/opt_out
.

--

--

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/groups/opt_out.

--

This type of structure is hard or impossible to express in XLSForm (or
Build, for that matter).

What you probably need to do is:

(1) have the 1st repeat group ask about all the children and their ages in
the household.

(2) have the 2nd repeat group begin with a filtered select question that
asks the user to select a child from among the children in the constrained
age range.
The remainder of that 2nd repeat group would then ask questions specific to
that child.

The 2nd repeat group would be repeated until the user has answered
questions for all children (unfortunately, there is no way to enforce this
with a constraint, nor is there a way to prevent the user from selecting
the same child twice).

Thus, the data for the 2nd repeat group has a field that identifies the
child from the 1st repeat group, followed by survey data for that selected
child.

The problem with representing this in XLSForm is the listing of all the
children in that filtered select question.

You will want to use the technique described here:
https://mail.google.com/mail/u/0/?shva=1#search/choiceOfRepeat/13ca4d765186fc92

To do that -- see the choiceOfRepeat.xml form definition for what that
first select should look like.

Mitch

··· On Mon, Apr 8, 2013 at 2:33 AM, Kennedy Macharia wrote:

Dear Trung,

Thanks alot. I hope someone has a workaround this in the forum.

Regards,
Karani.

On Mon, Apr 8, 2013 at 12:30 PM, Trung Dang Le trungdangle@gmail.comwrote:

I guess you want to reference the index of a repeat loop (for example, to
assign a code using the index). I think it's impossible for now but maybe
someone has a workaround.

On Monday, April 8, 2013 2:29:41 PM UTC+7, Kennedy Macharia wrote:

Dear Trung,

Thank you so much for your reply. My question is how to implement the
looping in xlsform is there a function for instance that i can use to index
particular element in the repeat. eg variablename(i).

Hope my explanation is now clear.

Regards,
Karani.

On Sun, Apr 7, 2013 at 5:02 PM, Trung Dang Le trung...@gmail.comwrote:

You can follow the exact same way of referring, as long as it's in your
repeat loop.

Trung.

On Sunday, April 7, 2013 5:21:29 PM UTC+7, Kennedy Macharia wrote:

Dear all,

I am developing a xlsform for a household survey in odk collect and
have used a repeat to capture household member, i now want to go to the
repeat and loop through checking the age of the member for a question that
is relevant to children between 3 and 18 year. Does anyone have an idea of
how this can be done.

With much regards,
Karani.

On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Thank you so much Waylon, am just from testing it and it has worked
very well!

Regards from Indepth Research Services, Nairobi, Kenya.

Karani.

On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette wbru...@gmail.comwrote:

To get the repeats into CSV please use ODK Briefcase to download the
Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for
repeated data.

Cheers,
Waylon

On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Dear All,

We have developed a form with repeats in ODK and are using it for a
survey that is currenty ongoing. However when we try to download data from
aggregate (exporting) we do not get the repeats and multiple responses. Any
idea on how to go about this will be most welcome. The application is
hosted on apps engine.

Best regards,

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.**com

Options: http://groups.google.com/group/opendatakit?hl=enhttp://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/grou
ps/opt_out https://groups.google.com/groups/opt_out.

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.**com

Options: http://groups.google.com/group/opendatakit?hl=enhttp://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/groups/opt_outhttps://groups.google.com/groups/opt_out
.

--

--

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://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/**groups/opt_outhttps://groups.google.com/groups/opt_out
.

--

--

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/groups/opt_out.

--

--

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/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Try this URL:
https://groups.google.com/d/msg/opendatakit/PH591iA4rSo/zqqbbuUNPucJ

··· On Friday, April 12, 2013, wrote:

Thanks Mitch!

I can't access the link you posted above (
https://mail.google.com/mail/u/0/?shva=1#search/choiceOfRepeat/13ca4d765186fc92)

How else can I get to that data?

And, just to confirm, this IS possible in XLS form, right? Or do I have
to use build?

On Monday, April 8, 2013 9:52:33 PM UTC+3, Mitch wrote:

This type of structure is hard or impossible to express in XLSForm (or
Build, for that matter).

What you probably need to do is:

(1) have the 1st repeat group ask about all the children and their ages
in the household.

(2) have the 2nd repeat group begin with a filtered select question that
asks the user to select a child from among the children in the constrained
age range.
The remainder of that 2nd repeat group would then ask questions specific
to that child.

The 2nd repeat group would be repeated until the user has answered
questions for all children (unfortunately, there is no way to enforce this
with a constraint, nor is there a way to prevent the user from selecting
the same child twice).

Thus, the data for the 2nd repeat group has a field that identifies the
child from the 1st repeat group, followed by survey data for that selected
child.

The problem with representing this in XLSForm is the listing of all the
children in that filtered select question.

You will want to use the technique described here:
https://mail.google.com/mail/u/0/?shva=1#search/choiceOfRepeat/13ca4d765186fc92

To do that -- see the choiceOfRepeat.xml form definition for what that
first select should look like.
Mitch

On Mon, Apr 8, 2013 at 2:33 AM, Kennedy Macharia < k...@indepthresearch.org <javascript:;>> wrote:

Dear Trung,

Thanks alot. I hope someone has a workaround this in the forum.

Regards,
Karani.

On Mon, Apr 8, 2013 at 12:30 PM, Trung Dang Le <trung...@gmail.com<javascript:;>> wrote:

I guess you want to reference the index of a repeat loop (for example,
to assign a code using the index). I think it's impossible for now but
maybe someone has a workaround.

On Monday, April 8, 2013 2:29:41 PM UTC+7, Kennedy Macharia wrote:
Dear Trung,

Thank you so much for your reply. My question is how to implement the
looping in xlsform is there a function for instance that i can use to index
particular element in the repeat. eg variablename(i).

Hope my explanation is now clear.

Regards,
Karani.

On Sun, Apr 7, 2013 at 5:02 PM, Trung Dang Le <trung...@gmail.com<javascript:;>> wrote:

You can follow the exact same way of referring, as long as it's in your
repeat loop.

Trung.

On Sunday, April 7, 2013 5:21:29 PM UTC+7, Kennedy Macharia wrote:
Dear all,

I am developing a xlsform for a household survey in odk collect and
have used a repeat to capture household member, i now want to go to the
repeat and loop through checking the age of the member for a question that
is relevant to children between 3 and 18 year. Does anyone have an idea of
how this can be done.

With much regards,
Karani.

On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia < k...@indepthresearch.org <javascript:;>> wrote:

Thank you so much Waylon, am just from testing it and it has worked very
well!

Regards from Indepth Research Services, Nairobi, Kenya.

Karani.

On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette <wbru...@gmail.com<javascript:;>> wrote:

To get the repeats into CSV please use ODK Briefcase to download the
Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for
repeated data.

Cheers,
Waylon

On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia < k...@indepthresearch.org <javascript:;>> wrote:

Dear All,

We have developed a form with repeats in ODK and are using it for a
survey that is currenty ongoing. However when we try to download data from
aggregate (exporting) we do not get the repeats and multiple responses. Any
idea on how to go about this will be most welcome. The application is
hosted on apps engine.

Best regards,

--

--

Post: opend...@googlegroups.com <javascript:;>

Unsubscribe: opendatakit...@googlegroups.com <javascript:;>

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 <javascript:;>.

For more options, visit https://groups.google.com/groups/opt_out.

--

--

Post: opend...@googlegroups.com <javascript:;>

Unsubscribe: opendatakit...@googlegroups.com <javascript:;>

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 <javascript:;>.

For more options, visit https://groups.google.com/groups/opt_out.

--

--

--

--

Post: opend...@googlegroups.com <javascript:;>

Unsubscribe: opendatakit...@googlegroups.com <javascript:;>

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 <javascript:;>.

For more options, visit https://groups.google.com/groups/opt_out.

--

--

--

Post: opend...@googlegroups.com <javascript:;>

Unsubscribe: opendatakit...@googlegroups.com <javascript:;>

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 <javascript:;>.

For more options, visit https://groups.google.com/groups/opt_out.

--

--

--

Post: opend...@googlegroups.com <javascript:;>

Unsubscribe: opendatakit...@googlegroups.com <javascript:;>

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 <javascript:;>.

For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com <javascript:;>

--

Post: opendatakit@googlegroups.com <javascript:;>
Unsubscribe: opendatakit+unsubscribe@googlegroups.com <javascript:;>
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 <javascript:;>.
For more options, visit https://groups.google.com/groups/opt_out.

Sorry, look at my response, and my example form.

··· On Fri, Apr 12, 2013 at 2:34 AM, wrote:

Thanks! But unfortunately they didn't seem to finally resolve the
issues...

On Friday, April 12, 2013 9:48:05 AM UTC+3, ニコノコ wrote:

Try this URL:
https://groups.google.com/d/msg/opendatakit/PH591iA4rSo/zqqbbuUNPucJ

On Friday, April 12, 2013, wrote:

Thanks Mitch!

I can't access the link you posted above (
https://mail.google.com/mail/u/0/?shva=1#search/choiceOfRepeat/13ca4d765186fc92)

How else can I get to that data?

And, just to confirm, this IS possible in XLS form, right? Or do I have
to use build?

On Monday, April 8, 2013 9:52:33 PM UTC+3, Mitch wrote:

This type of structure is hard or impossible to express in XLSForm (or
Build, for that matter).

What you probably need to do is:

(1) have the 1st repeat group ask about all the children and their
ages in the household.

(2) have the 2nd repeat group begin with a filtered select question
that asks the user to select a child from among the children in the
constrained age range.

The remainder of that 2nd repeat group would then ask questions
specific to that child.

The 2nd repeat group would be repeated until the user has answered
questions for all children (unfortunately, there is no way to enforce this
with a constraint, nor is there a way to prevent the user from selecting
the same child twice).

Thus, the data for the 2nd repeat group has a field that identifies
the child from the 1st repeat group, followed by survey data for that
selected child.

The problem with representing this in XLSForm is the listing of all
the children in that filtered select question.

You will want to use the technique described here:
https://mail.google.com/mail/u/0/?shva=1#search/choiceOfRepeat/13ca4d765186fc92

To do that -- see the choiceOfRepeat.xml form definition for what that
first select should look like.

Mitch

On Mon, Apr 8, 2013 at 2:33 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Dear Trung,

Thanks alot. I hope someone has a workaround this in the forum.

Regards,

Karani.

On Mon, Apr 8, 2013 at 12:30 PM, Trung Dang Le trung...@gmail.com wrote:

I guess you want to reference the index of a repeat loop (for example,
to assign a code using the index). I think it's impossible for now but
maybe someone has a workaround.

On Monday, April 8, 2013 2:29:41 PM UTC+7, Kennedy Macharia wrote:

Dear Trung,

Thank you so much for your reply. My question is how to implement the
looping in xlsform is there a function for instance that i can use to index
particular element in the repeat. eg variablename(i).

Hope my explanation is now clear.

Regards,

Karani.

On Sun, Apr 7, 2013 at 5:02 PM, Trung Dang Le trung...@gmail.com wrote:

You can follow the exact same way of referring, as long as it's in
your repeat loop.

Trung.

On Sunday, April 7, 2013 5:21:29 PM UTC+7, Kennedy Macharia wrote:

Dear all,

I am developing a xlsform for a household survey in odk collect and
have used a repeat to capture household member, i now want to go to the
repeat and loop through checking the age of the member for a question that
is relevant to children between 3 and 18 year. Does anyone have an idea of
how this can be done.

With much regards,

Karani.

On Sun, Apr 7, 2013 at 9:59 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Thank you so much Waylon, am just from testing it and it has worked
very well!

Regards from Indepth Research Services, Nairobi, Kenya.

Karani.

On Sat, Apr 6, 2013 at 9:10 PM, W. Brunette wbru...@gmail.com wrote:

To get the repeats into CSV please use ODK Briefcase to download the
Submissions from Aggregate. ODK Briefcase is capable of generating CSVs for
repeated data.

Cheers,

Waylon

On Sat, Apr 6, 2013 at 9:32 AM, Kennedy Macharia < k...@indepthresearch.org> wrote:

Dear All,

We have developed a form with repeats in ODK and are using it for a
survey that is currenty ongoing. However when we try to download data from
aggregate (exporting) we do not get the repeats and multiple responses. Any
idea on how to go about this will be most welcome. The application is
hosted on apps engine.

Best regards,

--

--

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/groups/opt_out.

--

--

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/groups/opt_out.

--

--

--

--

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/groups/opt_out.

--

--

--

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/groups/opt_out.

--

--

--

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/groups/opt_out.

--

Mitch Sundt

Software Engineer

University of Washington

mitche...@gmail.com

--

--

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/groups/opt_out.

--

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/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com