Skip to main content

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.