Add new column macros for OpenRefine

N.B. the 'PublicationTitle' column must exist before the code given below will work.

Column name

JSON to cut and paste into Refine
PublicationTitleThe PublicationTitle column must exist for any other code to work
gokb.ti.note (N.B. this is a custom field for a TI, you can amend the 'newColumnName' with an appropriate custom field name)
[
{
"op": "core/column-addition",
"description": "Create column gokb.ti.note at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "gokb.ti.note",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]
gokb.tipp.note (N.B. this is a custom field for a TIPP, you can amend the 'newColumnName' with an appropriate custom field name)
[
{
"op": "core/column-addition",
"description": "Create column gokb.tipp.note at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "gokb.tipp.note",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

title.identifier.issn

[
{
"op": "core/column-addition",
"description": "Create column title.identifier.issn at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "title.identifier.issn",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

title.identifier.eissn

[
{
"op": "core/column-addition",
"description": "Create column title.identifier.eissn at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "title.identifier.eissn",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

platform.host.url

[
{
"op": "core/column-addition",
"description": "Create column platform.host.url at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "platform.host.url",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

platform.host.name

[
{
"op": "core/column-addition",
"description": "Create column platform.host.name at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "platform.host.name",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

DateFirstPackageIssue

[
{
"op": "core/column-addition",
"description": "Create column DateFirstPackageIssue at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "DateFirstPackageIssue",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

VolumeFirstPackageIssue

[
{
"op": "core/column-addition",
"description": "Create column VolumeFirstPackageIssue at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "VolumeFirstPackageIssue",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

NumberFirstPackageIssue

[
{
"op": "core/column-addition",
"description": "Create column NumberFirstPackageIssue at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "NumberFirstPackageIssue",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

DateLastPackageIssue

[
{
"op": "core/column-addition",
"description": "Create column DateLastPackageIssue at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "DateLastPackageIssue",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

VolumeLastPackageIssue

[
{
"op": "core/column-addition",
"description": "Create column VolumeLastPackageIssue at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "VolumeLastPackageIssue",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

NumberLastPackageIssue

[
{
"op": "core/column-addition",
"description": "Create column NumberLastPackageIssue at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "NumberLastPackageIssue",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

CoverageDepth

[
{
"op": "core/column-addition",
"description": "Create column CoverageDepth at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "CoverageDepth",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

CoverageNotes

[
{
"op": "core/column-addition",
"description": "Create column CoverageNotes at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "CoverageNotes",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

KBARTEmbargo

[
{
"op": "core/column-addition",
"description": "Create column KBARTEmbargo at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "KBARTEmbargo",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

PackageName

[
{
"op": "core/column-addition",
"description": "Create column PackageName at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "PackageName",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

Org.publisher.name

[
{
"op": "core/column-addition",
"description": "Create column Org.publisher.name at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "Org.publisher.name",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

delayedOA

[
{
"op": "core/column-addition",
"description": "Create column delayedOA at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "delayedOA",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

delayedOAEmbargo

[
{
"op": "core/column-addition",
"description": "Create column delayedOAEmbargo at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "delayedOAEmbargo",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

hybridOA

[
{
"op": "core/column-addition",
"description": "Create column hybridOA at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "hybridOA",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

hybridOAurl

[
{
"op": "core/column-addition",
"description": "Create column hybridOAurl at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "hybridOAurl",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

PrimaryTIPP

[
{
"op": "core/column-addition",
"description": "Create column PrimaryTIPP at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "PrimaryTIPP",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

TIPPPayment

[
{
"op": "core/column-addition",
"description": "Create column TIPPPayment at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "TIPPPayment",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

TIPPStatus

[
{
"op": "core/column-addition",
"description": "Create column TIPPStatus at index 1 based on column PublicationTitle using expression grel:\"\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "TIPPStatus",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "grel:\"\"",
"onError": "set-to-blank"
}
]

Operated as a Community Resource by the Open Library Foundation