formshare - Stable 2.36.0

This release fixes the following bugs - Control space characters in CSVS for selectmultiplefromfile - Control space characters when updating a CSV linked to a selectmultiplefromfile in a form with a repository - Rollback DB errors using savepoints

Enjoy!

- Python
Published by qlands almost 2 years ago

formshare - 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

- Python
Published by qlands almost 2 years ago

formshare - Stable 2.32.0

This release: - Report duplicated submissions in logs - Fix importing CSVs with " in text - Remove support for or_other in selects

- Python
Published by qlands about 2 years ago

formshare - 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.

- Python
Published by qlands over 2 years ago

formshare - Stable 2.29.1

Minor release to fix a few small bugs.

- Python
Published by qlands over 2 years ago

formshare - 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

- Python
Published by qlands over 2 years ago

formshare - 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

- Python
Published by qlands over 2 years ago

formshare - 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

- Python
Published by qlands almost 3 years ago

formshare - 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 :-)

- Python
Published by qlands about 3 years ago

formshare - 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.

- Python
Published by qlands about 3 years ago

formshare - Stable 2.23.0

This new stable:

• Upgrade the docker images to Ubuntu LTS 22.0.4
• Upgrade MongoDB to version 6 as part of the new image

Please note that from Stable 2.23.0 the source code requires Python >= 3.10.X

- Python
Published by qlands about 3 years ago

formshare - Stable 2.22.0

This release: - Adds new functions to support remote SQL - Add citation file - Few minor bug fixes

- Python
Published by qlands about 3 years ago

formshare - Stable 2.21.0

This release has the following changes:

• Complete API
• CSV files used in selectonefrom_file or with search will update the related lookup table if a new CSV is uploaded by the interface or API
• Minor bug fixes.

Enjoy

- Python
Published by qlands about 3 years ago

formshare - Stable 2.20.0

This new stable release fixes some bugs and adds new features:

• Report the real number of submissions and not the maximum on 10,000
• Control the number of testing submissions to a maximum of 200. This won't allow thousands of testing submissions. Note: This is only a restriction on forms at the testing stage. Once the form has a repository there is no restriction on the number of submissions
• Rename several extension points to properly separate functionality
• Add ICollaborator and complete IProject extension interfaces
• Upgrade all dependencies
• Other the list of projects by active and then by date created
• Go to project details when a new project is created

- Other minor bug fixes

Enjoy!

- Python
Published by qlands over 3 years ago

formshare - Stable 2.18.0

Hi,

Second stable in less than 8 days! In this release:

• We noticed some performance issues affecting users with dozens of active projects. We redesigned some functions and interface processes to avoid this issue.
• Fixes some issues with the export of CSV, XLSX, and JSON when processing happens under high concurrency (dozens of export happening at the same micro-second)
• Few minor fixes.

Enjoy!!

- Python
Published by qlands over 3 years ago

formshare - Stable 2.17.0

Hello,

We are happy to release FormShare 2.17.0 (20220728) This release has the following features:

• Re-write the process that creates flat CSV files. It now uses JSON2CSV.
• The CSV ZIP (multiple files) is now able to perform a complete dump of the repository: data tables, lookup tables, and multi-select tables
• A new export to JSON ZIP (multiple files) with the possibility of a complete dump like CSV.
• Reprogrammed the CSV ZIP and JSON ZIP underlying c++ process (in ODK Tools) so it uses multi-threads to minimize the export time. For example, with this change, a complete dump in CSV or JSON of 30,000 submissions takes around 5 seconds (with 6 threads).
• Fixed some storage bugs that appear only on extreme concurrency. For example, when processing 20,000 submissions in a loop with 6 concurrent requests.
• Added a new guide on how FormShare stores data: https://github.com/qlands/FormShare/blob/472af419e82aadef9a7d25e70a8ff5d1ff305591/formshare/static/formsharestorageen.pdf
• Added new restrictions on variable names. These restrictions are JAVA reserved words. This avoids problems when generating OData entry points with variables called "abstract" or "final". This change is on ODK Tools.
• Other minor bug fixes and QA test lines.

Enjoy!

- Python
Published by qlands over 3 years ago

formshare - Stable 2.16.0

Hello,

This stable has the following features: - Allow public/crowdsourcing projects. All forms in a public project do not require login from Collect or Enketo - Update all dependencies - Update all Linux packages and C++ libraries in Docker - Minor bugs and language fixes

Enjoy! :-)

- Python
Published by qlands over 3 years ago

formshare - Stable 2.15.0

This release upgrades all libraries. The latest docker image 20220502 uses Ubuntu 21.10 (Python 3.9) as a step towards Ubuntu 22.04 LTS (Python 3.10) while we wait for Mongo to be released for Ubuntu 22.04 LTS.

