ODK Central v2024.1.0

Entities

• Create a new Entity List without publishing a Form (#575)
• Add a new property to an Entity List without publishing a Form (#576)
• Add additional Entities to an Entity List by uploading a spreadsheet (#589, #593, #583)
• Delete an Entity from the Entity data table (#584)
• Delete an Entity from the Entity detail page (#591)
• Remove Entity List from cache after Entity is deleted or Entity property is added to List (#599)
• Prevent an Entity List from being created with the same case-insensitive name as another (#627)
• Add support for $orderby OData query parameter (getodk/central-backend#1078)
• Return Entities in stable order from REST API (#582)
• Autogenerate missing UUID when creating Entity using API (#574)
• Exclude deleted Forms from list of Forms that use Entity List (#643)
• Exclude Draft Forms from list of Forms that use Entity List (#645)

Bugs Fixed + Small Wins

• Add feedback button (#616)
• Add margin to App User QR code image (getodk/central-frontend#938)
• Prevent duplicate Submissions in OData feed that could appear when instance ID was reused (#608)
• Show correct upload progress when uploading Form Attachment (#606)
• Return to using longer width for geopoint columns in Submissions table (#635)
• Prevent long display name from wrapping beneath navigation bar (getodk/central-frontend#348)
• Remove "New!" badge from Entities tab (#581)
• Link to latest API docs (#604)
• Improve text of Enable Encryption pop-up (#587)
• Add ETag header for Submission Attachments and XLSForms (getodk/central-backend#1045)
• Return fewer details with 500 error (getodk/central-backend#549)
• Remove X-Powered-By header (getodk/central-backend#1111)
• Add robots.txt (#621)
• Return better error if query parameter is not a string (getodk/central-backend#806)

Operations + Maintenance

• Fix check for Docker Compose v1 during upgrade to Postgres 14 (#619)
• Create number of API server instances based on memory available to container, not to host (#577)
• Resolve Docker Compose warning that version is obsolete (#636)
• Improve JSON output from command line tools (getodk/central-backend#979)
• Update usage information metrics (#572)
• Update backend dependencies (getodk/central-backend#1069)
• Update frontend dependencies (getodk/central-frontend#924)
• Update infrastructure dependencies (#570)
• Update Enketo (#571)
• Update pyxform (#571)
• Update translations (#569)

Forum announcement: https://forum.getodk.org/t/odk-central-v2024-1-add-entities-by-uploading-a-csv/46616

ODK Central v2023.5.1

• Update Enketo (#594)
• Update pyxform (#594)

ODK Central v2023.5.0

Updating Entities via Submission

• See update conflicts from home page (#500)
• See update conflicts on page of Entity Lists (#502)
• Filter by update conflicts in Entity table (#503)
• See update conflicts in Entity table (#504)
• See summary of update conflicts on Entity Detail page (#505)
• Mark update conflicts as resolved on Entity Detail page (#506)
• See update conflicts in Entity feed (#507)
• See Entity update in Submission feed (#513)

Other Improvements to Entities

• Automatically link a matching Form Attachment of a Form Draft to an Entity List if publishing the Draft also publishes the Entity List (#554)
• Show "Link Entity List" button for a newly published Entity List (getodk/central-frontend#916)
• Filter Entities CSV download using API (#521)
• Translate the word "label" when showing changes on Entity Detail page (getodk/central-frontend#816)
• Fix Entity OData feed by adding __system/version property to schema (#565)
• Rename version column to __version in Entities download to OpenRosa clients (#501)
• Exclude deleted Entities from count of Entities (#560)
• Do not classify later Submission edits as pending Submissions when changing Entity Workflow setting (#561)
• After Entity Workflow setting is changed, do not reprocess Submission versions that previously resulted in an Entity processing error (#547)
• Require new Forms that modify Entities to specify at least one Entity action (currently either create or update), then limit their Submissions to the specified actions (#518)
• Ensure that two Entity updates will not receive same version number under conditions of high concurrency (#541)

Bugs Fixed + Small Wins

• Include filter selections in URL when viewing Server Audits Logs (getodk/central-frontend#525)
• Prompt user for decryption passphrase if refresh of Submissions table downloads first encrypted Submission (getodk/central-frontend#521)
• Return a better error message if an email address is already in use (#144)
• Require database user to have fewer privileges to restore a database backup (getodk/central-backend#1010)
• Correctly encode a URL on SSO redirect page (getodk/central-backend#1014)

Operations + Maintenance

• Use slim Node images (#549)
• Process asynchronous jobs more quickly (getodk/central-backend#533)
• Speed up stopping postgres14 container (#419)
• Update usage information metrics (#498)
• Update backend dependencies (getodk/central-backend#1006)
• Update frontend dependencies (getodk/central-frontend#868)
• Update infrastructure dependencies (#497)
• Update Enketo (#499)
• Update pyxform (#499)
• Update translations (getodk/central-frontend#869)

Forum announcement: https://forum.getodk.org/t/odk-central-v2023-5-entity-updates-via-submissions/44311

ODK Central v2023.4.0

Single Sign-on

• Support Single Sign-on with OpenID Connect (#449)

Entities

• Rename "Dataset" to "Entity List" (#466)
• See Entity Lists on homepage (#460)
• Always see Entities tab (#448)
• Reject reserved Entity property names case-insensitively (#482)
• Do not update an Entity if someone else has updated it since it was loaded (getodk/central-frontend#843)
• Track Entity version numbers (getodk/central-backend#832)
• Load Entities table in chunks (getodk/central-frontend#741)
• List Forms that create Entities without properties in "Connections to Forms" section of Entity List overview (#464)
• Show hint if a Form creates Entities without properties (#463)
• Do not link to an Entity if it has been deleted (getodk/central-backend#822)
• Do not store Entity labels in Server Audit Logs (getodk/central-backend#822)
• Improve the order of the Entity properties updated by a Form (getodk/central-backend#708)
• Improve how Entity List actions are logged in Server Audit Logs (getodk/central-backend#664)
• Do not allow an XForm to save an Entity property to a field in a repeat group (getodk/central-backend#670)
• Prevent all access to an Entity List before the associated Form is published (#467)
• Do not allow an Entity to be created over the API until the associated Form is published (#483)
• Fix issues if an Entity List is named itemsets (getodk/central-backend#673)

Bugs Fixed + Small Wins

• Add ability to filter subtables (repeat groups) in OData (getodk/central-backend#391)
• Add support for $skiptoken OData query parameter (getodk/central-backend#665)
• Make the check for available space compatible with docker compose v2 (#439)
• Allow Web Forms to be used immediately (#385)
• Do not export individual client audit attachments in Submissions .csv.zip (getodk/central-backend#947)
• Fix an issue sending email caused by format of a Docker file (#454)
• Delete test Submissions to existing Form Drafts when encryption is enabled for a Project (getodk/central-backend#911)
• Improve display of usage information metrics when there is no Project (getodk/central-backend#763)
• Improve DKIM support (#485)
• Add endpoint to delete current session (getodk/central-backend#923)
• Exit with nonzero status code if a command line tool is run without a subcommand (getodk/central-backend#892)

Maintenance

• Update usage information metrics (#442)
• Upgrade to Node 18 (#432)
• Update backend dependencies (getodk/central-backend#916)
• Update frontend dependencies (getodk/central-frontend#824)
• Update infrastructure dependencies (#440)
• Update Enketo, pyxform-http (#441)
• Update translations (getodk/central-frontend#823)

Forum announcement: https://forum.getodk.org/t/odk-central-2023-4/43212

ODK Central v2023.3.1

• Set Entity properties correctly if a new Form version changes save_to (getodk/central-backend#914)
• If a Project has enabled encryption, its main data table for Submissions can now be downloaded (getodk/central-backend#701)
• Allow a Submission Attachment to be previewed in Enketo when its file name contains a dollar sign (#438)
• Add ability to use $select with a parent ID in OData (getodk/central-backend#722)
• Update Enketo (#445)
  • Performance improvements for loading large Forms
  • Ukrainian translation

ODK Central v2023.3.0

Datasets

• Create Entities on Submission receipt (getodk/central-backend#864)
• See Entity detail page (getodk/central-frontend#760)
• Update Entity data directly (getodk/central-frontend#774)
• Add Entity record by API (getodk/central-backend#798)
• Delete Entity record by API (getodk/central-backend#803)

Bugs Fixed + Small Wins

• Add columns to the Entities CSV download about the Entity creator, the Entity creation time, and other metadata (getodk/central-backend#801)
• Improve the speed at which incoming Submissions are accepted by updating indices in the database (getodk/central-backend#805)
• Provide support for overrides of docker-compose.yml (#435)
• Require more disk space before upgrading Postgres to help prevent the disk from becoming full during the upgrade (#424)
• Set a maximum width in the web interface for an improved user experience (getodk/central-frontend#447)
• Fix a bug that showed all empty values in the Entities table for a Dataset property whose name contained a hyphen or period or was otherwise not a valid OData identifier (getodk/central-frontend#793)
• Do not show empty rows in front of Properties in the Dataset overview (getodk/central-backend#833)
• Allow the file names of Submission Attachments to contain Unicode characters or punctuation (#433)
• Allow a test Submission to be created for a Form Draft that links to a Dataset (getodk/central-backend#897)
• Set ETag header for OpenRosa form attachment endpoint (getodk/central-backend#826)
• Ensure structural change to a Form does not prevent managed encryption form being enabled (getodk/central-backend#898)
• Check that Dataset property names are valid in XML XForms, not just XLSForms (getodk/central-backend#688, getodk/central-backend#784)
• Fix a bug in the API that returned incorrect createdAt and updatedAt timestamps for Submissions when extended metadata was requested. Properties of the submitter were incorrectly added to the Submission. (getodk/central-backend#858)
• The User-Agent header is no longer required in the API. Most API clients specify User-Agent automatically, but it is now fully optional. (getodk/central-backend#896)
• Return better errors from the API when there is a problem related to an Entity (getodk/central-backend#854)
• Return a better error when the Authorization header is invalid in the API (getodk/central-backend#849)
• Render two potentially large tables in chunks (getodk/central-frontend#767)
• Small changes to tooltips (getodk/central-frontend#753)
• Remove primary keys from Dataset Metadata API response (getodk/central-backend#890)

Maintenance

• Remove unreliable check for successful migration so that data deletion does not fail during Postgres upgrade (#430)
• Update Enketo (#409)
  • Submissions are now re-attempted multiple times when in offline mode
  • Draw/signature/annotate widgets now preserve original image size when annotating and have better resize performance
  • See here for more notes about what changed in Enketo.
• Update pyxform-http (#409)
• Update infrastructure dependencies (#398)
• Update backend dependencies (getodk/central-backend#791)
• Update frontend dependencies (getodk/central-frontend#758)
• Update translations (getodk/central-frontend#759)
• Update usage information metrics (#410)

Forum announcement: https://forum.getodk.org/t/odk-central-2023-3/41748

ODK Central v2023.2.1

• Speed up stopping containers (#416)
• Update Node for API server (#415)

ODK Central v2023.2.0

Infrastructure

• Upgrade to PostgreSQL v14 (#343)
• Enable easier customization of install variables (#389, #401)
• Upgrade to Docker v23.x, Docker Compose v2.16.x (#402)

Entities

• Add new page that shows the Entities of a Dataset (#381)
• Help ODK Collect determine which Datasets have been updated (getodk/central-backend#770)
• Don't show the Datasets page until a Form Draft that creates a Dataset is published (getodk/central-backend#745)
• Dataset should be created regardless of the publishing order of draft forms that define a Dataset (getodk/central-backend#777)
• Sort Entities in entities.csv by when they were created (getodk/central-backend#767)
• Show the Properties of a Dataset in a consistent order (getodk/central-backend#675)
• Link to the Project Overview from a Dataset page (getodk/central-frontend#748)

Bugs Fixed + Small Wins

• Return the instance name and other information about the Submission Version from the API (getodk/central-backend#629)
• Return a better error message if the version string in the Submission XML does not match any Form version (getodk/central-backend#629)
• Add a password strength meter to the user interface (getodk/central-frontend#528)
• Remove the --password option from Command Line Tools (getodk/central-backend#772)
• Update the text of the "Using OData" pop-up to include pyodk (getodk/central-frontend#740)
• Increase number of workers that Node uses (#399)
• Prevent an error when uploading a Form definition with a very large number of fields (getodk/central-backend#707)
• Don't allow a group or repeat group to be changed to a string field (getodk/central-backend#381)
• Generate Web Form links more quickly in two cases (getodk/central-backend#782)

Maintenance

• Update Enketo v6.0.x (#384)
  • Breaking Change: IE11 is no longer supported
  • XForm to HTML transformation is dramatically faster
  • Fix: include drawings, signatures and annotated images in PDFs
  • Fix: support single-column CSV
  • Fix: load external data when served with application/geo+json Content-Type header
  • Fix: rank widget on touch devices
  • Fix: undesired autocompletion of manually entered incomplete month-year
• Update Node (#390, getodk/central-backend#786, getodk/central-frontend#746)
• Update NGINX (#397, getodk/central-frontend#745)
• Update other infrastructure dependencies (#392, #393, #386)
• Update frontend dependencies (getodk/central-frontend#731)
• Migrate to the new Transifex CLI (getodk/central-frontend#577)
• Update translations (getodk/central-frontend#732)

Forum announcement: https://forum.getodk.org/t/odk-central-2023-2/40618

ODK Central v2023.1.0

Datasets

• See more context on Datasets list
• See Dataset properties and sources
• See Dataset source information on Form Overview

Bugs Fixed + Small Wins

• Remove Google Drive backups (#323)
• Prevent an error when attempting to recreate an Entity from an edited Submission (getodk/central-backend#729)
• When there is an error creating an Entity from a Submission, details about the error will now be shown more consistently in the Submission activity feed. (getodk/central-frontend#701)
• The timestamp precision of the Central database will now match the precision returned over the API, truncating sub-millisecond precision. (getodk/central-backend#459)
• Show a warning if a new Form version removes an existing Form field (getodk/central-backend#439)
• Show a warning if a new Form uses the same ID as a Form in the trash (getodk/central-backend#616)
• Check that new Forms include a meta group (getodk/central-backend#759)
• Link to XLSForm documentation when an XLSForm warning includes a URL (getodk/central-frontend#687)
• When a Form definition is uploaded, the file picker will filter for Excel and XML files. (getodk/central-frontend#682)
• Show tooltips immediately (getodk/central-frontend#648)
• Show "Latest Submission" in the tooltip when hovering over a date in a table of Forms (getodk/central-frontend#698)
• Fix the OData feed for repeat groups whose names contain invalid OData characters (getodk/central-backend#496, getodk/central-backend#607)
• Fix performance issues when there are many Form versions with the exact same Form fields (getodk/central-backend#662)
• Log the correct Form action in the Server Audit Log when Managed Encryption is enabled for a Project (getodk/central-backend#750)
• Use the OData $select query parameter in the frontend to reduce data transfer (getodk/central-frontend#638)
• Make accessibility improvements to the navigation bar (getodk/central-frontend#690)
• When a navigation tab is disabled, prevent keyboard navigation into it (getodk/central-frontend#686)
• Delete a Web User's sessions after their password is changed or invalidated
• Log in the Server Audit Log when a password is invalidated (getodk/central-backend#736)
• Prevent a Sitewide Administrator from invalidating their own password in the frontend (getodk/central-frontend#708)
• Reduce noise from npm when Central is built (#359, #362)
• Add indexes to the entities and entity_defs tables (getodk/central-backend#660)

Maintenance

• Add the ability to adjust the frequencies of certain tasks during regression testing (getodk/central-backend#713)
• Add request duration in Sentry logs (getodk/central-backend#723)
• Update Enketo to 5.0.2
  • Improve error messages for revoked Forms and Public Access Links
  • Improve localization for numeric input
• Update pyxform to v1.12.0 to add big-image support
• Update backend dependencies (getodk/central-backend#684)
• Update frontend dependencies (getodk/central-frontend#646)
• Update translations (getodk/central-frontend#647)
• Update usage information metrics (#350)

Release criteria: https://docs.google.com/document/d/1sufFP5TwCBjy7ZuY7kVo_n8iJSkdpTagHaXum10wvZc/edit?usp=sharing
Forum announcement: https://forum.getodk.org/t/odk-central-v2023-1/40267

ODK Central v2022.3.1

Bugs Fixed

• Values in groups showed as blank in Excel and Power BI when using the OData feed.