...
*Note: Some of the fields are filled out with values. These values are what will work if you were to run the tool on an installation of Noah System 4.9 or Noah System 4.9.1. These values must be changed to reflect valid users and patients in your database for the tester to work.
...
A. Known user id
...
This field should be populated with a known user id in your database. In the picture above, you will see a value of 8. This is for the ABC user in Noah System 4.
...
2) Now select the “Generate SQL” button right below the Patient managent check box.
...
a) You will see the window below once you select the Generate SQL button.
...
****Note: If your business system does not have a CE SQL database or MS SQL database, you will still need to generate either one of the scripts. You will then need to manually go into your database and create these patients in your patient table. All the patient data must be created EXACTLY the same as it appears in the text file or the Noah 4 Database Tester will fail.
...
A. Where to Get the Noah 4 Database Tester and how to run it.
Download the tool. Select the link below. You want the top box, “Documentation and Samples.” The Noah 4 Database tester is in this list. As of August 2018, it is the 5th item in the list.
https://www.himsa.com/en-us/members/development/noah4development/businesssystemdevelopment.aspx
...
3. Now copy the Noah 4 Database Tester.exe and the NoahDatabaseTestReport1.xsl files from the extracted zip. Paste these two files into the HIMSA\Noah 4 directory. On a Windows 10 Pro(64) computer with Noah Engine 4.9.1, this is the location, C:\Program Files (x86)\HIMSA\Noah 4. Please see the picture below.
...
4. Select the Noah 4 Database Tester.exe.
5. After reading Section 1 of this document, you will be able to fill out the required fields in the Noah 4 Database Tester tool. Please see the picture below.
...
6. Select the “Run Test” button to run the Noah 4 Database Tester tool.
...
1. Results are Test Successful
...
If your business system passes all the tests, you will see a “Test Successfull.” Under Result you will also see OK for all the items tested in the Result column.
...
2. Result of the test is Test Contains … errors
...
If your business System fails a test or tests, you will see, “Test contains … errors.” In the picture above, you can see I received 7 errors.
To see which tests I have failed, I must scroll through the results. In my picture below, you will see tests highlighted in red. Under the result column it will say “ERROR.” In my example these are two tests that failed. In your results the red highlighted tests that have Error in the Result column, are the items that you need to address. Once the issue has been fixed, the next time you run the Noah 4 Database Tester Tool, this test will say OK and no longer be highlighted in red.
...