grandchild specimen csv

Wiki ▸ Client CSV Import ▸ Specimens

Grandchild specimen CSV Import

Grandchild specimens are aliquots or derivatives that have an aliquot or derivative as a parent. Grandchild specimens do not derive from source specimens.

The columns required in this CSV file are:

Column Number	Column Label	Value required/ optional	Format(s)	Description
1	Inventory ID	Required	Text - numbers, letters, or both	The inventory ID to assign this specimen. Must not exist in Biobank, must be unique in the CSV file. The maximum length is 100.
2	Parent inventory ID	Required	Text - numbers, letters, or both	The inventory ID for its parent specimen. Must already exist in Biobank, or in the CSV file. The maximum length is 100.
3	Volume	Optional	Decimal number	The volume of liquid in millilitres. Should only be used for liquid specimen types.
4	Specimen type	Required	Text	This specimen’s specimen type name (not short name). The specimen type must already exist in Biobank.
5	Created time	Required	YYYY-MM-DD HH:MM	The date and time the specimen was processed at.
6	Patient number	Optional	Text	The patient number this specimen belongs to. Must already exist in Biobank. See notes below.
7	Origin center	Optional	Text	The short name for the center where the specimens were collected. If left blank, then origin center will be the center selected by the client when he/she logged in. The short name must already exist in Biobank.
8	Current center	Optional	Text	The short name for the center where the specimens are currently located. If left blank, then current center will be the center selected by the client when he/she logged in. The short name must already exist in Biobank.
9	Pallet product barcode	Optional	Text	The product barcode on the pallet this specimen is stored in. Must already exist in Biobank. Also, see Notes below.
10	Top parent container type	Optional (Required if column 11 is specified)	Text	The short name of container type for the top container this pallet is stored in. Must already exist in Biobank. Also, see Notes below.
11	Pallet label	Optional (Required if column 10 is specified)	Text	The label on the pallet this specimen is stored in. Must already exist in Biobank. Also, see Notes below.
12	Specimen position in pallet	Optional (Required if columns 9, 10, or 11 are specified)	Text	Must adhere to pallet’s child labeling scheme. The position string where this specimen is stored in. Should not include the pallet label. Must be a valid position on the pallet. Also, see Notes below.
13	Comment	Optional	Text	The comment to apply to this specimen. There is no size limit.

Template file

Here is a link to download a template CSV file: template

Assigning a position

To specify a specimen position, use one of the following options:

• only fill in columns 9 and 12,
• only fill in columns 10, 11, and 12,
• fill in columns 9, 10, 11, and 12 (not recommended since it is redundant)