Sage Premier: Monthly Update Validation Errors

[

 {

   "op": "core/fill-down",

   "description": "Fill down cells in column platform.host.name",

   "engineConfig": {

     "mode": "row-based",

     "facets": []

   },

   "columnName": "platform.host.name"

 },

 {

   "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": 10

 },

 {

   "op": "core/fill-down",

   "description": "Fill down cells in column package.name",

   "engineConfig": {

     "mode": "row-based",

     "facets": []

   },

   "columnName": "package.name"

 },

 {

   "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": "core/mass-edit",

   "description": "Mass edit cells in column org.publisher.name",

   "engineConfig": {

     "mode": "row-based",

     "facets": [

       {

         "omitError": false,

         "expression": "value.match(/(\\QSAGE Publications, Inc\\E|\\QSAGE India\\E|\\QCorwin\\E|\\QSAGE Publications Ltd\\E)/)",

         "selectBlank": false,

         "selection": [

           {

             "v": {

               "v": "SAGE India",

               "l": "SAGE India"

             }

           }

         ],

         "selectError": false,

         "invert": false,

         "name": "None looked up values in org.publisher.name",

         "omitBlank": true,

         "type": "list",

         "columnName": "org.publisher.name"

       }

     ]

   },

   "columnName": "org.publisher.name",

   "expression": "value",

   "edits": [

     {

       "fromBlank": false,

       "fromError": false,

       "from": [

         "SAGE India"

       ],

       "to": "Sage::{Org:8723}"

     }

   ]

 },

 {

   "op": "core/mass-edit",

   "description": "Mass edit cells in column org.publisher.name",

   "engineConfig": {

     "mode": "row-based",

     "facets": [

       {

         "omitError": false,

         "expression": "value.match(/(\\QSAGE Publications, Inc\\E|\\QSAGE India\\E|\\QCorwin\\E|\\QSAGE Publications Ltd\\E)/)",

         "selectBlank": false,

         "selection": [

           {

             "v": {

               "v": "SAGE Publications Ltd",

               "l": "SAGE Publications Ltd"

             }

           }

         ],

         "selectError": false,

         "invert": false,

         "name": "None looked up values in org.publisher.name",

         "omitBlank": true,

         "type": "list",

         "columnName": "org.publisher.name"

       }

     ]

   },

   "columnName": "org.publisher.name",

   "expression": "value",

   "edits": [

     {

       "fromBlank": false,

       "fromError": false,

       "from": [

         "SAGE Publications Ltd"

       ],

       "to": "Sage::{Org:8723}"

     }

   ]

 },

 {

   "op": "core/mass-edit",

   "description": "Mass edit cells in column org.publisher.name",

   "engineConfig": {

     "mode": "row-based",

     "facets": [

       {

         "omitError": false,

         "expression": "value.match(/(\\QSAGE Publications, Inc\\E|\\QSAGE India\\E|\\QCorwin\\E|\\QSAGE Publications Ltd\\E)/)",

         "selectBlank": false,

         "selection": [

           {

             "v": {

               "v": "SAGE Publications, Inc",

               "l": "SAGE Publications, Inc"

             }

           }

         ],

         "selectError": false,

         "invert": false,

         "name": "None looked up values in org.publisher.name",

         "omitBlank": true,

         "type": "list",

         "columnName": "org.publisher.name"

       }

     ]

   },

   "columnName": "org.publisher.name",

   "expression": "value",

   "edits": [

     {

       "fromBlank": false,

       "fromError": false,

       "from": [

         "SAGE Publications, Inc"

       ],

       "to": "Sage::{Org:8723}"

     }

   ]

 },

 {

   "op": "core/mass-edit",

   "description": "Mass edit cells in column org.publisher.name",

   "engineConfig": {

     "mode": "row-based",

     "facets": [

       {

         "omitError": false,

         "expression": "value.match(/(\\QSAGE Publications, Inc\\E|\\QSAGE India\\E|\\QCorwin\\E|\\QSAGE Publications Ltd\\E)/)",

         "selectBlank": false,

         "selection": [

           {

             "v": {

               "v": "Corwin",

               "l": "Corwin"

             }

           }

         ],

         "selectError": false,

         "invert": false,

         "name": "None looked up values in org.publisher.name",

         "omitBlank": true,

         "type": "list",

         "columnName": "org.publisher.name"

       }

     ]

   },

   "columnName": "org.publisher.name",

   "expression": "value",

   "edits": [

     {

       "fromBlank": false,

       "fromError": false,

       "from": [

         "Corwin"

       ],

       "to": "Sage::{Org:8723}"

     }

   ]

 },

 {

   "op": "core/mass-edit",

   "description": "Mass edit cells in column title.imprint",

   "engineConfig": {

     "mode": "row-based",

     "facets": [

       {

         "omitError": false,

         "expression": "value.match(/(\\QCorwin\\E)/)",

         "selectBlank": false,

         "selection": [

           {

             "v": {

               "v": "Corwin",

               "l": "Corwin"

             }

           }

         ],

         "selectError": false,

         "invert": false,

         "name": "None looked up values in title.imprint",

         "omitBlank": true,

         "type": "list",

         "columnName": "title.imprint"

       }

     ]

   },

   "columnName": "title.imprint",

   "expression": "value",

   "edits": [

     {

       "fromBlank": false,

       "fromError": false,

       "from": [

         "Corwin"

       ],

       "to": "Corwin::{Imprint:191945}"

     }

   ]

 },

 {

   "op": "core/mass-edit",

   "description": "Mass edit cells in column package.name",

   "engineConfig": {

     "mode": "row-based",

     "facets": [

       {

         "omitError": false,

         "expression": "value.match(/(\\QSage: Premier 2015::{Package:162198}\\E)/)",

         "selectBlank": false,

         "selection": [

           {

             "v": {

               "v": "Sage: Premier 2015::{Package:162198}",

               "l": "Sage: Premier 2015::{Package:162198}"

             }

           }

         ],

         "selectError": false,

         "invert": false,

         "name": "None looked up values in package.name",

         "omitBlank": true,

         "type": "list",

         "columnName": "package.name"

       }

     ]

   },

   "columnName": "package.name",

   "expression": "value",

   "edits": [

     {

       "fromBlank": false,

       "fromError": false,

       "from": [

         "Sage: Premier 2015::{Package:162198}"

       ],

       "to": "Sage Premier 2015::{Package:241917}"

     }

   ]

 },

 {

   "op": "core/mass-edit",

   "description": "Mass edit cells in column title.imprint",

   "engineConfig": {

     "mode": "row-based",

     "facets": [

       {

         "omitError": false,

         "expression": "value.match(/(\\QCorwin::{Imprint:191945}\\E)/)",

         "selectBlank": false,

         "selection": [

           {

             "v": {

               "v": "Corwin::{Imprint:191945}",

               "l": "Corwin::{Imprint:191945}"

             }

           }

         ],

         "selectError": false,

         "invert": false,

         "name": "None looked up values in title.imprint",

         "omitBlank": true,

         "type": "list",

         "columnName": "title.imprint"

       }

     ]

   },

   "columnName": "title.imprint",

   "expression": "value",

   "edits": [

     {

       "fromBlank": false,

       "fromError": false,

       "from": [

         "Corwin::{Imprint:191945}"

       ],

       "to": "Corwin::{Imprint:241916}"

     }

   ]

 }

]

