design.automation-nodejs-revit.rcw.parameters.excel

Description

This sample is based on design.automation-nodejs-revit.parameters.excel, it works almost as same as design.automation-nodejs-revit.parameters.excel, refer to that sample for the general workflow.

The only change of this sample is to support Revit Cloud Model. The sample demonstrates how to update a Revit Cloud Model stored in Autodesk Docs, using the new engine(later than Revit 2022) of Design Automation for Revit.

The sample does two things:

export parameters (Door Type Parameter “Fire Rating”, and/or Door Instance Parameter “Comments”) of Revit Cloud Model to an excel file.
Import parameters (same as above) from a locally stored excel file to Revit Cloud Model.

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.

Technique

Highlight the technique change to support Revit Cloud Model:

The user's 3 Legged token is required by the Revit Design Automation plugin to handle the Revit Cloud Model, it can be passed as adsk3LeggedTokenin in the workitme as follow:

 {
     inputXls: {
         url: "XXXXXXXXXX"
     },
     onComplete: {
         verb: "post",
             url: designAutomation.webhook_url
     },
     adsk3LeggedToken: access_token
 }

Instead of providing the storage link of the Revit model as input or output url, accessing the Revit Cloud Model only requires the Cloud information including Region, ProjectGuid, ModelGuid. These info can be passed within a JSON file in workitem, and Revit plugin will open/save the Revit Cloud Model like:

Open Revit Cloud Model

 var cloudModelPath = ModelPathUtils.ConvertCloudGUIDsToCloudPath(inputParams.Region, inputParams.ProjectGuid, inputParams.ModelGuid);
 Document doc = rvtApp.OpenDocumentFile(cloudModelPath, new OpenOptions());

Save Revit Cloud Model

  if (doc.IsWorkshared)
  {
     SynchronizeWithCentralOptions swc = new SynchronizeWithCentralOptions();
     swc.SetRelinquishOptions(new RelinquishOptions(true));
     doc.SynchronizeWithCentral(new TransactWithCentralOptions(), swc);
  }
  else
  {
     // Single user cloud model
     doc.SaveCloudModel();
  }

Within the Revit plugin, Revit API cann only synchronize the work-shared model with central, no Revit API to publish the model, you can actually publish the Revit Cloud Model by PublishModel API in the onComplete callback like:
```
         const commandApi = new CommandsApi();
         await commandApi.publishModel( workitem.projectId, workitem.cloudModelBody,{}, req.oauth_client, workitem.access_token_3Legged );
```

Thumbnail

Demonstration

Note: The video is for file-based Revit model, but the workflow should be same for Revit Cloud Model.

Live Demo

https://rcw-excel.herokuapp.com/

Main Parts of The Work

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, you can refer (https://youtu.be/1NCeH7acIko) and simply use the Configure button in the Web Application to create the Appbundle & Activity.
Create the Web App to call the workitem.

Web App Setup

Prerequisites

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 2023: 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.

Running locally

Install NodeJS, version 14 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.rcw.parameters.excel

Install the required packages using npm install.

ngrok

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.

Environment variables

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.

Using the app

Open the browser: http://localhost:3000, it provides the abilities to export & import parameter with Excel:

Select Revit Cloud Model file version in Autodesk Docs 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.

Deployment

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.

Packages used

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.

Limitation

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.

Tips & Tricks

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 Configure button in the Web Application to create the Appbundle & Activity(https://youtu.be/1NCeH7acIko).
It takes time for Autodesk Docs to automatically translate the new published Revit Cloud Model, please wait for a while to see the viewable and properties.

License

This sample is licensed under the terms of the MIT License. Please see the LICENSE file for full details.

Written by

Zhong Wu @johnonsoftware, Forge Partner Development

ehtick / design.automation-nodejs-revit.rcw.parameters.excel Goto Github PK

design.automation-nodejs-revit.rcw.parameters.excel's Introduction

design.automation-nodejs-revit.rcw.parameters.excel's People

Contributors

Recommend Projects

Recommend Topics

Recommend Org