Changes between Initial Version and Version 1 of OpenClinica HowTo Import Data


Ignore:
Timestamp:
05/13/15 16:04:12 (9 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • OpenClinica HowTo Import Data

    v1 v1  
     1= OpenClinica HowTo Import Data
     2
     3Tags: [[OpenClinica]] [[Odin]] [[Data Integration]]
     4
     5== Process
     6
     71. Convert a CSV file into a CDSIC XML file using [[Odin]]
     82. If importing data for patients at a site level, choose the site in [[Odin]], but always import into [[OpenClinica]] from within the study level.
     93. Select the {{{Import}}} option from the {{{Tasks}}} menu.
     104. Select the [[Odin]] output file.
     115. Error messages are displayed in red.  If you get an error, correct the data in the CSV file and redo the [[Odin]] transformation, reusing the mapping file.
     126. Error messages are not always shown, but you can tell if the import has not worked because it will ask you to upload a file at the bottom of the screen.
     137. Errors often occur in look ups, which it calls {{{Response Sets}}}, because the data contains an invalid option.
     148. Data can be imported into the same event / events multiple times, with the values overwriting the existing data.  If the column does not exist in the new data set, the value will not be overwritten.
     15
     16== Gotchas
     17
     181. Do not include semicolons in CRF field names, because they break OpenClinica.  I wonder why?
     19
     20== Alternative
     21
     22There is a OCDataImporter desktop client that is hard to use, does not import repeating values, but does give better error messages than Odin.
     23
     24[[BackLinks]]