search

ArctosDB / documentation-wiki

Arctos Documentation and How-To Guides
https://handbook.arctosdb.org
GNU General Public License v3.0
13 stars 13 forks source link

Bulk Parts Subsamples (Lots) documentation #95

Open Jegelewicz opened 5 years ago

Jegelewicz commented 5 years ago

Is there documentation anywhere about what http://arctos.database.museum/tools/BulkPartSample.cfm does? Just reading the descriptions on the upload page, it appears that this tool will take a part and split it into two:

Find the part to split by part-parent (eg, nunc tube level) barcode. Will overwrite GUID. image

but does it make one a subsample (child) of the other (parent), or dies it just create two identical parts?

We have occasions where subsamples are made for a loan, but then not sent. The subsamples need to be returned to the collection, but as they were not part of the loan, no subsample was created in Arctos. If this tool could create a subsample and make it the child of the original part, it would save us time creating subsamples one by one from the specimen records.

dustymc commented 5 years ago 
UAM@ARCTOS> desc specimen_part;

 COLLECTION_OBJECT_ID <--PKEY specimen_part
 PART_NAME                      <-- just data
 SAMPLED_FROM_OBJ_ID <-- FKEY (specimen_part.COLLECTION_OBJECT_ID)
 DERIVED_FROM_CAT_ITEM  <!-- FKEY (specimen record)

The original part (ideally identified by exists_barcode) remains as it was. A new part is created and becomes a child of (exists_barcode).

Jegelewicz commented 5 years ago

@campmlc we should test this.