Enable Relationship Field Mapping for Taxon table in WorkBench

[bhumikaguptaa]

Problem Description:

The Workbench uploader currently does not allow for mapping any relationship fields when the base table is a tree table, such as Taxon. This appears to be a systemic restriction that limits the data that can be imported for hierarchical structures.

An example of this limitation, raised by Oliva, CSIRO, is the inability to assign a "Created By" agent when batch-uploading new taxa. The specific workflow issue is:

-To upload new taxa, the Workbench requires the Taxon table to be set as the base table. However, doing so hides all relationship fields from the data mapper, including the "Created By" agent field. This prevents the assignment of a creator to new taxon records during a batch upload, meaning all records are assigned only to the user who commits the data.

Proposed Solution:

The general solution is to enable the mapping of relationship fields for taxon table within the Workbench uploader.

For the specific use case described, this would mean exposing the "Created By" agent field in the data mapper when Taxon is selected as the base table, allowing users to map it to a column.

Requested by

Olivia Evangelista, CSIRO

Link to the request on Asana: https://app.asana.com/1/1149656227937659/project/1162715361029220/task/1211168554631046?focus=true