Specimen Custom Forms CSV
Got feedback or spotted a mistake?

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

Specimen Custom Forms CSV

Steps to import CSV

  1. Go to the Participants list page of the collection protocol whose specimen custom form values have to be added/updated.

  2. Click on the 'More' button and select the option 'Biospecimen Data.' 

     

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

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

  6. Click on the 'Validate and Import' button.

  7. Refer 'Import status' to check the status of the import job

Example Form

Sample CSV

Data Dictionary

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

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.

It is required when users are updating data for a form with multiple records.

CP Short Title

String

Yes

Yes

 

 

Should exist within the system

Specimen Label

String

Yes

Yes

 

 

Should exist within the system

NOTE: This field can be used for updating the specimen's form data, if only a single record is allowed

Name Of Procedure

String

No

No

 

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

 

 

 

 

Got feedback or spotted a mistake?

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