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
110 stars 55 forks source link

Error importing Meter data from ESPM #3905

Closed RDmitchell closed 1 year ago

RDmitchell commented 1 year ago

Instance: seedv2 Org: LBNL Test 200 Cycle: Meter Import Testing

There is an ESPM file that is generating an error when trying to import the meter data.

It seems that the problem is that ESPM has changed the name of their "ID" from

to

I believe @axelstudios indicated that SEED is looking for a field called "Property Id" (notice the lower case "d") in the meter tab, and that is probably what is causing the problem.

As explained in this doc, once I changed the field name in both tabs to "Property Id", I was able to import the meter data.

https://docs.google.com/document/d/1dNQygyF616CmbXtGwFNXtBg2nVwu3RDopAjimhxqqic/edit?usp=sharing

RDmitchell commented 1 year ago

comment from user


I tried changing it from Property ID to Property Id, and it worked!

Thanks for figuring that out. Would be great if SEED told us more information (i.e., more detailed error report) when there is a formatting error.


RDmitchell commented 1 year ago

Instance: dev1 SHA: c94869068 (2.18.0)

I am now able to import the original file from Open Tech (in the folder for this issue) that had the new ESPM field names in the meter tab, and the meter data imported without issue.