Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use the normalize ISSNs macro

  1. Open the Normalize ISSNs macro.
  2. Copy the code found on the page beginning with the first open bracket and ending with the last close bracket.
  3. In OpenRefine, switch to the Undo/Redo tab.
  4. Click "Apply" and copy the code from the wiki page into the text box.
  5. Click "Perform operations."Right-click any cell and select "Apply Macro"
  6. Search for the Normalize ISSNs and eISSNs macro
  7. Click OK to run the macro
  8. Change back to the Errors tab and check to see if this error is still present. If this has not solved the problem, try the solution below.


Rename a column with a macro

  1.  Right-click any cell and select Apply Macro

  2. Search for the name of the package and/or provider to locate the correct macro, or search for the KBART (generic) macro.

  3. Click Ok to run the macro


Facet your data

  1. Open the quick resolution menu by clicking on the wrench icon in the upper right corner of the error message."Quick Resolution."
  2. Choose "Create facet."
  3. OpenRefine will create a facet of all the ISSNs that do not correspond to the correct format. Choose the "Invalid" facet.
  4. You will now see a filtered view of your project that shows only the incorrectly formatted ISSNs.
  5. If there are only a handful, fix them manually.
  6. If there are too many to correct one-by-one, contact the editor for help with the conversion process.

...