Add ability to export column mapping profile to CSV

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

Add ability to export column mapping profile to CSV #3610

Closed nllong closed 1 year ago

nllong commented 1 year ago

Is your feature request related to a problem? Please describe.

The py-seed project has the ability to create a column mapping profile from a CSV file. Doing this by hand can be error-prone due to having to match the names as they are in SEED. The CSV file format should look like this.

Describe the solution you'd like

Add the ability to export the mapping profile to CSV. Eventually, it would be nice to be able to import a mapping profile from the same CSV... but that can be for another day.

RDmitchell commented 1 year ago

@nllong -- is this something that can be done through the UI? If yes, where?

RDmitchell commented 1 year ago

instance: dev1 SHA: 4b8753257 Org: ID = 287

I went to the Org/Column Mappings link and clicked the Export to CSV icon

The file was exported, but looking at it, not all the fields are included, probably because of limitations of Excel The file stops on line 869 of the spreadsheet, with the field "Retail Store - Open of Closed Refrigeration ..."

However, looking at the column mapping screen in SEED for that org, there are many more fields under Retail Store

And the fields end with Zoo

Any user with ESPM data will likely have this many fields, as they are the standard "full" set of ESPM fields.

So we need to figure out a way to accommodate them, either by making 2 files, etc.

RDmitchell commented 1 year ago

@isalanglois -- this needs to go back into "in progress" to deal with the problem I found. Thx

isalanglois commented 1 year ago

@RDmitchell thanks for the update, tagging @nllong since it looks like he was working on it before

nllong commented 1 year ago

@RDmitchell - the file linked above is to Potential TAC Partners.

RDmitchell commented 1 year ago

@nllong -- how bizarre -- I just deleted it !!

nllong commented 1 year ago

I think I just fixed this issue. All the data were there, just not sorted the same way as the UI. It will be on develop after we merge the PR.

RDmitchell commented 1 year ago

instance: dev1 SHA: 7a529191a Release: 2.17.1

@nllong -- this seems like kind of an odd combination of a bunch of different views of the data that the user has. I think it needs some work -- I will open a new issue to refine it.

It's a combo of Column Settings and Column Properties, but not quite all of each.