×
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

SE BOM

SE BOM

(OP)
Hello, with Solid Edge V19 I want to generate a report for an asm file. Is there a way to have it structured in the following way:

asm_father asm_son field1 field2 ....
asm_father par_son field1 field2 ...

I want to copy the resulting report into a excel file where I need to have a structured BOM.

Thanks,
Stefano

RE: SE BOM

Run your report from the top level assembly file.  You can customize the output of the report from there.

I recommend you then copy and paste into Excel.  For some reason, the formatting comes out better with a cut-n-paste than it does with saving as a text file and importing into Excel.

--Scott

http://wertel.eng.pro

RE: SE BOM

You have 4 choices for running assy reports, you may have to play around with which most closely matches what you need.  You can customize them using format dialogue.  I'm not sure any of them will do exactly what you need but you may be able to get it close enough to then manipulate in excel.  You used to be able to save a format of report but I can't remember how any more.

You don't even have to open the assy in SE, you can navigate to it in Windows Explorer, right click and you should have the reports option.

However, for once I may know something Swertel doesn't-

Once you've run your report set up to save as a text file but - before you hit save change the file name extension to .xls.

It will then save it as an excel file.  The first time you open this file and save it it will get confused as it thinks it's a text file (I haven't done if for a while I think you have to manually overright the existing file or something) but from then on it works fine.

 

KENAT, probably the least qualified checker you'll ever meet...

RE: SE BOM

KENAT, you're a much better checker than me.  I get all caught up doing the tolerance stack-up analysis and typo errors when I check that I miss the big picture.  "You can't even machine that" has passed by my desk as a checker.  (Thankfully, not when they are my designs.)

I wasn't award of the report option being available on the right click menu of Windows Explorer.  Awesome.  But I just tried it with a Family of Assemblies and it has a bit of limited functionality.  I'm not going to take the time to verify right-click limitation or because it is an FoA, though.

The first dialog in the reports defines the general layout of the components: each part listed once with total quantities, each part listed underneath its parent regardless of number of instances it appears (so you may have 20 branches in the BOM with the same info if a subassembly was placed 20 times), or just a list of parts.

Clicking on Format brings up more layout options in terms of how the actual spreadsheet looks.  Click on Options to add or remove columns.

I left my first answer short because I can't quite picture your desired end result.  Hopefully KENAT's reply and mine will get you into the right direction.

--Scott

http://wertel.eng.pro

RE: SE BOM

It's the saving as xls even though it says it's a text file that I think's clever.  I can't take credit - an intern thought it up.

KENAT, probably the least qualified checker you'll ever meet...

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