COBie QC report - Design Deliverable

2013-10-24T19:23:40

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

Instructions

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.


Table of Contents


 1 QC Summary

    1.1 COBie Summary Table

    1.2 COBie.Contacts  (row count check)

    1.3 COBie.Contacts.Contact  (checked 1 row)

    1.4 COBie.Facilities  (row count check)

    1.5 COBie.Facilities.Facility  (checked 1 row)

    1.6 COBie.Floors  (row count check)

    1.7 COBie.Floors.Floor  (checked 5 rows)

    1.8 COBie.Spaces  (row count check)

    1.9 COBie.Spaces.Space  (checked 269 rows)

    1.10 COBie.Zones.Zone  (checked 259 rows)

    1.11 COBie.Types  (row count check)

    1.12 COBie.Types.Type  (checked 118 rows)

    1.13 COBie.Components  (row count check)

    1.14 COBie.Components.Component  (checked 3140 rows)

    1.15 COBie.Systems.System  (checked 428 rows)

    1.16 COBie.Documents.Document  (checked 118 rows)

    1.17 COBie.Attributes.Attribute  (checked 18625 rows)

 2 Detailed Error Report Grouped by Error/Warning Type

 3 Detailed Error Report Grouped by Row

 

1 QC Summary

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.

 

1.1 COBie Summary Table

Worksheet Has Rows? Row Count Row Warning Count Row Error Count
Contact true 1 0 0
Facility true 1 0 0
Floor true 5 0 0
Space true 269 0 0
Zone true 259 0 0
Type true 118 0 0
Component true 3140 0 0
System true 428 0 0
Assembly false 0 n/a n/a
Connection false 0 n/a n/a
Spare false 0 n/a n/a
Resource false 0 n/a n/a
Job false 0 n/a n/a
Document true 118 0 0
Attribute true 18625 0 0


  

1.2 COBie.Contacts  (row count check)

Total correct COBie.Contacts items  = 1 of 1 (100% correct)

Checks Performed

Contacts.AtLeastOneRowPresent

Field Error Counts

ContactSheet: 0


Field Warning Counts

ContactSheet: 0

Table of Contents

 

1.3 COBie.Contacts.Contact  (checked 1 row)

Total correct COBie.Contacts.Contact items  = 1 of 1 (100% correct)

Checks Performed

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

Field Error Counts

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


Field Warning Counts

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

Table of Contents

 

1.4 COBie.Facilities  (row count check)

Total correct COBie.Facilities items  = 1 of 1 (100% correct)

Checks Performed

Facilities.OneAndOnlyOneFacilityFound

Field Error Counts

FacilitySheet: 0


Field Warning Counts

FacilitySheet: 0

Table of Contents

 

1.5 COBie.Facilities.Facility  (checked 1 row)

Total correct COBie.Facilities.Facility items  = 1 of 1 (100% correct)

Checks Performed

Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), 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

Field Error Counts

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


Field Warning Counts

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

Table of Contents

 

1.6 COBie.Floors  (row count check)

Total correct COBie.Floors items  = 1 of 1 (100% correct)

Checks Performed

Floors.AtLeastOneRowPresent

Field Error Counts

FloorSheet: 0


Field Warning Counts

FloorSheet: 0

Table of Contents

 

1.7 COBie.Floors.Floor  (checked 5 rows)

Total correct COBie.Floors.Floor items  = 5 of 5 (100% correct)

Checks Performed

Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Category.NotNull , Floor.Elevation.ValidNumberOrNA , Floor.Height.ZeroOrGreaterOrNA

Field Error Counts

Name: 0, CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, Elevation: 0, Height: 0


Field Warning Counts

Name: 0, CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, Elevation: 0, Height: 0

Table of Contents

 

1.8 COBie.Spaces  (row count check)

Total correct COBie.Spaces items  = 1 of 1 (100% correct)

Checks Performed

Spaces.AtLeastOneRowPresent

Field Error Counts

SpaceSheet: 0


Field Warning Counts

SpaceSheet: 0

Table of Contents

 

1.9 COBie.Spaces.Space  (checked 269 rows)

Total correct COBie.Spaces.Space items  = 269 of 269 (100% correct)

Checks Performed

CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Category.NotNull , Name.NotNull, PrimaryKey.Unique.Warning (Name), PrimaryKey.Unique.Error (Name, FloorName) , FloorName.NotNull, FloorName.CrossReference , Description.NotNull , RoomTag.NotEmpty , UsableHeight.ZeroOrGreaterOrNA , GrossArea.ZeroOrGreaterOrNA , NetArea.ZeroOrGreaterOrNA

Field Error Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, Name: 0, FloorName: 0, Description: 0, RoomTag: 0, UsableHeight: 0, GrossArea: 0, NetArea: 0


Field Warning Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Category: 0, Name: 0, FloorName: 0, Description: 0, RoomTag: 0, UsableHeight: 0, GrossArea: 0, NetArea: 0

Table of Contents

 

1.10 COBie.Zones.Zone  (checked 259 rows)

Total correct COBie.Zones.Zone items  = 259 of 259 (100% correct)

Checks Performed

CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), Category.NotNull , Description.NotEmpty , ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Name.NotNull, PrimaryKey.Unique (Name, Category, SpaceNames) , SpaceNames.NotNull, SpaceNames.CrossReference

