How to add a Data Check to MET/TEAM

Text Instructions:

In this example, we are using the data check titled "Work Orders - Type Check". It can be used to keep work orders in sync if an asset changes its type after it has been received. Be warned, however, that this data check may break Job Number fund allocation behavior. A copy can be downloaded here:
Work Orders - Type Check.txt

Steps to add the data check to MET/TEAM:

1. Copy the contents of the text file to the clipboard.
2. Log onto MET/TEAM as an administrator and go to Configure -> Data Checks.
3. Click the Add button.
4. Name the data check "Work Orders - Type Check", set it as active, and set the Affected Page to "Work Orders".
5. Paste the contents of the text file into the body of this data check record.
6. Save the record.
7. Copy the commented out SQL statement near the top of the data check code (see below screenshot). SQL queries in data checks typically begin with SELECT.
8. Click the "Create Data Check SQL" green plus button in the lower-left corner of the SQL Functions grid.
9. Paste in the copied SQL code into the body of this pop-up window, and title it "GetTypeInfo" (sans quotes). Note: the title is case-sensitive and must exactly match the name called in the data check code.
   
10. Save the pop-up window.
11. Now open the affected page, in this case the Edit Work Order page and modify something on the page and click the "Save" button.
12. Ensure the page correctly saves and the refreshes with the "Save" button disabled.
13. If any errors occur or the page does NOT save, verify things were copy and pasted correctly. Also verify SQL functions were correctly named.  These are the most common issues with adding data checks.  If you are unable to get the page to save, un-check the "Active" check box and save the data check. This will immediately disable the data check so you can verify the page will again save correctly.  

If you have any questions or concerns, contact softwaresupport@flukecal.com