findatex-schemas

Note: findatex-schemas is not in any way affiliated with findatex.eu

Excel files are neither human nor machine friendly. This project tries convert the excel description of the EPT format to a JSON schema. The data can then be written in YAML (with editor validation) and converted to .xlsx file afterwards.

JSON schemas for https://findatex.eu formats

• ept.schema.json corresponds to EPT_V2.1_Final.xlsx
• tpt.schema.json corresponds to TPT_V6_20220314_final.xlsx
• EMT not done yet
• EET not done yet

installation

npm install -g findatex-schemas

validation

command line

eptValidate findatex-ept-captor-2023-12-29.yaml

vscode

In vscode you can add something like this to .vscode/settings.json and install redhat.vscode-yaml

{
  "json.schemas": [
    {
      "fileMatch": ["findatex-ept*.json"],
      "url": "https://raw.githubusercontent.com/CaptorAB/findatex-schemas/refs/heads/master/schemas/ept.schema.json"
    }
  ],
  "yaml.schemas": {
    "https://raw.githubusercontent.com/CaptorAB/findatex-schemas/refs/heads/master/schemas/ept.schema.json": [
      "findatex-ept*.yaml"
    ]
  }
}

executables

In addition to ept.schema.json findatex-schemas exposes executables to convert .xslx files to .yaml and back again.

for example:

eptExcel2yaml examples/findatex-ept-captor-2023-12-29.xlsx
eptYaml2excel findatex-ept-captor-2023-12-29.yaml
eptValidate findatex-ept-captor-2023-12-29.yaml

Contributions

Feel free to report bugs and submit pull requests