| | 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 | |