2013-10-08T13:44:58
Note: This checking routine only validates the internal quality of the COBie file. It does not validate the quality of the data with respect to the actual project. For more information on the COBie checker please visit the COBie Means and Methods page at:
http://www.buildingsmartalliance.org/index.php/projects/cobie
Save a new copy of your COBie model (either IFC or Spreadsheet) to a new file name so that you have a backup. Based on the information in this report update the copied file to correct each issue. To find the error in the COBie file, match the issue by Worksheet Name, Row Number, and object name to the data in your file. For example, a problem with the fifth space in the space worksheet, pertaining to the room named "Vestibule" would be listed as Space[5]:Vestibule. Once each relevant issue is fixed, re-run your file and see the impact of your changes. Note that this report provides a generic test, therefore, some issues may be allowed if the terms and conditions of your contract differ from those assumed in this reporting tool. Please consult your contract to evaluate the specific requirements for specific COBie deliverables on your projects.
Note: Row/Column checks are only listed for worksheets containing at least one row, but row count checks are listed for Contact, Facility, Space, Type, and Component (worksheets that must contain data) regardless of row count.
Worksheet | Has Rows? | Row Count | Row Warning Count | Row Error Count |
---|---|---|---|---|
Contact | true | 60 | 0 | 0 |
Facility | true | 1 | 0 | 0 |
Floor | true | 5 | 0 | 0 |
Space | true | 269 | 0 | 0 |
Zone | true | 260 | 0 | 0 |
Type | true | 366 | 0 | 0 |
Component | true | 5071 | 0 | 0 |
System | true | 596 | 0 | 0 |
Assembly | false | 0 | n/a | n/a |
Connection | false | 0 | n/a | n/a |
Spare | true | 13 | 0 | 0 |
Resource | true | 19 | 0 | 0 |
Job | true | 36 | 0 | 0 |
Document | true | 675 | 0 | 1 |
Attribute | true | 8935 | 0 | 0 |
Total correct COBie.Contacts items = 1 of 1 (100% correct)
Contacts.AtLeastOneRowPresent
ContactSheet: 0
ContactSheet: 0
Total correct COBie.Contacts.Contact items = 60 of 60 (100% correct)
Email.Unique, Email.NotNull, Email.Format , CreatedBy.CrossReference, CreatedBy.NotNull , CreatedOn.NotNull, CreatedOn.Valid (ISO DateTime) , ExternalSystem.NotEmpty , ExternalObject.NotEmpty , ExternalIdentifier.NotEmpty , Category.NotNull , Company.NotNull , Phone.NotNull , Department.NotEmpty , OrganizationCode.NotEmpty , GivenName.NotEmpty , FamilyName.NotEmpty , Street.NotEmpty , PostalBox.NotEmpty , Town.NotEmpty , StateRegion.NotEmpty , PostalCode.NotEmpty , Country.NotEmpty
Email: 0, CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExternalObject: 0, ExternalIdentifier: 0, Category: 0, Company: 0, Phone: 0, Department: 0, OrganizationCode: 0, GivenName: 0, FamilyName: 0, Street: 0, PostalBox: 0, Town: 0, StateRegion: 0, PostalCode: 0, Country: 0
Email: 0, CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExternalObject: 0, ExternalIdentifier: 0, Category: 0, Company: 0, Phone: 0, Department: 0, OrganizationCode: 0, GivenName: 0, FamilyName: 0, Street: 0, PostalBox: 0, Town: 0, StateRegion: 0, PostalCode: 0, Country: 0
Total correct COBie.Facilities items = 1 of 1 (100% correct)
Facilities.OneAndOnlyOneFacilityFound
FacilitySheet: 0
FacilitySheet: 0
Total correct COBie.Facilities.Facility items = 1 of 1 (100% correct)
Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), Category.NotNull , Description.NotEmpty , ProjectName.NotNull , SiteName.NotNull , LinearUnits.NotNull , AreaUnits.NotNull , VolumeUnits.NotNull , Currency.NotNull , AreaMeasurement.NotNull , ExternalSystem.NotEmpty , ExternalProjectObject.NotEmpty , ExternalProjectIdentifier.NotEmpty , ExternalSiteObject.NotEmpty , ExternalSiteIdentifier.NotEmpty , ExternalFacilityObject.NotEmpty , ExternalFacilityIdentifier.NotEmpty
Name: 0, CreatedBy: 0, CreatedOn: 0, Category: 0, Description: 0, ProjectName: 0, SiteName: 0, LinearUnits: 0, AreaUnits: 0, VolumeUnits: 0, CurrencyUnit: 0, AreaMeasurement: 0, ExternalSystem: 0, ExternalProjectObject: 0, ExternalProjectIdentifier: 0, ExternalSiteObject: 0, ExternalSiteIdentifier: 0, ExternalFacilityObject: 0, ExternalFacilityIdentifier: 0
Name: 0, CreatedBy: 0, CreatedOn: 0, Category: 0, Description: 0, ProjectName: 0, SiteName: 0, LinearUnits: 0, AreaUnits: 0, VolumeUnits: 0, CurrencyUnit: 0, AreaMeasurement: 0, ExternalSystem: 0, ExternalProjectObject: 0, ExternalProjectIdentifier: 0, ExternalSiteObject: 0, ExternalSiteIdentifier: 0, ExternalFacilityObject: 0, ExternalFacilityIdentifier: 0
Total correct COBie.Floors items = 1 of 1 (100% correct)
Floors.AtLeastOneRowPresent
FloorSheet: 0
FloorSheet: 0
Total correct COBie.Floors.Floor items = 5 of 5 (100% correct)
Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Category.NotNull , Floor.Elevation.ValidNumberOrNA , Floor.Height.ZeroOrGreaterOrNA
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, Elevation: 0, Height: 0
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, Elevation: 0, Height: 0
Total correct COBie.Spaces items = 1 of 1 (100% correct)
Spaces.AtLeastOneRowPresent
SpaceSheet: 0
SpaceSheet: 0
Total correct COBie.Spaces.Space items = 269 of 269 (100% correct)
Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Category.NotNull , FloorName.NotNull, FloorName.CrossReference , Description.NotNull , RoomTag.NotEmpty , UsableHeight.ZeroOrGreaterOrNA , GrossArea.ZeroOrGreaterOrNA , NetArea.ZeroOrGreaterOrNA
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, FloorName: 0, Description: 0, RoomTag: 0, UsableHeight: 0, GrossArea: 0, NetArea: 0
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, FloorName: 0, Description: 0, RoomTag: 0, UsableHeight: 0, GrossArea: 0, NetArea: 0
Total correct COBie.Zones.Zone items = 260 of 260 (100% correct)
CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), Category.NotNull , Description.NotEmpty , ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Name.NotNull , PrimaryKey.Unique (Name, Category, SpaceNames) , SpaceNames.NotNull, SpaceNames.CrossReference
CreatedBy: 0, CreatedOn: 0, Category: 0, Description: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Name: 0, PrimaryKey: 0, SpaceNames: 0
CreatedBy: 0, CreatedOn: 0, Category: 0, Description: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Name: 0, PrimaryKey: 0, SpaceNames: 0
Total correct COBie.Types items = 1 of 1 (100% correct)
Types.AtLeastOneRowPresent
TypeSheet: 0
TypeSheet: 0
Total correct COBie.Types.Type items = 366 of 366 (100% correct)
Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), Category.NotNull , ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Type.Component.AComponentForEachType , AssetType.NotNull , Manufacturer.NotNull, Manufacturer.CrossReference (Contact Sheet) , ModelNumber.NotNull , WarrantyGuarantorParts.NotNull, WarrantyGuarantorParts.CrossReference (Contact Sheet) , WarrantyDurationParts.validNumberZeroOrGreaterOrNA , WarrantyGuarantorLabor.NotNull, WarrantyGuarantorLabor.CrossReference (Contact Sheet) , WarrantyDurationLabor.ZeroOrGreaterOrNA , WarrantyDurationUnit.NotNull , ReplacementCost.ZeroOrGreaterOrNA , ExpectedLife.ZeroOrGreaterOrNA , DurationUnit.NotNull , WarrantyDescription.NotEmpty , NominalLength.ZeroOrGreaterOrNA , NominalWidth.ZeroOrGreaterOrNA , NominalHeight.ZeroOrGreater , ModelReference.NotEmpty , Shape.NotEmpty , Size.NotEmpty , Color.NotEmpty , Finish.NotEmpty , Grade.NotEmpty , Material.NotEmpty , Constituents.NotEmpty , Features.NotEmpty , AccessibilityPerformance.NotEmpty , CodePerformance.NotEmpty , SustainabilityPerformance.NotEmpty
Name: 0, CreatedBy: 0, CreatedOn: 0, Category: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, TypeComponentSheets: 0, AssetType: 0, Manufacturer: 0, ModelNumber: 0, WarrantyGuarantorParts: 0, WarrantyDurationParts: 0, WarrantyGuarantorLabor: 0, WarrantyDurationLabor: 0, WarrantyDurationUnit: 0, ReplacementCost: 0, ExpectedLife: 0, DurationUnit: 0, WarrantyDescription: 0, NominalLength: 0, NominalWidth: 0, NominalHeight: 0, ModelReference: 0, Shape: 0, Size: 0, Color: 0, Finish: 0, Grade: 0, Material: 0, Constituents: 0, Features: 0, AccessibilityPerformance: 0, CodePerformance: 0, SustainabilityPerformance: 0
Name: 0, CreatedBy: 0, CreatedOn: 0, Category: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, TypeComponentSheets: 0, AssetType: 0, Manufacturer: 0, ModelNumber: 0, WarrantyGuarantorParts: 0, WarrantyDurationParts: 0, WarrantyGuarantorLabor: 0, WarrantyDurationLabor: 0, WarrantyDurationUnit: 0, ReplacementCost: 0, ExpectedLife: 0, DurationUnit: 0, WarrantyDescription: 0, NominalLength: 0, NominalWidth: 0, NominalHeight: 0, ModelReference: 0, Shape: 0, Size: 0, Color: 0, Finish: 0, Grade: 0, Material: 0, Constituents: 0, Features: 0, AccessibilityPerformance: 0, CodePerformance: 0, SustainabilityPerformance: 0
Total correct COBie.Components items = 1 of 1 (100% correct)
Components.AtLeastOneRowPresent
ComponentSheet: 0
ComponentSheet: 0
Total correct COBie.Components.Component items = 5071 of 5071 (100% correct)
Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , TypeName.NotNull, TypeName.CrossReference (Type Worksheet) , Space.NotNull, Space.CrossReference (Component Worksheet) , Description.NotNull , SerialNumber.NotEmpty , InstallationDate.NotNull , WarrantyStartDate.NotNull , TagNumber.NotEmpty , BarCode.NotEmpty , AssetIdentifier.NotEmpty
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, TypeName: 0, Space: 0, Description: 0, SerialNumber: 0, InstallationDate: 0, WarrantyStartDate: 0, TagNumber: 0, BarCode: 0, AssetIdentifier: 0
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, TypeName: 0, Space: 0, Description: 0, SerialNumber: 0, InstallationDate: 0, WarrantyStartDate: 0, TagNumber: 0, BarCode: 0, AssetIdentifier: 0
Total correct COBie.Systems.System items = 596 of 596 (100% correct)
CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), Category.NotNull , ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Description.NotEmpty , PrimaryKey.Unique (Name, Category, ComponentNames), Name.NotNull , ComponentNames.NotNull, ComponentNames.CrossReference
CreatedBy: 0, CreatedOn: 0, Category: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, PrimaryKey: 0, ComponentNames: 0
CreatedBy: 0, CreatedOn: 0, Category: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, PrimaryKey: 0, ComponentNames: 0
Total correct COBie.Spares.Spare items = 13 of 13 (100% correct)
CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Description.NotEmpty , Category.NotNull , Name.NotNull, PrimaryKey.Unique (Name, TypeName) , TypeName.NotNull, TypeName.CrossReference , Suppliers.NotNull, Suppliers.CrossReference (Contact Sheet) , SetNumber.NotEmpty , PartNumber.NotEmpty
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, Name: 0, PrimaryKey: 0, TypeName: 0, Suppliers: 0, SetNumber: 0, PartNumber: 0
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, Name: 0, PrimaryKey: 0, TypeName: 0, Suppliers: 0, SetNumber: 0, PartNumber: 0
Total correct COBie.Resources.Resource items = 19 of 19 (100% correct)
Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Description.NotEmpty , Category.NotNull
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0
Name: 0, CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0
Total correct COBie.Jobs.Job items = 36 of 36 (100% correct)
CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Description.NotEmpty , Category.NotNull , Name.NotNull , PrimaryKey.Unique (Name,TypeName,TaskNumber) , Status.NotNull , TypeName.NotNull, TypeName.CrossReference , Duration.NotEmpty , DurationUnit.NotEmpty , Start.NotEmpty , TaskStartUnit.NotEmpty , Frequency.NotEmpty , FrequencyUnit.NotEmpty , TaskNumber.NotEmpty , Priors.NotEmpty , ResourceNames.NotEmpty, ResourceNames.CrossReference
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, Name: 0, PrimaryKey: 0, Status: 0, TypeName: 0, Duration: 0, DurationUnit: 0, Start: 0, TaskStartUnit: 0, Frequency: 0, FrequencyUnit: 0, TaskNumber: 0, Priors: 0, ResourceNames: 0
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, Name: 0, PrimaryKey: 0, Status: 0, TypeName: 0, Duration: 0, DurationUnit: 0, Start: 0, TaskStartUnit: 0, Frequency: 0, FrequencyUnit: 0, TaskNumber: 0, Priors: 0, ResourceNames: 0
Total correct COBie.Documents.Document items = 674 of 675 (99.85% correct)
CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Description.NotEmpty , Category.NotNull , PrimaryKey.Unique (Name, Stage, SheetName, RowName) , Name.NotNull , ApprovalBy.NotEmpty , Stage.NotNull , SheetName.NotNull, SheetNameRowName.CrossReference , RowName.NotNull , Directory.NotNull , File.NotNull , Reference.NotEmpty
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, PrimaryKey: 0, Name: 0, ApprovalBy: 0, Stage: 0, SheetName: 0, RowName: 1, Directory: 0, File: 0, Reference: 0
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, PrimaryKey: 0, Name: 0, ApprovalBy: 0, Stage: 0, SheetName: 0, RowName: 0, Directory: 0, File: 0, Reference: 0
Total correct COBie.Attributes.Attribute items = 8935 of 8935 (100% correct)
CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid ISO DateTime), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Description.NotEmpty , Category.NotNull , PrimaryKey.Unique (Name, SheetName, RowName) , Name.NotNull , SheetNameRowName.CrossReference , Value.NotEmpty , Unit.NotEmpty , AllowedValues.NotEmpty
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, PrimaryKey: 0, Name: 0, SheetNameRowName: 0, Value: 0, Unit: 0, AllowedValues: 0
CreatedBy: 0, CreatedOn: 0, ExtSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, PrimaryKey: 0, Name: 0, SheetNameRowName: 0, Value: 0, Unit: 0, AllowedValues: 0
Effected Rows:
Errors | |
---|---|
Error ID | Error Message |
Document.SheetNameRowName.Reference | Document.HVAC Filters-Product Data,As Built,Spare,PF-1: Document.RowName must exist in Spare.Name |