Operational Data Import

The Ops. Data Import capability lets you import any operational-related data to the platform.

The supported import format is a CSV file. 

The CSV Format

• 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 the software 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.