Feature for linking coordinates x, y, z with an Excel spreadsheet

[Frodl]

With the function "points" can work points are imported from an Excel spreadsheet with coordinates in a 2D or 3D sketch. It can be connected by lines or a spline points immediately.
However, the points can not be updated. That is, when the coordinates are changed in the Excel table, the imported points do not fit.

It should be possible, to link a table of coordinates x, y, z (3D Sketch) or x, y (2D Sketch), so that changes at the coordinates in the table, the points are automatically updated in the sketch.

There is a tool called "Link Points", which enables linking a Exel table (with coordinates) with a sketch. However, all of the points (and existing lines or splines) are deleted with this tool during an upgrade and the points will be re-imported. This go all dependencies lost.

 

[karthur1]

Does the "Cool Orange Point Linker" app not do exactly what you are asking for?  I think with the new build (16.0.31.0) you should be able to update the points.

Kirk

[Frodl]

Hi Kirk,

the "Cool Orange Point Linker" app can update the points. But while updating alle points will be erased and reinserted. The points will be updated one by one. The lines or spline will be re-created.

Through this process go any dependencies lost , for example, from planes and sketches.

The points shuold be updatetd without loosing all dependencies.

[Anonymous]

Is this "Cool Orange Point Linker" work with Inventor 2014?

Thanks

[Frodl]

I dont know. But you can try it.

I think it will work also with IV2014.

[Frodl]

I have seen in my old documents that Point Linker already existed for Inventor 2009.

[Gajus61]

I want to revive this proposal made by "Frodl" several years ago.

The linked Excel shall handle one spline/polyline/NumberOfPoints only. It should only be possible to control this object from the Excel table but NOT to change or extend it manually. Addionally there shall be the possibility making more than one linked table in one or several 3D-sketches.

[Frodl]

Have a look on this:
https://forums.autodesk.com/t5/inventor-ideas/feature-for-linking-coordinates-x-y-z-with-an-excel-sp...

https://forums.autodesk.com/t5/inventor-ideas/work-points-using-x-y-and-z-coordinates/idi-p/7728928

[Frodl]

Hi,

it would be great if a new kind of working points were created that were given a parameter in the parameter list, for example AP_x, AP_y and AP_z.

These working points could then be easily modified.

So far, we have solved this by assigning three dimensions between the working point to the three planes xy, xz, zy for each working point and thus defining the coordinates x, y and z.

However, this method is very complex.

It would be easier if these parameters were automatically created for an operating point.

We use the coordinates in iParts to create different variants.

[Frodl]

Hello,

meanwhile I think it's a much better idea if a new kind of working points were created that were given a parameter in the parameter list, for example AP1_x, AP1_y and AP1_z; AP2_x, AP2_y and AP2_z; AP3_x, AP3_y and AP3_z and so on.

These working points could then be easily modified in the parameter list.

So far, we have solved this by assigning three dimensions between the working point to the three planes xy, xz, zy for each working point and thus defining the coordinates x, y and z.

However, this method is very complex.

It would be easier if these parameters were automatically created for an operating point.

We use the coordinates in iParts to create different variants.

See also this idea:

Feature for linking coordinates x, y, z with an Excel spreadsheet - Autodesk Community

Hallo,

Mittlerweile halte ich es für eine viel bessere Idee, wenn eine neue Art von Arbeitspunkten erstellt würde, denen in der Parameterliste ein Parameter zugewiesen wird, zum Beispiel AP1_x, AP1_y and AP1_z; AP2_x, AP2_y and AP2_z; AP3_x, AP3_y and AP3_z usw.

Diese Arbeitspunkte könnten dann leicht in der Parameterliste geändert werden.

Bisher haben wir dies dadurch gelöst, dass wir jedem Arbeitspunkt drei Dimensionen zwischen dem Arbeitspunkt und den drei Ebenen xy, xz, zy zuordnen und so die Koordinaten x, y und z festlegen.

Allerdings ist diese Methode sehr aufwendig.

Einfacher wäre es, wenn diese Parameter automatisch für einen Betriebspunkt erstellt würden.

Wir nutzen die Koordinaten in iParts, um verschiedene Varianten zu erstellen.

[Yijiang.Cai]

Many thanks for posting the idea, and tracked as [INVGEN-74613]

[Yijiang.Cai]

Many thanks for posting the idea, and tracked as [INVGEN-74613]

[Frodl]

Hi,

that's grate. Thank you.
If you want to have some more information, then we can talk about this. I can also send you some example files for a better understanding.

[Frodl]

@Yijiang.Cai 

Given the increasing importance of Building Information Modelling (BIM) and Geographic Information System (GIS), the ability to model and work with coordinates in Inventor is becoming increasingly important.

It would be important and great if you could take this idea and implement it.

Thank you.