Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating an excel BOM from the Attributes of the Component Properties 1

Status
Not open for further replies.

JVisger

Automotive
Joined
May 7, 2015
Messages
4
Location
US
How can I export an excel BOM of Attributes of the Component Properties?
 
You can create a Drawing Parts List and then Export that using any one of several common formatting schemes, such as a text file with comma delimited columns, which would then be easy to load into a spreadsheet.

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

To an Engineer, the glass is twice as big as it needs to be.
 
Set up a parts list or the assembly navigator with the information that you need, then you can right click on it and use "export to spreadsheet".

www.nxjournaling.com
 
Thanks for the help so far. I have attached a file showing what has been done and what are goal is for an excel BOM
 
Please note that you can now edit (as well as delete), for a period of 24 hours, any of your OWN posts, so you could have gone back and added your missing attachment. After posting a response and you discover something that you wish to correct, just look for the 'Edit' and 'Delete' options in the lower Right corner of your post, as shown below:

Edit_Post_Option_Eng-Tips_erksix.png


Note that this is a new feature added to Eng-Tips in the past week or so. But note that there will be a 'paper trail' showing what it is that you edited so you can't use this tool to 'rewrite history' as it were.

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

To an Engineer, the glass is twice as big as it needs to be.
 
There is another way, you may call it 'quick and dirty'. I am not in front of my NX at the moment and can't give you the detailed description, but basically you can add custom columns to the Assembly Navigator that would show the needed attributes, and then right-ckick the header bad of the Assembly Navigator and choose 'Export to Spreadsheet'.

 
PrintScaffold - Thanks for the info. This will work for our needs.
 
I'm not aware of an explicit option to Export the contents of the Parts List note to a Spreadsheet. Rather the Export option is as I described it in my first response in this thread on 7 May.

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

To an Engineer, the glass is twice as big as it needs to be.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top