-
Notifications
You must be signed in to change notification settings - Fork 15
assign positions csv
Nelson Loyola edited this page Jan 29, 2018
·
3 revisions
Wiki ▸ Client CSV Import ▸ Assign specimen positions CSV
A CSV file with this format can be used to assign positions, or move, specimens.
| 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 already exist in Biobank. The maximum length is 100.
|
| 2 | Current pallet label | Optional | Text | Used when moving specimens: this is the label on the pallet this specimen is currently stored in. Must already exist in Biobank. |
| 3 | Pallet product barcode | Optional | Text | The product barcode on the pallet this specimen is stored in. The pallet must already exist in Biobank. Also, see Notes below. |
| 4 | Top parent container type | Optional (Required if column 5 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. |
| 5 | Pallet label | Optional (Required if column 4 is specified) | Text | The label on the pallet this specimen is stored in. Must already exist in Biobank. Also, see Notes below. |
| 6 | Specimen position in pallet | Required | 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. |
| 7 | Comment | Optional | Text | The comment to apply to this specimen. There is no size limit. |
To specify a specimen position, use one of the following options:
- only fill in columns 3 and 6,
- only fill in columns 4, 5, and 6,
- fill in columns 3, 4, 5, and 6 (not recommended since it is redundant)
Here is a link to download a template CSV file: template