OpenClinica
...
- The CP administrator configures the OpenClinica studies whose data needs to be imported or 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 the data files into in-memory structures representing the CRF metadata and data records.
- Validates the CRF metadata and records.
- Creates/updates corresponding forms and records in OpenSpecimen DB.
- Notifies users with metrics like how many forms, participants, visits, specimens, 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 or , copied from the local file system, or via API. This is determined by the server config chosen in the OpenClinica project/ 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, as mentioned on the OC Server Configuration