Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bills of Material trouble again :-(

Status
Not open for further replies.

RBasniak

Mechanical
Sep 19, 2001
59
Hello,

I have a assembly in SW but it's a big assembly, more than 300 unique parts and now the BOM is big like the assembly :-( Here, we usually put the final BOM in a sheet and then print it... Now my BOM has more than 5 pages and I can't break the Excel spreadsheet that I insert in the sheet. The question is "How can I print it??" If I could save that I can open in the Excel and I wouldn't have any problem... and I can save, but some of my BOM'fields have links to dimensions of SW, and when I save the spreadsheet to an XLS file the cells come like this "SW-Mass@3109-01-00.SLDPRT", Excel don't read the values...
Does anyone have a problem like this? What did you do to resolve that?

I'd ask something like that before, but the discussion was finished because I said that I could export the sheet to a DWG file, there the BOM apears correctly, but it's too unproductive :( And there are many chaces to make an error...

Thansk for all help,
Rodrigo Basniak :)
Curitiba, PR
Brazil
 
Replies continue below

Recommended for you

They have fixed this problem with the latest release of SolidWorks (SP 9). When you save or open the BOM in Excel, you will now see exactly what you see on the embedded BOM. I wrote a program that extracted the BOM to a separate Excel file, converting linked dimensions and weights. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
 
Hi DSI,

Can you send me this program???

Thank you,
Rodrigo Basniak
 
I wish I could! Unfortunately, I wrote this program for one of our clients, who maintains it as a proprietary application. I would have to write another program from scratch. While this is not terribly difficult, it would take a significant chunk of time. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
 
Ok... no problem dsi... I think I have to stay using the DWG file... :-(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor