ODK Collect with Google Sheets as a server
HTML-код
- Опубликовано: 15 июл 2024
- EDIT: This video is out of date and the steps described sadly do not work any more, but ODK lives on so go check it out!
This video shows an open source and free way to collect forms on an Android device with advanced features and offline capabilities. If you are wondering whether ODK is right for you, this is probably one of the quickest ways to give it a try. What is the difference between using ODK Aggregate and Google Drive as a server?
EDIT: The link to the XLSform converter has changed since I made the video:
getodk.org/xlsform/
Thanks for watching!
@rfletch0
Thanks to the ODK Community
forum.opendatakit.org
opendatakit.org/
xlsform.org/
Brief intro to the whole of ODK:
• ODK Brief Intro
How to install ODK Aggregate:
• Installing ODK Aggrega...
More that I've written about ODK:
rfletch0.wordpress.com/2017/0...
Using an e-reader with ODK Collect:
• E-ink vs Paper questio... 
Наука
Thanks for this great video! I had no idea this was possible!
Great video. best platform for testing surveys
Richard thanks this is very helpful
Really great tutorial
Thx pro. Have a nice day 🌹
Great video!!!
Many many thanks for this great tool
Friend thank you very much, your video helped me a lot. Really thank you
David Bustos Pulido thank you! (and the developers/community!)
Really helpful
thanks for great video
Really a great video. if possible make a full video on using the odk app for a beginner.
thank you
Many thanks for this amazing video, but i have a question where did bring this field submission URL? Please tell did you add it in the questionnaire or you added by yourself that would be a great help if you explain this. Please
Hi - I talk about this from about 2m50s in the video - use the "share" link from Google sheets, whatever file you want to be the destination for your results. Now you bring it up - I realized I have missed a step in the guide, to set up this file first. Basically it is just a blank spreadsheet in Google Sheets. Hope that helps
nice informative video. boss i have a question.is there any way around to upload existing data in database and download that data in ODK Collect App for further edit ????
Hi, I don't think ODK Collect does this, but I would look up ODK-X which is based around some similar elements but with more complex/advanced features
@@richardfletcher9410 please let me know about it. Thanks so much for your time and consideration
Thanks for this great video. I just had a question that I have two forms uploaded into google drive, but when I used ODK application to get the form, ODK application allows me to get only one form. Is it the restriction of that? THanks
Good question, unfortunately I've not tried it with more than 1 form at a time. I assume the forms are both valid, have you tried each one separately from the other? It would be useful for you to let the community know over at the forums forum.getodk.org/
Good luck and thanks!
very useful! thank you for this! A side question: what Android emulator are you using in the video? I need to get something for virtual trainings of enumerators, etc.
Hi it was a while ago but I am pretty sure it was Vysor - it was an app to display my phone on the PC - I think there is a free and paid version for more features. I suppose an emulator could work as well? Good luck with your project!
Hi Richard Fletcher, great tuts, thank you so much. I have a problem on how to convert excel sheet into machine readable form, because the i can find the new domain?
Hi Mohamed thanks for bringing this to my attention, the website has been changed since so I think the new address you are looking for is : getodk.org/xlsform/
I've put it in the description of the video as well
Wonderful video. However the Start GeoPoint just keep going and going, despite going outside to get a point. Is there any specific setting I should do?
Caroline Craig thanks!
Unfortunately I don't know much about the GPS/geopoint features, I've never had the excuse to try them out. If you ask over at the ODK forum maybe someone else will know? forum.opendatakit.org/
Thanks for the reply!
Hi @Richard Fletcher. I've just started to use ODK Collect and I have successfully set up my google drive as my server. Thanks for the tutorial.
I have 2 questions;
1. How many users can access the google drive at the the same time?
2. Will I have to add the gmail account to all their phones?
I would really appreciate a timely reponse
Hi, I'm glad you're finding it useful. I can't see why multiple users would not work - although I haven't tried it myself. 1 login between multiple devices would be my first idea, or perhaps a login per device with all accounts given access/permission to the same google drive/sheet.
Possibly if you were simultaneously sending responses very close together but even then if it can't send at one time, you can try again later. As noted in the video this approach is not as fast as other servers. With ODK Collect it saves each response as they are finalized locally to each device. It wont delete until it has confirmed that the data has been transferred, and you can change that option as well if you want. You can even download locally off devices with ODK Briefcase, no connection required.
Thanks for the video, but I am having problems to submit the finalized forms to Google drive, I got a 404 error, Im using my account in both sides but the error still even verifying the correct url with permission in gdrive
Hi, sorry about that, have you tried asking in the forum.opendatakit.org - Have you managed to submit other finalized forms to any other types of server (for example the demo aggregate server at opendatakit.appspot.com)
Hi Thankyou for the very helpful video. I have one concern, how can we attach data-sets and media files in this method?
Hi Kazim thank you. It does seem to be possible to use media with this method - both media as part of a question (eg images for options) and to send media as an answer (eg take a photo and send it). However if media is important to your use, I would look at setting up ODK Aggregate on Digital Ocean which is the current recommended method if you've never done it before: docs.opendatakit.org/aggregate-digital-ocean/
If you are thinking of something more complex with two way data sync then ODK X may be the more advanced version you need: docs.opendatakit.org/odk-x/
There is also the forum to ask for help: forum.opendatakit.org/
Thank you for this video,I think this ODK is great... I hope I can learn more about it quickly...
Pls the GPS location accuracy of the odk collect is not reading ,what should I do?
Hi - it could be something to do with your device: docs.getodk.org/collect-location/ or it could be something to do with how the form has been written: xlsform.org/en/#gps-with-accuracythreshold --- there are quite a lot of posts on the form about GPS as well: forum.getodk.org/t/gps-accuracy-and-accuracythreshold-issues/12645 --- good luck!
How can I see the points on a maps?
Hi, sorry I don't know much about the Geopoint or GPS features. You could try asking at the forum: forum.opendatakit.org
Good
Pls in the ODK collect app the GPS location accuracy is not reading, pls what should I do?
hi i have a problem with KOKO i cannot skip more than one question! Please help1
Hi, do you mean KOBO Toolbox? I am not familiar with that version of ODK. It's probably worth asking in the forums: forum.opendatakit.org/
@@richardfletcher9410 Thanks you for your respond! I've found the way now!!
Failing to submit filled form to google drive: I successfully added a url but my form can not submit. It says 400 bad request. Message: This operation is not supported for this document
Hi - sorry about your error. I am not 100% sure if this approach still works with the current version of ODK. Ask in the forums: forum.getodk.org/ Good luck
I need to add offline maps to ODK collect. you can guide me?
Hi, I think this is possible however my knowledge is a bit out of date now. Try the ODK forums, they're great!
How to add image next to radio button.?
Hi - this would make use of the Media function: xlsform.org/en/#media
Here is a post on the ODK forums that solves a similar issue with examples:
forum.opendatakit.org/t/adding-small-photo-with-each-answer/9533/10
I don't think I've tried this with Google Sheets specifically, but I can't see why it wouldn't work: when the other route for media files works.
Good luck!
After the form is filled, I can't send to the google drive. help me with this plz
If you mean in the ODK Collect app, Main menu -> Server Settings -> Type - select Google sheets/drive from there.
Not sure if that's what you meant but hope it helps. Also you could ask in: forum.opendatakit.org
@@richardfletcher9410 thank u for your repply. I follow this video every step. but the problem is that when I finished answer the form, I couldnt send finalised form to the sheet created in excel. I have no idea why
I had the same problem, and my solution was create the blank sheet directly on google drive and no create it on my computer and after upload it on google drive. the problem was fixed.
please help to understand more from excel to xlsform
Hi, this video might help: ruclips.net/video/XPpORIP7KsI/видео.html
Or you could try asking at the forum: forum.opendatakit.org/
Or this site has a very thorough explanation of all the possible XLSFORM options: xlsform.org/en/
Thanks
xlsform.org/en/#appearance
choices tab is missing from the video.
Very helpful video but my my form not submission
Hi, you can try asking for help at forum.opendatakit.org
ODK doesn't allow this anymore, and it infuriates me.
Hi thanks for letting me know. I haven't used ODK in a while so I have added a note to the description of the video.
عربي ياليت مترجم