×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Bills of Material trouble again :-(

Bills of Material trouble again :-(

Bills of Material trouble again :-(

(OP)
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

RE: Bills of Material trouble again :-(

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.

RE: Bills of Material trouble again :-(

(OP)
Hi DSI,

Can you send me this program???

Thank you,
Rodrigo Basniak

RE: Bills of Material trouble again :-(

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.

RE: Bills of Material trouble again :-(

(OP)
Ok... no problem dsi... I think I have to stay using the DWG file...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources