| 1 | = i2b2 - Mapped Importer Data Sources |
| 2 | |
| 3 | Below are the settings for the specific Data Sources for the i2b2 Mapped Importer |
| 4 | |
| 5 | == !MsSqlDataSourceSet |
| 6 | |
| 7 | Settings |
| 8 | |
| 9 | * {{{type}}}: {{{uk.org.briccs.onyxmappedexport2pdo.input.sql.MsSqlDataSourceSet}}} |
| 10 | * {{{Server}}}: ''The name of the SQL Server'' |
| 11 | * {{{instance}}}: ''The name of the SQL Server instance''' |
| 12 | * {{{database}}}: ''The name of the SQL Server database'' |
| 13 | * {{{username}}}: ''The username required to log on'' |
| 14 | * {{{password}}}: ''The password for the above user'' |
| 15 | * {{{query}}}: ''The query used to extract the patient data'' |
| 16 | |
| 17 | The query should return a row for each patient, and contain a patient identifier. |
| 18 | |
| 19 | === Mapping Source |
| 20 | |
| 21 | The {{{source}}} attribute list for mappings should contain one item: the name of the field from the query. |
| 22 | |
| 23 | == !MySqlDataSourceSet |
| 24 | |
| 25 | Settings |
| 26 | |
| 27 | * {{{type}}}: {{{uk.org.briccs.onyxmappedexport2pdo.input.sql.MySqlDataSourceSet}}} |
| 28 | * {{{Server}}}: ''The name of the SQL Server'' |
| 29 | * {{{database}}}: ''The name of the SQL Server database'' |
| 30 | * {{{username}}}: ''The username required to log on'' |
| 31 | * {{{password}}}: ''The password for the above user'' |
| 32 | * {{{query}}}: ''The query used to extract the patient data'' |
| 33 | |
| 34 | The query should return a row for each patient, and contain a patient identifier. |
| 35 | |
| 36 | === Mapping Source |
| 37 | |
| 38 | The {{{source}}} attribute list for mappings should contain one item: the name of the field from the query. |
| 39 | |
| 40 | == !OnyxDataSourceSet |
| 41 | |
| 42 | Settings |
| 43 | |
| 44 | * {{{type}}}: uk.org.briccs.onyxmappedexport2pdo.onyx.!OnyxDataSourceSet |
| 45 | * {{{export_directory}}}: ''The directory where the exported questionnaires are stored'' |
| 46 | |
| 47 | This is a data source written to import questionnaire data exported from the Onyx questionnaire tool. |
| 48 | |
| 49 | The 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}}}). |
| 50 | |
| 51 | === Mapping Source |
| 52 | |
| 53 | The {{{source}}} attribute list for mappings should contain two |
| 54 | items. 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. |
| 55 | |