Stable 2.36.0

This release fixes the following bugs

• Control space characters in CSVS for select_multiple_from_file
• Control space characters when updating a CSV linked to a select_multiple_from_file in a form with a repository
• Rollback DB errors using savepoints

Enjoy!

Stable 2.34.0

This release has the following changes and bug fixes:

• The QR code now has auto-update enabled.
• Fix several issues with CSVs. For example, create a repo with a CSV, update the CSV, and merge a new version with an updated CSV.
• The Excel output is now formatted for date and numbers
• Fix the network in the docker-compose file on certain Linux systems. Thanks to @istride
• Generate CSVs through plugins. Plugins can now generate live CSVs

Stable 2.32.0

This release:

• Report duplicated submissions in logs
• Fix importing CSVs with " in text
• Remove support for or_other in selects

Stable 2.30.0

This version:

• Update several libraries due to security issues (Dependabot alerts)
• Control ODK forms that are too long (too many fields) for MySQL to store. This could be the case of an ODK form without repeats with more than 193 text variables or 16,654 decimal variables. This does not happen in 99% of the uploads but must be controlled (ODK Tools >= 2.6).
• Fix the update of ODK Case Creator forms during testing.
• Other minor bug fixes.

Stable 2.29.1

Minor release to fix a few small bugs.

Stable 2.29.0

This release has the following features:

• Allow to customize the QR settings of ODK Collect
• Members can now create exports. This aligns access with the analytics module
• New extension interface IRawSubmission so plugins can process a submission as it comes from ODK Collect or Enketo
• Minor bug fixes

Stable 2.27.0

This stable has the following features:

• Allow adding assistants using CSV
• Support complex languages in ODK like EN-AU or KIK
• Add support for data columns. Data columns are extra columns in your ODK that you can import into FormShare after creating the repository. The data of any extra column in the survey sheet will be stored in the dictionary. The data of any extra column in the choices sheet will be stored in the lookup table created by the choice. With this, you can run complex queries using the information defined in the ODK form.
• Add Ukrainian translation (DeepL)
• Several bug fixes

Stable 2.26.0

This release:

• Upgrade Jquery to 3.5.1 and Bootstrap to 4.1.3
• Allow securing all the JS code by moving all HTML JS to ephemeral JS files.
• Allow adding assistants to a group in a fast way
• Allow easy access to assistants and groups in projects
• Minor bug fixes

Stable 2.25.0

This release:

• Fixes a bug in the export to Excel when a multi-select table is empty
• Fixed a bug that prevented lookups and multi-select to be included in a zip CSV
• Show GPS points on the map even if several geo-points variables are present in an ODK as part of a condition. Note: The first GPS with values will be used in the map
• Upgrade dependencies

Enjoy :-)

Stable 2.24.0

Happy new year!

This is the first release of 2023! This release:

• Adds complete support for GeoJSON as external selects. FormShare stores GeoJSONs selects as lookup tables with all their properties and coordinates. This allows querying submissions and filtering results by those properties or performing proximity spatial queries using the coordinates of each feature in the GeoJSON.
• Adds support for "start-geopoint" variables.
• Store the order of the selection made by the user in ODK Collect in multiple select variables.
• Adds a new extension point to modify the way FormShare encrypts and checks a user's password.