Skip to content

Bulk configuration

To modify the list of variables of a configured data source, you can use:

  • Excel/Spreadsheet: copy the table of variables into a spreadsheet, modify it and paste it back into the web interface
  • JSON: directly modify the configuration structure in JSON format

Note

This is useful for advanced users or when working with many variables. We always recommend entering two or three variables manually before proceeding with bulk modification, in order to have reference examples to start from.

Edit with Excel/Spreadsheet

  1. Click on the Edit with Excel icon

    Open bulk config

  2. Click on Copy to clipboard to copy the table of variables

    Copy to clipboard

  3. Paste the table into a spreadsheet (Excel, LibreOffice Calc, Google Sheets, etc) and modify it according to your needs. Some things to keep in mind:

    • Do not modify the column headers
    • Rows without a name (metadata/name) will be ignored
    • Do not modify the content of the variable_id column. The variable ID must be unique. When adding new variables, leave the field empty: a new ID will be generated automatically

    Spreadsheet

  4. Copy the modified table from the spreadsheet (select the entire sheet and press CTRL+C) and paste it into the indicated space

    Paste from clipboard

  5. Review the new variables listed, resolve any errors and confirm.

    Confirm

  6. The inserted/modified variables will now be visible in the variable table of the data source.

    Variables updated

Tip

If you are configuring several data sources from which you always acquire the same variables (e.g. multiple Modbus meters with the same registers), you can create an Excel/Spreadsheet file with the variable table starting from the first one configured. Remember to delete the content of the variable_id column cells. For each additional source, you just need to paste the same Excel file. This way you save time and reduce the risk of configuration errors.