The article details how the specification data is exported to COBie.
Also see the Export to COBie section in the NBS Create Help Centre
What is exported
COBie documents contain information on the maintainable assets so NBS Create will export all the data from your specification except for:
Project Management Sections (00)
Whole Building Performance Sections (05)
System and Product Execution Clauses (600-799)
System Completion Clauses (801-899)
System Facilities Management Clauses (901-999)
Any parked or deleted clauses
How the data is structured
Your specification data will populate four worksheets (Contact, Type, System and Attribute) in the COBie document.
The data is populated in these worksheets according to the following rules:
Contact sheet
- All system and product manufacturer clauses which contain a named manufacturer from NBS Plus or have been entered as a custom manufacturer are exported.
- Each manufacturer is exported once, one per row. Uniqueness is determined by manufacturer name.
- If the 'system manufacturer' or 'manufacturer' field in the specification is not the name of a company from NBS Plus or entered by the Custom Manufacturer feature e.g. it is entered as plain text, this will not get exported.
- Furthermore if the'manufacturer' field is not a name, for exampleif it contains 'Contractor's Choice' or 'Submit Proposals' this does not get exported.
|
Column name |
|
|
|
Manufacturers contact email (blank if not known) |
|
CreatedBy |
As entered by the user at the point of export. Usually practice email address. This will be blank by default if nothing was entered |
|
CreatedOn |
The date the export was completed in the format YYYY-MM-DDTHH:MM:SS |
|
Category |
PM_10_60_55 : Manufacturer |
|
Company |
Manufacturer name |
|
Phone |
Manufacturer contact telephone number |
|
ExternalSystem |
NBSCreate (text entry) |
|
ExternalObject |
NBSManufacturer (text entry) |
|
ExternalIdentifier |
The unique NBS identifier (known as the GUID) |
|
Street |
Populated from address field in NBS Plus or custom manufacturer or blank if not populated |
|
Town |
Populated from NBS Plus or custom manufacturer or blank if not known |
|
StateRegion |
Populated from NBS Plus or custom manufacturer or blank if not known |
|
PostalCode |
Populated from NBS Plus or custom manufacturer or blank if not known |
|
County |
Populated from NBS Plus or custom manufacturer or blank if not known |
All other columns in the worksheet are left blank
Type sheet
- One Product clause or System outline per row.
- Clauses in ‘General requirements’ are not exported to this worksheet but they will be included in the Attribute worksheet. General requirements are comparable to system performance which are not included in this worksheet.
|
Column name |
|
|
Name |
System outline or Product clause title followed by clause suffix (if applicable) |
|
CreatedBy |
As entered by the user at the point of export. Usually practice email address. This will be blank by default if nothing was entered |
|
CreatedOn |
When the export was completed in the following format YYYY-MM-DDTHH:MM:SS |
|
Category |
Classification formatted as [Clause number] : [Clause title] If both NBS Code and Uniclass 2015 are selected to export or there is a one-to-many mapping each classification is separated according to the COBie scheme as " ; " If there is no Uniclass 2015 code, "No mapping found for this clause in Uniclass 2015" is inserted as text |
|
Description |
Clause title followed by clause suffix (if applicable) |
|
Manufacturer |
NBS Plus or Custom Manufacturer email address. Alternatively if this field in your specification has been populated with “Submit proposals”, “Contractors choice” or “Contractors decision” or plain text this will be displayed in this field. It will be left blank if there is no value to display |
|
ModelNumber |
NBS Plus or Custom Manufacturer Product reference. This field will be left blank if there is no value to display |
|
ExtSystem |
NBSCreate (text entry) |
|
ExtObject |
NBSProductClause for product clauses NBSSystemClause for System outline |
|
ExtIdentifier |
The unique NBS identifier (known as the GUID) |
All other columns in the worksheet are left blank
System sheet
- One System outline per row.
|
Column name |
|
|
Name |
System outline clause title followed by clause suffix (if applicable) |
|
CreatedBy |
As entered by the user at the point of export. Usually practice email address. This will be blank by default if nothing was entered |
|
CreatedOn |
When the export was completed in the following format YYYY-MM-DDTHH:MM:SS |
|
Category |
Classification formatted as [Clause number] : [Clause title If both NBS Code and Uniclass 2015 are selected to export or there is a one-to-many mapping each classification is separated according to the COBie scheme as " ; " If there is no Uniclass 2015 code, "No mapping found for this clause in Uniclass 2015" is inserted as text |
|
ComponentNames |
System outline product clause item values as a comma separated list including suffixes. Only product clause items that are hyperlinks to clauses will be exported Plain text values will not be exported |
|
ExtSystem |
NBSCreate (text entry) |
|
ExtObject |
NBSSystemClause (text entry) |
|
ExtIdentifier |
The unique NBS identifier (known as the GUID) |
|
Description |
Description text from System Outline (blank if nothing to display) |
All other columns in the worksheet are left blank
Attribute sheet
- Product clause and System Outline clauses span over more than one row according to how many clause items them contain.
- The details of the clause reference in “General requirements” will take on the name of its parent clause. In the example below the ‘General or utility plywood’ clause references another product clause for ‘Timber procurement’ as general requirements. We export the contents of the Timber Procurement clause and apply the name of the parent clause against them – in this case General or utility plywood.
|
Column name |
|
|
Name |
System outline or Product clause title followed by clause suffix (if applicable) Note: where there is an indented clause item, the parent will be included e.g. Duty->Size->Width (mm) |
|
CreatedBy |
As entered by the user at the point of export. Usually practice email address. This will be blank by default if nothing was entered |
|
CreatedOn |
When the export was completed in the following format YYYY-MM-DDTHH:MM:SS |
|
Category |
Classification formatted as [Clause number] : [Clause title] If both NBS Code and Uniclass 2015 are selected to export or there is a one-to-many mapping each classification is separated according to the COBie scheme as " ; " If there is no Uniclass 2015 code, "No mapping found for this clause in Uniclass 2015" is inserted as text |
|
SheetName |
Type (text value) |
|
RowName |
Product clause title followed by suffix (if applicable) |
|
Value |
Clause item text (that corresponds to the Name field) |
|
ExtSystem |
NBSCreate (text entry) |
|
ExtObject |
NBSClauseItem (text entry) |
|
ExtIdentifier |
The unique NBS identifier (known as the GUID) |
All other columns in the worksheet are left blank
