| | 32 | |
| | 33 | === Available !DataSources |
| | 34 | |
| | 35 | There 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 | |
| | 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 | ==== !MySqlDataSourceSet |
| | 56 | |
| | 57 | Settings |
| | 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 | |
| | 66 | The query should return a row for each patient, and contain a patient identifier. |
| | 67 | |
| | 68 | ==== !OnyxDataSourceSet |
| | 69 | |
| | 70 | Settings |
| | 71 | |
| | 72 | * {{{type}}}: uk.org.briccs.onyxmappedexport2pdo.onyx.!OnyxDataSourceSet |
| | 73 | * {{{export_directory}}}: ''The directory where the exported questionnaires are stored'' |
| | 74 | |
| | 75 | This is a data source written to import questionnaire data exported from the Onyx questionnaire tool. |
| | 76 | |
| | 77 | 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}}}). |
| | 78 | |
| | 79 | ===== Mapping Source |
| | 80 | |
| | 81 | The {{{source}}} attribute list for mappings (see later) should contain two |
| | 82 | 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. |
| | 83 | |