ESPD-EDM branch contains JavaScript tools that process Excel files associated with ESPD-EDM.
Audience
This is a technical branch of ESPD-EDM repository and is intended to be used as a tool that uses as input:
- ESPD-EDM Excel Criterion file
- Code Lists Excel file
and processes them producing usable output files for the ESPD-EDM.
The main utility tools are in the root folder and are build in NodeJS.
The minimum NodeJS version required is 18.X
All libraries and commands are contained in the package.json file - this is a standard npm file. All commands must be launched in the root folder from the command line (CMD, PowerShell or any terminal) using a Windows Operating System. The tools work with Linux or OS X Operating Systems too, with the exception of some of utility commands, mentioned below.
To setup and install all necessary JavaScript libraries:
npm install
To cleanup the libraries folders (this works only under Windows):
npm run clean
The folder XSLT contains the XSL Transform files that were used until ESPD-EDM v4.0.0 to process and transform the Excel files.
XSLT/xslx-codelists-to-genericode/excel-to-gc-multilang-v1.0.xls was used to transfer the Excel Codelists file to genericode XML files.
XSLT/xslx-criterion-to-UBL/ODS-Data-Structures-to-ESPD-XML/ESPDRequest-Annotated.xslt was used to process the Excel Criterion file and produce the ESPD Request XML file, and XSLT/xslx-criterion-to-UBL/ODS-Data-Structures-to-ESPD-XML/From-RESQUEST-to-RESDPONSE.xslt was used to process the ESPD Request XML and produce the ESPD Response XML file.
All auxiliary support files are in XSLT/xslx-criterion-to-UBL/ODS-Data-Structures-to-ESPD-XML/inc folder.
The XSLT tools were deprecated starting with ESPD-EDM v4.0.0 and replaced by JavaScript tools. The XSLT scripts were preserved for archiving.
The folder xslx-criterion-VBA contains the VBA code that was used for ESPD-EDM v4.0.0 to generate the tags for each element in Excel Criterion files and to produce the XML Path like IDs. The code can only be used in conjunction with those specific Excel files.
The folder criterion contains Excel criterion files that are used by JavaScript tools. Those files are from corresponding tags for each ESPD-EDM release from GitHub ESPD-EDM repository.
The folder codelists contains the Excel Codelists file that is used by JavaScript tools to process and produce genericode XML files. The Excel files belong to a specific ESPD-EDM version.
To run a JavaScript utility using NodeJS, use the command line and type the name of the utility file, e.g: node check.js
For a list of available commands for each tool use --help option: node check.js --help.
| Tool | Description | Commands |
|---|---|---|
check.js |
A tool to process and check the Excel Criterion file for v4.0.0 | all_JSON - Print all spreadsheets as JSON full_structures - Print full structure of each spreadsheet each_structure - Print the element and child structure check_tag - Check the TAGS for each element check_UUID - Check the XML like path IDs for each element extract_codelists - List elements that have a Code List associated with |
codelist.js |
A tool to process Excel Codelists to generate genericode XML files, and download EU Vocabularies codelists. It uses the internal proxy for downloads, please adjust according to your network environment. | process_code_lists - Process Code Lists |
convert_to.js |
A tool to convert the Excel Criterion file to other formats. | excel2vue - Generates BootstrapVue components for each criteria excel2salt - Transforms Excel to PlantUML Salt UI mockups excel2treetrable - Transforms Excel to PlantUML tree table diagram |
excel2espd.js |
A tool to transform the Excel Criterion file v3.3.0 and v4.0.0 and generate the ESPD Request XML and ESPD Response XML files | espd_XML - Generates ESPD Request and Response XML files |
The Excel files are specified inside each script and should be modfied as required.
This software is shared using the European Union Public Licence (EUPL) version 1.2.