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