OpenClinica
- Users create study datasets. The dataset consists of all the study items that the users would like to import into the OpenSpecimen database.
- Subsequently, users create one scheduled job per dataset to export the corresponding study data. The scheduled job can be configured to export the data either on nightly weekly or weekly basis , depending upon the study activities. The scheduled job should be configured to export the data in ODM XML 1.3 format.
OpenSpecimen
- The CP administrator configures the OpenClinica studies whose data needs to be imported or synchronised synchronized into the OpenSpecimen database. Among other details, this configuration specifies how to pick the ODM XML data files from OpenClinica. The data files could be residing either on a local filesystem or remote filesystem. OpenSpecimen can handle both scenarios.
- A single pre-created scheduled job runs at pre-determined intervals and performs the following tasks for each configured study in the OpenSpecimen:
- downloads the study data files exported by OpenClinica using either SFTP or local filesystem copy command.
- parses Parses the data files into in-memory structures representing the CRF metadata and data records.
- validates Validates the CRF metadata and records.
- createsCreates/updates corresponding forms and records in OpenSpecimen DB.
- notifies Notifies users with metrics like how many forms, participants, visits, specimenspecimens, and form records were created/updated.
- Unlike OpenClinica, there is only one You can run the scheduled job in OpenSpecimen that is responsible for importing the data. Depending on the requirements, the frequency of the scheduled job can be changed to run on an hourly or daily, or weekly basis. Or else you can run the sync manually for a single protocol using 'Synchronize Records'.
OpenClinica Detailed Sync
...
- As mentioned above, the files are either downloaded from the remote file system using FTP
...
- , copied from the local file system, or via API. This is determined by the server config chosen in the OpenClinica
...
- study configuration.
...
- At present, there is no UI to show the list of server configs and their file handling mechanisms. The only option is to use the REST API Invoker
...
3. Local file system (config)
4. Remote file system
5. Server configs can be created using the POST method as illustrated below:
...
- , as mentioned on the OC Server Configuration