-
Notifications
You must be signed in to change notification settings - Fork 15
collection event attributes csv
Nelson Loyola edited this page Jan 10, 2018
·
5 revisions
Wiki ▸ Client CSV Import ▸ Collection Event Attributes
The columns required in this CSV file are:
Column Number | Column Label | Value required/ optional | Format(s) | Description |
---|---|---|---|---|
1 | Patient Number | Required | Text | The patient number this specimen belongs to. Must already exist in Biobank. |
2 | Visit Number | Required | Positive integer number. | The visit number to assign to the collection event. Must already exist in Biobank. |
3 | Attribute Name | Required | Text | The name of the collection event attribute. Must already exist in Biobank. |
4 | Attribute Value | Required | Text | The value to assign this collection event attribute. See notes following this table. The value must be less than or equal to 255 characters. |
The Attribute value depends on the type of the attribute being saved (as configured in the study) and are as follows:
- For type Number: the value can be a valid decimal number or integer.
- For type Text: the value can contain numbers letters or both.
- For type Date: the value has to be a string in the format
YYYY-MM-DD HH:MM
. - For type Select Single: the value can be the text corresponding to a valid selection.
- For type Select Multiple: the value can contain the text of multiple valid selections delimited with a semicolon.
Here is a link to download a template CSV file: template