SE BOM

[stefanob]

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

 

[swertel]

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

 

[KENAT]

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

 

[swertel]

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

 

[KENAT]

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