Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Macro-Brill.txt

[ { "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 } ]

  • No labels