taxonworks icon indicating copy to clipboard operation
taxonworks copied to clipboard

CO Linker accessible task: Export to BOLD [Was: Export Custom view CO Filter]

Open bpescador opened this issue 1 year ago • 6 comments

Feature or enhancement

Use Case: Preparing a plate of specimens for submission to BOLD for C01 sequencing. After preparing a plate of 95 specimens and databases in TW, we want to export select fields required for the specimen upload to BOLD. We want to prepare a custom view of the necessary fields in the CO Filter and then export those fields. I am attaching the BOLD template with example data. The BOLD export from TW would include the DwC fields on the attached template, even though they are on separate tabs on the template. SpecimenData_v3Transitional April 2024.xls

Location

CO Filter

Screenshot, napkin sketch of interface, or conceptual description

No response

Your role

PI

bpescador avatar Apr 23 '24 22:04 bpescador

What is the sample ID you intend to use here, the UUID we generate for the collection object?

mjy avatar Apr 26 '24 17:04 mjy

Sample ID example is "CASENT1234567-D01" Attaching fill out example that we created using cut and paste SpecimenData_Transitional_CCDB-49244_CCDB-49248_v2.xls

bpescador avatar Apr 26 '24 17:04 bpescador

What is the D0-1/2 added to sampleID? This is a catalog number with some text added?

mjy avatar Apr 26 '24 17:04 mjy

not to drag you into the sausage making but we have a system of linking a voucher catalog number to the leg of that voucher that was submitted for sequencing. So each time we remove a leg for sequencing, we give it a new catalog number based on the voucher + "D01" or "D02" when a second part (a leg) is submitted. The leg is never returned, but this has allowed us to link the identification of the voucher to the sequence - it is a 25-year-old system that works, so we have not changed it.

bpescador avatar Apr 26 '24 17:04 bpescador