Operational Data Import
Table of Contents
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
- %Y-%m-%d %H:%M:%S (ISO 8601 format)
-
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.