We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

Automated data extracts

Our configuration has Openclinica installed at a commercial data center and not hosted locally. We want to automated daily data extractions (ODM and Excel). After the data extraction the files should be transported to a specific folder on our network. What is a good way of doing this?


  • lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
    It is possible to set up automated jobs for extract dataset you have defined (Tasks->Admin->Jobs->Export Jobs->Create New). When a job runs, the file is saved a subfolder of the openclinica.data directory on the webserver and an email is sent to the address specified for the job.

    So you could replace the default folder (or specify one in datainfo.properties #18) with a symlink to an accessible network folder, or set the folder to sync using something like dropbox or google drive, etc. Alternatively, the email sent on completion of the job has a link to the extract file, so you could script the action of following the link, logging in to OpenClinica, and saving the file to some place.
  • mvirtosumvirtosu Posts: 276 ✭✭
    Another option would be to skip the automated daily extractions and build a program that logs into OpenClinica, calls the new REST services and saves the file wherever you want.
This discussion has been closed.