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.

ODK Central v2022.3.0

Datasets

• Get errors about names when uploading Draft for Dataset-managing Form
• Get hint about testing Datasets in alpha
• See Entities warning when enabling Managed Encryption
• See linked Datasets in Form Overview and Form Draft Status
• Publish a Dataset-registrating Form
• Manage Datasets
• Approve an Entity-registrating Submission
• See Entity creation on Submission feed
• Make Entity reference when managing Attachments
• List Dataset actions in Server Audit Log

Bugs Fixed + Small Wins

• Rename “Media File” to “Form Attachment” or “Submission Attachment”
• Add ability to filter Submissions on multiple Review States (getodk/central-frontend#559)
• Add ability to filter Submissions on multiple submitters
• Allow user to select more than 100 columns, but show warning (getodk/central-frontend#396)
• Add support for $select OData query parameter (getodk/central-backend#493)
• Configure Enketo to match relevance behavior of ODK Collect
• Handle Form titles that contain characters &, <, or > (getodk/central-backend#478)
• Return correct API response after comment creation (getodk/central-backend#516)
• Return combined verbs over API if User is assigned multiple Roles on a Project (getodk/central-backend#486)
• Return Problem response if API user specifies a number that is too large (getodk/central-backend#514)
• Improve handling of unexpected errors (getodk/central-backend#592)
• Fix issue starting multiple instances of API server (#329)
• Add Content Security Policy reporting
• Prevent reboot loop if openssl fails
• Remove duplicate logging for service (#265)
• Do not run server if database migration was removed as part of Central downgrade (getodk/central-backend#509)

Maintenance

• Update usage information metrics
• Send version information to Sentry (getodk/central-backend#547)
• Resolve Sentry errors missing information (getodk/central-backend#483)
• Add soak testing (getodk/central-backend#204)
• Upgrade to Node 16
• Update Backend dependencies
• Update Frontend dependencies
• Update Enketo
• Update pyxform-http
• Update translations

GitHub issue: #298
Forum announcement: https://forum.getodk.org/t/odk-central-v2022-3/39787