In this version we: - Dropped support for MySQL 5.X (This is the safest option after two LTS cycles with MySQL 8.X) - Added two new tools to recreate the dataset and record ES indices. Only needed if for any reason you lost your ES data

Enjoy :)

- Python
Published by qlands almost 4 years ago

formshare - Stable 2.14.0

This version fixes several minor bugs, adds several extension points, and provides the following new features: - New export to zip CSV. In this export, each table is a CSV file - Control ODK forms with coded and not coded languages.

Enjoy! :-)

- Python
Published by qlands almost 4 years ago

formshare - Stable 2.12.0

In this stable we: - Upgraded Pillow - Added a new way for extending FormShare's ORM. Plugin's now can use Alembic to create new tables - Allowed assistants with cleaning privileges over a form to download private products - Fixed some minor issues - Added few extension points

Enjoy!

- Python
Published by qlands about 4 years ago

formshare - Stable 2.11.1

This is a small service release that: - Updates Celery to 5.2.2 (Security fix) - Updates NLTK to 3.6.6 (Security fix)

Enjoy.

- Python
Published by qlands about 4 years ago

formshare - Stable 2.11.0

Happy new year! This is the first release for 2022! In this release, FormShare supports multiple time zones and adapts dates and times accordingly. This feature is for organizations that deploy ODK forms across the globe. Is available by default but it can be disabled in the settings. If it is enabled then FormShare handles different time zones: - FormShare's: This is the time zone of the Linux server running FormShare. - User: This is the time zone the user logged into FormShare - By project: Each project can have a different time zone. FormShare will show the time zone of each project. - Assistant: This is the time zone the assistant logged into FormShare. - Partner: This is the time zone the partner logged into FormShare.

FormShare will store all date-time information (except those coming from an ODK submission) in the time zone of the server, however users, assistants, and partners can see their activities in their own time zones. If they need a common time zone for discussion they can switch to FormShare's time zone or project time zone in real-time. FormShare will adapt the dates accordingly.

This version also fixes the following bugs: - Partners can now change their own passwords, API keys, and time zones. - Other minor fixes.

Enjoy!

- Python
Published by qlands about 4 years ago

formshare - Stable 2.10.2

This release corrects a few bugs and adds the following features: - Allow customizing the variables in KML - Allow customizing select options in CSV and Excel files (only for forms with a repository) - Allow importing raw XML data from ODK Collect / BriefCase - Provides extra help in case management - Remove problems with login and register - Control the size of table names so they don't exceed 64 characters. - Block all post to eliminate the possibility of double DB postings. - Case follow-up forms now need to indicate a date or a datetime variable. - Cleaning API now uses a route 100% generic (/api_update). Users just need a rowuuid and FormShare will know the project, form and data row to update

- Python
Published by qlands about 4 years ago

formshare - Stable 2.10.0

This release has the following changes:

• Partner access. Partners are trusted individuals outside your organization that require access to products and other resources in FormShare to collaborate with you. For example, a professor at a university (a partner in your project) requiring a KML export to match GPS points with weather data. In FormShare now you can create and attach partners to projects and forms. Partners access FormShare via the Partner Access page. Note: This feature is only available for custom installations of FormShare where public users cannot create accounts.
• Uses and checks for Elasticsearch 7.14.X
• Move individual form indices (datasets and records) to one dataset index and record index for all forms.
• Finished the automatic testing (UnitTest). With more than 15,000 lines of UnitTest code, we reached 95% of coverage. :-)
• Control several bugs when merging new versions of a form with changes in languages.
• Other minor bug fixes.

- Python
Published by qlands over 4 years ago

formshare - Stable 2.8.6

This stable version of FormShare: - Fixed some issues with secondary MySQL connections - Replaces SSE for MQTT for server-client communications - Other minor bug fixes.

- Python
Published by qlands over 4 years ago

formshare - Stable 2.8.4

This release: - Upgrade most of the dependencies - Upgrade DB locale to utf8mb4 - Fix celery to properly support task pooling - Properly abort celery tasks - Some minor bug fixes

- Python
Published by qlands over 4 years ago

formshare - Stable 2.8.3

This release fixes the following issues: - Support emojis in submissions - Fixed minor bugs and typos This release has the following improvements: - Faster Excel output - Faster CSV output

Enjoy :-)

- Python
Published by qlands over 4 years ago

formshare - Stable 2.8.2

This release: - Supports the use of bar code and QR code widgets in follow-up cases. This will allow having cases around things like "laboratory samples" where each sample has a barcode. - Control a bit more the variables used for case management - Control a bit more submission to follow-up cases by checking if the case is active (for follow-up and deactivate) or not (for activate) - Has intregration with CircleCI and Codecov

