MET/TEAM Software
Operation and Reference Guide
Copyright 2016
(Version 20170323)
Table of Contents
MET/TEAM Mobile
Requirements. 9
Configuring Active
Directory. 9
Configuring the MET/TEAM
Server Machine. 9
Configuring the Main SQL
Server® Machine. 9
Configuring MET/TEAM
Mobile Machines. 9
MET/TEAM and Windows
Authentication.. 10
Backing Up a SQL Server®
Database. 16
Update Due to Change in
Database Schema to GUIDs. 16
Restoring a MET/TEAM
Database. 17
Change Password from
Log-In. 21
MET/TEAM Software
Overview.. 29
MET/TEAM Reports
Directory. 35
Customer Portal Reports
Directory. 35
MET/TEAM Facility
Addresses and Reports. 35
Report Parameter
Combinations. 36
Dialog Menu Action
Buttons. 37
Categories and Sub
Categories. 51
Dates on the User
Interface. 53
Using Dates on Find
Screens. 53
Updating Crystal Reports
to UTC. 53
How to Get Started Using
MET/TEAM.. 55
Minimum Information
Required to Receive and Process Equipment. 57
Adding Users (individual
log in) 57
Adding Facilities
(customer, manufacturer, lab) 59
Adding Types
(grouping/catalog of serialized items) 59
Adding Assets (individual
serialized items) 60
Additional Information –
Manual Templates and External Files. 61
Adding an External File
(Spreadsheet) to MET/TEAM... 61
Setting Up a Type to Use
the Newly Added Template. 62
Job Number – Standard
Hours. 65
Job Number – Level of
Effort. 69
Auditing and Change
Tracking. 71
Report Writing with
Crystal Reports 2011. 74
Connecting to the
database. 76
Adding tables to the
report 78
Adding a Report to
MET/TEAM... 99
Adding a Report to
Customer Portal. 101
Some MET/CAL Example
Formulas. 106
Converting a MET/BASE
Report to MET/TEAM.. 108
View the Query and
Identify the Needed Fields. 109
Map the Fields to
MET/TEAM... 109
Run New Query and Verify
Results. 112
Test view in SQL Server®
Management Studio. 113
Set New Data Source
Location. 114
Extracting an Import
Definition. 121
Referencing Items in
Other Tables. 122
Reviewing a Completed
Import 135
Example: Importing Files
into MET/TEAM... 137
Required Fields per Table. 142
Dependent Tables to be
Included per Table. 143
UTC Date/Time Adjustment During
an Import 145
Manual Template Row Types. 145
Sample Import Definitions. 145
Work Order Section Status. 191
Work Order Export Results. 192
Example – Creating a
Manual Template. 273
Manual Template –
Calibrate Screen. 275
Incorporating Tool
Assignment with a Recall Alert 325
Using a Data Check to
Manage the Tool Assignment Recall Alert Recipients. 328
Using a Data Check to
Manage Recall Escalation Recipients with an Alert 330
Customizing the User
Interface. 374
MET/TEAM Field
Descriptions. 380
MET/TRACK to MET/TEAM
Field Map. 380
Sub Contracting Best
Practices. 380
Customer Portal
Delinquent 396