Dynamically loaded multiple-choice data with Google Drive

Issue: I'm using ODK with Google Drive/Sheets as described here. I would like to create multiple, conditional select lists / dropdowns (e.g., state --> city) using an externally pulled-in CSV.

I don't know how to get my smartphone to "find" the CSV file and pull it in.

Right now I have it sitting in the same directory as the XML on Google Drive. The XML is pulled in but not the CSV. I have also tried putting it in a directory, [XML]-media. The ODK running on my phone doesn't seem to see it and pull it in.

Here is one of the more complicated examples I have tried: https://opendatakit.org/downloads/download-info/sample-searchandselect-form/

I set up my stuff using this short tutorial: http://macbio-pacific.info/wp-content/uploads/2017/06/ODK_Google_Documentation.pdf

Hi @mariaplaying. I haven't tried this feature in a while, but this sounds like a bug to me. @Grzesiek2010, can you take a look at this one and try to reproduce it with the form at https://opendatakit.org/downloads/download-info/sample-searchandselect-form. My guess is that there is something odd about the form title/name or maybe CSVs aren't downloaded, but other media types are?

Oh, and Maria, when you get a chance, please introduce yourself here. I'd also encourage you to add a real picture as your avatar because it helps build community!

The form itself works well but I can confirm that we are not able to download media files using GD. This option is just not implemented. Looking at the code we just download an xml file.
I reported this issue https://github.com/opendatakit/collect/issues/1591

1 Like

@mariaplaying Please try your form with Collect v1.11.1 now available in the Play Store. This should fix the issue. Thanks, @Grzesiek2010!

Hello, Helene. Thanks for the note. I'll give it a try on Collect v1.11.1 but I'm not sure where to place the file and how to name it so that it is picked up.

Second, it seems this feature has not been implemented (per Grzesiek2010 and yanokwa) and their notes on github.com. So, shall I give the new version of Collect a try or wait to hear from the Bithub folks?

Hello there, yanokwa. Nice to meet you. I believe I have put an introduction in the right place.

Thanks for the response and for tackling this issue. I'll keep an eye on bithub for a solution. Please let me know if it is simply a matter of upgrading Collect.

It's just a matter of upgrading to v1.11.1.

Once you do that, put form.xml and form-media/my-file.csv on your Google Drive. Then when you download form.xml, it will automatically download all the media files in the form-media folder.

Great news! I'll give it a try. Thanks!

A post was split to a new topic: Select one text and image from loaded csv

@yanokwa and @mariaplaying I am trying to pull data while using ODK with google drive. Is there any video which can help me set it up? or a detailed document?

Thanks in advance.

You can try this video https://www.youtube.com/watch?v=GnXwGmhaI9U


Thank you @Grzesiek2010

One of the best resource for starting with ODK and Google Drive.