<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Sam<div><br></div><div>I guess you had a look at : <a href="http://code.google.com/p/opendatakit/wiki/ODKAggregate">http://code.google.com/p/opendatakit/wiki/ODKAggregate</a></div><div><br></div><div>On the FAQ section they mention Aggregate on MySQL but the link doesn't seem to go anywhere useful.</div><div><br></div><div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; line-height: 16px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><strong>What other servers can I use?</strong><br>There is ongoing work to support <a href="http://code.google.com/p/opendatakit/source/browse/#svn/branches/uw/aggregate-local" rel="nofollow" style="color: rgb(0, 0, 204); ">Aggregate on MySQL</a>, <a href="http://openmrs.org/" rel="nofollow" style="color: rgb(0, 0, 204); ">OpenMRS</a>, <a href="http://www.openxdata.org/" rel="nofollow" style="color: rgb(0, 0, 204); ">OpenXData</a>, <a href="http://www.healthnet.org/" rel="nofollow" style="color: rgb(0, 0, 204); ">GATHER</a>, <a href="http://www.sahana.lk/" rel="nofollow" style="color: rgb(0, 0, 204); ">Sahana</a>, <a href="http://episurveyor.org/" rel="nofollow" style="color: rgb(0, 0, 204); ">EpiSurveyor</a>, and <a href="http://drupal.org/" rel="nofollow" style="color: rgb(0, 0, 204); ">Drupal</a> as backends. ODK Aggregate currently supports passing data to <a href="http://docs.google.com/" rel="nofollow" style="color: rgb(0, 0, 204); ">Google Spreadsheets</a>, <a href="http://tables.googlelabs.com/Home?pli=1" rel="nofollow" style="color: rgb(0, 0, 204); ">Google Fusion Tables</a> and <a href="http://www.rhizalabs.com/products/insight/overview/" rel="nofollow" style="color: rgb(0, 0, 204); ">Rhiza Insight</a>.</span></div><div><br></div><div>Alex</div><div><br><div><div>On 02/09/2011, at 16:23 , Sam Wilson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Thanks Alex!<br><br>Looks like an interesting project, thanks for sharing. And very applicable to<br>tracking wooden power poles in WA! :-)<br><br>It is indeed the OpenDataKit systems that I've been looking at. The<br>ODKCollect runs on Android and seems to do pretty much what we want. <br>Unfortunately, there's a few missing pieces, like: what to do with the xforms<br>once they're back on the server; how to prefill data in the forms that are<br>downloaded; etc.<br><br>It just seems likely that this sort of data collection stuff has been done<br>before, and (hopefully) with free software. I like the Openrosa approach<br>because I'd like to be able to contribute something back to that community<br>(probably only documentation, that sort of thing), but really I've not got the<br>time to do as much as I'd like... hence, seeking someone else with the skills.<br> :-) (Anyone looking for a job?)<br><br>Anyway, Friday arvo now! Time for a beer and some *more fun* coding.... :-)<br><br>Thanks,<br>Sam.<br><br>On Fri, September 2, 2011 10:38 am, Alexander Hartner wrote:<br><blockquote type="cite">Hi Sam,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">In a previous live I worked for Helveta (<a href="http://helveta.com">http://helveta.com</a>). There we<br></blockquote><blockquote type="cite">designed and developed software for handhelds (in that case Windows Mobile<br></blockquote><blockquote type="cite">based) devices and backend software to process the collected data. In one<br></blockquote><blockquote type="cite">application we collected GPS location for exotic timber to track individual<br></blockquote><blockquote type="cite">trees from stump to the final product. Trees were bar coded which the devices<br></blockquote><blockquote type="cite">fitted with scanners and GPS were able store. The operator then added some<br></blockquote><blockquote type="cite">additional information about the tree, such as species, circumference etc<br></blockquote><blockquote type="cite">manually.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">The devices were offline in this case as often the operator had to travel off<br></blockquote><blockquote type="cite">the trodden path. Every so often they would sync the device with the server<br></blockquote><blockquote type="cite">which would then produce various reports for analysis.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Here is a picture showing the bar-code and the device.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">So much to my experience. Now to your issue. I had a look at the openrosa<br></blockquote><blockquote type="cite">website, but didn't find a download / screen shots. So I am not sure they have<br></blockquote><blockquote type="cite">a product or are still working on something.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">After a bit of googling I found :<br></blockquote><blockquote type="cite"><a href="http://code.google.com/p/opendatakit/wiki/ODKCollect">http://code.google.com/p/opendatakit/wiki/ODKCollect</a> which seems to be doing<br></blockquote><blockquote type="cite">what you want.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">There is a list of various implementations available on Wikipedia though:<br></blockquote><blockquote type="cite"><a href="http://en.wikipedia.org/wiki/XForms">http://en.wikipedia.org/wiki/XForms</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Technically XForms seems like the way to go. It does most if not all the<br></blockquote><blockquote type="cite">things we had to implement ourselves back then.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I had a look at the android app store and only found one match for xforms. Do<br></blockquote><blockquote type="cite">you already have a client app for this in mind ?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Your challenge I guess is to find the most mature implementation.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Hope this helps<br></blockquote><blockquote type="cite">Alex<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Begin forwarded message:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">From: "Sam Wilson" <<a href="mailto:sam@archives.org.au">sam@archives.org.au</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Subject: [plug] OpenRosa/OpenDataKit expertise, anyone?<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Date: 2 September 2011 09:59:49 AWST<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">To: <a href="mailto:plug@plug.org.au">plug@plug.org.au</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Reply-To: <a href="mailto:plug@plug.org.au">plug@plug.org.au</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hi,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I work for a contractor for Western Power and we're investigating the use of<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">OpenRosa tools for field data collection.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://openrosa.org/">http://openrosa.org/</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">(Basically: an android client downloads xforms from a server, fills them in,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">and sends them back. The specs for each part are pretty well defined.)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Has anyone here had any experience with this sort of thing, and interested<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">in<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">consulting? Or know anyone in Perth who might?<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Or, equally: what other avenues of FOSS-based field data collection I should<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">investigate? :-)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Thanks!<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">- Sam.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">PLUG discussion list: <a href="mailto:plug@plug.org.au">plug@plug.org.au</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://lists.plug.org.au/mailman/listinfo/plug">http://lists.plug.org.au/mailman/listinfo/plug</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Committee e-mail: <a href="mailto:committee@plug.org.au">committee@plug.org.au</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">PLUG Membership: <a href="http://www.plug.org.au/membership">http://www.plug.org.au/membership</a><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><br><br>_______________________________________________<br>PLUG discussion list: <a href="mailto:plug@plug.org.au">plug@plug.org.au</a><br><a href="http://lists.plug.org.au/mailman/listinfo/plug">http://lists.plug.org.au/mailman/listinfo/plug</a><br>Committee e-mail: committee@plug.org.au<br>PLUG Membership: http://www.plug.org.au/membership<br></div></blockquote></div><br></div></body></html>