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.



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.