[
{
"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 1 based on column PublicationTitle using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "platform.host.name",
"columnInsertIndex": 1,
"baseColumnName": "PublicationTitle",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/column-addition",
"description": "Create column package.name at index 2 based on column PublicationTitle using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "package.name",
"columnInsertIndex": 2,
"baseColumnName": "PublicationTitle",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/column-addition",
"description": "Create column org.publisher.name at index 3 based on column PublicationTitle using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "org.publisher.name",
"columnInsertIndex": 3,
"baseColumnName": "PublicationTitle",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/column-addition",
"description": "Create column title.identifier.doi at index 4 based on column PublicationTitle using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "title.identifier.doi",
"columnInsertIndex": 4,
"baseColumnName": "PublicationTitle",
"expression": "\"\"",
"onError": "keep-original"
},
{
"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 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 date_last_issue_online to DateLastPackageIssue",
"oldColumnName": "date_last_issue_online",
"newColumnName": "DateLastPackageIssue"
},
{
"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 num_last_issue_online to NumberLastPackageIssue",
"oldColumnName": "num_last_issue_online",
"newColumnName": "NumberLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column publisher_name to title.imprint",
"oldColumnName": "publisher_name",
"newColumnName": "title.imprint"
},
{
"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 coverage_depth to CoverageDepth",
"oldColumnName": "coverage_depth",
"newColumnName": "CoverageDepth"
},
{
"op": "core/column-rename",
"description": "Rename column title_change_history to gokb.ti.TitleHistoryNote",
"oldColumnName": "title_change_history",
"newColumnName": "gokb.ti.TitleHistoryNote"
},
{
"op": "core/column-rename",
"description": "Rename column access_type to TIPPPayment",
"oldColumnName": "access_type",
"newColumnName": "TIPPPayment"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column DateLastPackageIssue using expression value.gokbDateCeiling()",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "value.gokbDateCeiling()",
"onError": "keep-original",
"repeat": false,
"repeatCount": 0
},
{
"op": "gokb/capture-edit",
"description": "Captured edit on cells in column CoverageDepth based on 1 column values.",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "CoverageDepth",
"expression": "if ( if( isNotNull(gokbCaseInsensitiveCellLookup('CoverageDepth')), and (isNotNull(cells[gokbCaseInsensitiveCellLookup('CoverageDepth')]), cells[gokbCaseInsensitiveCellLookup('CoverageDepth')].value == 'Full text'), false), 'fulltext', value )",
"onError": "keep-original",
"repeat": false,
"repeatCount": 0,
"basedOn": [
"CoverageDepth"
],
"value": "fulltext"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column TIPPPayment using expression grel:if(value=='P', 'Paid', value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "TIPPPayment",
"expression": "grel:if(value=='P', 'Paid', value)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column TIPPPayment using expression grel:if(value=='F', 'Free', value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "TIPPPayment",
"expression": "grel:if(value=='F', 'Free', 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)==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 platform.host.name using expression grel:replace(value, \"\",\"Elsevier ScienceDirect::{Platform:67297}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "platform.host.name",
"expression": "grel:replace(value,\"\",\"Elsevier ScienceDirect::{Platform:67297}\")",
"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:4487}\")value",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "org.publisher.name",
"expression": "grel:replace(value,\"\",\"Elsevier::{Org:4487}\")value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:if(value==\"Elsevier\",\"Elsevier::{Imprint:74165}\", \nif(value==\"Urban & Fischer\", \"Urban & Fischer::{Imprint:194799}\", \nif(value==\"Academic Press\", \"Academic Press::{Imprint:136750}\", if(value==\"Pergamon\",\"Pergamon::{Imprint:74167}\", \nif(value==\"Elsevier Masson\",\"Elsevier Masson::{Imprint:74168}\", \nif(value==\"Elsevier Current Trends\",\"Elsevier Current Trends::{Imprint:194800}\", \nif(value==\"Elsevier Advanced Technology\",\"Elsevier Advanced Technology::{Imprint:194796}\", \nif(value==\"Elsevier Doyma\",\"Elsevier Doyma::{Imprint:194802}\", \nif(value==\"JAI\",\"JAI::{Imprint:194669}\",\nif(value==\"North-Holland\",\"North-Holland::{Imprint:194803}\", \nif(value==\"W.B. Saunders\",\"W.B. Saunders::{Imprint:194805}\",\nif(value==\"Reed Business Information\",\"Reed Business Information::{Imprint:194809}\",\nif(value==\"Mosby\", \"Mosby::{Imprint:162160}\", \nif(value==\"Baillière Tindall\",\"Baillière Tindall::{Imprint:194813}\",\nif(value==\"Cell Press\",\"Cell Press::{Imprint:194814}\",\nif(value==\"Churchill Livingstone\",\"Churchill Livingstone::{Imprint:74166}\",\nif(value==\"Elsevier Science B.V.\",\"Elsevier Science B.V.::{Imprint:194815}\",\nif(value==\"Excerpta Medica\",\"Excerpta Medica::{Imprint:194812}\", \nif(value==\"No longer published by Elsevier\",\"\", \nvalue)))))))))))))))))))",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:if(value==\"Elsevier\",\"Elsevier::{Imprint:74165}\", \nif(value==\"Urban & Fischer\", \"Urban & Fischer::{Imprint:194799}\", \nif(value==\"Academic Press\", \"Academic Press::{Imprint:136750}\", if(value==\"Pergamon\",\"Pergamon::{Imprint:74167}\", \nif(value==\"Elsevier Masson\",\"Elsevier Masson::{Imprint:74168}\", \nif(value==\"Elsevier Current Trends\",\"Elsevier Current Trends::{Imprint:194800}\", \nif(value==\"Elsevier Advanced Technology\",\"Elsevier Advanced Technology::{Imprint:194796}\", \nif(value==\"Elsevier Doyma\",\"Elsevier Doyma::{Imprint:194802}\", \nif(value==\"JAI\",\"JAI::{Imprint:194669}\",\nif(value==\"North-Holland\",\"North-Holland::{Imprint:194803}\", \nif(value==\"W.B. Saunders\",\"W.B. Saunders::{Imprint:194805}\",\nif(value==\"Reed Business Information\",\"Reed Business Information::{Imprint:194809}\",\nif(value==\"Mosby\",\"Mosby::{Imprint:162160}\", \nif(value==\"Baillière Tindall\",\"Baillière Tindall::{Imprint:194813}\",\nif(value==\"Cell Press\",\"Cell Press::{Imprint:194814}\",\nif(value==\"Churchill Livingstone\",\"Churchill Livingstone::{Imprint:74166}\",\nif(value==\"Elsevier Science B.V.\",\"Elsevier Science B.V.::{Imprint:194815}\",\nif(value==\"Excerpta Medica\",\"Excerpta Medica::{Imprint:194812}\", \nif(value==\"No longer published by Elsevier\",\"\", \nvalue)))))))))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
]