Import measurements in bulk

Adding measurements one by one, would be a time-consuming operation.
Therefore we support importing measurements in bulk, either via a spreadsheet or either via a JSON format. Open the dropdown next to Create measurement and select Import from excel on top of the measurements page to start the import.

Importing measurements in bulk

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.

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.

The spreadsheet parser reads rows until an empty row is found, any rows after that will not be imported.

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.

Measurement import error notification

Measurement import error modal

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.

Exporting measurements

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 timeseries 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 timeseries 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 it’s data.