Skip to content

Fluke MET/TEAM

Under Administration > Settings > Extensions > Fluke MET/TEAM you configure the bidirectional synchronization between calServer and Fluke MET/TEAM. The plugin automatically synchronizes device, calibration, and inventory data via an MSSQL connection.

Configuration

MET/TEAM Configuration

Connection Details

Field Description
Server Name Hostname or IP address of the MET/TEAM SQL Server.
Port SQL Server port (default: 1433).
Username Credentials for the MET/TEAM SQL Server.
Password Associated password.
Database Name of the MET/TEAM database (e.g., metteam_db).

Synchronization Options

Field Description
Sync inventory bidirectional Synchronize device inventories in both directions.
Sync calibration bidirectional Transfer calibration data (certificates, test notes) bidirectionally.

Actions

Action Description
Save Applies the configuration.
Test Connection Checks the reachability of the SQL Server and the credentials.
Copy Duplicates the configuration for a second instance.
Read Version Reads the MET/TEAM version.
Disable Temporarily deactivates synchronization without deleting the configuration.

How It Works

  • Changes in calServer or MET/TEAM are detected and automatically transferred to the other system.
  • All synchronization operations are logged in the AuditLog.
  • The plugin automatically detects the MET/TEAM version and adapts the synchronization accordingly.

Notes

  • Check the status message after saving. In case of errors, you will receive specific troubleshooting hints.
  • Bidirectional synchronization requires the SQL Server user to have both read and write permissions.
  • Changes to the field configuration in calServer should be completed before synchronization.

Table Mapping (Match Table)

The following overview documents the complete field mapping between calServer and MET/TEAM. The plugin uses these match patterns to synchronize data bidirectionally.

Table Overview

calServer Table MET/TEAM Table(s) Sync Table (MSSQL) AuditLog TableName Description
FrontendInventory Assets, AssetEx, AssetServices AssetSync Assets Device/inventory data
FrontendCalibration CallSheets, CallSheetEx — CallSheets Calibrations
FrontendResults CallSheetResults, Points — CallSheetResults Measurement results
FrontendStandards CallSheetStandardLink — CallSheetStandardLink Calibration standards
FrontendLocation ToolAssignments — ToolAssignments Locations/assignments
FrontendCustomer Facilities — — Customers

UID Linking Fields

These fields connect calServer records with their MET/TEAM counterparts and are automatically set during the first synchronization.

calServer Field MET/TEAM Field Table Description
nAssetUID nAssetUID Assets Inventory link
nCallSheetUID nCallSheetUID CallSheets Calibration link
nCallSheetResultUID nCallSheetResultUID CallSheetResults Result link
nPointUID nPointUID Points Measurement point link
nFacilityUID nFacilityUID Facilities Customer/location link
nToolAssignmentUID nToolAssignmentUID ToolAssignments Location link
nCallSheetStandardLinkUID nCallSheetStandardLinkUID CallSheetStandardLink Standard link

1. Inventory: calServer <-> MET/TEAM Assets

1.1 Assets (Main Table)

Stored Procedures: spl_Assets_INSERT, spl_Assets_UPDATE, spl_Assets_DELETE

calServer Field MET/TEAM Parameter Description Type
I4201 @cID, @cBarcode Test equipment no. string
I4202 @nManufacturerUID (Lookup) Manufacturer Lookup → Facilities
I4203 @cModelNumber Model string
I4204 @cDescription Description string
I4206 @cSerialNumber Serial number string
I4214 @cPhysicalLocation Stor-loc (storage location) string
I4218 @nDepartmentUID (Lookup) Own-dept (department) Lookup → Facilities
I4219 @nItemCost Acquisition cost number
I4221 @tPurchaseDate Purchase date datetime
I4225 @cStatus Status string
I4230 @nUseCount Number of uses number
I4237 @nAddUserUID (Lookup) Who Entered Lookup → Users
I4240 @nAssignedFacUID (Lookup) DB Subset Lookup → Facilities
I4258 @lInAbeyance Abeyance state number
I4259 @nAbeyanceInterval Abeyance interval number
I4260 @mNotes Inventory notes html
I4299 @cDisposition Condition string
ktag (Customer) @nFacilityUID (Lookup) Customer assignment Lookup → Facilities

