Difference between revisions of "Single Patient Identifier"
(→Import Mapping File) |
|||
| Line 29: | Line 29: | ||
=== Import Mapping File === | === Import Mapping File === | ||
| − | Switch to the ''Mapping File'' tab. Press the '''Import''' button and select the mapping file | + | Switch to the ''Mapping File'' tab. Press the '''Import''' button and select the mapping file ** |
The progress of the import will be shown at the foot of the window, & messages will appear in the log window. (information is posted every 50k records imported). | The progress of the import will be shown at the foot of the window, & messages will appear in the log window. (information is posted every 50k records imported). | ||
| + | |||
| + | You can press "Cancel" at any point, this will roll-back all changes and the database will be returned to the state prior to the Import button being activated. | ||
=== Legacy Identifiers === | === Legacy Identifiers === | ||
Revision as of 15:46, 19 August 2019
Contents
Wythenshawe Re-Numbering Project
Overview
The Aquila Substitution Program Module (SPM) is a Windows 32-bit application. It provides functionality to; import a mapping file, produce a legacy identifier report and perform identifier substitution.
Installation
The SPM installation file is available here: link
To upgrade, install over-the-top of an existing SPM installation.
You will need to enter the connection details of an existing AquilaCRS SQL Server database.
Settings
The SPM settings are stored in the logged in users "local app data" folder, under the sub-folder AquilaSPM.
The database connection information should be correct, but you can alter it here.
Add the output folders for the Summary Log and Execution Log. Both locations can be the same folder as the filenames are generated automatically.
Additional settings can be altered if necessary, i.e. CSV separator, system code & name.
Press Save Settings when done. If the database connection has changed, a new connection will be made at this point.
Import Mapping File
Switch to the Mapping File tab. Press the Import button and select the mapping file **
The progress of the import will be shown at the foot of the window, & messages will appear in the log window. (information is posted every 50k records imported).
You can press "Cancel" at any point, this will roll-back all changes and the database will be returned to the state prior to the Import button being activated.