Field Error Counts

CreatedBy: 0, CreatedOn: 0, Category: 0, Description: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Name: 0, SpaceNames: 0


Field Warning Counts

CreatedBy: 0, CreatedOn: 0, Category: 0, Description: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Name: 0, SpaceNames: 0

Table of Contents

 

1.11 COBie.Types  (row count check)

Total correct COBie.Types items  = 1 of 1 (100% correct)

Checks Performed

Types.AtLeastOneRowPresent

Field Error Counts

TypeSheet: 0


Field Warning Counts

TypeSheet: 0

Table of Contents

 

1.12 COBie.Types.Type  (checked 118 rows)

Total correct COBie.Types.Type items  = 118 of 118 (100% correct)

Checks Performed

Name.NotNotNull, Name.Unique, CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), Category.NotNull , ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Type.Component.AComponentForEachType , AssetType.NotNull , Manufacturer.CrossReferenceOrNA(Contact Sheet) , ModelNumber.NotEmpty , WarrantyGuarantorParts.CrossReferenceOrNA (Contact Sheet) , WarrantyDurationParts.validNumberZeroOrGreaterOrNA , WarrantyGuarantorLabor.CrossReferenceOrNA (Contact Sheet) , WarrantyDurationLabor.ZeroOrGreaterOrNA , WarrantyDurationUnit.NotEmpty , ReplacementCost.ZeroOrGreaterOrNAr , 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

Field Error Counts

Name: 0, CreatedBy: 0, CreatedOn: 0, Category: 0, ExternalSystem: 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


Field Warning Counts

Name: 0, CreatedBy: 0, CreatedOn: 0, Category: 0, ExternalSystem: 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

Table of Contents

 

1.13 COBie.Components  (row count check)

Total correct COBie.Components items  = 1 of 1 (100% correct)

Checks Performed

Components.AtLeastOneRowPresent

Field Error Counts

ComponentSheet: 0


Field Warning Counts

ComponentSheet: 0

Table of Contents

 

1.14 COBie.Components.Component  (checked 3140 rows)

Total correct COBie.Components.Component items  = 3140 of 3140 (100% correct)

Checks Performed

CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Name.NotNull, PrimaryKey.Unique.Warning (Name), PrimaryKey.Unique.Error (Name, Space) , TypeName.NotNull, TypeName.CrossReference (Type Worksheet) , Space.NotNull, Space.CrossReference (Component Worksheet) , Description.NotNull , SerialNumber.NotEmpty , InstallationDate.NotEmpty , WarrantyStartDate.NotEmpty , TagNumber.NotEmpty , BarCode.NotEmpty , AssetIdentifier.NotEmpty

Field Error Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Name: 0, TypeName: 0, Space: 0, Description: 0, SerialNumber: 0, InstallationDate: 0, WarrantyStartDate: 0, TagNumber: 0, BarCode: 0, AssetIdentifier: 0


Field Warning Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Name: 0, TypeName: 0, Space: 0, Description: 0, SerialNumber: 0, InstallationDate: 0, WarrantyStartDate: 0, TagNumber: 0, BarCode: 0, AssetIdentifier: 0

Table of Contents

 

1.15 COBie.Systems.System  (checked 428 rows)

Total correct COBie.Systems.System items  = 428 of 428 (100% correct)

Checks Performed

CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), Category.NotNull , ExternalSystem.NotEmpty, ExternalObject.NotEmpty , ExtIdentifier.NotEmpty , Description.NotEmpty , PrimaryKey.Unique (Name, Category, ComponentNames), Name.NotNull , ComponentNames.NotNull, ComponentNames.CrossReference

Field Error Counts

CreatedBy: 0, CreatedOn: 0, Category: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Name: 0, ComponentNames: 0


Field Warning Counts

CreatedBy: 0, CreatedOn: 0, Category: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Name: 0, ComponentNames: 0

Table of Contents

 

1.16 COBie.Documents.Document  (checked 118 rows)

Total correct COBie.Documents.Document items  = 118 of 118 (100% correct)

Checks Performed

CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), 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.NotEmpty , File.NotEmpty , Reference.NotEmpty

Field Error Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 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


Field Warning Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 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

Table of Contents

 

1.17 COBie.Attributes.Attribute  (checked 18625 rows)

Total correct COBie.Attributes.Attribute items  = 18625 of 18625 (100% correct)

Checks Performed

CreatedBy.CrossReference (ToContact), CreatedBy.NotNull, CreatedOn.NotNull, CreatedOn.Valid (Valid Email Address), 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

Field Error Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, PrimaryKey: 0, Name: 0, SheetNameRowName: 0, Value: 0, Unit: 0, AllowedValues: 0


Field Warning Counts

CreatedBy: 0, CreatedOn: 0, ExternalSystem: 0, ExtObject: 0, ExtIdentifier: 0, Description: 0, Category: 0, PrimaryKey: 0, Name: 0, SheetNameRowName: 0, Value: 0, Unit: 0, AllowedValues: 0

Table of Contents

   

2 Detailed Error Report Grouped by Error/Warning Type

No Errors

  

3 Detailed Error Report Grouped by Row

No Errors