/
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.
Ā
Ā
Transformation | Notes |
---|---|
Rename KBART columns to GOKb columns | This code renames all columns in a KBART file to GOKb equivalents except
|
Trim title.identifier.issn and title.identifier.eissn fields and ensure all 'x' characters are in uppercase | The 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:
|
Provider Transformation Macros | Each provider has one or more transformation macros based on the specific needs of its packages. These can be found on the provider management pages. |
, multiple selections available,
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
Operated as a Community Resource by the Open Library Foundation