collection event attributes csv

Wiki ▸ Client CSV Import ▸ Collection Event Attributes

Collection Event Attributes CSV Import

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:

1. For type Number: the value can be a valid decimal number or integer.
2. For type Text: the value can contain numbers letters or both.
3. For type Date: the value has to be a string in the format YYYY-MM-DD HH:MM.
4. For type Select Single: the value can be the text corresponding to a valid selection.
5. For type Select Multiple: the value can contain the text of multiple valid selections delimited with a semicolon.

Template file

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