×
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

HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

(OP)
Quote from http://www.d-digest.com/soliddigitaldigest/SDDArchive/V2I28SDD.html#T&T
----
A common misconception is that SolidWorks cannot link a custom property to a BOM balloon. Follow the instructions below to amaze your friends and co-workers by easily accomplishing the impossible.
*)Create a custom property named Detail_No in a component used in an assembly; use the underscore.
*)Create a BOM template with a new column titled Detail No. (No underscore is needed.)
*)Before saving the BOM template, go to the Insert menu, choose the Name option and select Define. If these menu items are grayed out, click out of the column header cell and then back into it. (Microsoft. Go figure.)
*)A box will come up with Detail_No in the Text box. Excel adds the underscore by itself. Press OK. Save the BOM template with a new name.
*)Insert this BOM into an assembly drawing. Make sure "Row numbers follow assembly ordering" is turned off in the control tab of the Bill of Material Properties window. You can't change item numbers if this is on.
*)Double-click on the BOM and select the first item number cell, A2. Type in an equal sign (=) and then click on the first cell in the Detail No column. Your item number column is now equal to your detail number column and your balloon is equal to your item number. Hide the Detail No column.
*)Rearrange the components in your assembly FeatureManager tree to get the correct detail number order. Sorting will work if you export the BOM into Excel. Sorting in SolidWorks does not work as well.
You now can have the same detail number (or a different one if you prefer) in drawing views of different configurations. This works as of SolidWorks 2001+ SP2; it has not been tested in SP3. -- Submitted by John D. Ayer, FISHER Unitech, Troy, Mich.

Editor's note: Check out John Ayer's nifty solution using VBA to batch process SolidWorks files in the July/August 2002 issue of SOLID Solutions magazine, which mails Tuesday, June 24.
---
BR,
Linqur

RE: HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

(OP)
OK

Linqur

RE: HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

Correct me if I got it wrong. By using above method we can change item No in assy by

1 adding required value to part custom property Detail No
or
2 change value in BOM in Excel column Detail_No

Using "1" is time consuming but it can be used later for pulling Detail No in single detail dwg.
Option "2" will not work in detailing.
Is that correct assumption?

Best Regards,
Bogdan

RE: HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

Will this work with SW2005?

RE: HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

Are you using an Excel BOM? If so, then the best way is to try it out.

Regards,

Scott Baugh, CSWP
www.scottjbaugh.com
FAQ731-376

RE: HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

Which is the better to use? Excell Base BOM or Table BOM from SW?  

I am asking as I have recently been assigned the tack of creating a working BOM we can add you drawings as well as export for use elswhere.

RE: HOW TO LINK A DETAIL NUMBER CUSTOM PROPERTY TO A BOM BALLOON

You can export either BOM's the same way. You really need to test each way to determine what is right for you. I prefer the SW BOM over the Excel, but others will disagree. It's up to the user and what you need the BOM to do.

Regards,

Scott Baugh, CSWP
www.scottjbaugh.com
FAQ731-376

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