Ichthyology post-import adjustments

[FedorSteeman]

In consultation with with Ichthyology staff, we arrived at the several adjustments that need to be made to the imported dataset. Apart from show adjustments to the UI, the preparation types need to be redone. Staff will provide a list of preferred preparation types. Some entries will need to be fixed. Most notably DNA Samples should both indicate the EtOH solution (if indicated) and the count (original pattern was e.g. "2*99%". To enable the emeriti to continue and work in a more conventional way using spreadsheets, a template will have to be provide.

The following tasks make up this ticket:

• [x] Remove the "ZMUC " prefix to the alternative catalog numbers (P numbers)
• [x] Remove stars ("*") from P group
• [x] Collecting Event name string to show locality name
• [x] Redo preparation types
• [x] Widen field for preparation type in UI
• [x] Locality names restore question marks
• [x] Excel spreadsheet for Workbench imports

Staff will have to do the following:

• [x] Specify what preparation types they'd like
• [x] Send a draught for an Excel spreadsheet template

Labels will also have to be designed from scratch, but this will be in a separate ticket #262

Note: There was some concern regarding the "pencil" icon for records in one-to-many relations (like e.g. Locality) that someone would accidentally makes changes that unintended would affect multiple records. The question was whether this feature could be disabled.

---

[EDIT 2023-11-17:] Further actions:

• [x] Storage: For P-group entries add Room abbreviation (DS, AS, KAR, etc.)
• [x] For the Box branches under "Karrum" the P-group level (currently as "Aisle") should be removed
• [x] For Karrum The boxes starting with "KT" to be moved to Tøndesamling
• [x] The "More data" flag to be moved to a boolean field and placed on the form

[FedorSteeman]

Henrik Carl came over with the necessary files some of further requirements for post-import.

• Storage-tree.xlsx
• Workbench_fisk_forslag.xlsx
• Preparations.xlsx

I will perform the required changes and return a spreadsheet template file that is suitable for import.

[FedorSteeman]

Latest version of workbench template:

Workbench Fisk Template v10.xlsx

Added ticket for label creation here: #263

[FedorSteeman]

Latest version of the workbench template:

Workbench Fisk Template v13.xlsx

[FedorSteeman]

Restoring question marks for locality names was looked at and deemed too difficult in proportion to gain. This will have to be regarded as a tolerable conversion error.

[FedorSteeman]

Widened preparation type fields.