OpenClinica - LimeSurvey - Interface for Estonia
Preparation create empty repository on github with only readme.md
in eclipse: file - import - Project from Git (with smart import) - clone URI
mind that the correct destination folder is selected: C:\Users\Gerben Rienk\Documents\GitHub
right click on project, select PyDev - Set as PyDev Project
copy package oli from oli_ire
put oli.config in .gitignore by right-clicking on it and choosing Team - Ignore; commit and push and it works (!)
put an example oli_example.config next to it, so others understand how it works
create a db-user for administrative purposes:
CREATE USER oli WITH LOGIN UNENCRYPTED PASSWORD 'xxx' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
CREATE DATABASE oli_est OWNER oli;
CREATE TABLE ls_responses ( sid integer NOT NULL, -- survey id, as is used in LimeSurvey response_id integer NOT NULL, study_subject_id character varying(32), study_subject_oid character varying(32), data_ws_request character varying(10000), data_ws_response character varying(4000), date_completed date, CONSTRAINT pk_ls_responses PRIMARY KEY (sid, response_id) ) WITH ( OIDS=FALSE ); ALTER TABLE ls_responses OWNER TO oli; COMMENT ON COLUMN ls_responses.sid IS 'survey id, as is used in LimeSurvey';
in oli.config change studyIdentifier, studyOid, sid, dbName
in export_ls_into_oc.py change line from utils.fam_est import compose_odm