Skip to content

Changes for 3.6

Jump to bottom Edit New page
Antonin Delpeuch edited this page Oct 3, 2022 · 65 revisions

Starting with version 3.6, OpenRefine requires Java 11 or later.

New features

  • The user is now warned when applying the "Fill down" or "Blank down" operations with a pending sorting criterion (#3256)
  • The import preview refreshing can be disabled (#4009)
  • Menu items to reveal collapsed columns were added to the column menus (#4067)
  • The path to the refine.ini configuration file can now be changed on the command line (#4113)
  • It is now possible to download the JSON representation of the operation history, without resorting to copy and paste (#4498)
  • It is now possible to work with Wikibase instances with federation enabled (#4287)
  • The merge strategy for statements can be configured in the Wikibase schema editor. This also adds support for deleting statements. Beware that schemas created with earlier versions of OpenRefine will still use the original merge strategy. (#3383, #2116, #4130)
  • OpenRefine can edit MediaInfo entities and not just Items (#4270)
  • It is possible to disable the new version notification by setting the configuration variable refine.display.new.version.notice=false (#4410)
  • The dialog to reorder and delete columns was improved to easily delete most columns (#4557)
  • The maximum editing speed and the Wikibase tag to apply to all Wikibase edits is now configurable for each Wikibase instance via its manifest (#3359)
  • Extra URL fields in the starting page can be removed thanks to a new button (#4606)
  • The "Use values as identifiers" operation now warns that it does not validate the identifiers (#3172)

GREL changes

  • A new GREL function, parent, was introduced to obtain the parent element of an XML element (#4181)
  • A new GREL function, scriptText, was introduced to obtain the text contained in a <script> or <style> element in HTML (#4189)
  • The random (previously randomNumber) GREL function was improved (#3143)
  • A new GREL function parseUri was introduced (#1857)
  • A new GREL function detectLanguage was introduced (#642)
  • New GREL functions encode and decode were introduced (#148)
  • The error handling of the pow and exp functions was improved (#3062)
  • The division operator returns NaN when computing 0/0 (#377)
  • A function timeSinceUnixEpochToDate was introduced, to convert a duration since Epoch to a date object (#608)
  • A function replaceEach was introduced, to replace multiple substrings in one go (#2606)

Bug fixes

  • XML and JSON importers now correctly create File and Archive columns when requested (#3462)
  • Casing in UI text in English was made more consistent (#3363)
  • Zip files with an unsupported compression method are correctly rejected by the UI at import time (#4112)
  • Date parsing for Excel and ODS importers was fixed to avoid off-by-one errors due to changes in Daylight Saving Time (#4294)
  • Labels of checkboxes in text filters are correctly bound to the corresponding checkboxes (#4243)
  • The templating exporter correctly reports when a template contains errors (#3382)
  • The dialog to add a Wikibase instance gives better error messages when the manifest's JSON structure is invalid (#4324)
  • The missing separators when using the templating exporter in records mode have been fixed (#3955)
  • The handling of curly braces inside export templates has been fixed (#3381)
  • The options to parse column names in the CSV/TSV exporter have been turned into radio buttons (#4299)
  • The project metadata dialog was improved to avoid being cut off when containing large values (#4119)
  • The tabular exporter dialog was fixed to respect column order changes (#4271)
  • The duplicates facet was fixed, it now works for all column names (#4233)
  • Links from the tool to the documentation were improved (#3578)
  • The XML importer correctly populates project metadata with import options (#4566)
  • When running OpenRefine on Windows without Java, the user is now redirected to our docs about setting up Java (#4511)
  • The alignment of OK/Cancel buttons was normalized to the right-hand side of all dialogs (#4564)
  • The sizing of the SQL exporter dialog was fixed (#4579)
  • Menu items which open a dialog end with a text ellipsis (#4585)
  • Renaming a column is now done via a proper dialog and not a Javascript prompt (#4590)
  • When creating a project by downloading the content of one or more URLs, all URLs are validated in the UI (#2687)
  • A tooltip falsely indicating that project tags could be edited was removed (#3979)
  • The spacing between the OK and Cancel buttons on some dialogs was fixed (#4622)
  • Spell-checking was disabled on many text inputs where it does not make sense (#3004)
  • The style of forms in the UI was made more consistent (#4639)
  • The borders of dialogs was made uniform across the tool (#4662)
  • The SQL exporter avoids adding invalid characters in its column names (#1940)
  • The interface remembers whether the last reconciliation applied to a single cell or to all similar cells (#2316)
  • Encoding issues in operation notifications have been fixed (#4540)
  • The parsing of empty ODS files was fixed (#2465)
  • The documentation around clustering was improved (#3033)
  • Proxy settings are now respected by reconciliation operations (#3919)
  • Encoding issues in project metadata fields were fixed (#3919)
  • The dialog to select a Wikibase instance was improved (#3824)
  • A bug causing workspace corruption when saving projects was fixed (#3719, #3277, #1418)
  • The positioning of dialogs was improved (#4906)
  • (from 3.6-rc1 on) The checks for Java versions in our start scripts have been updated to reflect that we support Java 11 to 17. (#4930)
  • (from 3.6-rc1 on) The "Collapse consecutive whitespace" operation correctly recognizes all Unicode whitespace as spaces (#4883)
  • (from 3.6-rc1 on) Menu items with ellipsis were fixed (#5003)
  • (from 3.6.1 on) The editing of redirected Wikibase entities was fixed (#5162)
  • (from 3.6.1 on) A bug with selection of clusters in the clustering dialog was fixed (#5138)
  • (from 3.6.1 on) Date handling in the Google data extension was fixed (#5107)
  • (from 3.6.1 on) A packaging issue in MacOS was tentatively fixed (#5160)
  • (from 3.6.2 on) An overflow issue with the reconciliation dialog was fixed (#5286)

For extension developers

  • (from 3.6-rc1 on) We migrated to jQuery 3.6.0. If you are using jQuery in your extension, some jQuery syntaxes that have been deprecated earlier might have been removed. If your extension runs with OpenRefine 3.5.2, you can check the web developer console for warning messages when the extension is used: fixing those should be enough for your extension to be compatible with OpenRefine 3.6 (#4891)

ok

Add a custom sidebar
Clone this wiki locally