Add historical data

Use the approved historical-import template for the active environment. The import must identify the target asset and timestamp for every row.

Required identity fields

Typical measurement fields

Supported import workflows can include fields such as:

• actualPower_W;
• energyDelta_Wh;
• phase or line voltages in volts;
• phase currents in amperes;
• temperature in degrees Celsius.

Use plain decimal notation without thousands separators. Do not convert watts to kilowatts or watt-hours to kilowatt-hours without also changing the field definition.

Example

When the same ID and timestamp occur more than once, duplicate handling depends on the importer. Remove unintended duplicates before upload and document intentional corrections.

Import sequence

1. Export or create a small sample.
2. Verify headers, IDs, timestamps, timezone, and units.
3. Compare the interval with existing telemetry.
4. Import the sample.
5. Verify the resulting device chart and energy total.
6. Import the remaining approved range.
7. Record the source file and validation result.

Download the example workbook