search

ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
60 stars 13 forks source link

CSV search of list of barcodes #6056

Open campmlc opened 1 year ago

campmlc commented 1 year ago

See #6053 I would like to request a tool in Object Tracking (or anywhere, for that matter) to allow for a search of a csv list of barcodes. This would be very similar to and return results in the same table format as the Container Contents CSV in Edit Container, except that instead of finding all contents of a single parent container, it would show the part locations of all the container barcodes in the csv list, including the guids for the cataloged items, including the barcodes which are not yet associated with a catalog item, and including barcodes that may still be container labels with no info.

Use case: I need this to find a list of barcodes and their locations even if they are located in different boxes, when the list includes barcodes containing objects which are not cataloged. And I would be able to download this list of barcodes, hierarchy locations, and associated items as csv. Example: List of barcodes for items which are not yet cataloged, which are located across different parent containers. I need to be able to download a csv list of their locations, and see which have associated cataloged items, and which do not.

Holloman barcodes_birds 2022.zip

Alternate approach: We currently have Find Container Barcode and In Barcode list searches, but these only return the part locations in the drag/print format, which isn't downloadable as csv. Above results using FindContainer and Drag/Print: bird barcodes scanned in Arctos 3-21-2023.pdf

Priority: Moderate to high, needed for work.

DerekSikes commented 1 year ago

I endorse this idea but would also like that csv list to include the accepted identification. This would make finding specimens much easier.

campmlc commented 1 year ago

So this is kind of like a hybrid between the current Container Contents csv and Show All Collection Objects in this Container. Except that it would give us that table from a csv list in Container Barcode search across multiple parent containers - as we currently now lack the ability to generate either of the above forms from such a list.

On Thu, Mar 23, 2023 at 4:36 PM DerekSikes @.***> wrote:

  • [EXTERNAL]*

I endorse this idea but would also like that csv list to include the accepted identification. This would make finding specimens much easier.

— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/6056#issuecomment-1482003598, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADQ7JBF34U4EOLAYWQABYVLW5TF7RANCNFSM6AAAAAAWFZZIAY . You are receiving this because you were assigned.Message ID: @.***>

campmlc commented 1 year ago

This is asking for the capability to search on a list of barcodes in Find Container with the capability of selecting all to download in the format of Container Contents.csv, with the associated collection objects when applicable. This list of barcodes may not share a common container, and they may or may not be associatd with collection objects. In this situation, the only option now is to use Drag/Print and then print as a pdf, which is a very difficult medium and which does not give us info on the associated collection objects.