Versions Compared

Old Version 23

changes.mady.by.user Shraddha Ranpise (Deactivated)

Saved on

compared with

New Version 24

changes.mady.by.user Nidhi Harmukh (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Steps to import CSV

Expand
titleExpand...
  1. Go to participants list page of the collection protocol whose visits custom form values has to be added/updated
  2. Click on 'More' button and select option 'Biospecimen Data'
  3. Select desired form, E.g. 'Base Haematology Pathology Annotation Form' from 'Select Record Type' visits' 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 'Input Records File' field, select 'Import Type' as 'Create' to add or 'Update' to update values of the custom forms
  6. Click on 'Validate and Import' button
  7. Refer 'Import status' to check the status of import job

Example Form

Base Haematology Pathology Annotation Form

Sample CSV

Download

Data Dictionary

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Update)

DescriptionPermissible ValuesValidations
Record IDIntegerNoYesNeed not be specified while adding a new record

Visit NameStringYesDepends

Visit should be existing within the system
Specimen ProcedureStringNoDependsValid value from the listPermissible Values File
CommentStringNoNo


Other Specimen ProcedureStringNoNo


Biopsy Or Aspirate SiteStringNoNo
  • Left posterior illiac crest
  • Not applicable
  • Not specified
  • Other
  • Right posterior illiac crest
  • Sternum

Adequacy Of SpecimenStringNoNo
  • Limited
  • Not Specified
  • Satisfactory
  • Unsatisfactory

Cytogenetics StatusStringNoNo
  • Not Specified
  • Not performed
  • Performed
  • Performed - See separate report

Cytogenetics ResultStringNoNo


Immuno Phenotyping StatusStringNoNo
  • Not Specified
  • Not performed
  • Performed
  • Performed - See separate report

Immuno Phenotyping ResultStringNoNo


Immuno Phenotyping Method UsedStringNoNo


Other Biopsy Or Aspirate SiteStringNoNo


Pathologic Finding#1#Pathologic Finding DetailsStringNoNo

In 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#DetailStringNoNo

Histologic Type#1#TypeStringNoNo

In 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#DetailsStringNoNo

...