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

UBID: Allow importing multiple UBIDs in the same field #4177

Closed RDmitchell closed 2 months ago

RDmitchell commented 1 year ago

instance; seeddemostaging SHA: 22e66f350 Org: LBNL 101 File: Commercial Real Estate for sale in El Cerrito-PortreroFixed-UBID.xlsx

I have generated 2 slightly different UBIDs, from 2 different PNNL UBID creation tools, for the same property.

I would like to import them both into SEED at the same time.

I tried adding them both to the UBID field in the import file, separated by a semicolon, but upon import they were both added to the same UBID line in the table. image

RDmitchell commented 1 year ago

The file in question is here SEED Shared Folder\Software Development\Issues\Issue 4177

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 11 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 9 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 7 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 7 months ago

@kflemin -- this is potentially related to the UBID discussions we've been having recently, ie, #3957

RDmitchell commented 7 months ago

And I guess right now there is a way to add the 2nd UBID "by hand" by copying and pasting the 2nd UBID into the UBID UI implementation

RDmitchell commented 2 months ago

instance: seeddemostaging SHA: ee056e67e Org: LBNL 21

This worked great, as long as the UBID field was not set to a matching field.

I will write up a separate issue for that, ie, probably in the initial mapping step, if UBID is set to matching and any record has more than one UBID, we give some sort of error to the user that they can't have more than one UBID in the same field if it is a matching field.