ElsevierFullConversionMacro.docx
| Word |
|---|
| name | ElsevierFullConversionMacro.docx |
|---|
|
[
{
"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
}
]
}
},
{
"op": "core/blank-down",
"description": "Blank down cells in column title.identifier.elsevier",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "title.identifier.elsevier"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(isBlank(value),\"Not Stated\",value)",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(isBlank(value),\"Not Stated\",value)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column VolumeLastPackageIssue using expression grel:if(isBlank(value),\"Not Stated\",value)",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "VolumeLastPackageIssue",
"expression": "grel:if(isBlank(value),\"Not Stated\",value)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column NumberLastPackageIssue using expression grel:if(isBlank(value),\"Not Stated\",value)",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "NumberLastPackageIssue",
"expression": "grel:if(isBlank(value),\"Not Stated\",value)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-addition",
"description": "Create column Last Issue Statement at index 8 based on column DateLastPackageIssue using expression grel:value+\",\"+if(isNonBlank(cells.VolumeLastPackageIssue.value),cells.VolumeLastPackageIssue.value,\"\")+\",\"+if(isNonBlank(cells.NumberLastPackageIssue.value),cells.NumberLastPackageIssue.value,\"\")",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"newColumnName": "Last Issue Statement",
"columnInsertIndex": 8,
"baseColumnName": "DateLastPackageIssue",
"expression": "grel:value+\",\"+if(isNonBlank(cells.VolumeLastPackageIssue.value),cells.VolumeLastPackageIssue.value,\"\")+\",\"+if(isNonBlank(cells.NumberLastPackageIssue.value),cells.NumberLastPackageIssue.value,\"\")",
"onError": "keep-original"
},
{
"op": "core/multivalued-cell-join",
"description": "Join multi-valued cells in column Last Issue Statement",
"columnName": "Last Issue Statement",
"keyColumnName": "title.identifier.elsevier",
"separator": "|"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Last Issue Statement using expression grel:with(value.split(\"|\").sort(),a,a[a.length()-1])",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "Last Issue Statement",
"expression": "grel:with(value.split(\"|\").sort(),a,a[a.length()-1])",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Last Issue Statement using expression grel:value.replace(\"Not Stated\",\"\")",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "Last Issue Statement",
"expression": "grel:value.replace(\"Not Stated\",\"\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-split",
"description": "Split column Last Issue Statement by separator",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "Last Issue Statement",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": ",",
"regex": false,
"maxColumns": 0
},
{
"op": "core/column-removal",
"description": "Remove column DateLastPackageIssue",
"columnName": "DateLastPackageIssue"
},
{
"op": "core/column-removal",
"description": "Remove column VolumeLastPackageIssue",
"columnName": "VolumeLastPackageIssue"
},
{
"op": "core/column-removal",
"description": "Remove column NumberLastPackageIssue",
"columnName": "NumberLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column Last Issue Statement 1 to DateLastPackageIssue",
"oldColumnName": "Last Issue Statement 1",
"newColumnName": "DateLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column Last Issue Statement 2 to VolumeLastPackageIssue",
"oldColumnName": "Last Issue Statement 2",
"newColumnName": "VolumeLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column Last Issue Statement 3 to NumberLastPackageIssue",
"oldColumnName": "Last Issue Statement 3",
"newColumnName": "NumberLastPackageIssue"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==4,(inc(inc(toDate(value),1,\"year\"),-1,\"day\")),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==4,(inc(inc(toDate(toString(value)),1,\"year\"),-1,\"day\")),value)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==7,(inc(inc(toDate(value),1,\"month\"),-1,\"day\")),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==7,(inc(inc(toDate(value),1,\"month\"),-1,\"day\")),value)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==10,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==10,toDate(value),value)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column VolumeLastPackageIssue using expression grel:value.toString()",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "VolumeLastPackageIssue",
"expression": "grel:value.toString()",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column NumberLastPackageIssue using expression grel:value.toString()",
"engineConfig": {
"mode": "record-based",
"facets": []
},
"columnName": "NumberLastPackageIssue",
"expression": "grel:value.toString()",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/row-removal",
"description": "Remove rows",
"engineConfig": {
"mode": "row-based",
"facets": [
{
"omitError": false,
"expression": "isBlank(value)",
"selectBlank": false,
"invert": false,
"selectError": false,
"selection": [
{
"v": {
"v": true,
"l": "true"
}
}
],
"name": "title.identifier.elsevier",
"omitBlank": false,
"type": "list",
"columnName": "title.identifier.elsevier"
}
]
}
}
]