MET/TEAM Software
Operation and Reference Guide
Copyright 2016
(Version 20161111)
Table of Contents
MET/TEAM Mobile
Requirements. 10
Configuring Active
Directory. 10
Configuring the MET/TEAM
Server Machine. 10
Configuring the Main SQL
Server® Machine. 10
Configuring MET/TEAM
Mobile Machines. 10
MET/TEAM and Windows
Authentication.. 11
Backing Up a SQL Server®
Database. 17
Update Due to Change in
Database Schema to GUIDs. 17
Restoring a MET/TEAM
Database. 18
Change Password from
Log-In. 22
MET/TEAM Software
Overview.. 30
MET/TEAM Reports
Directory. 36
Customer Portal Reports
Directory. 36
MET/TEAM Facility
Addresses and Reports. 37
Report Parameter
Combinations. 37
Dialog Menu Action
Buttons. 38
Categories and Sub
Categories. 52
Dates on the User
Interface. 54
Updating Crystal Reports
to UTC. 54
How to Get Started Using
MET/TEAM.. 56
Minimum Information
Required to Receive and Process Equipment. 58
Adding Users (individual
log in) 58
Adding Facilities
(customer, manufacturer, lab) 60
Adding Types
(grouping/catalog of serialized items) 60
Adding Assets (individual
serialized items) 61
Additional Information –
Manual Templates and External Files. 62
Adding an External File
(Spreadsheet) to MET/TEAM... 62
Setting Up a Type to Use
the Newly Added Template. 63
Job Number – Standard
Hours. 66
Job Number – Level of
Effort. 70
Auditing and Change
Tracking. 72
Report Writing with
Crystal Reports 2011. 75
Connecting to the
database. 77
Adding tables to the
report 79
Adding a Report to
MET/TEAM... 100
Adding a Report to
Customer Portal. 102
Some MET/CAL Example
Formulas. 107
Converting a MET/BASE
Report to MET/TEAM.. 109
View the Query and
Identify the Needed Fields. 110
Map the Fields to
MET/TEAM... 110
Run New Query and Verify
Results. 113
Test view in SQL Server®
Management Studio. 114
Set New Data Source
Location. 115
Extracting an Import
Definition. 122
Referencing Items in
Other Tables. 123
Reviewing a Completed
Import 136
Example: Importing Files
into MET/TEAM... 138
Required Fields per Table. 143
Dependent Tables to be
Included per Table. 144
UTC Date/Time Adjustment
During an Import 146
Manual Template Row Types. 146
Sample Import Definitions. 146
Work Order Section Status. 190
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