search

SEED-platform / seed

Standard Energy Efficiency Data (SEED) Platform™ is a web-based application that helps organizations easily manage data on the energy performance of large groups of buildings.
Other
107 stars 55 forks source link

Importing a file with meter data, get error of Overlapping Readings #4474

Closed RDmitchell closed 8 months ago

RDmitchell commented 9 months ago

Importing an ESPM file with one property in the first tab and 12 meter records in the 2nd tab.

The program seems to think there are 24 meter records, and eventually gives an error message saying there are overlapping readings.

image

image

RDmitchell commented 9 months ago

File is here G:\My Drive\SEED Shared Folder\Software Development\Issues\Issue 4474

axelstudios commented 8 months ago

This happened because the meters parser loops over the known energy types, and looks for all columns in the spreadsheet that start with them. Diesel is the only energy type where one of the types in SEED is a substring of another energy type, which caused it to recognize the column twice:

Energy types Diesel and Diesel #2 Use both matched Diesel #2 Use (GJ) in the spreadsheet.

RDmitchell commented 8 months ago

Instance: dev1 SHA: 9c719a96b

Fixed ! Thanks !! Image