This sample demonstrates how to update a file-based Revit model stored in BIM 360 Docs, using Design Automation for Revit. The sample does two things:
- export Revit parameters (Door Type Parameter “Fire Rating”, and/or Door Instance Parameter “Comments”) to an excel file.
- Import Revit parameters (same as above) from a locally stored excel file.
The custom button in a viewer is provided to make it easier to see the parameter values. You can also see the values in the default property panel as well.
https://revitexcel.herokuapp.com/
-
Create a Revit Plugin to be used within AppBundle of Design Automation for Revit. Please check PlugIn
-
Create your App, upload the AppBundle, define your Activity and test the workitem with the Postman collection under Postman Collection, or you can refer (https://youtu.be/1NCeH7acIko) and simply use the
Configurebutton in the Web Application to create the Appbundle & Activity. -
Create the Web App to call the workitem.
- Forge Account: Learn how to create a Forge Account, activate subscription and create an app at this tutorial.
- Visual Code: Visual Code (Windows or MacOS).
- ngrok: Routing tool, download here
- Revit 2019: required to compile changes into the plugin
- JavaScript ES6 syntax for server-side.
- JavaScript basic knowledge with jQuery
For using this sample, you need an Autodesk developer credentials. Visit the Forge Developer Portal, sign up for an account, then create an app. For this new app, use http://localhost:3000/api/forge/callback/oauth as Callback URL, although is not used on 2-legged flow. Finally take note of the Client ID and Client Secret.
Install NodeJS, version 8 or newer.
Clone this project or download it (this nodejs branch only). It's recommended to install GitHub desktop. To clone it via command line, use the following (Terminal on MacOSX/Linux, Git Shell on Windows):
git clone https://github.com/Autodesk-Forge/design.automation-nodejs-revit.parameters.excel
Install the required packages using npm install.
Run ngrok http 3000 to create a tunnel to your local machine, then copy the address into the FORGE_WEBHOOK_URL environment variable. Please check WebHooks for details.
Set the environment variables with your client ID & secret and finally start it. Via command line, navigate to the folder where this repository was cloned and use the following:
Mac OSX/Linux (Terminal)
npm install
export FORGE_CLIENT_ID=<<YOUR CLIENT ID FROM DEVELOPER PORTAL>>
export FORGE_CLIENT_SECRET=<<YOUR CLIENT SECRET>>
export FORGE_CALLBACK_URL=<<YOUR CALLBACK URL>>
export FORGE_WEBHOOK_URL=<<YOUR DESIGN AUTOMATION FOR REVIT CALLBACK URL>>
export DESIGN_AUTOMATION_NICKNAME=<<YOUR DESIGN AUTOMATION FOR REVIT NICK NAME>>
export DESIGN_AUTOMATION_ACTIVITY_NAME=<<YOUR DESIGN AUTOMATION FOR REVIT ACTIVITY NAME>>
npm start
Windows (use Node.js command line from Start menu)
npm install
set FORGE_CLIENT_ID=<<YOUR CLIENT ID FROM DEVELOPER PORTAL>>
set FORGE_CLIENT_SECRET=<<YOUR CLIENT SECRET>>
set FORGE_CALLBACK_URL=<<YOUR CALLBACK URL>>
set FORGE_WEBHOOK_URL=<<YOUR DESIGN AUTOMATION FOR REVIT CALLBACK URL>>
set DESIGN_AUTOMATION_NICKNAME=<<YOUR DESIGN AUTOMATION FOR REVIT NICK NAME>>
set DESIGN_AUTOMATION_ACTIVITY_NAME=<<YOUR DESIGN AUTOMATION FOR REVIT ACTIVITY NAME>>
npm start
Windows (use PowerShell)
npm install
$env:FORGE_CLIENT_ID="YOUR CLIENT ID FROM DEVELOPER PORTAL"
$env:FORGE_CLIENT_SECRET="YOUR CLIENT SECRET"
$env:FORGE_CALLBACK_URL="YOUR CALLBACK URL"
$env:FORGE_WEBHOOK_URL="YOUR DESIGN AUTOMATION FOR REVIT CALLBACK URL"
$env:DESIGN_AUTOMATION_NICKNAME="YOUR DESIGN AUTOMATION FOR REVIT NICK NAME"
$env:DESIGN_AUTOMATION_ACTIVITY_NAME="YOUR DESIGN AUTOMATION FOR REVIT ACTIVITY NAME"
npm start
Note. environment variable examples:
- FORGE_CALLBACK_URL:
http://localhost:3000/api/forge/callback/oauth - FORGE_WEBHOOK_URL:
http://808efcdc123456.ngrok.io/api/forge/callback/designautomation
The following are optional:
- DESIGN_AUTOMATION_NICKNAME: Only necessary if there is a nickname, Forge client id by default.
- DESIGN_AUTOMATION_ACTIVITY_NAME: Only necessary if the activity name is customized, ExportImportExcelActivity by default.
Open the browser: http://localhost:3000, it provides the abilities to export & import parameter with Excel:
- Select Revit file version in BIM360 Hub to view the Model, Select parameters which you want to export|import, choose either export or import and click 'Execute'.
- Select the Door type or instance in Model Viewer, and open the customized property panel to see the result.
Note: When you deploy the app, you have to open the Configure button to create the AppBundle & Activity before running the Export|Import feature, please check the video for the steps at https://youtu.be/1NCeH7acIko. You can also delete the existing AppBundle & Activity and re-create with different Design Automation Revit engine version.
To deploy this application to Heroku, the Callback URL for Forge must use your .herokuapp.com address. After clicking on the button below, at the Heroku Create New App page, set your Client ID, Secret, Callback URL and Revit Design Automation variables for Forge.
Watch this video on how deploy samples to Heroku.
The Autodesk Forge packages is included by default. Some other non-Autodesk packaged are used, including socket.io, express.
Within the Revit Plugin, LibXL is used to read/write the date of Excel.
Documentation:
-
This sample is based on Learn Forge Tutorial, please check details there about the basic framework if you are not familar.
-
Data Management API
Desktop APIs:
After installing Github desktop for Windows, on the Git Shell, if you see a error setting certificate verify locations error, use the following:
git config --global http.sslverify "false"
- Before using the sample to call the workitem, you need to setup your Appbundle & Activity of Design Automation, you can follow my Postman script to understand the whole process, or you can simply use the
Configurebutton in the Web Application to create the Appbundle & Activity(https://youtu.be/1NCeH7acIko). - Currently Revit Cloud Worksharing is not supported by the Design Automation. The scenario that this sample demonstrates is applicable only with a file-based Revit model.
- The free version of LibXL I used will write a banner in the first row of each spreadsheet and it will be able to read only 300 cells (first row is unavailable). If you want to remove banner and reading restriction, you may contact them for a license.
- It takes time for BIM360 to automatically translate the new uploaded Revit file version, please wait for a while to see the viewable and properties.
- Client JavaScript requires modern browser.
- Currently, the sample support Design Automation engine 2019 & 2020, you can use
Configurebutton to delete|create different versions of Design Automation Revit engine.
This sample is licensed under the terms of the MIT License. Please see the LICENSE file for full details.
Zhong Wu @johnonsoftware, Forge Partner Development Eason Kang @yiskang, Forge Partner Development
