Displaying part family spreadsheet data on the non-master drawing
Displaying part family spreadsheet data on the non-master drawing
(OP)
Greetings all!
I know this is an old question, but I didn’t find any solid answer so far.
If I have a part family and want to put data from it in the table on a drawing, I have no problem if drawing is located in the same part as the model. But if it is a non-master drawing, I there is a problem: NX won’t allow access to the part family spreadsheet of the component.
Is there a way around?
I know this is an old question, but I didn’t find any solid answer so far.
If I have a part family and want to put data from it in the table on a drawing, I have no problem if drawing is located in the same part as the model. But if it is a non-master drawing, I there is a problem: NX won’t allow access to the part family spreadsheet of the component.
Is there a way around?





RE: Displaying part family spreadsheet data on the non-master drawing
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: Displaying part family spreadsheet data on the non-master drawing
It works if the drawing is in the same part.
It does not when drawing is non-master.
Is there a way to make it work?
RE: Displaying part family spreadsheet data on the non-master drawing
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: Displaying part family spreadsheet data on the non-master drawing
This is a simple test file. The task is to create the similar drawing in the 'Part family drawing.prt' as already exists in the 'Part family.prt' (which is the part family master file), automatically.
I could not do this so far. Can this be done at all? Is there a technique? Am I missing some crucial step? If you could help me, I'd be very grateful!
RE: Displaying part family spreadsheet data on the non-master drawing
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: Displaying part family spreadsheet data on the non-master drawing
But, in a word, I followed NX own help file.
Did I do anything wrong, or at least, in a weird way?
In this case, what is the correct way to fill the tabular note on a drawing with part family data?
RE: Displaying part family spreadsheet data on the non-master drawing
BTW, whatever you did (and this is why I've questioned the method you used) while you might think you've linked the Tabular Note to the Part Family spreadsheet, that's not actually the case. If I edit the Part Family Spreadsheet in your part file, those changes never make it to your Tabular Note.
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: Displaying part family spreadsheet data on the non-master drawing
No need to describe how I import part family spreadsheet into a tabular not in my own words, because I strictly follow the NX help entry entitled 'Import a part family spreadsheet'.
To import a family table spreadsheet into a tabular note:
1.On the Table toolbar, click Tabular Note or choose Insert→Table→Tabular Note
2.Click to place the tabular note at the desired location
3.Select the top most empty cell of the tabular note.
4.Right-click and choose Import→Spreadsheet.
5.In the Import Spreadsheet dialog box, from the Spreadsheet list, select Family Table.
6.Select the appropriate Sheet or Range options.
7.Click OK or Apply.
The resulting table retains some associativity with the part family spreadsheet. If I edit the values within it, the changes are reflected on the drawing as well. But if I add lines, they are not added on the drawing version of table.
So the questions are:
Is this a correct way to show part family table of the drawing?
Is there other way to associatively display part family table?
Is there way to associatively display part family table on the non-master drawing (part family master as a component)?
RE: Displaying part family spreadsheet data on the non-master drawing
So to your last three questions, the answers are:
1) Yes
2) Not that I'm aware of.
3) NO
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: Displaying part family spreadsheet data on the non-master drawing
Feel free to list 1) and 2) as an enhancement request. That's much needed.
RE: Displaying part family spreadsheet data on the non-master drawing
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: Displaying part family spreadsheet data on the non-master drawing
#1 Works, but it's not fully associative.
It does not add new lines on the drawing, when they are added to the part family.
So I'd say that #1 needs to be improved.
RE: Displaying part family spreadsheet data on the non-master drawing
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: Displaying part family spreadsheet data on the non-master drawing
Drew
RE: Displaying part family spreadsheet data on the non-master drawing
Very interesting idea indeed!
I'll definitely give it a try.