create ucs with ilogic out of excell parameters

[kim.vervliet]

Hi,

I am working on a workflow dynamo to inventor. Idea is to bring in the data by excel for creating an up to date connection.

Currently i want to generate several UCS's by ilogic according to imported parameters ( i brought in the final position and rotations  as parameters in inventor).

I am not that skilled in i-logic and VB, so if anybody could set me in the correct direction, it would be a great help.

thanks,

Kim

[johnsonshiue]

Hi! You might need to use VBA code in iLogic rule. Inventor API/Programming help has a sample code creating a 3-point UCS. You can copy and paste VBA code to an iLogic rule. Please take a look.

https://knowledge.autodesk.com/search-result/caas/CloudHelp/cloudhelp/2018/ENU/Inventor-API/files/Us...

Many thanks!

[kim.vervliet]

hi,

thanks, for the reply

I ran the script and i mentioned that he is creating this on a "new" part Level. What i would like to have is several ucs's in one assembly or part, according to excell data. I was able to place some points with help of the following post, but then i only have points and still need to redefine the ucs's according to these points.

Would it be possible to create ucs by ilogic, on a method like ' for this parameter - go to this column '. And this up to the point that excel is running out of data.

https://forums.autodesk.com/t5/inventor-forum/3d-point-in-space-linked-to-excel/m-p/2971890?_ga=2.67...

kr

kim