Page Comparison

[ { "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 date_last_issue_online to DateLastPackageIssue", "oldColumnName": "date_last_issue_online", "newColumnName": "DateLastPackageIssue" }, { "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-addition", "description": "Create column title.oastatus at index 16 based on column publication_title using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "title.oastatus", "columnInsertIndex": 16, "baseColumnName": "publication_title", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/column-addition", "description": "Create column PrimaryTIPP at index 17 based on column publication_title using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "PrimaryTIPP", "columnInsertIndex": 17, "baseColumnName": "publication_title", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/column-addition", "description": "Create column TIPPPayment at index 18 based on column publication_title using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "TIPPPayment", "columnInsertIndex": 18, "baseColumnName": "publication_title", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/column-addition", "description": "Create column TIPPStatus at index 19 based on column publication_title using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "TIPPStatus", "columnInsertIndex": 19, "baseColumnName": "publication_title", "expression": "\"\"", "onError": "keep-original" }, { "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_last_vol_online to VolumeLastPackageIssue", "oldColumnName": "num_last_vol_online", "newColumnName": "VolumeLastPackageIssue" }, { "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 num_last_issue_online to NumberLastPackageIssue", "oldColumnName": "num_last_issue_online", "newColumnName": "NumberLastPackageIssue" }, { "op": "core/text-transform", "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==4,toDate(value),value)", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "DateFirstPackageIssue", "expression": "grel:if(length(value)==4,toDate(value),value)", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==7,toDate(value),value)", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "DateFirstPackageIssue", "expression": "grel:if(length(value)==7,toDate(value),value)", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==10,toDate(value),value)", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "DateFirstPackageIssue", "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 DateLastPackageIssue using expression grel:if(length(value)==4,(inc(inc(toDate(toString(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/column-rename", "description": "Rename column publication_title to PublicationTitle", "oldColumnName": "publication_title", "newColumnName": "PublicationTitle" }, { "op": "core/column-rename", "description": "Rename column title_url to tipp.url", "oldColumnName": "title_url", "newColumnName": "tipp.url" }, { "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-addition", "description": "Create column org.publisher.name at index 20 based on column PublicationTitle using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "org.publisher.name", "columnInsertIndex": 20, "baseColumnName": "PublicationTitle", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/text-transform", "description": "Text transform on cells in column org.publisher.name using expression grel:replace(value,\"\",\"Brill::{Org:3273}\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "org.publisher.name", "expression": "grel:replace(value,\"\",\"Brill::{Org:3273}\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/column-addition", "description": "Create column platform.host.name at index 21 based on column PublicationTitle using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "platform.host.name", "columnInsertIndex": 21, "baseColumnName": "PublicationTitle", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/column-addition", "description": "Create column package.name at index 22 based on column PublicationTitle using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "package.name", "columnInsertIndex": 22, "baseColumnName": "PublicationTitle", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/text-transform", "description": "Text transform on cells in column platform.host.name using expression grel:replace(value,\"\",\"Brill::{Platform:67299}\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "platform.host.name", "expression": "grel:replace(value,\"\",\"Brill::{Platform:67299}\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "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/text-transform", "description": "Text transform on cells in column title.identifier.issn using expression grel:replace(value,\" \",\"\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "title.identifier.issn", "expression": "grel:replace(value,\" \",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column title.identifier.issn using expression grel:replace(value,\"x\",\"X\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "title.identifier.issn", "expression": "grel:replace(value,\"x\",\"X\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column title.identifier.eissn using expression grel:replace(value,\" \",\"\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "title.identifier.eissn", "expression": "grel:replace(value,\" \",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column title.identifier.eissn using expression grel:replace(value,\"x\",\"X\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "title.identifier.eissn", "expression": "grel:replace(value,\"x\",\"X\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 } ]brill macro.txt