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.