PersonalNamesReconcile.txt

[
  {
    "op": "core/row-reorder",
    "description": "Reorder rows",
    "mode": "record-based",
    "sorting": {
      "criteria": [
        {
          "reverse": false,
          "caseSensitive": false,
          "column": "Name",
          "valueType": "string",
          "blankPosition": 2,
          "errorPosition": 1
        }
      ]
    }
  },
  {
    "op": "core/blank-down",
    "description": "Blank down cells in column Name",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Name"
  },
  {
    "op": "core/row-removal",
    "description": "Remove rows",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "isBlank(value)",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "Name",
          "omitBlank": false,
          "columnName": "Name",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": true,
                "l": "true"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    }
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Name using expression grel:replace(value, ' ', '%20')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Name",
    "expression": "grel:replace(value, ' ', '%20')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-addition-by-fetching-urls",
    "description": "Create column Fetch at index 1 by fetching URLs based on column Name using expression grel:\"http://viaf.org/viaf/search/viaf?query=local.personalNames+%3D+%22\" + value + \"%22+and+local.sources+%3D+%22lc%22&sortKeys=holdingscount&httpAccept=application/xml\"",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "Fetch",
    "columnInsertIndex": 1,
    "baseColumnName": "Name",
    "urlExpression": "grel:\"http://viaf.org/viaf/search/viaf?query=local.personalNames+%3D+%22\" + value + \"%22+and+local.sources+%3D+%22lc%22&sortKeys=holdingscount&httpAccept=application/xml\"",
    "onError": "set-to-blank",
    "delay": 300
  },
  {
    "op": "core/column-addition",
    "description": "Create column LC Record Link at index 2 based on column Fetch using expression grel:value.parseHtml().select('ns2|source').toString()",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "isBlank(value)",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "LCNAF Heading",
          "omitBlank": false,
          "columnName": "LCNAF Heading",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": false,
                "l": "false"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "newColumnName": "LC Record Link",
    "columnInsertIndex": 2,
    "baseColumnName": "Fetch",
    "expression": "grel:value.parseHtml().select('ns2|source').toString()",
    "onError": "set-to-blank"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LC Record Link using expression grel:substring(value, indexOf(value, 'LC'))",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "LC Record Link",
    "expression": "grel:substring(value, indexOf(value, 'LC'))",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LC Record Link using expression grel:substring(value, 0, indexOf(value, '<'))",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "LC Record Link",
    "expression": "grel:substring(value, 0, indexOf(value, '<'))",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LC Record Link using expression value.trim()",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "LC Record Link",
    "expression": "value.trim()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LC Record Link using expression value.replace(/\\s+/,' ')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "LC Record Link",
    "expression": "value.replace(/\\s+/,' ')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LC Record Link using expression grel:substring(value, 3)",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "LC Record Link",
    "expression": "grel:substring(value, 3)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LC Record Link using expression grel:replace(value, ' ', '')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "LC Record Link",
    "expression": "grel:replace(value, ' ', '')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-addition-by-fetching-urls",
    "description": "Create column LCNAF Heading at index 3 by fetching URLs based on column LC Record Link using expression grel:\"http://viaf.org/processed/LC|\" + value + \"?httpAccept=text/xml\"",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "isBlank(value)",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "LC Record Link",
          "omitBlank": false,
          "columnName": "LC Record Link",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": false,
                "l": "false"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "newColumnName": "LCNAF Heading",
    "columnInsertIndex": 3,
    "baseColumnName": "LC Record Link",
    "urlExpression": "grel:\"http://viaf.org/processed/LC|\" + value + \"?httpAccept=text/xml\"",
    "onError": "set-to-blank",
    "delay": 300
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LCNAF Heading using expression grel:value.parseHtml().select('mx|datafield[tag~=100]')[0].htmlText()",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "isBlank(value)",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "LC Record Link",
          "omitBlank": false,
          "columnName": "LC Record Link",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": false,
                "l": "false"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "columnName": "LCNAF Heading",
    "expression": "grel:value.parseHtml().select('mx|datafield[tag~=100]')[0].htmlText()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LCNAF Heading using expression value.trim()",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "isBlank(value)",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "LC Record Link",
          "omitBlank": false,
          "columnName": "LC Record Link",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": false,
                "l": "false"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "columnName": "LCNAF Heading",
    "expression": "value.trim()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LCNAF Heading using expression value.replace(/\\s+/,' ')",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "isBlank(value)",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "LC Record Link",
          "omitBlank": false,
          "columnName": "LC Record Link",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": false,
                "l": "false"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "columnName": "LCNAF Heading",
    "expression": "value.replace(/\\s+/,' ')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column LC Record Link using expression grel:\"http://id.loc.gov/authorities/names/\" + value",
    "engineConfig": {
      "facets": [
        {
          "invert": false,
          "expression": "isBlank(value)",
          "selectError": false,
          "omitError": false,
          "selectBlank": false,
          "name": "LC Record Link",
          "omitBlank": false,
          "columnName": "LC Record Link",
          "type": "list",
          "selection": [
            {
              "v": {
                "v": false,
                "l": "false"
              }
            }
          ]
        }
      ],
      "mode": "row-based"
    },
    "columnName": "LC Record Link",
    "expression": "grel:\"http://id.loc.gov/authorities/names/\" + value",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-move",
    "description": "Move column LC Record Link to position 3",
    "columnName": "LC Record Link",
    "index": 3
  },
  {
    "op": "core/column-removal",
    "description": "Remove column Fetch",
    "columnName": "Fetch"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Name using expression grel:replace(value, '%20', ' ')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Name",
    "expression": "grel:replace(value, '%20', ' ')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
]