Steps to import CSV
- Go to the collection protocols list page, click on 'Import' button and select option 'Biospecimen Data' OR
- Go to participants list page of the CP under which the visit has to be created/updated, click on 'More' button and select option 'Biospecimen Data'
- Select 'Visits' from 'Select Record Type' dropdown and 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 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update visits
- Click on 'Validate and Import' button
- Refer 'Import status' to check the status of import job
On updating the activity status of the visits to 'Disabled', the dependent data - specimens collected under this will be deleted. This is the force delete feature that is available on the UI as well.
Sample CSV
Data Dictionary
Column Name | Data type | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
| Identifier | Number | No | Depends | System auto-generated unique number for every visit | ||
| CP Short Title | String | Yes | No | Collection Protocol of the visit to be added | Should be existing and unique within OS | |
| PPID | String | Yes | No | The participant for whom this visit is being created. | Existing PPID. | |
| Event Label | String | No | No | Event Point Label from the protocol for which this event corresponds. E.g. baseline, surgery, etc. | In v3.4, if left blank, the system will add visit with event label as 'Unplanned Visit' | |
| Name | String | Depends | Yes | Name of the visit. Mandatory if the auto label generation set to OFF | Should be unique within OS | |
| Visit Date | Date | No | No | Select the correct date format from UI based on the data in the file. In v3.4, if left blank, the system will add current date by default | ||
| Visit Site | String | No | No | Valid site name | In v3.4, if left blank, the system will add recent visit site | |
| Visit Status | String | No | No |
| Default Value: Complete | |
| Clinical Diagnosis | String | No | No | Default Value: Not Specified | ||
| Clinical Status | String | No | No |
| Default Value: Not Specified | |
| Cohort | String | No | No | The group to which the visit belongs | By default, this field is not visible. In order to display this field, the system administrator needs to add values in the database table 'catissue_permissible_value' or user can add values through 'Dropdown Manager'. The drop-down is visible in visit page only if it has PVs added. | |
| Path. Number | String | No | No | Surgical Pathology Number | Default Value: Not Specified | |
| Pathology Report Name | String | No | No | The filename of the surgical pathology report | This is used to upload pathology reports. The document file name is specified in this column and the actual file is uploaded along with the CSV in a zip file. For more details refer 'File Upload via BO' | |
| Missed Reason | String | No | No | Reason for missed visit | Beyond processing time/ Insufficient sample collected / available/ Laboratory error/ Patient declined collection/ Poor sample quality/ Sample damaged/ Sample not collected by clinic / Clinic error/ Visit cancelled | Default Value: Not Specified |
| Comments | String | No | No | |||
| Activity Status | String | No | No |
| The value should be 'Active' during creation or kept blank in which case it will take default value as 'Active' | |
| Missed By#Email Address | String | No | No | Email address of the user who missed the visit | Should be an existing user in OpenSpecimen |