Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
English (US)
US English (US)
ES Spanish
IT Italian
  • Home
  • Using the Platform
  • Data Import

Operational Data Import

Written by Omri Landman

Updated at April 23rd, 2025

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Using the Platform
    Getting Started Administration Energy Applications Triggers and Notification Center Data Export Data Import Reports
  • Hardware & Deployment
    Frequently Asked Questions (FAQ) Hardware Datasheets and Deployment Guides Software Deployment Guide Troubleshooting Flow Charts
  • Interactive Demos
  • Legal
+ More

Table of Contents

Import CSV Manually How do I know if my data was stored successfully?

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 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 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.

Import CSV Manually

You can import the CSV to the software importing the CSV manually.

On the Panoramic Power platform, go to the Site Settings of the site you want the data to be related to.

Under the site settings, go to Ops. Data Import tab

In that tab, click 'Import Manually' 

Drop your CSV file in the designated place and click 'Submit'.

The file will go through a format validation process. 

An error indication will be shown in case of a format validation issue.

How do I know if my data was stored successfully?

After a successful data import, the date of the last import will be updated.

You can see the last import date on the Ops. Data Import section in the site settings.

In what cases could this feature be helpful?

You can use the Operational Data Import feature for basically any type of external data you'd like to bring into the platform.

Some examples are:

- Production data

- Budget

- Operational data

How can I access the data?

Currently, the data is stored in the platform's database and can be used to generate advanced customized reports.

In the near future, we are planning to extend this capability and display Ops. data in the platform itself.

data ingestion data upload

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • How are power and energy calculated from the sensors’ data?
  • Do PAN-10/PAN-12/PAN-14 sensors assume power factor of 1 to get kW?
  • Can I use the PAN-42 for sub metering applications?
Expand