American Medical Association Full Conversion Macro

[ { "op": "core/column-rename", "description": "Rename column publication_title to PublicationTitle", "oldColumnName": "publication_title", "newColumnName": "PublicationTitle" }, { "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 16 based on column PublicationTitle using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "org.publisher.name", "columnInsertIndex": 16, "baseColumnName": "PublicationTitle", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/column-addition", "description": "Create column package.name at index 17 based on column PublicationTitle using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "package.name", "columnInsertIndex": 17, "baseColumnName": "PublicationTitle", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/column-addition", "description": "Create column platform.host.name at index 18 based on column PublicationTitle using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "platform.host.name", "columnInsertIndex": 18, "baseColumnName": "PublicationTitle", "expression": "\"\"", "onError": "keep-original" }, { "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 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-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/text-transform", "description": "Text transform on cells in column org.publisher.name using expression grel:replace(value, \"\",\"American Medical Association::{Org:1523}\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "org.publisher.name", "expression": "grel:replace(value, \"\",\"American Medical Association::{Org:1523}\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column platform.host.name using expression grel:replace(value, \"\",\"American Medical Association::{Platform:247786}\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "platform.host.name", "expression": "grel:replace(value, \"\",\"American Medical Association::{Platform:247786}\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 } ]