1.2 AssetEx (Extended Fields)

Stored Procedures: spl_AssetEx_INSERT, spl_AssetEx_UPDATE

calServer Field MET/TEAM Parameter Description Type
I4205 @cField14 Fund string
I4207 @cField15 Options string
I4208 @cField16 Instructions string
I4209 @cField33 Trace Code string
I4210 @cField17 Notes string
I4211 @cField18 Status string
I4213 @cField19 Note-loc string
I4215 @cField20 Soft-Rev string
I4216 @cField21 Firm-Rev string
I4217 @cField22 Accessory Asset string
I4220 @cField6 Life string
I4222 @cField7 P.O. Number string
I4223 @cField25 Fed. Stock No. string
I4231 @cField1 Due date string
I4232 @cField2 User Defined string
I4233 @cField3 User Defined string
I4234 @cField4 User Defined string
I4235 @cField5 User Defined string
I4241 @cField23 Calibration instruction string
I4242 @cField24 User Defined string
I4243 @cField26 User Defined string
I4244 @cField8 Reserved field (string) string
I4245 @cField9 Reserved field (string) string
I4246 @cField10 Reserved field (string) string
I4247 @cField11 Reserved field (string) string
I4248 @cField12 Reserved field (string) string
I4249 @cField13 Reserved field (string) string
I4261 @cField31 OLE Document string
I4262 @cField32 Notes string
idsrc @cField29 Data source string
replic @cField27 Replication ID string
I4212 @tField5 Note-date datetime
I4250 @tField1 Reserved field (date) datetime
I4251 @tField2 Reserved field (date) datetime
I4252 @tField3 Reserved field (date) datetime
I4253 @tField4 Reserved field (date) datetime
I4226 @lField1 Calibration seal number
I4254 @nField1 Reserved field (number) number
I4255 @nField2 Reserved field (number) number
I4256 @nField3 Reserved field (number) number
I4257 @nField4 Reserved field (number) number

1.3 AssetServices (Calibration Service Data)

Stored Procedures: spl_AssetServices_INSERT, spl_AssetServices_UPDATE

calServer Field MET/TEAM Parameter Description Type
C2301 + C2333 @tMaintDate Calibration date + time (from active calibration) datetime
C2303 + C2334 @tNextMaintDate Next calibration + time (from active calibration) datetime
I4228 @cIntervalUOM Time unit calibration interval string
I4229 @cInterval Calibration interval string
— @nServiceTypeUID = 'Calibration' Service type (fixed) Lookup

2. Calibration: calServer <-> MET/TEAM CallSheets

2.1 CallSheets (Main Table)

Stored Procedures: spl_CallSheets_INSERT, spl_CallSheets_UPDATE, spl_CallSheets_DELETE

calServer Field MET/TEAM Parameter Description Type
C2301 + C2333 @tMaintDate Calibration date + calibration time datetime
C2302 @cInterval Interval string
C2303 + C2334 @tMaintNextDate Next calibration + time datetime
C2304 @cCallSheetNumber Index/certificate no. string
C2308 @cInitialCondition Found/Left (prior condition) string
C2311 @cTemperature Temperature string
C2312 @cHumidity Humidity string
C2313 @nWorkingFacilityUID (Lookup) Calibration facility Lookup → Facilities
C2316 @tOpenDate Received at calibration lab datetime
C2320 @nProcedureUID (Lookup) Metcal procedure Lookup → Procedures
C2323 @cWorkOrderResults Result (Pass/Fail) string
C2326 @mOOTNotes Reason Warranty/Escalation string
C2331 @cIntervalUOM Interval units string
C2395 @cCertificationNumber Certificate number string
C2307 @nAssignedTechUID (Lookup) Technician Lookup → Users
C2327 / C2336 @nTechnicianUID (Lookup) 2nd signature / Who Entered Lookup → Users
(calculated) @nCost Cost number

