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
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
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 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
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
KENAT, probably the least qualified checker you'll ever meet...