Using Excel to drive HP pier foundation heights

[ryntau]

I feel like i'm missing something really easy here. I'm trying to use an excel table to drive my elevation heights. I currently have all of the piers placed in the right spot with Marks. but for some reason the Elements.SetParameterByName is not setting my elevation offset. Any help would be much appreciated?

[Mengelmn]

I feel like i'm missing something really easy here. I'm trying to use an excel table to drive my elevation heights. I currently have all of the piers placed in the right spot with Marks. but for some reason the Elements.SetParameterByName is not setting my elevation offset. Any help would be much appreciated?

The Element input expects a list of "revit elements" currently you are inputting "values"


Sent from my iPhone using Tapatalk

[ryntau]

That makes sense. I'm not sure how to input the elements in the correct order (by Mark) ?

[Mengelmn]

That makes sense. I'm not sure how to input the elements in the correct order (by Mark) ?

Try looking at 'sort by key' this should allow you to sort the original element list by the Mark value list.


Sent from my iPhone using Tapatalk

[amoursol]

Hello Ryntau,

Is this what you are after?



Bear in mind that this system works on internal logiac, so that it functions correctly with regards to numbers but will fail if we have a different mark system.

For example:

W1
W11
W12
W13
...
W2
W21

In lieu of an actual ordering system. In this case, you would have to split the string into numbers only for ordering purposes.