Import measurements in bulk
Adding measurements one by one, would be a time-consuming operation.
Therefore we support importing measurements in bulk via a spreadsheet. Open the dropdown next to Create measurement and select Import from excel on top of the measurements page to start the import.
A template for importing measurements in bulk can be retrieved from the collectors page. Since this template depends on the collector type, first select the matching collector and then download the template .
Spreadsheet
For a spreadsheet, the file extensions .xlsx and .ods are accepted. The table below provides a generic example of the different measurement settings. Next to some optional fields, most of the fields are required. Furthermore, the specific measurement settings are depending on the collector type selected.
The left-most Import field should be used to mark which rows should be imported. Upon import of a spreadsheet, only rows where the Import column is not empty will be processed.
| Import | UUID | Name | Description | Datatype | Database | Collector | Tags | Status | Labels | Engineering specifications | Specific measurement settings | Metadata |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Optional | Optional | Optional | .. | .. | column for every unique key |
To give a clear overview of the measurements, it’s recommended to have separate tabs/spreadsheets for every collector type.
Import status
On a successful import, a green success notification should appear holding the message. If the import failed, an error notification will show up. Click the question mark to retrieve more details about the error.
Export measurements
Next to importing measurements in bulk, all measurements can be exported at once into a spreadsheet format. Open the dropdown next to Create measurement and select Export to excel on top of the measurements page to start the export.
Pause or delete measurements in bulk
Via the bulk import, one has the ability to set the status of multiple measurements at once.
To conveniently update the status of multiple measurements in one go, start from a
clean export
!
Pause measurements in bulk
To pause measurements in bulk, set the status column of these measurements to Paused. If these measurements still exist in Factry Historian, their status will be updated and the data collection for these measurements will be paused until it is resumed again. To resume the data collection for these measurements, set the status back to Active.
Delete measurements in bulk
To delete measurements in bulk, set the status column of these measurements to Deleted. If these measurements exist in Factry Historian, they will be soft deleted (they get a status Deleted but are still retrievable by Factry Support in case of necessity). Once a measurement is deleted, the measurement stops collecting data and will disappear for good from the historian webpage.
Onboarding measurements in bulk
To onboard discovered measurements in bulk, the required field Database has to be filled in with the name of a configured time series database, and its status needs to be set to Active or Paused. Optionally, the name of the measurement to be onboarded can be changed, in this case it is important to not alter the
UUID field to not lose the reference to the original measurement.
Renaming measurements
Renaming of measurements in a time series data model is a resource costly operation. After all, the name of a measurement exists as a hard reference to the measurement’s data upon the creation of the measurement. Therefore renaming a measurement includes making a new measurement with a new name and migrating all the data of the old measurement to the new measurement.
For that reason, renaming of measurements is not available as an operation in Factry Historian, yet if necessary it can be done manually for a few measurements by Factry Support. Alternatively, one can create a new measurement and delete the old measurement together with its data.