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.
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).
PHP client for interacting with OpenClinica webservices, and 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.