Linking data between tables in MET/TEAM is often
done via the UID of the other record. To establish a link between tables
during the import, for example to specify the manufacturer for an Asset to be
imported, the Assets.nManufacturerUID column should be added to the definition.
The data for Assets.nManufacturerUID should be the actual facility name of the
manufacturer, not the reference number normally stored in nManufacturerUID.
In order to establish the link, the referenced item
has to be located or created. In order to do so, all fields that uniquely
identify the referenced item have to be specified within that one column of
data in the import data file. In case two fields are needed to uniquely
identify the referenced record, the data elements are separated by a
double-colon (::). This method is currently employed when referencing Units and
Service Types. If the data column does not contain a double-colon, the second
part of the data is defaulted. The unit prefix defaults to no prefix, the service mode (ServiceTypes.cServiceType) defaults to
Calibration.
|
Addresses.nFacilityUID |
Facilities.cFacilityName |
|
AssetServices.nServiceTypeUID |
ServiceTypes.cServiceName::ServiceTypes.cServiceType |
|
Assets.nAssignedFacUID |
Facilities.cFacilityName |
|
Assets.nAuthorizedFacUID |
Facilities.cFacilityName |
|
Assets.nCategoryUID |
Category.cDescription |
|
Assets.nDepartmentUID |
Facilities.cFacilityName |
|
Assets.nFacilityUID |
Facilities.cFacilityName |
|
Assets.nInventoryByUID |
Users.cUsername |
|
Assets.nMaintenanceFacUID |
Facilities.cFacilityName |
|
Assets.nManufacturerUID |
Facilities.cFacilityName |
|
Assets.nParentUID |
Assets.cBarcode |
|
Assets.nSubCategoryUID |
SubCategory.cDescription |
|
CallSheetStandardLink.nAssetUID |
Assets.cBarcode |
|
CallSheetPartsLink.nJobNumberUID |
JobNumbers.cJobOrderNumber |
|
CallSheetResults.nProcedureUID |
Procedures.cProcedureName |
|
CallSheetResults.nRunAtFacilityUID |
Facilities.cFacilityName |
|
CallSheetResults.nTechnicianUID |
Users.cUsername |
|
CallSheets.nAssignedTechUID |
Users.cUsername |
|
CallSheets.nCategoryUID |
Category.cDescription |
|
CallSheets.nDepartmentUID |
Facilities.cFacilityName |
|
CallSheets.nInvoiceUID |
Invoices.cInvoiceNo |
|
CallSheets.nJobNumberUID |
JobNumbers.cJobOrderNumber |
|
CallSheets.nProcedureUID |
Procedures.cProcedureName |
|
CallSheets.nQCApprovedByUID |
Users.cUsername |
|
CallSheets.nReturnedByUID |
Users.cUsername |
|
CallSheets.nSubCategoryUID |
SubCategory.cDescription |
|
CallSheets.nSubContractorUID |
Facilities.cFacilityName |
|
CallSheets.nTechnicianUID |
Users.cUsername |
|
CallSheets.nWorkingFacilityUID |
Facilities.cFacilityName |
|
Contacts.nManagerUID |
Contacts.cEmail2 |
|
Contacts.nUserUID |
Users.cUsername |
|
Facilities.nCategoryUID |
Category.cDescription |
|
Facilities.nParentFacilityUID |
Facilities.cFacilityName |
|
Facilities.nSubCategoryUID |
SubCategory.cDescription |
|
JobNumbers.nFundingAuthorityUID |
Facilities.cFacilityName |
|
Labor.nCategoryUID |
Category.cDescription |
|
Labor.nJobNumberUID |
JobNumbers.cJobOrderNumber |
|
Labor.nSubCategoryUID |
SubCategory.cDescription |
|
Labor.nUserUID |
Users.cUsername |
|
Parts.nCategoryUID |
Category.cDescription |
|
Parts.nInventoryByUID |
Users.cUsername |
|
Parts.nManufacturerUID |
Facilities.cFacilityName |
|
PointAmbients.nAmbientHumidityUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointAmbients.nAmbientPressureUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointAmbients.nAmbientTemperatureUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField001UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField002UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField003UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField004UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField005UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField006UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField007UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField008UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField009UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField010UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField011UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField012UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField013UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField014UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField015UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField016UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField017UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField018UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField019UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField020UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField021UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField022UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField023UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField024UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField025UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField026UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField027UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField028UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField029UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField030UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField031UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField032UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField033UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField034UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField035UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField036UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField037UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField038UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField039UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField040UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField041UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField042UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField043UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField044UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField045UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField046UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField047UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField048UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField049UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField050UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField051UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField052UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField053UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField054UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField055UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField056UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField057UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField058UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField059UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField060UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointReadings.nAssetUID |
Assets.cBarcode |
|
PointReadings.nReadingUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nCardinalPointUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nCorrectionUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nReferenceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nSystemAccuracyUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nUUTRangeUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nUUTUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMaximumReferenceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMaximumUUTUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMinimumReferenceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMinimumUUTUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReference2StandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReferenceRaw2StandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReferenceRawStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReferenceStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nSampleRateUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nUUTRawStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nUUTStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nErrorUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nReferenceToleranceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nToleranceErrorUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nToleranceNegativeUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nTolerancePositiveUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nToleranceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nGuardBandLowerUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nGuardBandUpperUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nLowerLimitUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nModifier1UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nModifier2UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nS1UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nS2UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyDominantUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyExpandedUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter10UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter1UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter2UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter3UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter4UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter5UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter6UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter7UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter8UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter9UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyStandardUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUpperLimitUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Procedures.nApprovedByUID |
Users.cUsername |
|
Procedures.nAttTemplateUID |
Files.cFileName |
|
Procedures.nCategoryUID |
Category.cDescription |
|
Procedures.nProcedureFileUID |
Files.cFileName |
|
ToolAssignments.nContactUID |
Contacts.cEmail2 |
|
TypeProcedureDefaults.nAttTemplateUID |
Files.cFileName |
|
Types.nCategoryUID |
Category.cDescription |
|
Types.nManufacturerUID |
Facilities.cFacilityName |
|
Types.nSubCategoryUID |
SubCategory.cDescription |
|
Users.nManagerUID |
Users.cUsername |
<any>.nAddFacilityUID
<any>.nAddUserUID
<any>.nUpdateFacilityUID
<any>.nUpdateUserUID
Addresses.nAddressUID
AssetEx.nAssetExUID
AssetEx.nAssetUID
AssetLog.nAssetLogUID
AssetLog.nAssetUID
Assets.nAssetUID
Assets.nTypeUID
AssetServices.nAssetServiceUID
AssetServices.nAssetUID
CallSheetEx.nCallSheetExUID
CallSheetEx.nCallSheetUID
CallSheetPartsLink.nCallSheetPartLinkUID
CallSheetPartsLink.nCallSheetUID
CallSheetPartsLink.nPartUID
CallSheetResults.nCallSheetResultUID
CallSheetResults.nCallSheetUID
CallSheets.nAssetUID
CallSheets.nCalendarUID
CallSheets.nCallSheetAttributeUID
CallSheets.nCallSheetUID
CallSheets.nGroupUID
CallSheets.nTypeProcedureDefaultUID
CallSheets.nTypeUID
CallSheetStandardLink.nCallSheetStandardLinkUID
CallSheetStandardLink.nCallSheetUID
CallSheetStandardLink.nLastStandardCallSheetUID
Contacts.nContactUID
Facilities.nFacilityUID
FacilityContactLink.nContactUID
FacilityContactLink.nFacilityContactLinkUID
FacilityContactLink.nFacilityUID
FacilityEX.nFacilityEXUID
FacilityEX.nFacilityUID
FacilityUserLink.nFacilityUID
FacilityUserLink.nFacilityUserLinkUID
FacilityUserLink.nUserUID
Files.nFileUID
Files.nManualTemplateUID
Formats.nFormatUID
JobNumbers.nJobnumberUID
JobNumbers.nProjectUID
Labor.nCallSheetUID
Labor.nLaborUID
ManualTemplateRows.nManualTemplateRowUID
ManualTemplateRows.nManualTemplateUID
ManualTemplates.nManualTemplateUID
Parts.nPartUID
PointAmbients.nAmbientHumidityFormatUID
PointAmbients.nAmbientPressureFormatUID
PointAmbients.nAmbientTemperatureFormatUID
PointAmbients.nPointAmbientUID
PointAmbients.nPointUID
PointExLogicals.nPointExLogicalUID
PointExLogicals.nPointUID
PointExNumerics.nField001FormatUID
PointExNumerics.nField002FormatUID
PointExNumerics.nField003FormatUID
PointExNumerics.nField004FormatUID
PointExNumerics.nField005FormatUID
PointExNumerics.nField006FormatUID
PointExNumerics.nField007FormatUID
PointExNumerics.nField008FormatUID
PointExNumerics.nField009FormatUID
PointExNumerics.nField010FormatUID
PointExNumerics.nField011FormatUID
PointExNumerics.nField012FormatUID
PointExNumerics.nField013FormatUID
PointExNumerics.nField014FormatUID
PointExNumerics.nField015FormatUID
PointExNumerics.nField016FormatUID
PointExNumerics.nField017FormatUID
PointExNumerics.nField018FormatUID
PointExNumerics.nField019FormatUID
PointExNumerics.nField020FormatUID
PointExNumerics.nField021FormatUID
PointExNumerics.nField022FormatUID
PointExNumerics.nField023FormatUID
PointExNumerics.nField024FormatUID
PointExNumerics.nField025FormatUID
PointExNumerics.nField026FormatUID
PointExNumerics.nField027FormatUID
PointExNumerics.nField028FormatUID
PointExNumerics.nField029FormatUID
PointExNumerics.nField030FormatUID
PointExNumerics.nField031FormatUID
PointExNumerics.nField032FormatUID
PointExNumerics.nField033FormatUID
PointExNumerics.nField034FormatUID
PointExNumerics.nField035FormatUID
PointExNumerics.nField036FormatUID
PointExNumerics.nField037FormatUID
PointExNumerics.nField038FormatUID
PointExNumerics.nField039FormatUID
PointExNumerics.nField040FormatUID
PointExNumerics.nField041FormatUID
PointExNumerics.nField042FormatUID
PointExNumerics.nField043FormatUID
PointExNumerics.nField044FormatUID
PointExNumerics.nField045FormatUID
PointExNumerics.nField046FormatUID
PointExNumerics.nField047FormatUID
PointExNumerics.nField048FormatUID
PointExNumerics.nField049FormatUID
PointExNumerics.nField050FormatUID
PointExNumerics.nField051FormatUID
PointExNumerics.nField052FormatUID
PointExNumerics.nField053FormatUID
PointExNumerics.nField054FormatUID
PointExNumerics.nField055FormatUID
PointExNumerics.nField056FormatUID
PointExNumerics.nField057FormatUID
PointExNumerics.nField058FormatUID
PointExNumerics.nField059FormatUID
PointExNumerics.nField060FormatUID
PointExNumerics.nPointExNumericUID
PointExNumerics.nPointUID
PointExStrings.nPointExStringUID
PointExStrings.nPointUID
PointReadings.nPointReadingUID
PointReadings.nPointUID
PointReadings.nReadingFormatUID
Points.nCallSheetResultUID
Points.nCardinalPointFormatUID
Points.nCorrectionFormatUID
Points.nManualTemplateRowUID
Points.nPointUID
Points.nReferenceFormatUID
Points.nSystemAccuracyFormatUID
Points.nTemplateItemUID
Points.nUUTFormatUID
Points.nUUTRangeFormatUID
PointStandardReadings.nReadingFormatUID
PointStatistics.nMaximumReferenceFormatUID
PointStatistics.nMaximumUUTFormatUID
PointStatistics.nMinimumReferenceFormatUID
PointStatistics.nMinimumUUTFormatUID
PointStatistics.nPointStatisticUID
PointStatistics.nPointUID
PointStatistics.nReference2StandardDeviationFormatUID
PointStatistics.nReferenceRaw2StandardDeviationFormatUID
PointStatistics.nReferenceRawStandardDeviationFormatUID
PointStatistics.nReferenceStandardDeviationFormatUID
PointStatistics.nSampleRateFormatUID
PointStatistics.nUUTRawStandardDeviationFormatUID
PointStatistics.nUUTStandardDeviationFormatUID
PointTolerances.nErrorFormatUID
PointTolerances.nPointToleranceUID
PointTolerances.nPointUID
PointTolerances.nReferenceToleranceFormatUID
PointTolerances.nToleranceErrorFormatUID
PointTolerances.nToleranceFormatUID
PointTolerances.nToleranceNegativeFormatUID
PointTolerances.nTolerancePositiveFormatUID
PointUncertainties.nGuardBandLowerFormatUID
PointUncertainties.nGuardBandUpperFormatUID
PointUncertainties.nLowerLimitFormatUID
PointUncertainties.nModifier1FormatUID
PointUncertainties.nModifier2FormatUID
PointUncertainties.nPointUID
PointUncertainties.nPointUncertaintyUID
PointUncertainties.nS1FormatUID
PointUncertainties.nS2FormatUID
PointUncertainties.nUncertaintyDominantFormatUID
PointUncertainties.nUncertaintyExpandedFormatUID
PointUncertainties.nUncertaintyFormatUID
PointUncertainties.nUncertaintyParameter10FormatUID
PointUncertainties.nUncertaintyParameter1FormatUID
PointUncertainties.nUncertaintyParameter2FormatUID
PointUncertainties.nUncertaintyParameter3FormatUID
PointUncertainties.nUncertaintyParameter4FormatUID
PointUncertainties.nUncertaintyParameter5FormatUID
PointUncertainties.nUncertaintyParameter6FormatUID
PointUncertainties.nUncertaintyParameter7FormatUID
PointUncertainties.nUncertaintyParameter8FormatUID
PointUncertainties.nUncertaintyParameter9FormatUID
PointUncertainties.nUncertaintyStandardFormatUID
PointUncertainties.nUpperLimitFormatUID
Procedures.nProcedureUID
ServiceTypes.nServiceTypeUID
ToolAssignmentEx.nToolAssignmentExUID
ToolAssignmentEx.nToolAssignmentUID
ToolAssignments.nAssetUID
ToolAssignments.nToolAssignmentUID
TypeProcedureDefaults.nProcedureUID
TypeProcedureDefaults.nTypeProcedureDefaultUID
TypeProcedureDefaults.nTypeUID
Types.nImageUID
Types.nTypeUID
TypesEx.nTypeExUID
TypesEx.nTypeUID
Units.nUnitUID
Users.nUserUID
Other
columns that should not be assigned:
CallSheetResults.cDataOrigin
CallSheetResults.lRun
CallSheets.nRevision
Units.cUnitSymbol
Related Topics