Image files on the server

Saad · April 13, 2018, 11:06am

Hi,

I have a customized dashboard on top of ODK Aggregate, which pulls the data from the default ODK database and tables. For images, I am decoding the data direct from the VALUE column of the table FormName_ImageName_BLB. However, it is tedious and puts load on server. I also noticed that there is an image filename in FormName_ImageName_BN table, in the column UNROOTED_FILE_PATH.

Does ODK save the image file as filename.jpg anywhere on the ODK server? Which directory?

Thanks,
Saad

mathieubossaert · April 13, 2018, 1:52pm

Hi, here you'll find a discussion about that :

github.com/getodk/aggregate

Increase collected images accessibility / Store media files into database and server file system

opened 02:06AM - 28 Nov 17 UTC

getodk-bot

<a href="https://github.com/mathieubossaert"><img src="https://avatars1.githubus…ercontent.com/u/1642645?v=4" align="left" width="96" height="96" hspace="10"></img></a> **Issue by [mathieubossaert](https://github.com/mathieubossaert)** _Friday Aug 04, 2017 at 15:26 GMT_ _Originally opened as https://github.com/opendatakit/opendatakit/issues/1313 (6 comment(s))_ ---- Good evening, It's so easy to collect images with Collect that it's a little bit frustrating not to be able easily access it once they are in Aggregate. It would be a great enhancement if Aggragete could store medias files into the database and into the file system or if Aggregate could purpose a way to access stored files by unique url.

But as far as I know, no, Aggregate does not yet store medias files as files on the server.

mathieubossaert · April 13, 2018, 1:56pm

But this is a PostgreSQL-only workaround.

Saad · April 13, 2018, 2:00pm

Right. But what's the purpose of putting image name in the ODK table?

Saad · April 13, 2018, 2:06pm

Actually I am already processing the image file on my customized dashboard through a script which adjusts the UTC date/time according to the country timezone and then prints the date/time on top of image, and also compresses the image. The final image is displayed in the browser with submission date/time in its top-left corner. But this is done on the access only and so far I am not storing the modified image on the disk. If ODK provides a default image file instead of database call, it would be great. Else I would write a cronjob/script to do this thing externally.

Saad · May 23, 2018, 1:43pm

Any help on this please?