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

200 error (from geocoding) trying to import file by logging into ESPM from SEED #4675

Open RDmitchell opened 1 month ago

RDmitchell commented 1 month ago

instance: production SHA: 1dc901360 Org: LBNL 200 ESPM account logged into from data import in SEED: SEED_City_Test ESPM Custom Report Template selected: SEED City Benchmarking Report, which has 4 records in it image

I logged into the ESPM account from the Data import dialog box in SEED, selected the template, mapped the fields, and then the "Finding Inventory Matches" dialog box appeared, and appeared to generate a 200 error

image

This is similar to another user's experience doing the same thing, for an ESPM report with only 10 records in it.

RDmitchell commented 1 month ago

Instance: production SHA: 1dc901360 Org: LBNL 200 Data set: ESPM Import Test

The program got further, to Geocoding, and then appeared to get stuck there

image

It seems that Geocoding is causing a 200 error. This was importing the ESPM report as an Excel file, not using the SEED / ESPM login feature

image


Instance: dev1 SHA: f5fc3b772 Org: LBNL 200 Data set: EPA Test Import

Mapping image Mapping Review image Finding Inventory Matches -- 200 error image

RDmitchell commented 1 month ago

It would appear that the MapQuest API key is invalid. Image

But I don't really want to have geocoding on anyway.

RDmitchell commented 1 month ago

nstance: dev1 SHA: f5fc3b772 Org: LBNL 200 Data set: EPA Test Import

If I uncheck the geocoding fields, the import gets past the Geocoding 200 error.

Got through the entire import Image

I guess we need a way to bypass the geocoding step in mapping if there are problems with the geocoding settings? Either the API or the fields set for geocoding?

Need to give the user some information about how to deal with this.

RDmitchell commented 1 month ago

Instance: production SHA: 1dc901360 Org: LBNL 200 EPA Test Import cycle and data set

Unchecked the Geocoding fields in Column Settings, and then the program could import the Custom Report Template from the ESPM login in SEED.

Seems like we need to have more user help about this problem.