Stable 2.12

This stable has the following changes:

• PyxFormToMysql controls that spaces are not used in the column "name" on select_multiple_from_file. The tool will output error 36 and XML indicating the files with problems.

Stable 2.11

This release corrects a bug when processing forms with only external selects.

Stable 2.10

Hi,

In this release, MySQLToXLSX reports the sheets created in the Excel file with their corresponding table. If the output is /out.xlsx then the tool will create a new XML file called /out.xlsx.xml with the sheets and their corresponding table names.

Stable 2.9

In this release, we upgraded the code of the STATA export so it uses multi-thread. The export also generates the labels for variables and the lookup values in separated files.

Stable 2.8

This version removes support for or_other in selects. We remove the or_other feature because if a select has it and another doesn't, the type could change between int and char and vice-versa, producing incorrect field types within a form and across sub-versions.

Also, we consider or_other a bad practice because it assumes that the code for other is "other" and the variable to store the other is [variable]_other when this could be different across languages.

Stable 2.7

In this release of ODK Tools, we removed the -i parameter from JSONToMySQL. JSONToMySQL does not store anywhere if a submission file has already been processed. This was a legacy feature from version 1.0 that we don't need anymore.

Stable 2.5.1

This is a bug fix release:

• Do not include "-desc" columns if resolve type is not 3 (include codes and names)

Stable 2.5

In this release:

• MySQLDenormalize generate JSONs as if they where created with ODK Collect
• Support for data columns. Data columns are extra columns that can be defined in the survey and choices sheet. Examples:
  - A column named TLU in the choices sheet used in the livestock list can be imported into the database. Each livestock will have a TLU value in the database and therefore it could be used in queries.
  - A column name "KPI" in the survey sheet can be used to match specific variables to Key Performance Indicators and will appear as such in the dictionary.
• Some other minor bug fixes.

Stable 2.4

This stable release:

• Has a new tool called DCFToODK that converts a CSPro DCF into an ODK Form. This tool is useful to accelerate the migration from CSPro to ODK. Note: This only converts the information in the DCF. It does not convert any logic. Each record in CSPro is translated into a repeat. All value lists are converted to option lists.
• Has support for complex languages in ODK. For example, localized languages "en-au" or ISO 639-3 codes like "kik"

Stable 2.2

This release:

• Controls selects and multi select to no have _cod or _des in their names. This breaks other code because _cod and _des is used in lookup tables.