Thanks for your help - hoping that someone from the ODK team can help with a direct solution. I'm guessing this might be useful if you were, for example wanting to link the data to google maps.
I found the relevant information from this link: and adapted it for this purpose.
In case it helps, this formula changes the hyperlink (SUBSTITUTE) from "open?id=" to "/uc?export=download&id=", which loads the file rather than opens a new window, and the IMAGE part does what you might imagine and shows an image rather than the hyperlink. I can see that this would be a way to deal with it, but means another 'dependency' rather than being part of ODK - it would be much more useful (in my opinion) to include the filename within the spreadsheet when ODK Collect sends the data, as this would be updated whenever new records are submitted.Īlthough it doesn't solve my problem I found a useful way of show the images within the spreadsheet using a formula in an additional column (again, not a solution, but a helpful measure): Sheets uses one column Y,X (a Google convention or just Lat, Long?) whereas Briefcase exports 2 columns -Latitude and -longitude. While I'm at it, it would be really useful for Google Sheets to store location data in the same format as Briefcase exports it - again merging data is more of a hassle than I expected. I think this is the same as but I can't see a solution here or on the related thread. I can then visualise / analyse the data locally when I have no internet connection (common). I have tried using the google sheets script mentioned above but this doesn't appear to give me access to the image name (maybe it's not even intended to do so now I study the script itself!).Įssentially I want to be able to use my data offline, so exporting to excel / csv (with image name column that matches the downloaded images).
#DIRECT URL TO GOOGLE DRIVE IMG FULL#
However I can batch rename them to remove the full path. This makes it hard to integrate with data imported from Briefcase (where the cell contents refer to the image name and relative path, e.g. I have found that the images are stored in a separate folder and have the 'full path' from my phone as their name i.e.
#DIRECT URL TO GOOGLE DRIVE IMG DOWNLOAD#
However, when I download the spreadsheet I only have a hyperlink, which does not allow me to access the images directly, or the image names. This appeared to be a really useful way of collating data from a small team rather than using Aggregate or Central (I am notoriously useless at installing and configuring the server!) I have a similar issue - I have collected data on the phone and uploaded it to Google Sheets.
Rather than start a new topic, I am reviving this thread as I can't see that it has been resolved.
0 kommentar(er)
