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