×
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

I-Deas parts List to NX to Excel
2

I-Deas parts List to NX to Excel

I-Deas parts List to NX to Excel

(OP)
We have converted a file from I-Deas to NX that contains just text that has lines sketched around it. I would like to be able to select all of this text at once and paste it into Excel. When I select all the text I am not able to paste this information into Excel. If I have to select every line one by one this will take forever. I would Like to get this information into a Table format with little to no editing. I have attached a small screen shot of what the data looks like in NX.

Thanks

RE: I-Deas parts List to NX to Excel

It might be possible to create a simple program which could convert the selected text into a tab-delimited text file which could then be imported into Excel.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

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

RE: I-Deas parts List to NX to Excel

(OP)
thanks John We have a program started. We are having issues sorting the notes into cells in the correct position. Any Ideas on how this could be done?.

RE: I-Deas parts List to NX to Excel

What do you have so far? I'd try adding the note information to a datatable (note text, Y position, X position, etc), then sort the table by Y position, X position. This should order your notes by row/column no matter the pick order.

www.nxjournaling.com

RE: I-Deas parts List to NX to Excel

cowski,

This is what we have. You select all the notes, grab the object information, and copy and paste into excel. Then run the macro that places the Text Strings, XC and YC coordinates onto sheet 2. This is as far as I got. Since the text doesn't line up, nor does the notes appear in the selected order (left to right, top to bottom, 1,2,3,4,), I was going to export the curve information and use this to develop intersections to place the values into cells.

RE: I-Deas parts List to NX to Excel

(OP)
I had issues trying to Select the note. When I created an original note in NX it would let me select. But when I try to select the notes that was CMM from I-Deas within the program it will not select them. Also I can change the filter without being in the program and it will see the I-Deas CMM notes as notes.


RE: I-Deas parts List to NX to Excel

I updated the journal at the above link to use the 'all_subtype' for the note selection. Please download it again and give it a try. If it still does not work, can you post a small example file with a few of these note objects (or email it to me at info@nxjournaling.com)?

www.nxjournaling.com

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