This dialog box allows you run various scripts on the Image database as well as the UKCTOCS System database. It also allows you to run a series of automated User Acceptance Tests and validate the operation of the stored procedures you have installed on the UKCTOCS System database. The Database Admin dialog box is opened from the main menu (Tools | Database Admin), but it is only available to URA-Admin and SysAdmin users.
Click on the controls in the picture to access links to appropriate information
Normal Use: Validating the UKCTOCS System database connection
Open this Database Admin dialog box (Tools | Database Admin)
Enter the Surname, First names and Volunteer Reference for someone in the UKCTOCS System database
Press the TestPatientDb button and wait for the results to appear in the Results box
Normal Use: Running the User Acceptance Tests (UAT)
Open this Database Admin dialog box (Tools | Database Admin)
Press the Create UAT Files button and wait for the results to appear in the Results box
Press the Run UAT button and wait for your Browser to open displaying the result UAT document
Check the result UAT document contains no unexpected errors, i.e. read or yellow tables
Normal Use: Running a Database Script
Open this Database Admin dialog box (Tools | Database Admin)
Select the script named 'TestImageDb' in the Database Scripts list (script a) and press the Run button
Confirm that you want to run the script
Check the itemd that appear in the Results box to confirm that your connection to the Image database is good.
Repeat steps 2, 3 and 4, but for the script named 'TestPatientDb' to confirm that your connection to the UKCTOCS System database is good.
Note: The scripts are held in the application's DbScripts directory and are run from this dialog box according to the corresponding settings in your configuration file.
Controls
Enter the Volunteer's Surname in this textbox
Enter the Volunteer's First Names in this textbox
Enter the Volunteer Ref number in this textbox
Executes the test. The results are shown in the Results box
Creates the files needed for the UAT in the FIT directory. The progression of this file creation operation is shown in the Results box
Opens the UAT document in Word so that you can edit your User Acceptance Tests. After changing these tests save the document as a 'Web filtered (html) document with the same name and in the same location as the original. That is to say save it as the filename defined in your configuration file in your Install directory.
Executes the automated User Acceptance Tests by passing the UAT document to the FIT test runner. The progression of the testing is shown in the Results box and the resultant document is displayed in your browser. The name and location of this result document is given to the right of the button.
Scripts configurated to be run from this dialog box.
Note: The scripts are held in the application's DbScripts directory and are run from this dialog box according to the corresponding settings in your configuration file.
Runs the script selected in the Database Scripts List.
Displays the output generated by running a script, executing the UAT or testing the UKCTOCS database connection
Closes the dialog box