OpenRefine Changelog

What's new in OpenRefine 2.8

Nov 20, 2017
  • New features:
  • Project metadata support
  • Enhancement of the reconciliation API
  • Support split multivalued-cells by regex/special characters
  • Text filter exclude
  • Add free memory detection and Notification to user
  • Improved UI for better usability
  • New importer for Wikitables
  • Some bug fixes

New in OpenRefine 2.7 RC 2 (Mar 24, 2017)

  • Upgrade the Jython library to 2.7.

New in OpenRefine 2.6 Beta 1 (Sep 19, 2013)

  • New features:
  • shiny new OpenRefine branding
  • internationalized UI available in both Italian and English
  • a number of small of localization improvements such as support for locale in the toDate() function #729 (if you'd like to help translating for your language, contact us)
  • better data fidelity for import - it's now possible to turn off all automatic conversions
  • improved CSV support, including support for multi-character field separators
  • support for the new Freebase v1 APIs released by Google as well as the latest Freebase Suggest 4.3
  • better feedback on memory usage and low memory situations when creating projects
  • shorter more friendly column names for JSON imports #524
  • sorting of large data sets is orders of magnitude faster #738
  • almost one hundred bug fixes including fixes for some of the persistently annoying ones like cross() failures #432
  • more robust project saving and project recovery -- if you have projects in your workspace which have been renamed .project.corrupted, you may be able to recover some of the data if you rename them back to the standard .project extension

New in OpenRefine 2.5 Build 2407 (Mar 21, 2012)

  • New Features:
  • Custom tabular exporter that allows for selecting and configuring columns to export, and direct upload to Google Spreadsheets and Fusion Tables
  • Support for IE8 and IE9 through Google Chrome Frame
  • New command "Key/value Columnize" (see explanation)
  • New importer for PC-Axis file format.
  • Completely new user interface for project creation, including:
  • Live preview with interactive settings before creating project
  • Fixed-width importer that allows for specifying column widths by clicking ( Issue 85 )
  • XML and JSON importers that allow for interactive selection of elements to import
  • Direct access to Google Spreadsheets ( issue 278 ) and Google Fusion Tables ( Issue 279 )
  • Import and export to private Google Spreadsheets & Fusion Tables for logged-in users
  • Import using results of Google spreadsheet visualisation API query ( issue 375 )
  • Sheet selection for import from Excel ( issue 280 ) & Google Spreadsheets ( issue 281 )
  • Support for directly selecting files within zip/archive file without unpacking them first ( Issue 131 )
  • Support for creating a project using contents of the paste buffer ( Issue 84 )
  • Better progress feedback during upload & processing ( issue 179 )
  • Enhancements:
  • Issue 31 : Maximum number of facet values should be configurable.
  • Issue 38 : Wishlist Fix the table header so that it's always visible when scrolling a long page
  • Issue 97 : Exporting CSV should allow for optional columns
  • Issue 447 : Extend toTitlecase() function with support for custom delimiters
  • Operation "Transpose columns into rows" now supports an additional mode of generating 2 key and value columns (rather than generating just one combined column); it also has an option for filling in other columns.
  • reinterpret() now supports optionally specifying a source encoding to be used instead of the project encoding - reinterpret("target encoding", "source encoding")
  • Bug Fixes:
  • Issue 149 : rows button stays strike-through when clicking on it
  • Issue 349 : Clustering not finding duplicates when facet is showing groupings
  • Issue 394 : Add a reset button to Text filter
  • Issue 419 : Values with Characters like é split across several lines
  • Issue 424 : Duplicate column names don't allow user to recover
  • Issue 426 : filter with custom facet adds zero lines choice
  • Issue 428 : Excel import sometimes drops last row of data
  • Issue 433 : Usability: use HTML label (e.g., for checkboxes)
  • Issue 440 : Fetch URLs aborts while saving/loading/computing facets
  • Issue 441 : onError - "keep-original" / "store-blank" working oddly for value.toDate()
  • Issue 442 : Two column transforms to date on the same column turns the cells blank
  • Issue 449 : Uncaught exception from Excel importer
  • issue 502 - Fetch URLs does not return a correct HTTP response
  • Miscellaneous:
  • Issue 233 : 404 Error upon Launch
  • Issue 362 : Augmentation screencast (#3) is now missing/private
  • Issue 410 : Convert line-endings to DOS format
  • Issue 435 : refine sh script only checks for java 1.6, not > 1.6
  • Issue 444 : Patch for /trunk/main/webapp/modules/core/scripts/dialogs/custom-tabular-exporter-dialog.html
  • Issue 445 : Patch for /trunk/main/webapp/modules/core/scripts/dialogs/custom-tabular-exporter-dialog.html
  • Issue 453 : Patch for /trunk/main/tests/server/src/com/google/refine/tests/importers/JsonImporterTests.java