A place to put scripts relating to OpenClinica. Some of these are listed on the OpenClinica Extensions page, or are mentioned in the Wikibook.
XSL transformations for converting data from an ODM 1.3 XML into CSV, R, SAS and Access.
Access database and accompanying scripts for building an SQL data mart - superseded by sqldatamart
Python script for generating csv listing of all value-label pairs for coded items in a study, from an ODM 1.3 XML or study metadata XML file.
XSL transformations for collating rule XML files into one file for editing / upload, and another for grouping (and ungrouping) rules by the target item.
XSL transformation for combining multiple versions of an ODM 1.3 XML file for comparison, to show the changes in bulk
Access database to read CRF .xls files in for review or editing, and write them out again.
XSL transformations for preparing a pdf report of discrepancy notes from an ODM 1.3 XML file.
Example of a CRF with many repeated items (16x50), a VBScript to generate rule xml for them based on a template (33 ruledefs, 35 rule actions) and selenium test suite to test the rules.
Python script for logging in to OpenClinica, scraping enrolment information and emailing a summary.
Selenium scripts for automating user tasks - bulk CRF version migration, deleting rules.
SQL scripts for building and maintaining a report database connected to OpenClinica's database via a foreign data wrapper. Also includes SQL scripts to facilitate export to xlsx (via R), and subsequent conversion to .dta (via stata) and .sas7bdat (via sas).
Clients for interacting with OpenClinica webservices.
- Python 3 client, with tests! Returns Lists of OrderedDicts instead of XML.
- PHP client with helper classes / function to build ODM structured data for import.
See also:
XSL transformation for converting an xform xml form into a flat structure for review.
Python script that reads an ODK xlsform and generates images for each question, in order to provide a layout style that is a bit nicer than the default. Supports multiple languages. Included example xlsform and generated files with image settings ideal for a Galaxy Tab 4.