Importing ESPM Meter data for multiple buildings

RDmitchell commented 5 years ago

Expected Behavior

Import a spreadsheet from ESPM with only a Meter Entries tab but with multiple buildings (Portfolio Manager ID)

Actual Behavior

It seemed like it was going to import properly, showing the list of meters
But then I get an error that it can't complete the import.
Then I tried importing it again and it worked (!!). So not sure you will be able to reproduce this but wanted to log it.
Steps to Reproduce

See this folder for file to import (ESPMCityBldgs-MeterEntriesOnly.xlsx) https://drive.google.com/drive/u/0/folders/1DaLNcy9MIiImf8JuamfXg6E5E5WKXVw2
Import the file into a Data Set
Should see a confirmation dialog box showing the meters
Click the Confirm button
Got an error (that I didn't record) and the file wouldn't import
I believe it generated a Sentry error (1109124477) (but this issue does not address that), and it is unclear what actually triggered that Sentry error)
But then I tried to import the file again and it worked (!!).. sigh ...
Here is the final dialog box confirming the import
And the meter data is matched to the properties in the Inventory Detail Meter view

Instance Information

Instance: dev1 (NREL) SHA: 04c106fa Org: LBNL 200 Cycle: 2019 Compliance Cycle Dataset: 2019 Compliance

adrian-lara commented 5 years ago

@RDmitchell just a heads up, I'll be creating a separate issue for the Sentry error you provided. Likely, no action is needed from you unless you want to remove the text about the SentryError here as to avoid anyone thinking it was resolved once this is issue closed.

EDIT: After re-reading the contents of this issue, it looks like this issue was initially created just for the error with the smaller PM Property ID request included. I still think it might be appropriate for me to create a separate issue as I'd like to include more technical details in the main text.

RDmitchell commented 5 years ago

@adrian-lara -- thanks -- I deleted the image, but left the Sentry number in.

And feel free to make a new issue. Sometimes I put too many things in one issue and they need to be separated out !!

RDmitchell commented 5 years ago

Instance: dev1 (NREL) SHA: e120119f Org: LBNL 200 Cycle: 2019 Compliance

This seems to be working well.

SEED-platform / seed