Working with images stored in Aggregate
I am running ODK-Aggregate-v1.5.0-Linux-x64.run on PostgreSQL10.x Ubuntu 14:04 / 16:04 tomcat8.
When pulling from briefcase or export forms to csv I get a path for the images i.e. http://server:8080/project_name/view/binaryData?blobKey=FORM_A[%40version%3Dnull+and+%40uiVersion%3Dnull]%2FPROJECT_FORM_A_points[%40key%3Duuid%3A971977f8-537c-43b0-8406-d7ac4e02175e]%2Fimage_a
which when used in html I can display and amend display through CSS codes in QGIS Atlases, Reports and Layouts.
I have developed a method for myself which runs SQL scripts through CRON jobs on the aggregate schema which does the prep and manipulates of the field collected data and then moves it to public schema for use in QGIS and other front end tools... This runs really well and keeps the ODK data separate and constantly updates the layers in the databases public schema both spatial and non-spatial data making it current or as near real time as possible. WHY? a big saving is space as the image is only stored once in the odk schema but referenced many times for visualization. It reduces manual tasks in my workflow of downloading csv files and briefcase malarkey. The missing link to full automation is how to get the path as demonstrated above from the aggregate side. I'm not clever enough to reverse engineer the path as used on the aggregate site on 8080, but I know its available, I just need help to get it out so I can include the path in the tuple for referencing