phoenixctms / ctsms

Phoenix CTMS - the ultimative CTMS/PRS/CDMS.
http://www.phoenixctms.org
GNU Lesser General Public License v2.1
55 stars 35 forks source link

ecrfdataexport.sh does not publish any files #141

Closed rkrenn closed 3 years ago

rkrenn commented 3 years ago

I'm currently searching for a reliable tool to integrate various features for trial design and execution. I came upon your excellent web-based tool Phoenix Clinical Trial Management System and have tried to get a feel for it by creating test trials. I very much like the possibilities and the look of the CTMS.

However, I was somehow unable to export the generated eCRF-files and wanted to ask whether you can help me with that? I ran the code provided on the website and I encountered one error: "publish_ecrf_pdfs error: my_department_cron@http://127.0.0.1:8080 - 422". When I ran the code without the task to publish pdfs it finishes without an error message and tells me the files should be available under "Files" in the trial webpage. However, there is no file and not even a subfolder within the CRF folder.

I don't know what I'm missing and I would greatly appreciate any help!

rkrenn commented 3 years ago

the issue is confirmed:

running the ecrfdataexport.sh tool as described in https://www.phoenixctms.org/features/modules/trials/ecrf/

sudo -u ctsms /ctsms/ecrfdataexport.sh --id=576472 \
 --task=cleanup_all \
 --task=export_ecrf_data_vertical \
 --task=export_ecrf_data_horizontal \
 --task=publish_ecrf_data_sqlite \
 --task=publish_ecrf_data_horizontal_csv \
 --task=publish_ecrf_data_xls \
 --task=publish_ecrf_data_pdfs \
 --task=publish_audit_trail_xls \
 --task=publish_ecrf_journal_xls \
 --task=publish_ecrfs_xls \
 --force

does not publish any output files to the trial, but prints the strange output below:

Trial eCRF export/data aggregation:

- working directory folders cleaned up

- vertical eCRF data prepared

- horizontal eCRF data prepared

publish_ecrf_data_horizontal_csv finished

publish_ecrf_data_xls finished

publish_ecrf_data_pdfs error: no files downloaded at /ctsms/bulk_processor/CTSMS/BulkProcessor/Projects/ETL/EcrfExporter/process.pl line 274.
rkrenn commented 3 years ago

please specify the new --upload option, ie.

sudo -u ctsms /ctsms/ecrfdataexport.sh --id=576472 \
 --task=cleanup_all \
 --task=export_ecrf_data_vertical \
 --task=export_ecrf_data_horizontal \
 --task=publish_ecrf_data_sqlite \
 --task=publish_ecrf_data_horizontal_csv \
 --task=publish_ecrf_data_xls \
 --task=publish_ecrf_data_pdfs \
 --task=publish_audit_trail_xls \
 --task=publish_ecrf_journal_xls \
 --task=publish_ecrfs_xls \
 --upload \
 --force

a more verbose hint will be introduced with https://github.com/phoenixctms/bulk-processor/pull/6 . also, it should no longer stop the processing sequence in that case..