×
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

BOM QUANTIY EXTRACTION

BOM QUANTIY EXTRACTION

BOM QUANTIY EXTRACTION

(OP)
Does anyone have a macro to extract the quatity of parts in an assembly or from a bom and have it update the file properties?

Thanks.

RE: BOM QUANTIY EXTRACTION

CADMiester

If I understand you correctly.  You could use Custom Properties for this issue?  You can create new ones if required.  Hope this helps.

Cheers,

Ralph Wright, CSWP
SolidWorks 2005, SP5.0
P4, 2.53Ghz
1.5 Gb RAM
ATI Fire GL8800 Card
Windows 2000 Pro

RE: BOM QUANTIY EXTRACTION

explain what you are doing please? I don't understand why you would want the info from the BOM QTY or assembly to update the file properties... besides what file properties do you want to update (assembly, part, drawing)?

Regards,

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

RE: BOM QUANTIY EXTRACTION

I assume he's already talking about custom properties.  We have a custom property on our part files for quantity.  It's linked to a note in the title block on our parts drawing template.  I think CADmiester is looking for a macro that would read the BOM on an assembly drawing and update the custom property field with the quantity from the BOM.  Of course, unless he is using no standard parts (nuts, bolts, etc.) and has no common parts across different jobs/machines/products, he'll probably want to be able to skip certain files.  This should be an easy enough macro to write.  I've already got one that accesses the text in the BOM, but it only reads it as text in a dumb table, by rows and columns.  I'm not at work right now, but I would imagine that there's a way to find the part/subassembly file bound to a row of the BOM through the API.  

Cadmiester, what is your familiarity with VBA?  Would a good starting point and a few pointers get you to where you can figure it out, or are you needing a plug-and-play solution?    

It sounds to me like you need this functionality for assemblies with more than a few parts.  However, if I'm wrong and you only care about a few critical parts then FAQ559-1232 may be able to help you some.

Have a great day!

RE: BOM QUANTIY EXTRACTION

CADMiester - if you can read German as your handle suggests, go to http://solidworks.cad.de/mm_boerse.htm.  I started with the code in item 05 and have built a tool that goes through our assemblies, counts parts, updates custom properties, and more.  The sky is the limit with the SW API.  We do not use drawing BOM's to get lists for projects, we always scan the model.  Good luck!

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