[
{
"op": "core/column-rename",
"description": "Rename column print_identifier to title.identifier.issn",
"oldColumnName": "print_identifier",
"newColumnName": "title.identifier.issn"
},
{
"op": "core/column-rename",
"description": "Rename column online_identifier to title.identifier.eissn",
"oldColumnName": "online_identifier",
"newColumnName": "title.identifier.eissn"
},
{
"op": "core/column-rename",
"description": "Rename column date_first_issue_online to DateFirstPackageIssue",
"oldColumnName": "date_first_issue_online",
"newColumnName": "DateFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column num_first_vol_online to VolumeFirstPackageIssue",
"oldColumnName": "num_first_vol_online",
"newColumnName": "VolumeFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column num_first_issue_online to NumberFirstPackageIssue",
"oldColumnName": "num_first_issue_online",
"newColumnName": "NumberFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column date_last_issue_online to DateLastPackageIssue",
"oldColumnName": "date_last_issue_online",
"newColumnName": "DateLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column num_last_vol_online to VolumeLastPackageIssue",
"oldColumnName": "num_last_vol_online",
"newColumnName": "VolumeLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column num_last_issue_online to NumberLastPackageIssue",
"oldColumnName": "num_last_issue_online",
"newColumnName": "NumberLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column title_url to platform.host.url",
"oldColumnName": "title_url",
"newColumnName": "platform.host.url"
},
{
"op": "core/column-rename",
"description": "Rename column embargo_info to KBARTEmbargo",
"oldColumnName": "embargo_info",
"newColumnName": "KBARTEmbargo"
},
{
"op": "core/column-rename",
"description": "Rename column coverage_depth to CoverageDepth",
"oldColumnName": "coverage_depth",
"newColumnName": "CoverageDepth"
},
{
"op": "core/column-rename",
"description": "Rename column publication_title to PublicationTitle",
"oldColumnName": "publication_title",
"newColumnName": "PublicationTitle"
},
{
"op": "core/column-addition",
"description": "Create column platform.host.name at index 27 based on column PublicationTitle using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "platform.host.name",
"columnInsertIndex": 27,
"baseColumnName": "PublicationTitle",
"expression": "\"\"",
"onError": "keep-original"
},{
"op": "core/column-addition",
"description": "Create column package.name at index 28 based on column PublicationTitle using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "package.name",
"columnInsertIndex": 28,
"baseColumnName": "PublicationTitle",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/column-addition",
"description": "Create column org.publisher.name at index 29 based on column PublicationTitle using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "org.publisher.name",
"columnInsertIndex": 29,
"baseColumnName": "PublicationTitle",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column CoverageDepth",
"engineConfig": {
"mode": "row-based",
"facets": [
{
"omitError": false,
"expression": "if (and(isNonBlank(value), (value.match(/^(\\Qfulltext\\E|\\Qselected articles\\E|\\Qabstracts\\E)$/) == null)), 'invalid', null)",
"selectBlank": false,
"selection": [
{
"v": {
"v": "invalid",
"l": "invalid"
}
}
],
"selectError": false,
"invert": false,
"name": "Invalid value in CoverageDepth",
"omitBlank": true,
"type": "list",
"columnName": "CoverageDepth"
}
]
},
"columnName": "CoverageDepth",
"expression": "value",
"edits": [
{
"fromBlank": false,
"fromError": false,
"from": [
"Full text"
],
"to": "fulltext"
}
]
},
{
"op": "core/column-rename",
"description": "Rename column title_id to title.identifier.elsevier",
"oldColumnName": "title_id",
"newColumnName": "title.identifier.elsevier"
},
{
"op": "core/column-rename",
"description": "Rename column notes to gokb.tipp.ElsevierNotes",
"oldColumnName": "notes",
"newColumnName": "gokb.tipp.ElsevierNotes"
},
{
"op": "core/column-rename",
"description": "Rename column publisher_name to gokb.ti.imprint",
"oldColumnName": "publisher_name",
"newColumnName": "gokb.ti.imprint"
},
{
"op": "core/column-rename",
"description": "Rename column preceding_publication_title_id to gokb.ti.ElsevierPrecedingPublicationID",
"oldColumnName": "preceding_publication_title_id",
"newColumnName": "gokb.ti.ElsevierPrecedingPublicationID"
},
{
"op": "core/column-rename",
"description": "Rename column title_change_history to gokb.ti.TitleHistoryNote",
"oldColumnName": "title_change_history",
"newColumnName": "gokb.ti.TitleHistoryNote"
},{
"op": "core/text-transform",
"description": "Text transform on cells in column platform.host.name using expression grel:replace(value,\"\",\"ScienceDirect::{Platform:21268}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "platform.host.name",
"expression": "grel:replace(value,\"\",\"ScienceDirect::{Platform:21268}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column org.publisher.name using expression grel:replace(value,\"\",\"Elsevier::{Org:205}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "org.publisher.name",
"expression": "grel:replace(value,\"\",\"Elsevier::{Org:205}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column DateFirstPackageIssue using expression value.toDate()",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssue",
"expression": "value.toDate()",
"onError": "keep-original",
"repeat": false,
"repeatCount": 0
},
{
"op": "core/column-move",
"description": "Move column title.identifier.elsevier to position 0",
"columnName": "title.identifier.elsevier",
"index": 0
},
{
"op": "core/row-reorder",
"description": "Reorder rows",
"mode": "record-based",
"sorting": {
"criteria": [
{
"errorPosition": 1,
"caseSensitive": false,
"valueType": "string",
"column": "title.identifier.elsevier",
"blankPosition": 2,
"reverse": false
},
{
"errorPosition": 1,
"valueType": "date",
"column": "DateFirstPackageIssue",
"blankPosition": 2,
"reverse": false
}
]
}
},...
| Word |
|---|
| name | ElsevierFullConversionMacroTEST.docx |
|---|
|