Interval data import overview

  • Lets you import multiple meter readings at one time for one or more meters.
  • Managed through the Interval Data Profile in the Interval Data module.

How to get your interval data

  1. Coordinate with IT or your meter vendor.
    Work with your IT department or meter vendor to identify where your interval data comes from and how to access it.
  2. File format options:
    • What file types does the system provide?
    • Can the format be customized?
    • How often does the system export data?
    • Where are the files stored?

Next step

After you have this information you can setup your Interval Data Profile in EnergyCAP to start importing the data regularly.

Identify the meter or channel ID

Each meter uses a meter import ID or channel ID. You must enter this ID into EnergyCAP. Use the application or a spreadsheet to enter the information.

Confirm required file contents

Your interval data file must include:

  • A meter or channel import ID
  • A timestamp
  • An interval data value

Your file can include other columns, they are ignored unless you map them.

Create an import format

Set up an import format that matches the structure of your file. The format must follow specific rules, covered in the next section.

Options for importing interval data

  • Import files manually.
  • Use APIs and automation scripts to schedule the import.
  • Use a service to obtain and upload interval data.