Operational Data Import
The Ops. Data Import capability lets you import any operational-related data to PowerRadar.
The supported import format is a CSV file.
The CSV Format
timestamp | relation_type | relation_id | value | units | unit_desc |
---|---|---|---|---|---|
date + time | site / device_group / device | site/device group/device ID | numeric value | display unit | part name / unit description |
2022-06-01 21:59:00 | device_group | 12345 | 16 | Ton | screws |
timestamp - the date and time of which the data was measured, in one of the following formats:
%Y-%m-%d %H:%M:%S (ISO 8601 format)
Example: 2022-04-17 11:25:12%m/%d/%Y %H:%M:%S
Example: 04/17/2022 11:25:12%d %b %Y %H:%M:%S
Example: 17 Apr 2022 11:25:12%Y %b %d %H:%M:%S
Example: 2022 Apr 17 11:25:12%d/%b/%Y:%H:%M:%S
Example: 17/Apr/2022:11:25:12
relation_type - the entity in PowerRadar to which the data in this specific row is related.
You can relate data to either a Site, a specific Device, or a Device Group.
The valid entries in this type of cell are:site
device
device_group
relation_id - the ID of the site/device/device_group.
You can find your IDs in the "View site, devices and device groups IDs" helper menu (shown in the first image)value - any numeric value that describes the value of what was measured
units - the units in which this value is being measured.
Example: Kg, Ton, Pieces, Boxes, Liters, etc.
Since it's a free text input - you can add any unit
The unit length is limited to 30 characters long.unit_desc - a specific description for the selected unit
Example: nails, screws, dishes, water
The unit description length is limited to 50 characters long.