Picture links not working in KML export for ODK Aggregate VM

Hello,

We're using ODK Aggregate using the VM developed by Nafundi. It's working fine, but we're encountering an issue that the links to images attached to forms don't work when the submissions are exported as KMZ. Instead of the VM IP address location, the kml file contains links with a domain: http://aggregate.defaultdomain

The same concern was posted here: https://groups.google.com/forum/#!topic/geoodk-community/x1XSKqVUUR4

But I could not find a solution within the threads of this group.

Can anybody assist?

Thanks,
Rudo

Forgot to mention that we're currently running a VM with ODK Aggregate version 1.4.7; I don't know if the later versions address this issue, although I don't see it mentioned in the release notes.

Hi Rudo,

I can confirm that this is an issue on the VM.

You'll see the problem with the exports and publishers because the
images are hosted on the VM itself. And since the VM has a dynamic IP,
and can be moved around, those URLs will rarely work.

Your best bet is to use Briefcase to pull all the data and the
multimedia from the VM to your local machine, export to CSV, and use
GeoODK's Mobile Data Conversion Kit (http://geoodk.com/mdk_howto.php)
to make the KML.

Alternatively, once the data is in Briefcase, you can grab the images,
put them on some public host (e.g., Dropbox) and rewrite the URLs in
the KML you get from the VM.

Thanks, and let me know how it goes!

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Tue, May 10, 2016 at 11:52 PM, rkemper@amazonteam.org wrote:

Forgot to mention that we're currently running a VM with ODK Aggregate version 1.4.7; I don't know if the later versions address this issue, although I don't see it mentioned in the release notes.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks Yaw. In our case, the VM is set up to function pretty much permanently with a static IP generated within our LAN. Is there a way to hard code the IP address somewhere in the ODK Aggregate code?

Depends upon how you are directing traffic to it.

The configuration is described here:

You would need to set the

security.server.hostname

and the ports so that they are appropriate for your server.

This will require some experimentation.

··· On Fri, May 13, 2016 at 9:13 AM, wrote:

Thanks Yaw. In our case, the VM is set up to function pretty much
permanently with a static IP generated within our LAN. Is there a way to
hard code the IP address somewhere in the ODK Aggregate code?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Thank you Mitch. Where can I find the relevant Aggregate files on the ODK-Aggregate VM server? I can't find any of those files in the Linux file tree.

The ODK Aggregate website files will be in the Tomcat server's webapps
directory. Not sure where that is on this VM -- perhaps under /www If you
search for ODKAggregate-settings.jar on the VM, it should have only one
match.

··· On Fri, May 13, 2016 at 9:59 AM, wrote:

Thank you Mitch. Where can I find the relevant Aggregate files on the
ODK-Aggregate VM server? I can't find any of those files in the Linux file
tree.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

It should be in
/var/lib/tomcat6/webapps/ROOT.war/WEB-INF/lib/ODKAggregate-settings.jar/security.properties

The right way to do it is to stop Tomcat, then start from the ROOT.war
file, unzip that, then unzip WEB-INF/lib/ODKAggregate-settings.jar to
get to the security properties file. Then edit that properties file,
rezip the jar and the war.

If you can wait a few days, I'll write a script that can do it. I have
it already, but I need to test it to make sure it works well.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Fri, May 13, 2016 at 7:17 PM, Mitch Sundt mitchellsundt@gmail.com wrote:

The ODK Aggregate website files will be in the Tomcat server's webapps
directory. Not sure where that is on this VM -- perhaps under /www If you
search for ODKAggregate-settings.jar on the VM, it should have only one
match.

On Fri, May 13, 2016 at 9:59 AM, rkemper@amazonteam.org wrote:

Thank you Mitch. Where can I find the relevant Aggregate files on the
ODK-Aggregate VM server? I can't find any of those files in the Linux file
tree.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

That would be fantastic, Yaw! Thanks for your assistance.

Seems like everything is resolved, but just wanted to let you know that
there is also a online converter for geopoint,geoshape and geotrace here.
You might find useful

http://geoodk.com/xlsform_converter.php#xlsgeoconverter

Github code if you want on you own server.

Best,
Jon

··· On Friday, May 13, 2016 at 2:27:06 PM UTC-4, rke...@amazonteam.org wrote: > > That would be fantastic, Yaw! Thanks for your assistance.

Hi folks,

I've put the script that updates the war hostname at
https://gist.github.com/yanokwa/1585d7f79b2af06b702505f606cbd362

It's tested on my systems, and worked for Rudo, but nothing is
bug-free. Please make sure no one is submitting data, then take a
snapshot or backup of the VM before you run this.

You have to get this script inside the VM, and then run it like so:

$ chmod +x ./update-war-hostname.sh
$ ./update-war-hostname.sh your_static_ip

The script stops Tomcat, makes a backup of the ROOT.war, patches it to
have your new hostname, then restarts Tomcat.

If you get infinite redirects in Aggregate after you run the script,
try opening an incognito/private mode window on your browser (or try a
new browser) and see if that works.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Fri, May 13, 2016 at 9:39 PM, Jon Nordling jonnordling@gmail.com wrote:

Seems like everything is resolved, but just wanted to let you know that
there is also a online converter for geopoint,geoshape and geotrace here.
You might find useful

http://geoodk.com/xlsform_converter.php#xlsgeoconverter

Github code if you want on you own server.

https://github.com/GeoODK/xls-geoconverter

Best,
Jon

On Friday, May 13, 2016 at 2:27:06 PM UTC-4, rke...@amazonteam.org wrote:

That would be fantastic, Yaw! Thanks for your assistance.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.