JP_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:

1. Administration→ Configure Excel Export
2. New Export
3. Name COBie
4. Shared for multi user access
5. Select template 
6. 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. 

1. Instruction 
2. Contact
3. Facility
4. Floor
5. Space
6. Zone
7. Type
8. Component
9. System
10. Assembly
11. Spare
12. Resource
13. Job
14. Impact
15. Document
16. Attribute
17. Coordinate
18. Connection
19. Issues
20. PickLists

3. Assign Data Sources to the following Sheets.

1. 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
2. Facility
   1. Target Type: Project
   2. Name: Project
   3. Attributes:
      1. Add: General: Name
   4. Save
3. 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
4. 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
5.  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
6. 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