Exporting a BOM without needing to open up my whole assembly.

Hey,

I'm new to Solidworks and I have a question that I hope can be answered. I hope that this is in the proper discussion thread. If not I can move it.

I have an assemby (about 2000 parts) that has been getting put together for a while. We are now moving into building an inventory system that will keep track of the manufacturing. Within this assembly I have a configuration entited "Hardware." This configuration just shows hardware such as nuts and bolts. I know I can export a BOM to my inventory system but I really don't want to have to open up my huge "Hardware" assembly and make a new BOM everytime I add a new part or someone else does. I know I could just add it into my inventory system but I really think there must be a better way. Is there a way that I can "ask" Solidworks to spit out an updated list (at any given point in time) in an order simular to below?

Assembly

     Sub-Assembly 1

          Part A               Quantity: X

          Part B               Quantity: Y

          .                       .

          .                       .

          .                       .

     Sub-Assembly 2

          Part A               Quantity: X

          Part B               Quantity: Y

          .                       .

          .                       .

     Sub-Assembly 3

          Part A               Quantity: X

          Part B               Quantity: Y

          .                       .

          .                       .

          .                       .

     And so on...

Basically I am wanting a list of the quantity of a certain part used within a given assembly. A given part may be used within more than one assembly.

For the inventory system I am needed to specify the total quantity of a given part within the whole assembly but also in what assembly it is coming from.

If it helps, each part within the "Hardware" configuration has a "hardware" part property within the custom part property.

This maybe a completely dumb question and I'm sorry if it is but I'm really new to Solidworks so I am still learning how this program works.

Thanks for any help!

SolidworksImport export
Answers 9
SF
SF 2012-05-25 Best Answer

David,

You might want to post this in both the BOM and the API forums. I suspect that the guys in the API forum are going to be the most likely to come up with a solution.

Jerry Steiger

SF
SF 2012-05-25

Jerry,

Thanks for the advice. Will do!

David

SF
SF 2012-06-20

*bump*

I am having a similar problem. I'm working on the production side in my company and we're trying to pull the BOM straight out of SolidWorks to a database in SQL automatically, periodically. If we could get the BOM to automatically export in excel form, I can code my database to pick it up automatically.

Long story short: Does anyone know how to get a SolidWorks BOM to automatically, periodically export from a drawing or assembly file into an excel file or SQL format?

SF
SF 2012-06-25

Thanks for your help. Is there a way to modify that code so that I can grab the BoM from a assembly file and specify which property goes into which column in the excel?

SF
SF 2012-06-25

By the way, the code did work in its intended way.

SF
SF 2012-06-25

I've gotten it so that I can export custom properties information from the assembly but the information is about the assembly instead of the parts inside of the assembly. How can I make the VBA code scrolls through the parts in the assembly and puts down their property information as well as the quantity of each part type in the assembly?

SF
SF 2012-06-25

Thomas,

I'll give you the same advice I gave the original poster. Try posting your question in the API forum. The folks who hang out there are going to be the ones who can answer your questions.

Jerry Steiger

DG
DG 2012-06-25

I believe yes but not sure about it at the moment. I even can't do any testing as my machine is still under break down