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 in the Parameters tab.
| Tab | Field | Description |
|---|---|---|
| File sheets | addAllSheets |
Allows you to build datasets directly for all sheets in the file |
| File sheets - Sheets | add |
Allows you to build a dataset with the corresponding sheet by checking the box |
| File sheets - Sheets | title |
This corresponds to the name you want for your dataset. By default, the title will be the sheet name. |
| 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 | sheet |
Name of the sheet from which the update should be made, selectable from the list of available sheets. |
| 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.