Hi there, I’m working on my 3rd Dynamo graph and have been tasked to export our typical air terminal schedule to excel for manipulation then import new values back to the model. I’ve got the Pressure Drop and the Air Flow to export/import but am hitting a wall at the air terminal model parameter. …

First of all, how is your schedule setup? I’d be very surprised if your schedule is setup to where you don’t need to do ANY element sorting before setting your parameters. As for setting type parameters… I was able to set the Model parameter using Element.SetParameterByNameTypeOrInstance, but you c…

Hi Nick, the schedule is a mix of shared (flow rate, pressure drop), family (size, neck size) and native instance parameters (comments). The exported schedule has parameter values connected to the list.create node, which exports fine, I’m working my way through these items on the import parameter…

Element.SetParameterByNameTypeOrInstance worked, with warnings but it worked! [image] Cheers Nick thanks for the help.

What is the warning? Is your schedule set to itemize every instance or do you have it sorted/grouped? If you have the schedule grouped or sorted you’ll have to do the same grouping/sorting in your Dynamo graph to make sure you’re setting the updated parameters for the correct elements.

Nick, see attached warning. I havent sorted or grouped items in the schedule while i’m testing if each column works. When I’m happy every column works the end result is to also export the elemnent ids into the schedule, sort the schedule by grille number, engineers to input their data, I’ll take t…

Could this help? [image] Built in parameters Revit Hello guys! Does anyone know the internal name for “Unbounded Height” built in parameter in Revit??? I am trying to change that with a python script but doesnt work. Thanks, John

Thanks Yna_Db I did browse that thread before posting and couldnt find model in the list of parameters from the API, to be honest got quite initimidated by the thought of some hardcore programming!

Export/Import Air Terminal to Excel - Built In Parameter Issue

Lists-Logic

Yna_Db October 17, 2017, 12:23pm 9

It should be ALL_MODEL_MODEL (see Get BipParameter Name node from Archi-lab Grimshaw) but it does not seem to return any result.

Topic		Replies	Views
Import Excel, Element.setParameterByName Error Revit	10	1404	January 9, 2020
Export schedule to excel with relative Parameter , update parameter in excel & import back to revit with updated parameter Lists-Logic	6	1223	November 25, 2018
Import Type Parameters to Revit Revit	11	326	June 21, 2023
Import/export Revit data from/to excel Revit	1	4176	January 30, 2017
Set Family Type via dynamo Revit excel	4	208	November 14, 2023

Export/Import Air Terminal to Excel - Built In Parameter Issue

Related topics