Converts an Excel file to a JSON file to be imported in to ODK 2.0
This was written to act as a Java replacement to the JavaScript file XLSXConverter2.js for the OpenDataKit 2.0-based Poverty Stoplight project.
This project is dependent on xlsx-to-json-hamster, which does a simple Excel-to-JSON conversion. This project performs the modifications necessary for OpenDataKit so that the survey can be imported into the ODK 2.0 "Hamster" Web Service.
This project manipulates the structure of the incoming file as Java Collections objects, and exports to JSON using the Google Gson library.
When it is complete, this project will produce a JSON file in the formDef.json format for import into ODK Hamster. This is the same format produced by ODK App Designer, at least as of the Benetech fork made in fall 2016.