Specimen Events CSV
Got feedback or spotted a mistake?

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/Edit Event

  1. Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data' OR

  2. Go to the participants list page of the CP, click on the 'More' button, and select the option 'Biospecimen Data.'

  3. Select 'Frozen Event' from the 'Select Record Type' specimen's dropdown and click on 'Download Template File' to download the template file.

  4. Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table

  5. 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.

  6. Click on the 'Validate and Import' button

  7. 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

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:

  1. 'Fixed Event ID' for 'Fixed Event'

  2. 'Frozen Event ID' for 'Frozen Event

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com