Input Node coordinates from excel

[skellyRSA2023]

Hi,

is there anyway of exporting node co-ordinates from excel to robot, x y z, so as the node coordinates are generated in one collective input rather having to type them in individually in robot? As i find it tedious having to do all these individually, and its an easier way of defining model in robot as there are less errors in model when you just connect the dots so to speak.

simon. 

[Artur.Kosakowski]

Hi @skellyRSA2023 

You can do so with the limitation being that the their numbering will be done automatically by RSA (you select and copy coordinates only). If you need to keep node numbers as defined by you then you need to use API or text (*.str) file instead.

If I managed to answer your question(s) press the Accept as Solution button please. This will help other users to find solution(s) much faster. Thank you.

[skellyRSA2023]

Artur,

thanks. I am not to worries about robot numbering them. When you say "select and copy coordinates only" where and how is this done? From excel?

simon. 

[Artur.Kosakowski · Accepted solution]

Hi @skellyRSA2023 

Yes, you create 3 columns with X, y and Z coordinates respectively in Excel and then you select these numbers and paste them into the Nodes table Edit tab.

If I managed to answer your question(s) press the Accept as Solution button please. This will help other users to find solution(s) much faster. Thank you.

[Rafal.Gaweda]

Hi @skellyRSA2023 

See webinar 6, video on slide 32

https://forums.autodesk.com/t5/robot-structural-analysis-forum/robot-structural-analysis-webinars/td...

[skellyRSA2023]

Brilliant, Thanks both of you!