Steps to import CSV
- Go to the participants list page of the collection protocol whose specimens custom form values have to be added/updated.
- Click on the 'More' button and select the option 'Biospecimen Data.'
- Select desired form, E.g. 'Specimen Additional Rule' from 'Select Record Type' specimen's dropdown, click on 'Download Template File' to download the template file.
- Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table
- Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to add or 'Update' to update values of the custom forms or 'Update Else Create' to either create or update record. For the 'Update Else create' feature, please refer to Create & Update in Single Bulk Operation.
- Click on the 'Validate and Import' button.
- Refer 'Import status' to check the status of import job
|
Example Form
New Diagnosis Health Annotation
Sample CSV
Download
Data Dictionary
Column Name | Datatype | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
---|
Record ID | Integer | No | No | Should be specified while updating a record |
| Support to get this ID from a query is yet to be implemented. Right now, this ID can be retrieved from the events/forms tab in UI. For multiple records, update the record id required |
CP Short Title | String | Yes | Yes |
|
| Should Be existing within the system |
Specimen Label | String | Yes | Yes |
|
| The specimen should be existing within the system |
Name Of Procedure | String | No | No |
| Permissible Values File | Valid value from the list |
Date Of Examination | Date | No | No |
|
| Select the correct date format from UI based on the data in the file
|
Other Procedure | String | No | No |
|
|
|