Request - automagic .csv file for barcode swapper from container contents

[happiah-madson]

Help us understand your request (check below):

• search or data request (help with SQL or provide the specific fields you are trying to retrieve for your collection)
• add a new Github user to the Arctos Users team
• a new barcode series
• a new term for data entry or management
• a change or new report or label
• update to an Agent (split, merge, or other type of change)
• bulkload changes (to Agents, Identifiers, etc that are not already available as a bulkloading tool)
• new feature or otherwise a good idea to make Arctos even better
• quarantine taxon name and suggested replacement (please supply links)
• other

Describe what you're trying to do
In the last object tracking meeting (https://docs.google.com/document/d/1on0bbE7Z21YycA0CDeuyDmky96GW72ZcxpeMga29h2Y/edit?tab=t.0#heading=h.n39160yuawro), @Jegelewicz, @campmlc, and I wrote a updated, more generalized protocol for switching barcodes (https://docs.google.com/document/d/1k7bKUgGj8CudsUhVSbLwfuiv2sQL9-VAmz8b8ATOEiE/edit?tab=t.0#heading=h.nzafxxkwvug).

As the function of this work, we are requesting the following of @dustymc:
Please, would you make us an automated .csv file download for the barcode swapper tool from the Container Contents view? That way a user could search Container: Find (https://arctos.database.museum/findContainer.cfm) for a box that they are going to relabel, click on container contents (i.e., https://arctos.database.museum/info/container_contents.cfm?container_id=22957332), and then download the information needed for the barcode swapper tool. As there are many container levels present in the container contents view, a user would need to declare the level they want downloaded (i.e., 3, 4, etc.). We would like the downloaded .csv file to include BCx, LBLx, Tx, CIDx, and Institutional_acronym in this order so that it matches the view in container contents.

By extension, then, we think the barcode swapper tool should ask for BCx, LBLx, Tx, CIDx, and Institutional_acronym. Then you (@dustymc) can just use whichever fields you need for swapping magic.

Once a user has the autogenerated .csv file, they would just need to enter the replacement barcode, ideally greatly reducing the possibility of transcription/copy/paste/gremlin errors.

[dustymc]

This tool should only ever be used in outlier-ish situations, and has the potential to be absolutely catastrophic if even slightly misused, so I question the value (esp. vs. risk) of any development.

file to include BCx, LBLx, Tx, CIDx,

Very related to #8110 - I'd not be comfortable with this dangerous tool having cryptic headers, which suggests I probably shouldn't be comfortable with those cryptic headers existing at all. (They exist to crunch up the UI - tiny benefit vs huge cost??)

transcription/copy/paste/gremlin errors

I'm always happy to help pull data.

[happiah-madson]

which suggests I probably shouldn't be comfortable with those cryptic headers existing at all

!!!!!

I'm always happy to help pull data.

And I appreciate that! One of the concerns is that if we do pull data, we have to rearrange the columns to match the barcode swapper tool. That seems bad. Same order seems better.

[campmlc]

We don't need the cryptic headers expanded if we can get a "key" to the headers at the top of the page with the summary info.
And I agree with @happiah-madson that not having the columns in consistent order between the display/download and the tool is a problem. Any time we have to rearrange data to match a different tool we introduce error. We are asking for consistency that should be standard across all Arctos tools. But let's start here, please. This is needed across two collections, at least one for a major grant-funded project (MSB) that will involve barcode swaps for 4 freezers worth of cryovials..

[happiah-madson]

And while we are not as big as MSB, we do need to swap barcodes on probably err, 30,000 things?

[campmlc]

Because this isn't a one-off situation, we need modifications to this existing tool so that we do not have to submit a SQL download request every time.

[Jegelewicz]

This is NOT a one-off tool. It will be useful for all kinds of situations and it might as well be set up to help reduce the number of errors. I also don't think it is collection specific. There are at least two potential "heavy" users and I don't think that will be the end of it.

[campmlc]

This is only collection-specific if you include all genomics collections or anyone who uses object tracking. I also disagree with this label and with the assumption this is a one off tool. This is really a simple request that will drastically reduce the probability of error in an already complex process. Can we please make this happen? @mkoo

[campmlc]

Note we use this tool on a regular basis - if it is so dangerous, then that is an even better reason for the download to match the tool upload columns, and for there to be an autofilled download file as already exists for identifier bulkloads and edits, among others.