Setup


Download & install software

Windows
  • Check that you have Firefox or Chrome browsers installed and set as your default browser. OpenRefine runs in your default browser. It will not run correctly in Internet Explorer.
  • Download the latest software version from http://openrefine.org. 
  • Unzip the downloaded file into a directory by right-clicking and selecting Extract .... Name that directory something like OpenRefine.
  • Go to your newly created OpenRefine directory.
  • Move the folder to c:\program files (you may need administrator privileges to do this)
  • Launch OpenRefine by clicking the openrefine.exe file (this will launch a command prompt window, but you can ignore that and wait for the browser to launch)
  • If you are using a different browser, or OpenRefine does not automatically open for you, point your browser at http://127.0.0.1:3333/ or http://localhost:3333 to launch the program.

Windows Troubleshooting

You may also need to install Java for Windows

Mac
  • Check that you have Firefox or Chrome browsers installed and set as your default browser. OpenRefine runs in your default browser. It will not run correctly in Internet Explorer.
  • Download latest software version from http://openrefine.org
  • Drag icon into Applications folder
  • Doubleclick to launch OpenRefine
  • If you are using a different browser, or OpenRefine does not automatically open for you, point your browser at http://127.0.0.1:3333/ or http://localhost:3333 to launch the program.

Mac Troubleshooting

  • If OpenRefine doesn’t open due to security settings go to:
    • System Preferences> security & privacy > see message re: OpenRefine
    • Select Open anyway
Linux
  • Check that you have Firefox or Chrome browsers installed and set as your default browser. OpenRefine runs in your default browser. It will not run correctly in Internet Explorer.
  • Download the latest software version from http://openrefine.org. 
  • Unzip the downloaded file into a directory. Name that directory something like OpenRefine.
  • Go to your newly created OpenRefine directory.
  • Launch OpenRefine -Type ./refine into the terminal within the OpenRefine directory
  • If you are using a different browser, or OpenRefine does not automatically open for you, point your browser at http://127.0.0.1:3333/ or http://localhost:3333 to launch the program.

About the data

The dataset used in this workshop is adapted from Crash data from Queensland roads, © 2019 The State of Queensland, licensed under a Creative Commons Attribution 4.0 International licence, CC BY 4.0.. It was downloaded from the Queensland Government’s open data portal.

The original dataset presents 17 years of traffic accidents, their location, type of accident, level of injury, and other features, with over 300,000 observations.

The data used in these lessons is a smaller, four-year subset and has had changes made for training purposes.

Download workshop data

Alternately, when you launch OpenRefine in the Create lesson:


Get help

Online

You can find out more at the OpenRefine website. Check out the documentation and great introductory videos. These videos and others on OpenRefine can also be found on YouTube - use the search term ‘OpenRefine’.

There is a Google Group that can answer a lot of beginner questions and problems.

At Griffith University

Help is available from eResearch and Library specialists at Griffith University. Get in touch with us here for an online consultation.