| 43 | | Settings |
| 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 | | |
| 53 | | The query should return a row for each patient, and contain a patient identifier. |
| 54 | | |
| 55 | | ===== Mapping Source |
| 56 | | |
| 57 | | The {{{source}}} attribute list for mappings (see later) should contain one item: the name of the field from the query. |
| 58 | | |
| 59 | | ==== !MySqlDataSourceSet |
| 60 | | |
| 61 | | Settings |
| 62 | | |
| 63 | | * {{{type}}}: {{{uk.org.briccs.onyxmappedexport2pdo.input.sql.MySqlDataSourceSet}}} |
| 64 | | * {{{Server}}}: ''The name of the SQL Server'' |
| 65 | | * {{{database}}}: ''The name of the SQL Server database'' |
| 66 | | * {{{username}}}: ''The username required to log on'' |
| 67 | | * {{{password}}}: ''The password for the above user'' |
| 68 | | * {{{query}}}: ''The query used to extract the patient data'' |
| 69 | | |
| 70 | | The query should return a row for each patient, and contain a patient identifier. |
| 71 | | |
| 72 | | ===== Mapping Source |
| 73 | | |
| 74 | | The {{{source}}} attribute list for mappings (see later) should contain one item: the name of the field from the query. |
| 75 | | |
| 76 | | ==== !OnyxDataSourceSet |
| 77 | | |
| 78 | | Settings |
| 79 | | |
| 80 | | * {{{type}}}: uk.org.briccs.onyxmappedexport2pdo.onyx.!OnyxDataSourceSet |
| 81 | | * {{{export_directory}}}: ''The directory where the exported questionnaires are stored'' |
| 82 | | |
| 83 | | This is a data source written to import questionnaire data exported from the Onyx questionnaire tool. |
| 84 | | |
| 85 | | 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}}}). |
| 86 | | |
| 87 | | ===== Mapping Source |
| 88 | | |
| 89 | | The {{{source}}} attribute list for mappings (see later) should contain two |
| 90 | | 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. |