2.2 CallSheetEx (Extended Fields)

Stored Procedures: spl_CallSheetEx_INSERT, spl_CallSheetEx_UPDATE

calServer Field MET/TEAM Parameter Description Type
C2306 @cField1 Departure from calibration lab string
C2309 @nField1 Labor cost number
C2314 @cField2 Order number string
C2315 @nField3 TUR Limit number
C2317 @nField29 OOT Limit number
C2318 @cField4 Tolerance reference string
C2319 @lField3 Pass100 number
C2321 @cField5 Revision string
C2322 @lField4 Bill order with CRW number
C2324 @nField4 Calibration time number
C2325 @lField6 Bad STD number
C2328 @nField5 Calibration time 2 number
C2329 @cField6 Maintenance note string
C2330 @cField7 On-site humidity variation number
C2339 @nField6 Valid entry number
C2342 + C2343 @tField6 End date + end time datetime
C2344 @nField7 Total Passes number
C2345 @nField8 Significantly Within Tolerance number
C2346 @nField9 Within Tolerance number
C2347 @nField10 Out of Tolerance number
C2350 @nField11 Marginal Tests number
C2351 @nField12 Notify User number
C2352 @nField13 Failed Tests number
C2353 @nField14 Adjustments number
C2354 @cField17 Calibration mark / sequential no. string
C2355 @cField18 Calibration mark / company string
C2356 @cField19 Calibration mark / YYYYMM string
C2357 @cField20 Time QL in h string
C2358 @cField21 Ext. repair/calibration cost string
C2359 @cField22 Calibration procedure string
C2360 @cField23 Transition Standard – UUT string
C2361 @cField24 Loading string
C2362 @nField15 Reliability number
C2364 @cField8 Customer order number string
C2365 @cField9 1st reason for delay string
C2366 @cField10 Calibration location / city string
C2367 @cField11 Calibration location / lab string
C2368 @cField12 On-site temperature variation string
C2369 @cField13 Operating mode string
C2370 @cField14 Rotational speed string
C2371 @tField1 On-site calibration date datetime
C2372 @tField2 Reserved field (date) datetime
C2373 @tField3 Reserved field (date) datetime
C2374 @tField4 Reserved field (date) datetime
C2375 @nField16 Acclimatization time in h number
C2376 @nField17 Invoicing number
C2377 @nField18 Reserved field (number) number
C2378 @nField19 Ambient pressure number
C2379 @nField20 Reserved field (number) number
C2380 + C2381 @tField5 Abeyance date + time datetime
C2382 @lField7 Abeyance state number
C2383 @nField21 Abeyance interval number
C2384 @mField1 Engineers Notes string
C2385 @cField26 OLE Document string
C2386 @nField22 Temperature Tolerance number
C2387 @nField23 Pressure variation number
C2388 @nField24 TUR Reporting Threshold number
C2389 @nField25 Borderline Threshold number
C2390 @nField26 SOT Threshold number
C2391 @nField27 SWT Threshold number
C2392 @nField28 Reported Uncert. Conf. Level number
C2393 @lField8 Use Dominance Test number
C2394 @lField9 Validation performed number
cdsrc @cField3 Data source string

3. Measurement Results: calServer <-> MET/TEAM CallSheetResults + Points

3.1 CallSheetResults (Main Table)

Stored Procedures: spl_CallSheetResults_INSERT, spl_CallSheetResults_UPDATE

calServer Field MET/TEAM Parameter Description Type
nCallSheetUID @nCallSheetUID Calibration UID string
test_status @cStatus Test status string
— @cDataOrigin = 'MET/BASE' Data origin (fixed) string

3.2 Points (Measurement Points)

Stored Procedures: spl_Points_INSERT, spl_Points_UPDATE

