Spline node co-ordinates into Excel?

[RTaylorLboro]

Hello,

I would like to know if it is possible to extract the co-ordinates of a 2-D spline's nodes into an Excel spreadsheet.

I have tried using Analysis>Deviation>Gauge, this produces a notepad file of the co-ordinates and some other data, but is there a way to get only the co-ordinates into Excel directly?

Thanks very much
Rich

 

[jerry1423]

What version of NX are you running?

Don't forget to specify that when asking a question, because people who come here are running versions from NX2-NX6

 

[RTaylorLboro]

sorry! It is version 5.

 

[JohnRBaker]

Some of us can still run V16 if we wanted to ;-)

No, there is no way to do this directly without the help of some custom application written in NX Open. If you only wish to do this infrequently, going the Analysis route is probably the best way to go, but if it's something that you really do need to do a regular basis, investing in some NX Open effort might be appropriate.

John R. Baker, P.E.
Product 'Evangelist'
NX Design
Siemens PLM Software Inc.
Cypress, CA

http://www.siemens.com/plm

http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.

 

[man2007]

Hi Rich,

I think this question was posted (and answered) long back in this forum only.

Here is the procedure that I had read,

1) Created point set-> spline poles
2) Select points from screen, if the order is important select them in that order only. Now MB3 the first point selected, goto Properties -> Type PT (or any string), tick on "Add index to name", give OK.
You can see the points are renamed like PT1, PT2, PT3 . . . etc
3)Goto Tools->Spreadsheet

Type PT1 in A1 (for example), PT2 in A2 and so on, to populate the column A.

Select cells B1 through D1

type = (for formula)

type POINT(A1) then Ctrl+Shift+Enter

You can see X, Y and Z coordinates in the cells B1, C1 and D1 respectively.

Similarly, you can populate the other point coordinates.

 

[RTaylorLboro]

That's great, thanks.

It would be really good to write an NX Open application for it, but there does not seem to be any method that I can record using journaling.

For the moment the create point set method works well.

On a related note, is there any way to find out the R-value identification (e.g. "HANDLE R-1485") required to refer to each spline in VB without recording a journal and inspecting it to view the code?