search

ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
Apache License 2.0
59 stars 13 forks source link

Auto increment catalog or other numbers? #7745

Open cjconroy opened 2 months ago

cjconroy commented 2 months ago

On the data entry screen, we used to have the option to auto-increment something like the catalog integer. Was this removed due to some good arguments? Or some database mechanics?

dustymc commented 2 months ago

https://docs.google.com/spreadsheets/d/1VbNC3k17WAHMum_qD5UYoXxUUWwXXh5gZSM5vfGvRzU/edit#gid=800227536&range=7:7

cjconroy commented 2 months ago

So, this is a decision for a collection? But also, we don't always catalog in order. Having it pick the next unused number would not work.

dustymc commented 2 weeks ago

I don't know how to address this. I can only know what catalog numbers you've used at the point of loading, any number of things could happen at any time before that, I think any attempts to predict or understand any of them is just going to be a confusing failure. Am I not understanding something??

catalog in order

I think this probably means 'in some order that makes sense to a particular human in a particular situation' and does not seem like something accessible to code.