Importing measurements in bulk

factry historian supports importing measurements in bulk via a spreadsheet this can be used for bulk creation, editing and deletion of measurements prerequisites permissions in factry historian to manage measurements see privileges docid\ k2nnyecuxqqsiuclmpfkh an installed collector if you have not done so already, first installing a collector docid\ iv4 sd56tdxcqkrkcj4kv adding measurements in bulk open the collectors page in the factry historian web interface and select the collector for which you would like to import in bulk next, click the ellipsis vertical icon in the top right select export template from the dropdown menu you will be presented with an excel file template to complete enter the required information in the excel file this will be dependent on the collector type you are configuring for more information, consult the collectors then, proceed with importing measurements in bulk docid\ g5wek8z fipxau2ymzirz editing measurement in bulk open the measurements page in the factry historian web interface and filter on your collector next, click the dropdown icon next to create measurement and select export to excel you will be presented with an excel file template to edit the excel file will be populated with existing measurements make the required changes and mark with a 'x' in column a (import) whether the changes you made should be imported for more information, consult the collectors then, proceed with importing measurements in bulk docid\ g5wek8z fipxau2ymzirz 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 in the {{tsdb}} ) once a measurement is deleted, the measurement stops collecting data and will disappear from the historian webpage renaming measurements in bulk renaming of measurements is not available in factry historian, yet if necessary it can be done manually for a few measurements alternatively, you can create a new measurement and delete the old measurement together with its data 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 importing measurements in bulk open the measurements page in the factry historian web interface next, click the dropdown icon next to create measurement and select import from excel click browse , select the spreadsheet file you just edited, and click confirm a green success notification will appear if the import was successful if the import failed, an error notification will show up click the question mark to retrieve more details about the error 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 the spreadsheet parser reads rows until an empty row is found, any rows after that will not be imported onboarding measurements in bulk with mqtt sparkplug b in the case of mqtt sparkplug b, with measurement sparkplug b messages docid\ ey5tgfrnf4egfqzembzxo turned on, bulk editing can be used to onboard measurements 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 not to alter the {{uuid}} field, as this would break the reference to the original measurement