You are here:
Vanderbilt Biostatistics Wiki
>
Main Web
>
Projects
>
ResDM
>
RdmGroup
>
ResearchDatabaseGoals
(08 Aug 2005,
JeremyStephens
)
(raw view)
E
dit
A
ttach
---+ Research Database Goals The research database [[RdmGroup][discussion group]] topic is the parent of this topic. ---++ Server Installation * RSDBdevServInst * Our Development [[http://debian.mc.vanderbilt.edu][Page]] ---++ Database Qualification Tests * Form Branching * Categorical Data * checkboxes * radio buttons * text boxes * user comments * continuous variables * floats * others ? * Range Checks * Hard - (only accept values between certain limits, without exceptions) * Soft - (warns about out-of-bounds values, but will accept them) * Audit trails * Import/export capabilities (including "Print" copies) ---++ Tasks for August Meeting * Main.DalePlummer - Look at Java developer tools [[http://www.eclipse.org][Eclipse]] and [[http://www.oracle.com/technology/products/jdev/index.html][JDeveloper]] * Main.JeffreyHorner * Call Tom Caldwell to re-evaluate his system and see if he's still interested in open sourcing <nop>MetaClinic * Call Akaza folks to ask where's the next release of [[http://www.openclinica.org/][OpenClinica]] * Main.ColeBeck * Can you change <nop>OpenClinica CRFs (add variables, alter categorical variabes) mid-trial? What happens to existing data? * You can add new versions of CRFs, but the old data will still be attached the old version of the CRF. You can't load the old data from the old CRF into the new CRF. You can export all versions of CRFs at the same time- the number of columns is approximately the number of questions in each CRF times the number of CRFs. If data is not collected for a particular version, that column is left blank. * What are <nop>OpenClinica's audit capabilities? * Auditing seems to be unimplemented, yet planned (and at a moderately high priority FWIW) * Can you use <nop>OpenClinica for non-patient data? * You probably aren't supposed to - a new subject needs an identifier, a gender, and a YOB date. * However, you could easily enter any gender or birthdate for any subject, regardless if it is human. * Main.JeremyStephens - research the <nop>OpenClinica Java code that reads the CRF excel spreadsheat spec. Does it translate to the spreadsheet to an intermediate format? Is it easy to add new CRF import functionality? * There seems to be no intermediate format. <nop>OpenClinica makes use of a Apache Java class called [[http://jakarta.apache.org/poi/apidocs/][HSSF]] (Horrible Spread Sheet Format) to convert Excel documents to useful Java objects. * Using the existing algorithm for validation and importing files, it wouldn't be too hard to make a new class to accept different kinds of input. The easiest way would be to copy the existing class and modify it. * CSVTable and supporting classes are installed in the <nop>OpenClinica framework on the test server; <nop>OpenClinica will accept CSV files for CRF input now (to upload, take a XLS CRF form and consolidate all sheets onto one; seperate the sections by one or more empty rows). [[%ATTACHURL%/pet.csv][Example CSV]] attached below. * Main.CharlesDupont - evaluate [[http://www.visitrial.com/][VisiTrial's]] CRF CDISC XML format for adding to <nop>OpenClinica ---++ Database Goals ---+++ 2005 July 18 * [[http://www.txoutcome.org/][Open Infastructure Outcomes]] * install * test for ease of use * [[http://www.openclinica.org/index.php][OpenClinica]] * install * test for ease of use * Oracle * look at range of options and usablity ---++ Miscellaneous * JakartaNotes
Attachments
1
Attachments
1
Topic attachments
I
Attachment
Action
Size
Date
Who
Comment
csv
pet.csv
manage
1.3 K
08 Aug 2005 - 11:40
JeremyStephens
Example CSV for OpenClinica CRFs
E
dit
|
A
ttach
|
P
rint version
|
H
istory
: r12
<
r11
<
r10
<
r9
|
B
acklinks
|
V
iew topic
|
Edit
w
iki text
|
M
ore topic actions
Topic revision: r12 - 08 Aug 2005,
JeremyStephens
Main
Department Home Page
Biostatistics Graduate Program
Vanderbilt University Medical Center
Main Web
Main Web Home
Search
Recent Changes
Changes
Topic list
Biostatistics Webs
Archive
Main
Sandbox
System
Register
|
Log In
Copyright © 2013-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Vanderbilt Biostatistics Wiki?
Send feedback