Excel to Revit (Unique ID) - Entire Row

Revit
,
1

We are currently having an issue with our dynamo script.

This script is supposed to pull all data from Excel, each row and place that info into the family according to the Unique ID code from Excel to the matching Unique ID in the Revit Family.

Error Message:
Warning: Element.SetParameterByName operation failed.
The call is ambiguous between the following methods or properties: ‘Revit.Elements.InternalUtilities.ElementUtils.SetParameterValue(Autodesk.Revit.DB.Parameter, Revit.Elements.Element)’ and 'Revit.Elements.InternalUtilities.ElementUtils.SetParameterValue(Autodesk.Revit.DB.Parameter, string)

I have included the excel file and the dynamo script. The excel file has been cleared to not include client information.

https://1drv.ms/u/s!AtNGuWcLjQNixwVA0pvMCqm-Kp-b?e=xEgybg

Looking for ideas on how to do this or fix this issue…?

Capture
Capture.png2968×3686 545 KB

2

Hi @astoneMYXWY,

You can’t attach files as a new user. Instead you can use an external service, like Dropbox or Google drive.

3

Going to do that now. Thanks!

4

Also, when taking pictures of your Dynamo graph, make sure to zoom in until the nodes are legible and then press the Camera button in the top right. It will take an overall picture maintaining the zoom level.

6

Please use link below for excel, dynamo and RFA files. These are the files that we are using as a framework.

https://1drv.ms/u/s!AtNGuWcLjQNixwVA0pvMCqm-Kp-b?e=xEgybg

7

Hi @astoneMYXWY,

I think you get an error because all the cells are read as strings, and you have a few parameters which takes doubles. So make sure not to convert everything to strings :slight_smile:

Here’s an alternative way to get the job done:

image
image.png1792×876 196 KB

The nulls are there because there are more columns in the Excel Sheet then the components got parameters.

image
image.png1861×953 97 KB

I’ve attached the graph.

Unique ID Data Import_ForAustin.dyn (144.9 KB)

1 Like
8

Thanks Martin! This works! I will keep that in mind.