Does anybody can help to solve one issue:
we need to export BOM from Solidworks Assembly to SQL database the same structure as it is in Design.
If more information is needed please let me know!
How we can do it?
Best regards, Pavel.
Hi Pavel, the best way to do this is by writing a macro. This macro can then be linked to a button in one of your toolbars.
What version of SQL is it? If you can provide information on the database (name, type, table and fields to populate) I can write some sample code for you.
We’re using Microsoft SQL Server 2005 Standard.
Database solution is from INFLOW (www.inflowinventory.com)
Database name is inFlow
Table structure, where we need to populate the hierarchical BOM data:
[ItemBomId] [int] IDENTITY(100,1) NOT NULL,
[Quantity] [decimal](18, 4) NOT NULL,
[QuantityUom] [nvarchar](10) NOT NULL,
[QuantityDisplay] [decimal](18, 4) NULL,
[LastModUserId] [int] NOT NULL,
[LastModDttm] [datetime] NOT NULL,
[Version] [int] NOT NULL,
[Timestamp] [timestamp] NOT NULL,
[ProdId] [int] NOT NULL,
[ChildProdId] [int] NOT NULL)
We have defined products in inflow system. Each product has an unique ID code (in the table above the field “ProdId”).
When we create BOM, we need to associate one ProdId with
For each “ProdId” we can have different amount of other products stored in “ChildProdId” field.
Quantity:as defined in drawing/assembly
Other fields not so important
In the example above I have defined an item BOM with master product (100) that has 2 child products (110, 1234)
What type of bom are you using (Excel based or Solidworks)?
Will there always be only one bom in the assembly or have a fixed name?
Where is the ProdId coming from? Is it supposed to be auto-incremental? I'm assuming this number should be linked to something, but I'm not understanding what.
I'm no programming Guru...but I will certainly try my best to help you out.
At this moment we are using Excel-based BOM but we prefer to use BOM from Solidwroks directly using design tree.
There will be only one BOM.
ProdID is a special number what is generated by InFlow Database to every position but we are working with "Item Name/Code" which we generate from numbers 1XXXXXX, 2XXXXXX, 3XXXXXX, 4XXXXXX, 5XXXXXX and 6XXXXXX with step 1 incrementation, so these ProdID are connected to "Item Name/Code" like ProdID 101 has "Item Name/Code" 5001244
Pavel, did you figure out how to do this?
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?
There are a lot of different ways to go about what you guys are trying to do. There are some applications out there, but they never seem to completly satisfy the customer. There is usually some business logic or other automation that makes these programs useless. If is is something that you'd seriously like to accomplish, I'd be willing to work on this for you by creating custom applications or macros for you.
I'd appreciate any help you could give! I'm trying to export a BoM automatically, periodically from an assembly or drawing into an excel file. The BoM that we need pulled out of the assembly or drawing file will be different than any assembly or drawing file that we have present there, but I know exactly what properties we need from every part.
I know I'm late I have not been on the forms for a long time but I saw your post
I have an Addin that take SW BOM to SQL2005 database
if you still need help let me know and I can send you part of code to help out and also share issue and thing i done to get past them like patterns and surpressed parts
what we have in the back end is multiple table
a table that has part and configure with mass properties and material and some custom prosperities
a assembly has Parent ID ,ChildID ,qty ,& Buy/Make
we also have a material table with the cost and density this way we get a cost pre part or layout
I have been working off and on now for five years so i got a lot of know-how in this
Retrieving data ...