Leave a comment at the end of this page or email contact@krishagni.com
Specimen Events CSV
Listed below are 2 sample event templates with descriptions for all the fields:
- Create/Update Frozen Event
- Create/Update Molecular Review Event
- Specimen disposal event
- Specimen return event
Create/Edit Event
- Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data' OR
- Go to the participants list page of the CP, click on the 'More' button, and select the option 'Biospecimen Data.'
- Select 'Frozen Event' from the 'Select Record Type' specimen's 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 the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update specimen frozen event, 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 the import job.
A general description of the other fields is listed below. File for permissible values for all the events
Column Name | Datatype | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
| Record ID | Integer | No | Yes | System generated the unique identifier for each event. Used to update an existing event record in the system | Required only when updating. | |
| CP Short Title | String | Yes | Yes | It is required when a unique label per CP setting is enabled. | ||
| Specimen Label | String | Yes | Yes | Specimen label of the specimen for which the frozen event is to be added | The specimen should exist within the system. | |
| Activity Status | String | No | No | Activity status of the record. To remove the existing records for the form, add 'Disabled.' | Active/Disabled | Default: Active 'Disabled' status cannot be used when creating specimen event. |
| User | String | Yes | No | Email address of the user | ||
| Date and Time | Date and Time | Yes | No | The format should be the same as that selected on UI during import. |
Note
From version v5.2 onwards, when a user downloads any specimen event template to update the events, the user will see the specific event name with the ID field instead of 'Record ID' since it was very confusing to the user while updating the specimen events.
Example:
- 'Fixed Event ID' for 'Fixed Event'
- 'Frozen Event ID' for 'Frozen Event
Leave a comment at the end of this page or email contact@krishagni.com