×
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

Export BOM

Export BOM

Export BOM

(OP)
Is it possible to export the BOM or indented Product assembly structure from NX to a CSV or Excel file, with part names and part numbers?

RE: Export BOM

Have you tried Tools > Assembly Navigator > Export to Spreadsheet?  It will kick out the NAV. info to Excel for whatever columns you have active in the NAV.  It will insert blank spaces in front of the info in each cell to represent the tree structure.

RE: Export BOM

kevklem
I did an export to spreadsheet. It worked. But I do not see the assembly tree structure. It is all lined up.
I am in NX 2.0.2.2

Thank You

RE: Export BOM

Yes, that is how it will come out. There is no indentation of the product structure levels.

"Wildfires are dangerous, hard to control, and economically catastrophic."

Ben Loosli
Sr IS Technologist
L-3 Communications

RE: Export BOM

If you use the BOM in drafting you can export that to excel..

1. create the BOM
2. on the top left corner of the BOM right click and select exprt. This will bring up a dialog box click on file give it a name and location and click apply.
3. Open excel
4. In excel   data->import external data->import data-> select the file you created from UG

then you will get a new dialog box that comes up and shows your info before you place it in cells. You can adjust the cell width here to make your data fit in the cells.


Hope this helps

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