ArctosDB / arctos

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

Code Table Request - Addition of identifier_type #7024

Closed Cloveis closed 10 months ago

Cloveis commented 10 months ago

Initial Request

We think we need to add a "identifier_n_type" specific to NMU:Mamm collection, in order to use those catalog numbers in that column in the new bulkloader format. If that is the case, we are requesting that vocabulary be added so that we are able to create relationships between mammals and their parasites through the bulkloader.

Goal

we are trying to add parasites to their own NMU:Para collection with their own catalog number unique from their host, however in the same bulkloader we are using "identifier_n_type, identifier_nvalue," etc to create a "parasite of" relationship between the two. With the new bulkloader format, we suppose we need to add a NMU:Mamm catalog number to the identifier_n_type code table

Context

existing values to not relate to NMU:Mamm specimens and therefore identifier_n_value catalog number would not connect

Table

https://arctos.database.museum/info/ctDocumentation.cfm?table=ctcoll_other_id_type

Proposed Value

NMU:Mamm Northern Museum of Zoology Mammals

Proposed Definition

Northern Museum of Zoology Catalog Numbers

Priority

medium-high, we are trying to send out a parasite loan and need to add catalog numbers to the specimens before mailing them out.

Example Data

Parasite Bulkoader - NemLoan2023.csv

keg34 commented 10 months ago

And, to reciprocate the relationship, would we need NMU:Para added to the ID type code table as well?

On Wed, Dec 6, 2023 at 4:02 PM Brendan Carroll @.***> wrote:

Initial Request

We think we need to add a "identifier_n_type" specific to NMU:Mamm collection, in order to use those catalog numbers in that column in the new bulkloader format. If that is the case, we are requesting that vocabulary be added so that we are able to create relationships between mammals and their parasites through the bulkloader. Goal

we are trying to add parasites to their own NMU:Para collection with their own catalog number unique from their host, however in the same bulkloader we are using "identifier_n_type, identifier_nvalue," etc to create a "parasite of" relationship between the two. With the new bulkloader format, we suppose we need to add a NMU:Mamm catalog number to the identifier_n_type code table Context

existing values to not relate to NMU:Mamm specimens and therefore identifier_n_value catalog number would not connect Table

https://arctos.database.museum/info/ctDocumentation.cfm?table=ctcoll_other_id_type Proposed Value

NMU:Mamm Northern Museum of Zoology Mammals Proposed Definition

Northern Museum of Zoology Catalog Numbers Priority

medium-high, we are trying to send out a parasite loan and need to add catalog numbers to the specimens before mailing them out. Example Data

Parasite Bulkoader - NemLoan2023.csv https://github.com/ArctosDB/arctos/files/13591540/Parasite.Bulkoader.-.NemLoan2023.csv

— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7024, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEEJQMSGABGPHXOCTXZLFKTYIDMORAVCNFSM6AAAAABAKAFJKWVHI2DSMVQWIX3LMV43ASLTON2WKOZSGAZDSMZXG43TKMA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

--


Kurt Galbreath | he/him/his | Professor | @.*** Department of Biology | Northern Michigan University | 1401 Presque Isle Ave | Marquette, MI 49855 Office: Weston 2119 | Northern Museum of Zoology: Weston 2202 | Phone: 906-227-1586 | Fax: 906-227-1063

Jegelewicz commented 10 months ago

This is no longer necessary! Simply add the entire url as the identifier value to link Arctos records. An example looks like this:

https://arctos.database.museum/guid/MSB:Para:1000 image

with the reciprocal https://arctos.database.museum/guid/MSB:Host:845

image

Let me know if that doesn't make sense - I am happy to meet up and help out.

keg34 commented 10 months ago

Thanks, Teresa!

On Wed, Dec 6, 2023 at 5:03 PM Teresa Mayfield-Meyer < @.***> wrote:

This is no longer necessary! Simply add the entire url as the identifier value to link Arctos records. An example looks like this:

https://arctos.database.museum/guid/MSB:Para:1000 image.png (view on web) https://github.com/ArctosDB/arctos/assets/5725767/edcaf5f8-70f6-41e7-bd70-bd3e0f5d5bf9

with the reciprocal https://arctos.database.museum/guid/MSB:Host:845

image.png (view on web) https://github.com/ArctosDB/arctos/assets/5725767/e828f048-152c-4fa9-aba4-47def1af3e4b

Let me know if that doesn't make sense - I am happy to meet up and help out.

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

--


Kurt Galbreath | he/him/his | Professor | @.*** Department of Biology | Northern Michigan University | 1401 Presque Isle Ave | Marquette, MI 49855 Office: Weston 2119 | Northern Museum of Zoology: Weston 2202 | Phone: 906-227-1586 | Fax: 906-227-1063

Jegelewicz commented 10 months ago

@keg34 please close this issue if you are satisfied with the outcome!