BOM FROM ASSEMBLY 1

[mdossaji]

I want to create a customized BOM on spreadsheet from an assebmly. If anybody is familiar with proe, there is a BOM icon that allows you to generate a file that can be edited using word. Can it be done as such in SW?

 

[Mandrake22]

Solidworks has two BOM choices; a native version and one using MS Excel. When using the Excel version, it can be saved as an Excel file which then can be used for any purpose.

 

[eranz]

The native version can be saves as .csv or .txt and then edited in Excel, Word or other applications

 

[mdossaji]

But how do you generate that file from the assembly mode?

 

[SBaugh]

You can't add a BOM at the assembly. You have to add the BOM in a drawing, after the assembly is placed in there.

Regards,

Scott Baugh, CSWP

http://www.3dvisiontech.com

http://www.scottjbaugh.com

If you are in the SW Forum Check out the FAQ section

To make the Best of Eng-Tips Forums FAQ731-376

 

[mdossaji]

I would think that SW should add this as an enhancement. Most of the engineers at our plant do not create drawings we just issue BOM and models. Our drafting takes care of drawings.

 

[SBaugh]

Your one of the few that does this. Most everyone Ihave ever spoke too always wants this to be taken care of in the Drawing and that the drawing side of SW needs improvement. Which is were SW05 comes in ot play this year.

Your request will have to be placed in as an ER (Enhancement Request) at

http://www.solidworks.com

A away around it be to put the assembly into a drawing produce a BOM. Export that BOM as a .csv, .txt or if you use the Excel based BOM, a .xls file. Then you can close the drawing and go back to the assemlby. Then insert that BOM into your model via, Insert\Object.

It will not be linked to your assembly, but all the data from the BOM that you exported from the drawing file will be there.

Regards,

Scott Baugh, CSWP

http://www.3dvisiontech.com

http://www.scottjbaugh.com

If you are in the SW Forum Check out the FAQ section

To make the Best of Eng-Tips Forums FAQ731-376

 

[TheTick]

<

http://webpages.charter.net/mkikstra/SolidWorks.html>

"AssemblyBOM" macro

 

[Bouke]

FYI: I think (i'm not at the office so can't check) you can''t just save the bom but you'll have RMB on the BOM and select save as template or something like that.

 

[SBaugh]

Yes you can but you can't do it in a direct assembly file. That Macro seems to have worked around the issue.

Never under estimate the power of API.

Regards,

Scott Baugh, CSWP

http://www.3dvisiontech.com

http://www.scottjbaugh.com

If you are in the SW Forum Check out the FAQ section

To make the Best of Eng-Tips Forums FAQ731-376

 

[mdossaji]

Tick,

Can the macro be setup to where it reports the BOM as it is assembled. Currently it displays from lower to higher numerical value part numbers.

 

[TheTick]

I'm sure it can. It's not my macro or my site.