- Python
Published by qlands almost 5 years ago

formshare - Stable 2.8.1

This version just implements security updates:

Upgrade py to version 1.10.0 Upgrade pyxform to 1.4.0 Upgrade black Some other minimal updates

- Python
Published by qlands almost 5 years ago

formshare - Stable 2.8.0

Version 2.8.0 is here! This version has several changes and bug fixes: Infrastructure changes: - Uses and checks for Elasticsearch 6.8.14 as a first migration step toward 7.X. See upgrading notes in readme - For users using the docker MySQL, this version will migrate MySQL to 8.0.23

Data management changes: - Longitudinal/case management workflow at project level. See readme for details - Data dictionary stored in the database

Bug fixes: - Fix the online data cleaning when variables descriptions are too long to display. - Don't show 404 in case of possible bot login or registration

Extensibility: - New extension points at submission

Security: - Updated libraries based on GitHub security alerts

Enjoy!

- Python
Published by qlands almost 5 years ago

formshare - Stable 2.7.5

This version creates a new KML file with embedded information for each geo-point.

- Python
Published by qlands almost 5 years ago

formshare - Stable 2.7.4

This version: - Better handles ES - Fix search of collaborators by email - Display submission information for a marker in the map

- Python
Published by qlands about 5 years ago

formshare - Stable 2.7.3

This stable version corrects a bug in the allocation of images for submissions that are incomplete when a form is in the testing stage

- Python
Published by qlands about 5 years ago

formshare - Stable 2.7.2

This release has the following changes: - Users need to indicate a primary key when uploading an ODK form - FormShare will check in the background if an ODK form can build a repository before creating it - Fix a lot of English typos - Fix a lot of Spanish typos - Updated official French and Portuguese translations - Minor bug fixes

- Python
Published by qlands about 5 years ago

formshare - Stable 2.7.1

Stable 2.7.1 has the following changes: - Easy correction of log entries - Some small bug fixes

- Python
Published by qlands about 5 years ago

formshare - Stable 2.7.0

This version: - Moves the Docker images to Ubuntu 20.04 - Fixes issues when ODK Collect send submissions in parts - The testing framework is almost completed by covering 88% of the code - Other minor bug fixes

- Python
Published by qlands about 5 years ago

formshare - Stable 2.6.11

This release fixes a bug in the merging of Forms created by MySQLDump with MySQL servers >= 8

- Python
Published by qlands over 5 years ago

formshare - Stable 2.6.10

This version fixes a bug in the map caused by MapBox API changes.

- Python
Published by qlands over 5 years ago

formshare - Stable 2.6.9

This version provides a few bug fixes and some extra features: - Add a new button to try to push again a submission in the logs - Fix minor docker-compose bugs - Fix some typos

- Python
Published by qlands over 5 years ago

formshare - Stable 2.6.3

This version has the following updates: In the log interface: - Fix minor bugs - Make it easier to compare duplicated submissions - Allow to download media for submissions in the logs - Move submissions from the repository to the logs Libraries: - PyXForm 1.1.0 - PyUtilib 5.8.0 Testing: - Test multi language ODKs Products: - Send email if error occurs - Create an empty zip when no media files are present - Report outdated products - Show latest product - Make URL of latest product to be /latest - Fix minor bugs Repository: - Report duplicated options in CSV - Report on mixing option in CSV with options sheet Forms: - Quick actions section - Examples on API data cleaning - API to upload files to a form Translation: - French translation is not machine generated

- Python
Published by qlands almost 6 years ago

formshare - Hot-fix 2.5.2

This version fix a problem with certain Microsoft Edge browser that pass any uploaded file with a \ character.

- Python
Published by qlands about 6 years ago

formshare - Release 2.5.1

This release has the following: - Several bug fixes - Initial automatic testing and coverage - Portuguese language

- Python
Published by qlands about 6 years ago

formshare - Stable 2.0

This is the first stable release of FormShare 2.0.

- Python
Published by qlands over 6 years ago

formshare - Stable 1.1.0

Stable 1.1.0 is out!

Some changes: - Formshare is now available as a docker container. - Patched several bits of code so Formshare can run in other locations than / . For example: /formshare - Fixed break in celery with the new version of billiard. - Added multilingual support (English / Spanish). - Removed the registration URLs because they are no needed. - Changed requirements to not point to Ona account in github. - Some other minor changes

- Python
Published by qlands over 9 years ago

formshare - Stable 1.0.0

We need to start somewhere. Even though there are some bugs and plenty of things to do we can call this FormShare 1.0

- Python
Published by qlands over 9 years ago