COBie Compliant Export

There are times when a COBie deliverable is required and with the growing trend toward using COBie via the buildingSMART Alliance we have created a short guide to how to use our excel export settings to meet these needs. There are several levels to COBie compliance and in the example below we are using the Example provided by NIBS.

1. Excel Export:

Administration→ Configure Excel Export
New Export
Name COBie
Shared for multi user access
Select template
Save

2. Name Sheets by Selecting the New within the"Sheet" tab. Ensure that the naming convention of each sheet is consistent with CoBie Standards. By default, the starting row is 1. Switch the starting row for each sheet to 2. Save Each Sheet.

Instruction
Contact
Facility
Floor
Space
Zone
Type
Component
System
Assembly
Spare
Resource
Job
Impact
Document
Attribute
Coordinate
Connection
Issues
PickLists

3. Assign Data Sources to the following Sheets.

Contact
1. Target Type: User
2. Name: Contact
3. Attributes:
  1. Add: General: Email
  2. Add fixed value: dRofus_admin
  3. Add fixed value: n/a
  4. Add fixed value: Planner
  5. Add fixed value: n/a
  6. Add fixed value: n/a
  7. Add fixed value: dRofus
4. Save
Facility
1. Target Type: Project
2. Name: Project
3. Attributes:
  1. Add: General: Name
4. Save
Floor
1. Target Type: Group
2. Name: Floor
3. Attributes:
  1. Add: General: Name
  2. Add: Created by: Created by: Email
  3. Add: Group Type: Group Type: Created
  4. Add: General: Reference
  5. Add fixed value: dRofus
  6. Add fixed value: ifcBuildingStorey
  7. Add fixed value: n/a
  8. Add: General: Description
  9. Add fixed value: n/a
  10. Add fixed value: n/a
4. Save
Space
1. Target Type: Room
2. Name: Space
3. Attributes:
  1. Add: Room: Room Function #
  2. Add: Created by: Created by: Email
  3. Add fixed value: n/a
  4. Add: Level: Level: Name **
  5. Add Complex value: Room Name, Room Name Description
    1. Format Template: {0} {1}
    2. E.g: Room Name Room Name Description
  6. Add fixed value: dRofus
  7. Add fixed value: IfcSpace
  8. Add fixed value: n/a
  9. Add: Room: Name on Drawing
  10. Add: Room: Prog. Area
  11. Add: Room: Designed Area
  12. Add: Room: Ceiling Height
4. Save
Zone
1. Target Type: Room
2. Name: Room
3. Attributes:
  1. Add Complex Value: Room Function: Number, Room Function: Name
    1. Format Template: {0} {1}
    2. E.g: Room function: Number Room function: Name
  2. Add fixed value: dRofus_admin
  3. Add fixed value: n/a
  4. Add fixed value: Occupancy Zone
  5. Add: Room: Room Function #:
  6. Add fixed value: dRofus
  7. Add fixed value: n/a
  8. Add fixed value: n/a
  9. Add: Room: Room Name
4. Save
Type:
1. Target Type: Item
2. Name: Item
3. Attributes:
  1. Add: General: Item Number
  2. Add Fixed Value: ( leave blank)
  3. Add: Log History: Created
  4. Add: General: Name
  5. Add: Categorization: Sub Set (Name)
  6. Add: Specification - Description (Flag) - Asset Type (Group) - Fixed/Movable (Element) - (Radio buttons/ combo box)*
  7. Add fixed value: n/a
  8. Add fixed value: n/a
  9. Add fixed value: n/a
  10. Add fixed value: n/a
  11. Add fixed value: n/a
  12. Add fixed value: n/a
  13. Add fixed value: n/a
  14. Add fixed value: dRofus
  15. Add fixed value: n/a
  16. Add fixed value: n/a
  17. Add: General: Budget Price
  18. Add fixed value: n/a
  19. Add fixed value: n/a
  20. Add fixed value: n/a
  21. Add: General: Item Number
  22. Add: Specification-Building I (Flag): Max dimensions and weight (Group) - With/length (Element) - inch (Numeric Field) *
  23. Add: Specification-Building I: Max dimensions and weight - Depth (Element) - inch (Numeric Field) *
  24. Add: Specification-Building I : Max dimensions and weight - Height (Element) - inch (Numeric Field) *
4. Save

*Attribute Added to Item Specification GUI

** Added type to Groups

This page references https://www.nibs.org/?page=bsa_commonbimfiles