Closed jdpye closed 4 months ago
HFX project had two instances of PI metadata: one before and one after addition of a PI. This caused the one-to-many match error.
contact_pi detectedby
<char> <char>
1: Dave Hebert (david.hebert@dfo-mpo.gc.ca), Fred Whoriskey (fwhoriskey@dal.ca) HFX
2: Dave Hebert (david.hebert@dfo-mpo.gc.ca), Robert Lennox (robert.lennox@dal.ca), Fred Whoriskey (fwhoriskey@dal.ca) HFX
The fix checks if multiple instances of PI information exist per project and, if so, combines those instances, extracts unique character elements, and replaces the PI/POC/PI_emails/POC_emails with the combined instance.
That did the trick. Appreciated, Mike!
Changing PIs with time is a tricky proposition!
Got a fun error when processing all the OTN NSBS data (open, attached)
Looks like there are more results in the PI/station_summary aggregation than there are in the data file. Could this be a problem with what our assumptions about uniqueness are for station names within a project, or is there another issue for us to chase down? Willing to bet it's a source data foible.
Source file was too big to attach, i'll ship it to you via Slack.