calServer Field MET/TEAM Parameter Description Type
row_num @nPointOrdinal Row number / ordinal number
result_type @cPointLabel Result type string
fsc @cFunctionSelectCode Function Select Code (FSC) string
test_desc @cPointDescription Test description string
pass_fail @cPointPassFailStatus Pass/Fail status string
remark @cRemarks Remark string
condition2 @cCondition Condition string
measurement_u, measurement_p @nUUTUnitUID UUT unit Lookup → Units
measurement @nUUTFormatUID UUT format Lookup → Formats
sys_actual_u, sys_actual_p @nReferenceUnitUID Reference unit Lookup → Units
sys_actual @nReferenceFormatUID Reference format Lookup → Formats
cpt_u, cpt_p @nCardinalPointUnitUID Cardinal point unit Lookup → Units
cpt @nCorrectionFormatUID Cardinal point format Lookup → Formats
corr_u, corr_p @nCorrectionUnitUID Correction unit Lookup → Units
corr @nCardinalPointFormatUID Correction format Lookup → Formats
uut_range_u, uut_range_p @nUUTRangeUnitUID UUT range unit Lookup → Units
uut_range @nUUTRangeFormatUID UUT range format Lookup → Formats
sys_acc_u, sys_acc_p @nSystemAccuracyUnitUID System accuracy unit Lookup → Units
sys_acc @nSystemAccuracyFormatUID System accuracy format Lookup → Formats
calServer Field MET/TEAM Field Description
CTAG nCallSheetUID Calibration assignment
C2430 (MTAG of the standard) nAssetUID Standard device (asset)
MTAG — Device MTAG in calServer
nCallSheetStandardLinkUID nCallSheetStandardLinkUID Link UID

5. Locations: calServer <-> MET/TEAM ToolAssignments

calServer Field MET/TEAM Field Description
nToolAssignmentUID nToolAssignmentUID (ltag) Location UID
MTAG Location_MTAG → nAssetUID (Lookup) Device assignment
L2809 L2809 Location field 1
L2810 L2810 Location field 2

6. Customers: calServer <-> MET/TEAM Facilities

Customer data is automatically synchronized during inventory sync via lookup functions. The mapping is done via nFacilityUID.

calServer Field MET/TEAM Field Description
KTAG — calServer customer ID
nFacilityUID nFacilityUID MET/TEAM Facility UID
K4601 — Customer number (fallback matching)
K4602 — Customer name

Sync Mechanism

calServer → MET/TEAM (TransferToMSSQLCommand)

Sync Method Description
syncInventoryFromMySQL() Writes inventory data to Assets / AssetEx / AssetServices
syncCalibrationFromMySQL() Writes calibration data to CallSheets / CallSheetEx
syncResultsFromMySQL() Writes measurement results to CallSheetResults / Points

MET/TEAM → calServer (SyncDataFromMSSQLCommand)

Stored Procedure (MSSQL) Operation MET/TEAM Table
Get_List_Inventory_UPDATE Update Assets
Get_List_Inventory_DELETE Delete Assets
Get_List_Calibration_INSERT Insert CallSheets
Get_List_Calibration_UPDATE Update CallSheets
Get_List_Calibration_DELETE Delete CallSheets
Get_List_Results_INSERT Insert CallSheetResults
Get_List_Results_UPDATE Update CallSheetResults
Get_List_Results_DELETE Delete CallSheetResults

Change Detection

Changes in MET/TEAM are detected via the AuditLog2 table:

AuditLog2 TableName Operation Description
Assets UPDATE, DELETE Inventory changes
CallSheets INSERT, UPDATE, DELETE Calibration changes
CallSheetResults INSERT, UPDATE, DELETE Result changes
CallSheetStandardLink INSERT New standard assignments
ToolAssignments INSERT New location assignments

Full Synchronization

Direction Event Class Description
calServer → MET/TEAM Copy_All_To_METTEAM Copies all inventory, calibration, and result data to MET/TEAM
MET/TEAM → calServer Copy_All_To_CalWebApp Imports all data from MET/TEAM into calServer