Error

Fix

Rename KBART columns to GOKb columns

This code renames all columns in a KBART file to GOKb equivalents except

• first_author - there is no current GOKb equivalent to this KBART field

• title_id - this can contain a variety of information and so there is no direct mapping to a GOKb equivalent field.

• publisher_name - this often contains organization names that GOKb would consider imprints.

platform.host.name

Import does not specify an platform.host.name column

Append a blank column

package.name

Import does not specify an package.name column

Append a blank column

org.publisher.name

Import does not specify an org.publisher.name column

Rename a column

publisher_name

platform.host.name

One or more rows contain no data for column "platform.host.name"

Look up Platform name

Edit cells > fill down

DateFirstPackageIssue

One or more rows contains invalid dates in the column "DateFirstPackageIssue".

Edit cells > Common transformations > to date

package.name

One or more rows contain no data for column "package.name"

Look up package or Create New

Edit cells > fill down

tipp.url

One or more rows contain no data for column "tipp.url"

Create facet

search for journal title on publishers website

Add URL to tipp.url cell and click Apply

DateLastPackageIssue

One or more rows contains invalid dates in the column "DateLastPackageIssue".

Attempt automatic conversion

org.publisher.name

One or more rows contains values in "org.publisher.name" that appear to not have been looked up from gokb. Please use the lookup functions on the right-click menu to populate this field

create facet

Select first publisher name facet, click include

Edit > look up

Apply to all identical cells

DateFirstPackageIssue

One or more rows contain no data for column "DateFirstPackageIssue"

create facet

update dates if known

title.imprint

One or more rows contains values in "title.imprint" that appear to not have been looked up from gokb. Please use the lookup functions on the right-click menu to populate this field

create facet

look up

apply to all identical cells

Update GOKb

Proceed with ingest

Source

Provider

Save and checkin

Log into the GOKb web interface

Search for Package

Select your package to edit

Add the List Verifier

List verifier date

Edit status: Approved

Nominal Platform: add name