×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

XYZ coordinate points to Excel

XYZ coordinate points to Excel

XYZ coordinate points to Excel

(OP)
Hi

I am using NX 8.  I often have situations where I have to get XYZ coordinate points for hundreds of point locations on a model and transfer those points to an excel spread sheet.  up until now I have done it manually using "information, point" for each one  and then I enter it manually into Excel.   the points I am taking are actual UG points i have entered in on a special layer when i was creating features.... like it is the point on a curved surface where a hole originates.   I know I can do all the points at once and get a large listing that I can sort in excel but that does not allow me to determine how to put the points in an order we desire as decided by the customer.   

Ideally I would like to select the point in UG and see the XYZ points appear in my spreadsheet in 3 columns right at the time I selected it and maybe without extra commands like copy and past etc.   

I appreciate your ideas.
thank you

RE: XYZ coordinate points to Excel

This thread might provide you with some help:

http://www.eng-tips.com/viewthread.cfm?qid=314774

If that doesn't help, it wouldn't take much to whip-up a cheap and dirty program which would at least take the 3D coordinates of selected point and write the data to formatted text file which could then be loaded into an Excel spreadsheet.

Do you have a GRIP execute license?  

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
UG/NX Museum:   http://www.plmworld.org/p/cm/ld/fid=209

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

RE: XYZ coordinate points to Excel

It seems that I've already written a GRIP program to do just that (attacehd below, just edit the extension from .zipper to .zip before extracting the files), so if you've got a GRIP execute license, you're in business (read the description of the program in the .grs file for instructions on how to use it).

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
UG/NX Museum:   http://www.plmworld.org/p/cm/ld/fid=209

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

RE: XYZ coordinate points to Excel

(OP)
John,

Thanks so much for your help and interest...!!    so you know...I have never "programmed" macros in UG and unsure how to "load it in"....   my last prgramming was fortran back in school......way long ago.....  I will seek some help here at my office and look to see if you offer any more advice...... I noticed you work for siemens and want to mention that UG is the best program around and I have recommended it  here where I work....which resulted in 2 new stations and also recommended it to another company who ended up getting 4 seats.....   so I appreciate your getting back to me ....
thanks again..!!   
Vince

RE: XYZ coordinate points to Excel

To run the grip program go to File -> Execute -> Grip... then navigate to the .grx file and press OK. If this is something you will be using frequently, you can add a custom item to your menu or toolbar to act as a shortcut.

www.nxjournaling.com

RE: XYZ coordinate points to Excel

Or press CTRL+G

Best regards,

Michaël.

NX7.5.4.4 + TC Unified 8.3
Win 7 64 bit

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources