i have a requirement and want to share with you all. i have a excel form
which contains lot of choice's fields around 50,000 no. of rows in choice
sheet (XML file size about 5MB). So as per my requirement when i am
collecting data through ODK Collect, suppose a list of values there & i
have to choose one of them (as 'select_one' type) i want those list of
values should come from internal database (SQLite database of ODK Collect)
not from the XML file directly. So that form complexity would be reduce.
Process would be happen like this (as per my thinking). whenever i'll
download XML forms to ODK Collect,
select_one or select_multiple List of values will store in SQLite
database automatically & while choosing them it will fetch from the
database directly.
Please suggest me how can i achieve this functionality in ODK Collect. Your
advice and suggestion can help me a lot.
In SurveyCTO (www.surveycto.com), we have a "dynamic search and select"
feature that allows you to load multiple-choice options from pre-loaded
.csv files. In Collect, the .csv is converted into a SQLite database, and
then options are loaded as-needed into particular multiple-choice fields.
The latest ODK version of Collect also has a method for this, I believe,
though I am not sure where it has been documented. Yaw?
Best,
Chris
···
On Mon, Nov 25, 2013 at 2:55 AM, Debasis Patra wrote:
Hello,
i have a requirement and want to share with you all. i have a excel form
which contains lot of choice's fields around 50,000 no. of rows in choice
sheet (XML file size about 5MB). So as per my requirement when i am
collecting data through ODK Collect, suppose a list of values there & i
have to choose one of them (as 'select_one' type) i want those list of
values should come from internal database (SQLite database of ODK Collect)
not from the XML file directly. So that form complexity would be reduce.
Process would be happen like this (as per my thinking). whenever i'll
download XML forms to ODK Collect,
select_one or select_multiple List of values will store in SQLite
database automatically & while choosing them it will fetch from the
database directly.
Please suggest me how can i achieve this functionality in ODK Collect.
Your advice and suggestion can help me a lot.
I am not sure if it's easy on ODK already but unable to find the solution myself. I collected data in a group with loop. I wanted to load the data collected in the group loop to a select option just after the group.
···
On Monday, November 25, 2013 at 1:40:44 PM UTC+5:45, Debasis Patra wrote:
> Hello,
>
>
> i have a requirement and want to share with you all. i have a excel form which contains lot of choice's fields around 50,000 no. of rows in choice sheet (XML file size about 5MB). So as per my requirement when i am collecting data through ODK Collect, suppose a list of values there & i have to choose one of them (as 'select_one' type) i want those list of values should come from internal database (SQLite database of ODK Collect) not from the XML file directly. So that form complexity would be reduce.
>
>
> Process would be happen like this (as per my thinking). whenever i'll download XML forms to ODK Collect,
> 1. select_one or select_multiple List of values will store in SQLite database automatically & while choosing them it will fetch from the database directly.
>
>
> Please suggest me how can i achieve this functionality in ODK Collect. Your advice and suggestion can help me a lot.
>
>
> Thanks in advance.
>
>
> Debasis
Yes, ODK Collect has a method to load large external itemsets from a
.csv file and it makes for very fast form loading and navigation.
We haven't publicized the method because it's manual and ideally it
would be added to the XLSForm tool. Looks like that addition will take
some time, so until then, here's how to make your own external
itemsets: http://opendatakit.org/help/form-design/external-itemsets
Yaw
···
--
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
In SurveyCTO (www.surveycto.com), we have a "dynamic search and select"
feature that allows you to load multiple-choice options from pre-loaded .csv
files. In Collect, the .csv is converted into a SQLite database, and then
options are loaded as-needed into particular multiple-choice fields.
The latest ODK version of Collect also has a method for this, I believe,
though I am not sure where it has been documented. Yaw?
i have a requirement and want to share with you all. i have a excel form
which contains lot of choice's fields around 50,000 no. of rows in choice
sheet (XML file size about 5MB). So as per my requirement when i am
collecting data through ODK Collect, suppose a list of values there & i have
to choose one of them (as 'select_one' type) i want those list of values
should come from internal database (SQLite database of ODK Collect) not from
the XML file directly. So that form complexity would be reduce.
Process would be happen like this (as per my thinking). whenever i'll
download XML forms to ODK Collect,
select_one or select_multiple List of values will store in SQLite
database automatically & while choosing them it will fetch from the database
directly.
Please suggest me how can i achieve this functionality in ODK Collect.
Your advice and suggestion can help me a lot.
···
--
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.
On Monday, November 25, 2013 at 1:40:44 PM UTC+5:45, Debasis Patra wrote:
Hello,
i have a requirement and want to share with you all. i have a excel form which contains lot of choice's fields around 50,000 no. of rows in choice sheet (XML file size about 5MB). So as per my requirement when i am collecting data through ODK Collect, suppose a list of values there & i have to choose one of them (as 'select_one' type) i want those list of values should come from internal database (SQLite database of ODK Collect) not from the XML file directly. So that form complexity would be reduce.
Process would be happen like this (as per my thinking). whenever i'll download XML forms to ODK Collect,
select_one or select_multiple List of values will store in SQLite database automatically & while choosing them it will fetch from the database directly.
Please suggest me how can i achieve this functionality in ODK Collect. Your advice and suggestion can help me a lot.
Thanks in advance.
Debasis
Hi,
I am not sure if it's easy on ODK already but unable to find the solution myself. I collected data in a group with loop. I wanted to load the data collected in the group loop to a select option just after the group.
Thanks Yaw. I had visited the link & looked out that example. I want the
corresponding excel file of "cascading_select_external_itemsets.xml" file,
so that i'll get some idea how to design my own excel form file which will
communicate with "itemsets.csv" file for its list of values. Please
suggest..
Thank you.
Debasis
···
On Tuesday, November 26, 2013 2:22:07 AM UTC+5:30, Yaw Anokwa wrote:
>
> Chris,
>
> Yes, ODK Collect has a method to load large external itemsets from a
> .csv file and it makes for very fast form loading and navigation.
>
> We haven't publicized the method because it's manual and ideally it
> would be added to the XLSForm tool. Looks like that addition will take
> some time, so until then, here's how to make your own external
> itemsets: http://opendatakit.org/help/form-design/external-itemsets
>
> Yaw
> --
> Need ODK services? http://nafundi.comprovides form design, server
> setup, professional support, and software development for ODK.
>
> On Mon, Nov 25, 2013 at 3:18 AM, Christopher Robert <chrisl...@gmail.com > wrote:
> > Hi Debasis,
> >
> > In SurveyCTO (www.surveycto.com),
> we have a "dynamic search and select"
> > feature that allows you to load multiple-choice options from pre-loaded
> .csv
> > files. In Collect, the .csv is converted into a SQLite database, and
> then
> > options are loaded as-needed into particular multiple-choice fields.
> >
> > The latest ODK version of Collect also has a method for this, I believe,
> > though I am not sure where it has been documented. Yaw?
> >
> > Best,
> >
> > Chris
> >
> >
> >
> > On Mon, Nov 25, 2013 at 2:55 AM, Debasis Patra <debasis...@gmail.com> wrote:
> >>
> >> Hello,
> >>
> >> i have a requirement and want to share with you all. i have a excel
> form
> >> which contains lot of choice's fields around 50,000 no. of rows in
> choice
> >> sheet (XML file size about 5MB). So as per my requirement when i am
> >> collecting data through ODK Collect, suppose a list of values there & i
> have
> >> to choose one of them (as 'select_one' type) i want those list of
> values
> >> should come from internal database (SQLite database of ODK Collect) not
> from
> >> the XML file directly. So that form complexity would be reduce.
> >>
> >> Process would be happen like this (as per my thinking). whenever i'll
> >> download XML forms to ODK Collect,
> >> 1. select_one or select_multiple List of values will store in SQLite
> >> database automatically & while choosing them it will fetch from the
> database
> >> directly.
> >>
> >> Please suggest me how can i achieve this functionality in ODK Collect.
> >> Your advice and suggestion can help me a lot.
> >>
> >> Thanks in advance.
> >>
> >> Debasis
> >>
> >>
> >> --
> >> --
> >> 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.
>
Thanks Yaw. I had visited the link & looked out that example. I want the
corresponding excel file of "cascading_select_external_itemsets.xml" file,
so that i'll get some idea how to design my own excel form file which will
communicate with "itemsets.csv" file for its list of values. Please
suggest..
Thank you.
Debasis
On Tuesday, November 26, 2013 2:22:07 AM UTC+5:30, Yaw Anokwa wrote:
Chris,
Yes, ODK Collect has a method to load large external itemsets from a
.csv file and it makes for very fast form loading and navigation.
We haven't publicized the method because it's manual and ideally it
would be added to the XLSForm tool. Looks like that addition will take
some time, so until then, here's how to make your own external
itemsets: http://opendatakit.org/help/form-design/external-itemsets
Yaw
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Mon, Nov 25, 2013 at 3:18 AM, Christopher Robert chrisl...@gmail.com wrote:
Hi Debasis,
In SurveyCTO (www.surveycto.com), we have a "dynamic search and select"
feature that allows you to load multiple-choice options from pre-loaded
.csv
files. In Collect, the .csv is converted into a SQLite database, and
then
options are loaded as-needed into particular multiple-choice fields.
The latest ODK version of Collect also has a method for this, I believe,
though I am not sure where it has been documented. Yaw?
i have a requirement and want to share with you all. i have a excel
form
which contains lot of choice's fields around 50,000 no. of rows in
choice
sheet (XML file size about 5MB). So as per my requirement when i am
collecting data through ODK Collect, suppose a list of values there & i
have
to choose one of them (as 'select_one' type) i want those list of
values
should come from internal database (SQLite database of ODK Collect) not
from
the XML file directly. So that form complexity would be reduce.
Process would be happen like this (as per my thinking). whenever i'll
download XML forms to ODK Collect,
select_one or select_multiple List of values will store in SQLite
database automatically & while choosing them it will fetch from the
database
directly.
Please suggest me how can i achieve this functionality in ODK Collect.
Your advice and suggestion can help me a lot.
Hi Yaw,
This is a great feature when working with large lists. One problem I am facing is that it allows to only select one of the choices. Is there a workaround for allowing user to select multiple choices when presenting choices from external itemsets.csv.
Thanks,
Anurag
···
On Wednesday, November 27, 2013 12:52:47 AM UTC+5:30, Yaw Anokwa wrote:
> Debasis,
>
>
>
> There is no corresponding XLS. You have to manually make the XML file
>
> using the steps outlined at
>
> http://opendatakit.org/help/form-design/external-itemsets.
>
>
>
> Yaw
>
> --
>
> Need ODK services? http://nafundi.com provides form design, server
>
> setup, professional support, and software development for ODK.
>
>
>
> On Tue, Nov 26, 2013 at 2:14 AM, Debasis Patra wrote:
>
> > Thanks Yaw. I had visited the link & looked out that example. I want the
>
> > corresponding excel file of "cascading_select_external_itemsets.xml" file,
>
> > so that i'll get some idea how to design my own excel form file which will
>
> > communicate with "itemsets.csv" file for its list of values. Please
>
> > suggest..
>
> >
>
> > Thank you.
>
> >
>
> > Debasis
>
> >
>
> >
>
> > On Tuesday, November 26, 2013 2:22:07 AM UTC+5:30, Yaw Anokwa wrote:
>
> >>
>
> >> Chris,
>
> >>
>
> >> Yes, ODK Collect has a method to load large external itemsets from a
>
> >> .csv file and it makes for very fast form loading and navigation.
>
> >>
>
> >> We haven't publicized the method because it's manual and ideally it
>
> >> would be added to the XLSForm tool. Looks like that addition will take
>
> >> some time, so until then, here's how to make your own external
>
> >> itemsets: http://opendatakit.org/help/form-design/external-itemsets
>
> >>
>
> >> Yaw
>
> >> --
>
> >> Need ODK services? http://nafundi.com provides form design, server
>
> >> setup, professional support, and software development for ODK.
>
> >>
>
> >> On Mon, Nov 25, 2013 at 3:18 AM, Christopher Robert wrote:
>
> >> > Hi Debasis,
>
> >> >
>
> >> > In SurveyCTO (www.surveycto.com), we have a "dynamic search and select"
>
> >> > feature that allows you to load multiple-choice options from pre-loaded
>
> >> > .csv
>
> >> > files. In Collect, the .csv is converted into a SQLite database, and
>
> >> > then
>
> >> > options are loaded as-needed into particular multiple-choice fields.
>
> >> >
>
> >> > The latest ODK version of Collect also has a method for this, I believe,
>
> >> > though I am not sure where it has been documented. Yaw?
>
> >> >
>
> >> > Best,
>
> >> >
>
> >> > Chris
>
> >> >
>
> >> >
>
> >> >
>
> >> > On Mon, Nov 25, 2013 at 2:55 AM, Debasis Patra wrote:
>
> >> >>
>
> >> >> Hello,
>
> >> >>
>
> >> >> i have a requirement and want to share with you all. i have a excel
>
> >> >> form
>
> >> >> which contains lot of choice's fields around 50,000 no. of rows in
>
> >> >> choice
>
> >> >> sheet (XML file size about 5MB). So as per my requirement when i am
>
> >> >> collecting data through ODK Collect, suppose a list of values there & i
>
> >> >> have
>
> >> >> to choose one of them (as 'select_one' type) i want those list of
>
> >> >> values
>
> >> >> should come from internal database (SQLite database of ODK Collect) not
>
> >> >> from
>
> >> >> the XML file directly. So that form complexity would be reduce.
>
> >> >>
>
> >> >> Process would be happen like this (as per my thinking). whenever i'll
>
> >> >> download XML forms to ODK Collect,
>
> >> >> 1. select_one or select_multiple List of values will store in SQLite
>
> >> >> database automatically & while choosing them it will fetch from the
>
> >> >> database
>
> >> >> directly.
>
> >> >>
>
> >> >> Please suggest me how can i achieve this functionality in ODK Collect.
>
> >> >> Your advice and suggestion can help me a lot.
>
> >> >>
>
> >> >> Thanks in advance.
>
> >> >>
>
> >> >> Debasis
>
> >> >>
>
> >> >>
>
> >> >> --
>
> >> >> --
>
> >> >> 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: 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.
No, because select multiple doesn't make sense for cascading selects.
Perhaps you can explain the particular use case that you need to
support where you'd need select multiple?
Yaw
···
--
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
Hi Yaw,
This is a great feature when working with large lists. One problem I am facing is that it allows to only select one of the choices. Is there a workaround for allowing user to select multiple choices when presenting choices from external itemsets.csv.
Thanks,
Anurag
On Wednesday, November 27, 2013 12:52:47 AM UTC+5:30, Yaw Anokwa wrote:
Debasis,
There is no corresponding XLS. You have to manually make the XML file
Yaw,
You are right it does not make sense except when at the last stage of cascading select. In my case I am prompting user for choosing the books they have bought/ used. The list of books displayed is based upon prior selection of grade and subject. Another place where I could think of using this for school attendance where a list of students is displayed based on school and grade selection and teacher can select the students who are present (or absent since this selection would be shorter).
Regards,
Anurag
···
On Monday, February 24, 2014 5:12:43 AM UTC+5:30, Yaw Anokwa wrote:
> Anurag,
>
>
>
> No, because select multiple doesn't make sense for cascading selects.
>
> Perhaps you can explain the particular use case that you need to
>
> support where you'd need select multiple?
>
>
>
> Yaw
>
> --
>
> Need ODK services? http://nafundi.com provides form design, server
>
> setup, professional support, and software development for ODK.
>
>
>
> On Fri, Feb 21, 2014 at 4:46 PM, wrote:
>
> > Hi Yaw,
>
> > This is a great feature when working with large lists. One problem I am facing is that it allows to only select one of the choices. Is there a workaround for allowing user to select multiple choices when presenting choices from external itemsets.csv.
>
> >
>
> > Thanks,
>
> > Anurag
>
> >
>
> > On Wednesday, November 27, 2013 12:52:47 AM UTC+5:30, Yaw Anokwa wrote:
>
> >> Debasis,
>
> >>
>
> >>
>
> >>
>
> >> There is no corresponding XLS. You have to manually make the XML file
>
> >>
>
> >> using the steps outlined at
>
> >>
>
> >> http://opendatakit.org/help/form-design/external-itemsets.
>
> >>
>
> >>
>
> >>
>
> >> Yaw
>
> >>
>
> >> --
>
> >>
>
> >> Need ODK services? http://nafundi.com provides form design, server
>
> >>
>
> >> setup, professional support, and software development for ODK.
>
> >>
>
> >>
>
> >>
>
> >> On Tue, Nov 26, 2013 at 2:14 AM, Debasis Patra wrote:
>
> >>
>
> >> > Thanks Yaw. I had visited the link & looked out that example. I want the
>
> >>
>
> >> > corresponding excel file of "cascading_select_external_itemsets.xml" file,
>
> >>
>
> >> > so that i'll get some idea how to design my own excel form file which will
>
> >>
>
> >> > communicate with "itemsets.csv" file for its list of values. Please
>
> >>
>
> >> > suggest..
>
> >>
>
> >> >
>
> >>
>
> >> > Thank you.
>
> >>
>
> >> >
>
> >>
>
> >> > Debasis
>
> >>
>
> >> >
>
> >>
>
> >> >
>
> >>
>
> >> > On Tuesday, November 26, 2013 2:22:07 AM UTC+5:30, Yaw Anokwa wrote:
>
> >>
>
> >> >>
>
> >>
>
> >> >> Chris,
>
> >>
>
> >> >>
>
> >>
>
> >> >> Yes, ODK Collect has a method to load large external itemsets from a
>
> >>
>
> >> >> .csv file and it makes for very fast form loading and navigation.
>
> >>
>
> >> >>
>
> >>
>
> >> >> We haven't publicized the method because it's manual and ideally it
>
> >>
>
> >> >> would be added to the XLSForm tool. Looks like that addition will take
>
> >>
>
> >> >> some time, so until then, here's how to make your own external
>
> >>
>
> >> >> itemsets: http://opendatakit.org/help/form-design/external-itemsets
>
> >>
>
> >> >>
>
> >>
>
> >> >> Yaw
>
> >>
>
> >> >> --
>
> >>
>
> >> >> Need ODK services? http://nafundi.com provides form design, server
>
> >>
>
> >> >> setup, professional support, and software development for ODK.
>
> >>
>
> >> >>
>
> >>
>
> >> >> On Mon, Nov 25, 2013 at 3:18 AM, Christopher Robert wrote:
>
> >>
>
> >> >> > Hi Debasis,
>
> >>
>
> >> >> >
>
> >>
>
> >> >> > In SurveyCTO (www.surveycto.com), we have a "dynamic search and select"
>
> >>
>
> >> >> > feature that allows you to load multiple-choice options from pre-loaded
>
> >>
>
> >> >> > .csv
>
> >>
>
> >> >> > files. In Collect, the .csv is converted into a SQLite database, and
>
> >>
>
> >> >> > then
>
> >>
>
> >> >> > options are loaded as-needed into particular multiple-choice fields.
>
> >>
>
> >> >> >
>
> >>
>
> >> >> > The latest ODK version of Collect also has a method for this, I believe,
>
> >>
>
> >> >> > though I am not sure where it has been documented. Yaw?
>
> >>
>
> >> >> >
>
> >>
>
> >> >> > Best,
>
> >>
>
> >> >> >
>
> >>
>
> >> >> > Chris
>
> >>
>
> >> >> >
>
> >>
>
> >> >> >
>
> >>
>
> >> >> >
>
> >>
>
> >> >> > On Mon, Nov 25, 2013 at 2:55 AM, Debasis Patra wrote:
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >> Hello,
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >> i have a requirement and want to share with you all. i have a excel
>
> >>
>
> >> >> >> form
>
> >>
>
> >> >> >> which contains lot of choice's fields around 50,000 no. of rows in
>
> >>
>
> >> >> >> choice
>
> >>
>
> >> >> >> sheet (XML file size about 5MB). So as per my requirement when i am
>
> >>
>
> >> >> >> collecting data through ODK Collect, suppose a list of values there & i
>
> >>
>
> >> >> >> have
>
> >>
>
> >> >> >> to choose one of them (as 'select_one' type) i want those list of
>
> >>
>
> >> >> >> values
>
> >>
>
> >> >> >> should come from internal database (SQLite database of ODK Collect) not
>
> >>
>
> >> >> >> from
>
> >>
>
> >> >> >> the XML file directly. So that form complexity would be reduce.
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >> Process would be happen like this (as per my thinking). whenever i'll
>
> >>
>
> >> >> >> download XML forms to ODK Collect,
>
> >>
>
> >> >> >> 1. select_one or select_multiple List of values will store in SQLite
>
> >>
>
> >> >> >> database automatically & while choosing them it will fetch from the
>
> >>
>
> >> >> >> database
>
> >>
>
> >> >> >> directly.
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >> Please suggest me how can i achieve this functionality in ODK Collect.
>
> >>
>
> >> >> >> Your advice and suggestion can help me a lot.
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >> Thanks in advance.
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >> Debasis
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >>
>
> >>
>
> >> >> >> --
>
> >>
>
> >> >> >> --
>
> >>
>
> >> >> >> 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: 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 could use SurveyCTO's dynamic search-and-select feature to dynamically
load and filter options from a pre-loaded .csv -- which is more appropriate
and more efficient than putting a large number of options in the choices
sheet. In fact, we've been working with Nafundi and UW to merge that
feature into the core ODK, so we hope that it won't be too long before it's
available outside SurveyCTO (no promises yet on when that will be released,
though).
Best,
Chris
···
On Wed, Feb 26, 2014 at 10:11 PM, wrote:
Yaw,
You are right it does not make sense except when at the last stage of
cascading select. In my case I am prompting user for choosing the books
they have bought/ used. The list of books displayed is based upon prior
selection of grade and subject. Another place where I could think of using
this for school attendance where a list of students is displayed based on
school and grade selection and teacher can select the students who are
present (or absent since this selection would be shorter).
Regards,
Anurag
On Monday, February 24, 2014 5:12:43 AM UTC+5:30, Yaw Anokwa wrote:
Anurag,
No, because select multiple doesn't make sense for cascading selects.
Perhaps you can explain the particular use case that you need to
This is a great feature when working with large lists. One problem I
am facing is that it allows to only select one of the choices. Is there a
workaround for allowing user to select multiple choices when presenting
choices from external itemsets.csv.
Thanks,
Anurag
On Wednesday, November 27, 2013 12:52:47 AM UTC+5:30, Yaw Anokwa wrote:
Debasis,
There is no corresponding XLS. You have to manually make the XML file
Chris,
Thanks for your suggestions. I had a quick look. I did not think that ability to select multiple items from search-and-select feature is supported.
Regards,
Anurag
···
On Thursday, February 27, 2014 5:04:36 PM UTC+5:30, Christopher Robert wrote:
> Anurag,
>
>
> You could use SurveyCTO's dynamic search-and-select feature to dynamically load and filter options from a pre-loaded .csv -- which is more appropriate and more efficient than putting a large number of options in the choices sheet. In fact, we've been working with Nafundi and UW to merge that feature into the core ODK, so we hope that it won't be too long before it's available outside SurveyCTO (no promises yet on when that will be released, though).
>
>
>
>
> Best,
>
>
> Chris
>
>
>
>
>
> On Wed, Feb 26, 2014 at 10:11 PM, wrote:
>
>
> Yaw,
>
> You are right it does not make sense except when at the last stage of cascading select. In my case I am prompting user for choosing the books they have bought/ used. The list of books displayed is based upon prior selection of grade and subject. Another place where I could think of using this for school attendance where a list of students is displayed based on school and grade selection and teacher can select the students who are present (or absent since this selection would be shorter).
>
>
>
>
>
> Regards,
>
> Anurag
>
>
>
>
> On Monday, February 24, 2014 5:12:43 AM UTC+5:30, Yaw Anokwa wrote:
>
> > Anurag,
>
> >
>
> >
>
> >
>
> > No, because select multiple doesn't make sense for cascading selects.
>
> >
>
> > Perhaps you can explain the particular use case that you need to
>
> >
>
> > support where you'd need select multiple?
>
> >
>
> >
>
> >
>
> > Yaw
>
> >
>
> > --
>
> >
>
> > Need ODK services? http://nafundi.com provides form design, server
>
> >
>
> > setup, professional support, and software development for ODK.
>
> >
>
> >
>
> >
>
>
>
> > On Fri, Feb 21, 2014 at 4:46 PM, wrote:
>
> >
>
> > > Hi Yaw,
>
> >
>
> > > This is a great feature when working with large lists. One problem I am facing is that it allows to only select one of the choices. Is there a workaround for allowing user to select multiple choices when presenting choices from external itemsets.csv.
>
>
>
> >
>
> > >
>
> >
>
> > > Thanks,
>
> >
>
> > > Anurag
>
> >
>
> > >
>
> >
>
> > > On Wednesday, November 27, 2013 12:52:47 AM UTC+5:30, Yaw Anokwa wrote:
>
> >
>
> > >> Debasis,
>
> >
>
> > >>
>
> >
>
> > >>
>
> >
>
> > >>
>
> >
>
> > >> There is no corresponding XLS. You have to manually make the XML file
>
> >
>
> > >>
>
> >
>
> > >> using the steps outlined at
>
> >
>
> > >>
>
> >
>
> > >> http://opendatakit.org/help/form-design/external-itemsets.
>
> >
>
> > >>
>
> >
>
> > >>
>
> >
>
> > >>
>
> >
>
> > >> Yaw
>
> >
>
> > >>
>
> >
>
> > >> --
>
> >
>
> > >>
>
> >
>
> > >> Need ODK services? http://nafundi.com provides form design, server
>
> >
>
> > >>
>
> >
>
> > >> setup, professional support, and software development for ODK.
>
> >
>
> > >>
>
> >
>
> > >>
>
> >
>
> > >>
>
> >
>
> > >> On Tue, Nov 26, 2013 at 2:14 AM, Debasis Patra wrote:
>
> >
>
> > >>
>
> >
>
> > >> > Thanks Yaw. I had visited the link & looked out that example. I want the
>
> >
>
> > >>
>
> >
>
> > >> > corresponding excel file of "cascading_select_external_itemsets.xml" file,
>
> >
>
> > >>
>
> >
>
> > >> > so that i'll get some idea how to design my own excel form file which will
>
> >
>
> > >>
>
> >
>
> > >> > communicate with "itemsets.csv" file for its list of values. Please
>
> >
>
> > >>
>
> >
>
> > >> > suggest..
>
> >
>
> > >>
>
> >
>
> > >> >
>
> >
>
> > >>
>
> >
>
> > >> > Thank you.
>
> >
>
> > >>
>
> >
>
> > >> >
>
> >
>
> > >>
>
> >
>
> > >> > Debasis
>
> >
>
> > >>
>
> >
>
> > >> >
>
> >
>
> > >>
>
> >
>
> > >> >
>
> >
>
> > >>
>
> >
>
> > >> > On Tuesday, November 26, 2013 2:22:07 AM UTC+5:30, Yaw Anokwa wrote:
>
> >
>
> > >>
>
> >
>
> > >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> Chris,
>
> >
>
> > >>
>
> >
>
> > >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> Yes, ODK Collect has a method to load large external itemsets from a
>
> >
>
> > >>
>
> >
>
> > >> >> .csv file and it makes for very fast form loading and navigation.
>
> >
>
> > >>
>
> >
>
> > >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> We haven't publicized the method because it's manual and ideally it
>
> >
>
> > >>
>
> >
>
> > >> >> would be added to the XLSForm tool. Looks like that addition will take
>
> >
>
> > >>
>
> >
>
> > >> >> some time, so until then, here's how to make your own external
>
> >
>
> > >>
>
> >
>
> > >> >> itemsets: http://opendatakit.org/help/form-design/external-itemsets
>
> >
>
> > >>
>
> >
>
> > >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> Yaw
>
> >
>
> > >>
>
> >
>
> > >> >> --
>
> >
>
> > >>
>
> >
>
> > >> >> Need ODK services? http://nafundi.com provides form design, server
>
> >
>
> > >>
>
> >
>
> > >> >> setup, professional support, and software development for ODK.
>
> >
>
> > >>
>
> >
>
> > >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> On Mon, Nov 25, 2013 at 3:18 AM, Christopher Robert wrote:
>
> >
>
> > >>
>
> >
>
> > >> >> > Hi Debasis,
>
> >
>
> > >>
>
> >
>
> > >> >> >
>
> >
>
> > >>
>
> >
>
> > >> >> > In SurveyCTO (www.surveycto.com), we have a "dynamic search and select"
>
> >
>
> > >>
>
> >
>
> > >> >> > feature that allows you to load multiple-choice options from pre-loaded
>
> >
>
> > >>
>
> >
>
> > >> >> > .csv
>
> >
>
> > >>
>
> >
>
> > >> >> > files. In Collect, the .csv is converted into a SQLite database, and
>
> >
>
> > >>
>
> >
>
> > >> >> > then
>
> >
>
> > >>
>
> >
>
> > >> >> > options are loaded as-needed into particular multiple-choice fields.
>
> >
>
> > >>
>
> >
>
> > >> >> >
>
> >
>
> > >>
>
> >
>
> > >> >> > The latest ODK version of Collect also has a method for this, I believe,
>
> >
>
> > >>
>
> >
>
> > >> >> > though I am not sure where it has been documented. Yaw?
>
> >
>
> > >>
>
> >
>
> > >> >> >
>
> >
>
> > >>
>
> >
>
> > >> >> > Best,
>
> >
>
> > >>
>
> >
>
> > >> >> >
>
> >
>
> > >>
>
> >
>
> > >> >> > Chris
>
> >
>
> > >>
>
> >
>
> > >> >> >
>
> >
>
> > >>
>
> >
>
> > >> >> >
>
> >
>
> > >>
>
> >
>
> > >> >> >
>
> >
>
> > >>
>
> >
>
> > >> >> > On Mon, Nov 25, 2013 at 2:55 AM, Debasis Patra wrote:
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >> Hello,
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >> i have a requirement and want to share with you all. i have a excel
>
> >
>
> > >>
>
> >
>
> > >> >> >> form
>
> >
>
> > >>
>
> >
>
> > >> >> >> which contains lot of choice's fields around 50,000 no. of rows in
>
> >
>
> > >>
>
> >
>
> > >> >> >> choice
>
> >
>
> > >>
>
> >
>
> > >> >> >> sheet (XML file size about 5MB). So as per my requirement when i am
>
> >
>
> > >>
>
> >
>
> > >> >> >> collecting data through ODK Collect, suppose a list of values there & i
>
> >
>
> > >>
>
> >
>
> > >> >> >> have
>
> >
>
> > >>
>
> >
>
> > >> >> >> to choose one of them (as 'select_one' type) i want those list of
>
> >
>
> > >>
>
> >
>
> > >> >> >> values
>
> >
>
> > >>
>
> >
>
> > >> >> >> should come from internal database (SQLite database of ODK Collect) not
>
> >
>
> > >>
>
> >
>
> > >> >> >> from
>
> >
>
> > >>
>
> >
>
> > >> >> >> the XML file directly. So that form complexity would be reduce.
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >> Process would be happen like this (as per my thinking). whenever i'll
>
> >
>
> > >>
>
> >
>
> > >> >> >> download XML forms to ODK Collect,
>
> >
>
> > >>
>
> >
>
> > >> >> >> 1. select_one or select_multiple List of values will store in SQLite
>
> >
>
> > >>
>
> >
>
> > >> >> >> database automatically & while choosing them it will fetch from the
>
> >
>
> > >>
>
> >
>
> > >> >> >> database
>
> >
>
> > >>
>
> >
>
> > >> >> >> directly.
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >> Please suggest me how can i achieve this functionality in ODK Collect.
>
> >
>
> > >>
>
> >
>
> > >> >> >> Your advice and suggestion can help me a lot.
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >> Thanks in advance.
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >> Debasis
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >>
>
> >
>
> > >>
>
> >
>
> > >> >> >> --
>
> >
>
> > >>
>
> >
>
> > >> >> >> --
>
> >
>
> > >>
>
> >
>
> > >> >> >> 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.
You can dynamically load and filter the options for either a select_one or
a select_multiple. If you want to allow multiple selections, you would
simply use a select_multiple field.
Best,
Chris
···
On Thu, Feb 27, 2014 at 9:23 PM, wrote:
Chris,
Thanks for your suggestions. I had a quick look. I did not think that
ability to select multiple items from search-and-select feature is
supported.
Regards,
Anurag
On Thursday, February 27, 2014 5:04:36 PM UTC+5:30, Christopher Robert wrote:
Anurag,
You could use SurveyCTO's dynamic search-and-select feature to
dynamically load and filter options from a pre-loaded .csv -- which is more
appropriate and more efficient than putting a large number of options in
the choices sheet. In fact, we've been working with Nafundi and UW to merge
that feature into the core ODK, so we hope that it won't be too long before
it's available outside SurveyCTO (no promises yet on when that will be
released, though).
You are right it does not make sense except when at the last stage of
cascading select. In my case I am prompting user for choosing the books
they have bought/ used. The list of books displayed is based upon prior
selection of grade and subject. Another place where I could think of using
this for school attendance where a list of students is displayed based on
school and grade selection and teacher can select the students who are
present (or absent since this selection would be shorter).
Regards,
Anurag
On Monday, February 24, 2014 5:12:43 AM UTC+5:30, Yaw Anokwa wrote:
Anurag,
No, because select multiple doesn't make sense for cascading selects.
Perhaps you can explain the particular use case that you need to
This is a great feature when working with large lists. One problem I
am facing is that it allows to only select one of the choices. Is there a
workaround for allowing user to select multiple choices when presenting
choices from external itemsets.csv.
Thanks,
Anurag
On Wednesday, November 27, 2013 12:52:47 AM UTC+5:30, Yaw Anokwa wrote:
Debasis,
There is no corresponding XLS. You have to manually make the XML
file