Tips and Tricks

Making a handout

Adapt/print from:

• Library Carpentry Reference Page
• Instructor Draft Notes
• Introduction to OpenRefine by Owen Stephens

General notes on OpenRefine

Common problems

• If learners are using a browser other than Firefox, or OpenRefine does not automatically open for them when they click the .exe file, have them point their browser at http://127.0.0.1:3333/ or http://localhost:3333 to launch the program.

• Mac users with the newest operating system will have to allow this to run by “allowing everything” to run. They can change the setting back after the exercise.

• Some students will run into issues with
  • unzipping
  • finding the .exe file once the software has been unzipped
  • finding the data file on their computers after downloading
• If OpenRefine crashes when launched from a network share drive, do the following:
  • Copy the OpenRefine folder to a local drive not mapped to a network share, e.g. “C:\Users\JaneDoe”
  • Open a Windows Command prompt
  • Change the working directory to the OpenRefine folder at “C:\Users\JaneDoe”
  • Run openrefine.exe
• If a learner is unable to install OpenRefine on their computer due to IT restrictions for example, there are cloud services available that they could try:
  • openrefineder using MyBinder (OpenRefine 3.4.1, free to use without registration, restricted to 1-2 GB RAM and server will be deleted after 10 minutes of inactivity)

• If “https” doesn’t work to fetch CrossRef during Advanced OpenRefine Functions, they can try “http”

• If they need to diagnose failure to fetch the content from the URL they can check the “Store error” option in the “Add column by fetching URLs” dialogue and try looking at the common problems listed in the documentation