Steps to import CSV
| Expand |
|---|
|
- Go to the participant's list page of the collection protocol whose visits custom form values has to be added/updated.
- Click on the 'More' button and select the option 'Biospecimen Data.'
 Image Added - Select desired form, E.g., ' Pathology' from the 'Select Record Type' visits' dropdown and click on 'Download Template File' to download the template file.
 Image Added - Enter all valid data in the template file as mentioned in the 'Data Dictionary' table below.
- 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 Update Else Create Operation.
- Click on the 'Validate and Import' button.
- Refer the 'Import status' to check the status of the import job.
|
Example Form
Base Haematology Pathology Annotation Form
Sample CSV
Download
Data Dictionary
Column Name | Datatype | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|
| Record ID | Integer | No |
| | | Specimen Label | No | Need not be specified while adding a new record. |
| For multiple records, update the record id required. |
| Visit Name | String | Yes |
| | | Yes |
|
| The visit should be existing within the system. |
| Specimen Procedure | String | No | No | Valid value from the list. | Permissible Values File |
| | | No |
|
|
|
| Other Specimen Procedure | String | No |
| |
|
|
|
| Biopsy Or Aspirate Site | String | No | No |
| | |
| - Left posterior illiac crest
- Not applicable
- Not specified
- Other
- Right posterior illiac crest
- Sternum
|
|
| Adequacy Of Specimen | String | No | No |
| |
|
|
| Cytogenetics Status | String | No |
| | | No |
| - Not Specified
- Not performed
- Performed
- Performed - See separate report
|
|
| Cytogenetics Result | String | No |
| | | No |
|
|
|
| Immuno Phenotyping Status | String | No | No |
| | - Not Specified
- Not performed
- Performed
- Performed - See separate report
|
|
| Immuno Phenotyping Result | String | No |
| |
|
|
|
| Immuno Phenotyping Method Used | String | No |
| | | No |
|
|
|
| Other Biopsy Or Aspirate Site | String | No |
| | | No |
|
|
|
| Pathologic Finding#1#Pathologic Finding Details | String | No | No | In the case of Sub Forms,
multiple values can be specified by adding additional columns in the csv as: Pathologic Finding#2#Pathologic Finding Details Pathologic Finding#2#Detail Pathologic Finding#3#Pathologic Finding Details Pathologic Finding#3#Detail
| Permissible Values File |
|
|
| Pathologic Finding#1#Detail | String | No |
| | No |
|
|
| Histologic Type#1#Type | String | No | No | In the case of Sub Forms,
multiple values can be specified by adding additional columns in the csv as: Histologic Type#2#Type Histologic Type#2#Details Histologic Type#3#Type Histologic Type#3#Details | Permissible Values File |
| |
|
| Histologic Type#1#Details | String | No |
| |
...