Transcript DIY FM: Bridging the AEC/FM Gap using Revit DB Link, ASP

DIY FM: Bridging the AEC/FM Gap using Revit
DB Link, ASP.NET, HTML, VB and Java
Brandon Pike
[email protected]
What We’ll Cover Today
•
Part 1- BIM/FM Data Input and Exchange using COBie
–
–
–
•
How have we gotten where we are today?
Crash course in COBie data models and data exchange
A look into the next generation of data exchange
Part 2 - Let’s do it!! – Next Generation Data Transfer - Live Demonstration
–
–
–
–
–
Quick tour of a COBie-compliant Revit model
Use Microsoft SQL Server Management Studio to create a new SQL database
Use Revit DBLink to sync model data with the SQL Database
Use Visual Web Developer Express to create an application to broadcast SQL
Server data across the web
Make data changes flow round trip throughout the system
Autodesk Releases AutoCAD
Architectural Desktop v1.0
ADT to Microsoft Excel
Paper Deliverables
Revit Tech. Corp. Releases Revit v1.0
Revit to Microsoft Excel
Paper Deliverables
1989
1998
2000
2010
Microsoft Releases Office v1.0
AutoCAD to Microsoft Excel
Paper Deliverables
1982
Autodesk Releases Revit DBLink
Revit to SQL Server Database
Electronic Deliverables
Bi-Directional Relationships
Revit to IFC Export
Electronic Deliverables
One-Way Data Transfer
Revit to ODBC Export
Electronic Deliverables
One-Way Data Transfer
Revit to Microsoft Excel
Electronic Deliverables
One-Way Data Transfer (some bi-directional)
Autodesk Founded
Releases AutoCAD v1.0
Paper Deliverables
A Blast from the Past!
COBie Process Overview
Construction Operations Building information exchange
Open Standards for:
Building operational data parameters and information types
Data exchange means and methods
COBie Process Overview
COBie Process Overview
COBie Process Overview
Job
Type
Resource
Spaces
Components
Spare
Zones
Systems
Floors
(and warranty)
(and installation)
Design
Build
Common
Contacts
Issues
Attributes
Documents
Coordinates
Connections
O&M
Non-Model Data
Model Data
Facility
COBie Process Overview
BIM Model
export
COBie Spreadsheet
Design
Build
BIM Model
*
export
FM, O&M
Platforms
IFC
O&M
FM, O&M
Platforms
COBie Process Overview
Revit Model
SQL Server
Web
Application
•
Part 2 - Let’s do it!! – Next Generation Data Transfer - Live Demonstration
–
–
–
–
–
Quick tour of a COBie-compliant Revit model
Use Microsoft SQL Server Management Studio to create a new SQL database
Use Revit DBLink to sync model data with the SQL Database
Use Visual Web Developer Express to create an application to broadcast SQL
Server data across the web
Make data changes flow round trip throughout the system
Review
•
Revit Architecture 2012
•
Autodesk COBie Toolkit
•
Revit DBLink Add-in for Revit Architecture 2012
•
Local instance of SQL Server 2008 Express
–
Or a slice of your corporate SQL Server
•
SQL Server Management Studio 2008 r2
•
Microsoft Visual Web Developer 2010 Express
•
Standard Web Browser
Revit
Model
SQL
Server
Web
Application
Questions?
Brandon Pike
[email protected]