Quick question - just migrating to ODK Central and this comes with its list of question. First one for the day, can the Odata feed be connected to Google Sheets? The links I am reading from, I find them quite unreliable of sorts. Any ideas on this please?
Hello @yanokwa. Writing on behalf of @Prasanna_Sundaram. We need it in Google sheet because we have created ready to use individual forms for end users so that live data could be uploaded. in case the data could be linked to google sheets, the results would be live.
Have to explore yet on other platforms. We have done that in the past on google sheets and clients are comfortable with that.
@yanokwa We primarily work with schools of lower socio economic status in India, and for most of them a higher end technology like PowerBI is still a few miles away. They prefer and are comfortable with more static options like Excel and Google Sheets.
Between Excel and Google Sheets again, Google sheets is live, real-time, the integration of form creations to certain administrative files they need are much more real time. With Excel its an extra step for them to work with Excel online.
Finally, we have set up and trained folks to be comfortable on Google Sheets, drive access, sharing etc. so for all purposes, the demography we work with is finally comfortable with google sheets now and if it can be avoided to re-invent the wheel, then we would like to do that.
hi all: your explanation makes sense for why you are trying to use google sheets.
but if excel is available, you might be interested to know that they've done a lot of work under the covers on live and sync'd data cases, and in this case because it natively understands odata, it may be the more robust choice. google sheets seems more live/realtime because it is more responsive to direct human input, but because 1) it is used to being the sole "truth" and in this case it is not, and 2) it does not natively understand odata, i worry that it may actually be the more difficult choice.
in either case, two observations might be helpful for you:
whether you use excel or google sheets, i would suggest an architecture where there is one imported source of truth of ODK data, a separate source of truth on data collect via the google form, and to merge those two into a third final product which is read-only. this will minimize issues where if the synchronization fails you no longer know which rows are truth and which are broken.
odata sounds fancy but really it is just JSON. the odata part of it additionally specifies a standard schema definition format (which we provide) and a write-back query for modifying data (which we do not support). so if you can't find a good odata-related tool, but you already understand what your own data schema is, then any tool that understands JSON will do just fine.