I-Deas parts List to NX to Excel 2

[SDETERS]

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

 

[JohnRBaker]

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.

 

[SDETERS]

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?.

 

[cowski]

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

 

[jdhoelscher1]

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.

 

[cowski]

Try this journal:

https://dl.dropboxusercontent.com/u/80688373/DumbNotesToExcel.vb

It will allow you to select notes and try to figure out the table positions and finally write them to an Excel sheet.

It's a bit rough, let me know if you find bugs...

www.nxjournaling.com

 

[SDETERS]

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.

 

[cowski]

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