Introduction
caTissue Plus OpenSpecimen contains the following improvements to the Bulk Operation feature:
- Upload Custom Forms/Dynamic Extensions (DE) data via BO
- Remove dependency on system identifiers (like participant id, specimen id, etc)
- BO rerun
- Better handling missing columns
- Default value
...
Custom Forms BO Support
In NCI 1.2, bulk upload was only possible for static model data. In Plus, user User will be able to insert data using BO for DE forms. Sample templates for default DE annotations at every level - participant, SCG & specimen is listed in the table belowCustom forms. When a new custom form is created or existing one is updated, the BO template is automatically generated. Users can use this for uploading data in bulk.
Remove dependency on system identifiers
In NCI 1.2older versions, when migrating data for Participant, SCG, and Specimens, one needed to perform certain manual operations in between uploading the files. I.e., upload participants, copy the participant system identifier into SCG CSV, upload SCG CSV, copy SCG system identifiers into Specimen CSV. This can long and tedious, as well as error prone due to manual intervention.
Plus OpenSpecimen fixes this issue by removing the dependency on system identifiers. So the work flow would be:
...
Note: there are some cases where you still need system ids and being resolved as we move along in PlusOpenSpecimen. Please feel free to report places where you find them.
...
Setting default value in template
In PlusOpenSpecimen, user can specify default values in the BO XML template at attribute level. User can skip such columns from CSV when loading data. Below are some use cases and examples how this can be used:
...
If the BO XML template contains a certain set of columns, then it was mandatory to have those columns in the CSV file too. However, in case of optional columns or in case of "Edit", it is not necessary to have all the columns in the CSV file. In PlusOpenSpecimen, BO ignores the missing columns unless any of the missing column was mandatory. Even the mandatory columns can be skipped if default value is specified in the template.
...
You can load standard BO templates by running below ant target from CATISSUE_HOME OpenSpecimen installable directory.
ant load_bulk_operator_templates
...
Ant target to load Bulk Operation templates
Run below ant target from CATISSUE_HOME directory OpenSpecimen installable directory by changing respective parameters depending upon your template.
...