Manage big list (20 000+) of choices in ODK

Hello,
We're using ODK to collect data relative to hospitals in various countries.
The first questions are typically about selecting a province/district and
then the facility using a cascading select.

The problem is that for our biggest project we have more than 20 000
facilities at the last level. We managed to create the form and upload it
using the ONA service, but it won't open in ODK (it wait for a long time
then crash).

Our current solution has been to "split" that form into identical parts
dedicated to each province, but it's not really practical.

Any advice/experience with very large choices? The ODK doc refer to the
option of putting long lists into separated CSV file, has anyone
experience with this?

Thanks a lot,

Martin

··· -- *Martin Van Aken - **Freelance Enthusiast Developer*

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken http://twitter.com/martinvanaken
Call me on Skype : vanakenm
Hang out with me : martin@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com

Hi Martin,

Are you using the pull csv function or are you creating the entire list in
the form? If it's in the form it's likely it will crash due to its size.
Give pull csv a shot. I think it would work for you.

Thanks,

Matt

··· On Mon, Jan 2, 2017 at 2:28 PM Martin Van Aken wrote:

Hello,
We're using ODK to collect data relative to hospitals in various
countries. The first questions are typically about selecting a
province/district and then the facility using a cascading select.

The problem is that for our biggest project we have more than 20 000
facilities at the last level. We managed to create the form and upload it
using the ONA service, but it won't open in ODK (it wait for a long time
then crash).

Our current solution has been to "split" that form into identical parts
dedicated to each province, but it's not really practical.

Any advice/experience with very large choices? The ODK doc refer to the
option of putting long lists into separated CSV file, has anyone
experience with this?

Thanks a lot,

Martin

--
*Martin Van Aken - *Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken http://twitter.com/martinvanaken
Call me on Skype : vanakenm
Hang out with me : martin@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.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/d/optout.

Hi Matt,
Thanks for the quick reply - for now we are putting the choices directly in
the form. I saw the doc about the CSV option, but I was interested in
experience/validation on that choice (it's a bit of work on our side) -
which you just provided, so I'll try it.

Regards,

Martin

··· On Tue, Jan 3, 2017 at 5:59 AM, Matt Berg wrote:

Hi Martin,

Are you using the pull csv function or are you creating the entire list in
the form? If it's in the form it's likely it will crash due to its size.
Give pull csv a shot. I think it would work for you.

Thanks,

Matt

On Mon, Jan 2, 2017 at 2:28 PM Martin Van Aken martin@joyouscoding.com wrote:

Hello,
We're using ODK to collect data relative to hospitals in various
countries. The first questions are typically about selecting a
province/district and then the facility using a cascading select.

The problem is that for our biggest project we have more than 20 000
facilities at the last level. We managed to create the form and upload it
using the ONA service, but it won't open in ODK (it wait for a long time
then crash).

Our current solution has been to "split" that form into identical parts
dedicated to each province, but it's not really practical.

Any advice/experience with very large choices? The ODK doc refer to the
option of putting long lists into separated CSV file, has anyone
experience with this?

Thanks a lot,

Martin

--
*Martin Van Aken - *Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken http://twitter.com/martinvanaken
Call me on Skype : vanakenm
Hang out with me : martin@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.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/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.

--
*Martin Van Aken - *Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken http://twitter.com/martinvanaken
Call me on Skype : vanakenm
Hang out with me : martin@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com

Yes definitely give it a shot. It's designed specifically to help address
this use case. Enketo has also been updated to help handle very large CSV
lookups too without compromising on performance.

··· On Tue, Jan 3, 2017 at 11:00 AM, Martin Van Aken wrote:

Hi Matt,
Thanks for the quick reply - for now we are putting the choices directly
in the form. I saw the doc about the CSV option, but I was interested in
experience/validation on that choice (it's a bit of work on our side) -
which you just provided, so I'll try it.

Regards,

Martin

On Tue, Jan 3, 2017 at 5:59 AM, Matt Berg mlberg@gmail.com wrote:

Hi Martin,

Are you using the pull csv function or are you creating the entire list
in the form? If it's in the form it's likely it will crash due to its size.
Give pull csv a shot. I think it would work for you.

Thanks,

Matt

On Mon, Jan 2, 2017 at 2:28 PM Martin Van Aken martin@joyouscoding.com wrote:

Hello,
We're using ODK to collect data relative to hospitals in various
countries. The first questions are typically about selecting a
province/district and then the facility using a cascading select.

The problem is that for our biggest project we have more than 20 000
facilities at the last level. We managed to create the form and upload it
using the ONA service, but it won't open in ODK (it wait for a long time
then crash).

Our current solution has been to "split" that form into identical parts
dedicated to each province, but it's not really practical.

Any advice/experience with very large choices? The ODK doc refer to the
option of putting long lists into separated CSV file, has anyone
experience with this?

Thanks a lot,

Martin

--
*Martin Van Aken - *Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken http://twitter.com/martinvanaken
Call me on Skype : vanakenm
Hang out with me : martin@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.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/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.

--
*Martin Van Aken - *Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken http://twitter.com/martinvanaken
Call me on Skype : vanakenm
Hang out with me : martin@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.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/d/optout.