Exporting Formhub data to JSON files

Few weeks ago we installed FormHub in one of our servers at ILRI. Formhub is an online system for aggregating ODK data coming from mobile devices. The data is stored in a Mongo Database. Although Formhub provides exporting features to CSV and Excel it does not provide exporting to more interoperable formats like JSON.

I created a small Python program that connects to a Formhub database and extracts survey data into a directory using the Survey ID as filter. Each data submission is exported as a JSON file using the UUID as file name.

You can get it from here

The long-awaited post and ODK Viewer

I have been programming software for the past 18 years, had a web-server for the past 10, it is until now that I started a blog about programming and it took me ages to decide on my first post. Quite ridiculous!

Nevertheless I think I can share one of the latest tools I have been working on.

ODK Viewer is a tool for Android devices to visualize ODK (Open Data Kit) data in tabular form. It allows loading, visualizing and editing ODK XML data.

You can grab the code and the APK @ https://github.com/ilri/odkviewer