Data integration form Excel through Grasshopper to Tekla Structures UDA

Hello everyone!

I would like to ask a question. I am a student and very new to Grasshopper. I want to import from Excel through Grasshopper to Tekla Structures user-defined attributes when I select elements in TS. I don’t know how to integrate data from Grasshopper to TS UDA. Can anyone please help me develop the script?

Hi win thu,

How do you link the excel data to the correct elements in Tekla Structures? You have an Element ID in the table, is that referring to e.g. an UDA of an existing object in Tekla?

Cheers,

-b

Hello, Sebastian Lindholm. I would like to show the data in UDA properties in Tekla Structures when I select an element; the data source is Excel. I’m not sure how to list the data and link to the correct elements. Anyway, thanks so much for your attention!

With respect, Win Thu,

Try with this as a starting point.

SetUDAsFromExcelExample.gh (20.2 KB)

Pic:

It will assume that you have written the id:s into “User field 3” beforehand.

It reads in all the objects from the model, and uses their id to locate the correct row from the excel data and then writes the attributes into the other UDA fields. Adjust the names as needed of course.

Good evening, Sebastian Lindholm.

Thank you for your help! I will try that script.

With respect, Win Thu.