Hi everybody,
I would like to populate a field in a ODK form with a data that I have
to take (in real time) from an external source, via an SQL query to a
MySQL database. I tried it using an External Apps procedure
(https://opendatakit.org/help/form-design/external-apps/) but I cannot
make it works.
My query has this format:
http://ortelius.cmima.csic.es:8080/SadoWS/DataQuery?BaseDatos=SADO&grupo=posicion
and return the following text y the browser:
/fecha,longitud,latitud,longitud,latitud,rumbo,velocidad,profundidad,cog,sog,fecha_telegrama
2011-11-30T13:59:24.0,//-18.1232782,27.9093235//,-18.1232782,27.9093235,144.7,4.9,2892.05,150,4.9,2011-11-30 13:59:24.0/
I need the bolt fields in my ODK Form (-18.1232782,27.9093235 ).
Any idea?
Thanks a lot.
Miguel
Balearic island
Spain
This would generally require that you write an external application to
access that external database.
ยทยทยท
On Fri, Jan 23, 2015 at 3:16 AM, Casa Felechu < casafelechu@asturiascasaaldea.es> wrote:
Hi everybody,
I would like to populate a field in a ODK form with a data that I have to
take (in real time) from an external source, via an SQL query to a MySQL
database. I tried it using an External Apps procedure (
https://opendatakit.org/help/form-design/external-apps/) but I cannot
make it works.
My query has this format:
http://ortelius.cmima.csic.es:8080/SadoWS/DataQuery?BaseDatos=SADO&grupo=posicion
and return the following text y the browser:
fecha,longitud,latitud,longitud,latitud,rumbo,velocidad,profundidad,cog,sog,fecha_telegrama
2011-11-30T13:59:24.0,-18.1232782,27.9093235,-18.1232782,27.9093235,144.7,4.9,2892.05,150,4.9,2011-11-30 13:59:24.0
I need the bolt fields in my ODK Form (-18.1232782,27.9093235 ).
Any idea?
Thanks a lot.
Miguel
Balearic island
Spain
--
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