Invalid json error for a previously used json file

Support and Helpdesk
1

I'm importing a history.json file, which gives an invalid json error. However, I've imported before this same file with no problem...with previous versions of openrefine. Has openrefine changed something on json files?

This is the file:

[
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "ULLVERD",
    "expression": "grel:value.replace('👁️', '')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "PÚBLIC",
    "expression": "grel:value.replace('👁️', '')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna PÚBLIC usant lexpressió {1}"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "FEM/MASC",
    "newColumnName": "GENERE",
    "description": "Reanomena la columna FEM/MASC a GENERE"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "J",
    "newColumnName": "JORNADA",
    "description": "Reanomena la columna J a JORNADA"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "G",
    "newColumnName": "GRUP",
    "description": "Reanomena la columna G a GRUP"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "RES\n[0-2]",
    "newColumnName": "RES",
    "description": "Reanomena la columna RES\n[0-2] a RES"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "JUG \n[0-2]",
    "newColumnName": "JUG_ULLVERD",
    "description": "Reanomena la columna JUG \n[0-2] a JUG_ULLVERD"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "TEC\n[0-2]",
    "newColumnName": "TEC_ULLVERD",
    "description": "Reanomena la columna TEC\n[0-2] a TEC_ULLVERD"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "DEL\n[0-2]",
    "newColumnName": "DEL_ULLVERD",
    "description": "Reanomena la columna DEL\n[0-2] a DEL_ULLVERD"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "GRA\n[0-2]",
    "newColumnName": "GRA_ULLVERD",
    "description": "Reanomena la columna GRA\n[0-2] a GRA_ULLVERD"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "NOTA_V\n[0-10]",
    "newColumnName": "NOTA_ULLVERD",
    "description": "Reanomena la columna NOTA_V\n[0-10] a NOTA_ULLVERD"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "PÚBLIC",
    "newColumnName": "PUBLIC",
    "description": "Reanomena la columna PÚBLIC a PUBLIC"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "JUG\n[0-2]",
    "newColumnName": "JUG_PUBLIC",
    "description": "Reanomena la columna JUG\n[0-2] a JUG_PUBLIC"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "TEC\n[0-2]2",
    "newColumnName": "TEC_PUBLIC",
    "description": "Reanomena la columna TEC\n[0-2]2 a TEC_PUBLIC"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "DEL\n[0-2]2",
    "newColumnName": "DEL_PUBLIC",
    "description": "Reanomena la columna DEL\n[0-2]2 a DEL_PUBLIC"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "GRA\n[0-2]2",
    "newColumnName": "GRA_PUBLIC",
    "description": "Reanomena la columna GRA\n[0-2]2 a GRA_PUBLIC"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "NOTA_P\n[0-10]",
    "newColumnName": "NOTA_PUBLIC",
    "description": "Reanomena la columna NOTA_P\n[0-10] a NOTA_PUBLIC"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "JUG_ULLVERD",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna JUG_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "JUG_ULLVERD",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna JUG_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "JUG_ULLVERD",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna JUG_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "TEC_ULLVERD",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna TEC_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "TEC_ULLVERD",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna TEC_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "DEL_ULLVERD",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna DEL_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "DEL_ULLVERD",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna DEL_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "GRA_ULLVERD",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna GRA_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "GRA_ULLVERD",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna GRA_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "NOTA_ULLVERD",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna NOTA_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "NOTA_ULLVERD",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna NOTA_ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "PUBLIC",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "ULLVERD",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna ULLVERD usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "RES",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna RES usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "JUG_PUBLIC",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna JUG_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "JUG_PUBLIC",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna JUG_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "TEC_PUBLIC",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna TEC_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "TEC_PUBLIC",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna TEC_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "DEL_PUBLIC",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna DEL_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "DEL_PUBLIC",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna DEL_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "GRA_PUBLIC",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna GRA_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "GRA_PUBLIC",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna GRA_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "NOTA_PUBLIC",
    "expression": "grel:value.replace(',','.')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna NOTA_PUBLIC usant lexpressió {1}"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "NOTA_PUBLIC",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Transforma text en les cel·les de la columna NOTA_PUBLIC usant lexpressió {1}"
  }
]
2

Hi @Robertgarrigos can you share:

  • The version of OpenRefine
  • The browser you use
  • The process you are following
  • When the process fails
  • What error message (if any) you see

Thank you

3

Sure:

openrefine 3.9.3 with Vivaldi browser 7.4.3. I'm just importing a json file, which was saved with openrefine. I've already used this file before without any problem, it was just in a previous version of operefine. Once imported, after clicking the apply button, and before the actions get applied, a red message at the bottom of the import window appears saying that the json is invalid:

Cursor_and_JUGA_VERD_CODINENC_PUNTUACIÓ_PARTITS_4_csv_-OpenRefine-_Vivaldi
Cursor_and_JUGA_VERD_CODINENC_PUNTUACIÓ_PARTITS_4_csv_-OpenRefine-_Vivaldi837×659 95.7 KB

4

If you switch to English language interface and try the same process do you get any more information in the error?

5

ah indeed, it has a more concrete error message. Shouldn't any other language have the same error? or at least, the original message in English, if there is not translation?

6

Found the problem: the original string has been changed since my last translation. Fixed in weblate :wink:

1 Like
7

I took the opportunity to finish the translation. Now it's at a 100% again.

2 Likes