econservation: Migrate Catalog conservation data to Conservation Examination tab #1324
Open
Description
related issues:
- econservation: Topic 15: Using the Analysis Tab instead of Notes. #1250
- econservation: Topic 17: Consolidating Parties / Personnel Involved fields #1252
- Question 23: Sensitive + hazardous collections [MB] #1302
- related flags (e.g. 'Hazardous') in Catalog and Exhibit Objects have pulled from Conservation since 2020.
Data from the ecatalogue / Analysis tab needs to be deduplicated & migrated to the corresponding fields in econservation , primarily on the Examination tab:
| Catalog | Conservation | mapping |
|---|---|---|
| irn | ObjObjectsRef_tab.irn | many-to-one |
| AnaAnalysisNo_tab | AnaAnalysis_tab | |
| AnaMethod_tab | AnaMethod_tab | |
| AnaProposalNotesText0 | TreTreatmentProposal | |
| AnaStartDate0 | CheDateChecked0 | |
| AnaResults_tab | AnaResult0 | |
| AnaInvolvedPartiesRef_nesttab | CheNameRef_tab | attach Collaboration-Party if multiple |
| AnaRole_nesttab | CheRole_tab | in Collaboration-Party if multiple |
| AnaRelatedLoanRef_tab [eloans.InfLoanNumber] | InfTransactionRef ['A-'+efmnhtransactions.TraInvoiceNo] | |
| AnaMakeResultsAvailable_tab | NA | |
| AnaDateWhen0 | NA | |
| PARSE from AnaResults_tab text | AnaHazardous_tab | |
| PARSE from AnaResults_tab text | AnaPositiveNegative_tab |