/
Macros

Macros

We have created macros for existing GOKb data providers and other common transformations. Ā 

To run a macro in an OpenRefine project:

  • Right-click in any cell and selectĀ Apply Macro
  • In the search box, type the name of your provider to locate the correct macro
  • ClickĀ OkĀ Ā to run the macro.Ā 
    • Note: the macro will run automatically and should only take a few seconds. When the macro functions are complete, you should see fewer Error and Warning messages in the left-hand column.

Ā 

Ā 

TransformationNotes
Rename KBART columns to GOKb columns

This code renames all columns in a KBART file to GOKb equivalents except

  • first_author - there is no current GOKb equivalent to this KBART field
  • title_id - this can contain a variety of information and so there is no direct mapping to a GOKb equivalent field.
  • publisher_name - this often contains organization names that GOKb would consider imprints.
Trim title.identifier.issn and title.identifier.eissn fields and ensure all 'x' characters are in uppercaseThe columns title.identifier.issn and title.identifier.eissn must exist before this code is used
Transform volume, number, and date information originally formatted like "1:1 (1919)."

This code creates three columns: DateFirstPackageIssue, VolumeFirstPackageIssue, and NumberFirstPackageIssue. The code assumes you have all of this information in a single column named "PDF Starts."

Elsevier Macro: Collapse duplicate titles into single rows

Before applying this macro, confirm:

  • All DateFirsPackageIssue fields are populated
  • Any rows that contain a VolumeLastPackageIssue and/or a NumberLastPackageIssue also contain a DateLastPackageIssue
  • You have renamed the "title_id" column "title.identifier.elsevier"
Provider Transformation MacrosEach provider has one or more transformation macros based on the specific needs of its packages. These can be found on the provider management pages.

Related content

OpenRefine How-Tos
OpenRefine How-Tos
Read with this
Clean up data in OpenRefine (KBART files)
Clean up data in OpenRefine (KBART files)
More like this
Comparing Two Sets of Data in OpenRefine
Comparing Two Sets of Data in OpenRefine
Read with this
OpenRefine Warning Message: One or more rows contain duplicated data for column "title.identifier.issn" (or "title.identifier.eissn")
OpenRefine Warning Message: One or more rows contain duplicated data for column "title.identifier.issn" (or "title.identifier.eissn")
More like this
GOKb Data Loading Cheat Sheet
GOKb Data Loading Cheat Sheet
More like this
Columns
Columns
More like this

Operated as a Community Resource by the Open Library Foundation