For initial configuration of DQM QAPP Settings, use the “DQM Starter QAPP” EDD and the “Getting Started with DQM” instructions.
Follow the instructions below to update existing DQM QAPP Settings configured with a previous version of EQuIS\DQM to a newer version.
A “DQM QAPP Updates vX.XX.X” EDD has been created for each new DQM version for which changes were made that included new DQM QAPP Settings, commencing with version 6.6.1 (there were no such additions made for v7.20.2, so no EDD exists for that update). Each new “DQM QAPP Updates” EDD file only contains the new settings associated with the new DQM version, whereas each new “DQM Starter QAPP” EDD contains all of the DQM configuration data for a completely new QAPP.
Note: If you are updating to a version more than one step up, you must use the “DQM QAPP Updates” EDD files in successive order of DQM version to prevent errors from trying to upload new rules and parameters associated with a check that does not yet exist in your current DQM QAPP.
1.Download the “DQM QAPP Updates” EDD or EDDs that you will be using from the links above.
2.Open EQuIS Professional and connect to any facility in the database. Note that you must have updated your database to at least the same version (or higher) to the version you desire to update your DQM QAPP to.
3.Open the RT_DQM_QAPP table and copy the name of the DQM_QAPP_CODE you desire to update.
4.Open the version of the “DQM QAPP Updates” file that you are preparing to upload in Excel.
5.Use the Excel Find and Replace function in the DQM QAPP Updates file (found in the Home tab of Excel or by selecting “Ctrl” and the “F” key simultaneously)
a.In the “Find what” text box, enter: “Your_QAPP_Code”.
b.In the “Replace with” text box, paste the DQM_QAPP_Code from RT_DQM_QAPP.
c.For the Options tab, select “Within: Workbook”.
d.Click the Replace All button.
6.Review and revise any of the default settings contained in the Excel file in the worksheets for:
a.RT_HOLDING_TIME, tab name = rt_holding_time_v2, see special instructions below;
b.RT_DQM_REASON, change the Reason Codes and Descriptions to your own values for the new rules;
c.RT_DQM_RULE, change the Qualifiers and Reason Codes to your own values for the new rules;
d.RT_DQM_CHECK_PARAM, the new check parameters have been set to values that turn the new functionalities OFF, so review them all carefully and change the values for the functionalities that you want to turn ON.
7.Save the Excel file or Save As (with a name that indicates which DQM QAPP you are updating) to an appropriate location.
9.From EQuIS Professional, open EDP.
a.Select the DQM-refvals format from the EQuIS\Formats\DQM folder.
b.Locate and select the EDD saved in step 6 above.
c.Check for and resolve any errors.
d.Proceed to Create and Commit the EDD with the Insert and Merge option.
1.From EQuIS Professional version 7.20.4 or higher, open EDP.
2.Select the DQM-refvals format from the EQuIS\Formats\DQM folder.
3.Select the Home tab and ensure that the “errors only” box is not selected.
4.Select the Professional tab.
5.Click the EDD dropdown in the Export section and select RT_HOLDING_TIME_V2.
6.Select the QAPP to update and click the Green Arrow button.
7.Make the desired changes and then re-upload to the database using the Create and Commit (Insert and Merge) functions.
Copyright © 2020 EarthSoft, Inc • Modified: 02 Nov 2020