Changes between Version 5 and Version 6 of i2b2 Mapped Importer


Ignore:
Timestamp:
10/03/13 15:26:37 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • i2b2 Mapped Importer

    v5 v6  
    1313
    1414== Settings
    15 The source and output used is defined is a YAML file.  By default this file is called settings.yaml in the application root directory, but the setings file path can be defined using the {{{-s=xxx}}} or {{{--settingsFilePath=xxx}}} command line arguments.
     15The source and output to used is defined is a YAML file.  By default this file is called settings.yaml in the application root directory, but the setings file path can be defined using the {{{-s=xxx}}} or {{{--settingsFilePath=xxx}}} command line arguments.
    1616
    17 The settings that can be defined are {{{dataSource}}} and {{{output}}}.  Both settings have a field called {{{type}}} that defines the class used to as a source or output processor.  The further fields are specific for the {{{type}}} specified.
     17The settings that can be defined are {{{dataSource}}} and {{{output}}}.  Both settings have a field called {{{type}}} that defines the class to be used as a source or output processor.  The further fields are specific for the {{{type}}} specified.
    1818
    1919Here is an example settings file:
     
    3030 export_directory: data
    3131}}}
     32
     33=== Available !DataSources
     34
     35There are three data sources at present, with others to be written as the need arises. The available ones are:
     36
     37* !MsSqlDataSourceSet
     38* !MySqlDataSourceSet
     39* !OnyxDataSourceSet
     40
     41==== !MsSqlDataSourceSet
     42
     43Settings
     44
     45* {{{type}}}: {{{uk.org.briccs.onyxmappedexport2pdo.input.sql.!MsSqlDataSourceSet}}}
     46* {{{Server}}}: ''The name of the SQL Server''
     47* {{{instance}}}: ''The name of the SQL Server instance'''
     48* {{{database}}}: ''The name of the SQL Server database''
     49* {{{username}}}: ''The username required to log on''
     50* {{{password}}}: ''The password for the above user''
     51* {{{query}}}: ''The query used to extract the patient data''
     52
     53The query should return a row for each patient, and contain a patient identifier.
     54
     55==== !MySqlDataSourceSet
     56
     57Settings
     58
     59* {{{type}}}: {{{uk.org.briccs.onyxmappedexport2pdo.input.sql.MySqlDataSourceSet}}}
     60* {{{Server}}}: ''The name of the SQL Server''
     61* {{{database}}}: ''The name of the SQL Server database''
     62* {{{username}}}: ''The username required to log on''
     63* {{{password}}}: ''The password for the above user''
     64* {{{query}}}: ''The query used to extract the patient data''
     65
     66The query should return a row for each patient, and contain a patient identifier.
     67
     68==== !OnyxDataSourceSet
     69
     70Settings
     71
     72* {{{type}}}: uk.org.briccs.onyxmappedexport2pdo.onyx.!OnyxDataSourceSet
     73* {{{export_directory}}}: ''The directory where the exported questionnaires are stored''
     74
     75This is a data source written to import questionnaire data exported from the Onyx questionnaire tool.
     76
     77The tool exports a set of questionnaires into a series of sub-directories, each directory containing the results for all patients for one questionnaire. Each questionnaire folder contains a file called {{{Entities.xml}}} that maps patients to numbered XML files within the same directory (for example {{{00000001.xml}}}).
     78
     79===== Mapping Source
     80
     81The {{{source}}} attribute list for mappings (see later) should contain two
     82items.  The first is the name of the questionnaire folder, the second is the name of the variable element within the patient's numbered XML file.
     83
    3284== Mapping
    3385
     
    58110* !DataSourceDateField
    59111* !YearOnlyDateField
    60