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

Add Column Uniqueness Exclusions #4071

Open axelstudios opened 1 year ago

axelstudios commented 1 year ago

Is your feature request related to a problem? Please describe. Importing data from ESPM, and then adding custom data within SEED (like Salesforce IDs) via manual edits will cause the record to be an in-exact match for every future import rather than an ignored duplicate.

Describe the solution you'd like The Column Settings page should have an additional column with a checkbox to allow specific columns to be excluded from hashing. That way the hash_object can be identical to future ESPM imports, even if changes were made in SEED to excluded columns.

github-actions[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

github-actions[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

github-actions[bot] commented 10 months ago

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

github-actions[bot] commented 8 months ago

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

github-actions[bot] commented 6 months ago

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

RDmitchell commented 4 months ago

@axelstudios / @kflemin -- this is a problem for the City of Berkeley because they have 2 custom fields that they edit and that causes the duplicate data to be imported every time they update their ESPM data.

This has caused them to have to edit the ESPM data file outside SEED and only include data that has changed, which is definitely less than ideal.

Can we bump up the status of this so it gets fixed sooner rather than later ? Thanks !!

haneslinger commented 3 months ago

https://github.com/SEED-platform/seed/pull/4687 heres a necessary first step

RDmitchell commented 3 months ago

Ammon from the City of Berkeley is happy to demo the issue they are having if that would be useful.