A plugin that allows the creation and management of datasets from Excel files or zip files containing them.
- List sheets — Lists the sheets and corresponding information in your file
- Dataset management — Create or update a file dataset from the desired sheets, configurable from the processing parameters.
- Graceful stop — honours the stop signal from the platform and exits cleanly mid-run; optionally, the stop can be ignored to test forced termination after timeout.
The plugin configurations change depending on the datasetMode to be applied. There are three of them:
listto list the different sheetscreateto create a new datasetupdateto target an existing one
Overall, only the URL in the settings tab remains common, representing a stable URL from which the data file is downloaded (this is the only possible option, there is no repository).
For this mode, you only need to enter the URL.
| Tab | Field | Description |
|---|---|---|
| Datasets | prefix |
This corresponds to the title of the datasets to be created. The datasets are named according to this prefix and the name of the corresponding sheet |
| Parameters | addAllSheets |
Allows you to build datasets directly for all sheets in the file |
| Parameters | listIdsSheets |
Identifier of the sheets to extract to create datasets |
| Tab | Field | Description |
|---|---|---|
| Datasets | datasets |
List of datasets to be updated, taking into account the sheet number and the schema update forcing |
| Datasets - Datasets to update | dataset |
Name of the dataset to update, selectable from the list of available datasets |
| Datasets - Datasets to update | idSheet |
Sheet number used to update the corresponding dataset |
| Datasets - Datasets to update | forceUpdate |
Indicates whether the scheme update should also be forced |
Be careful when fixing dependencies. The project uses ExcelJS version 4.4.0. The npm audit fix command may downgrade this library, which will definitely crash the processing.