Contact US

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!

*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

AutoCAD BOM Conversion

AutoCAD BOM Conversion

AutoCAD BOM Conversion

We are currently using AutoCAD 2004 as our 2D software. Our BOMs are just pieces of "dtext" for the different attributes (Material/Quantity/Description) within a grid of lines to represent a table all within the AutoCAD drawing. (Hopefully that wasn't a confusing description. I can provide an example if needed.)

In order to work with our new ERP system, we are looking to move forward to a "smarter" BOM as the newer versions of AutoCAD seem to have where the each line of the BOM is a block that contains attributes for each column. Then those attributes can be extracted to an excel spreadsheet or directly into an ERP system.

If we were to upgrade to a newer version of AutoCAD that uses "smart" BOMs, can be convert our old BOMs into the newer style? or would we have to retype all of the information back in?

If we chose not to upgrade AutoCAD, can we extract our old BOM style into an excel spreadsheet?

Thanks for the help,


Kadant Carmanah Design
Vancouver, BC

RE: AutoCAD BOM Conversion

Not without some really creative scripting and the hope-and-prayer that there is /some/ consistency from BOM to BOM so that automation is even possible.

The best I figure you can do is create a scripted command, LISP routine, or some such thing that will expedite manual conversion, reading the dtext contents, properties, and location, before creating a new attribute object with the appropriate properties set, and the text set to whatever it read from the dtext. With this, a user will still have to go through, click the right command, and select each dtext object.

Without detailed information on current examples and expected results, I don't think an answer could be given.

Intelligent objects can be made stupid. Stupid objects cannot very easily be made intelligent. It's why some CAD Managers "delete" the explode command (insomuch as that's possible).

NX8.0, Solidworks 2014, AutoCAD, Enovia V5

RE: AutoCAD BOM Conversion

Yeah that's what I figured. I think exporting the text into an Excel spreadsheet using a LISP routine is going to be our best option.

Thanks for the answer JNieman.

Kadant Carmanah Design
Vancouver, BC

RE: AutoCAD BOM Conversion

Consider removing the BOM from the drawing entirely, and maintaining it only in the ERP system.

Mike Halloran
Pembroke Pines, FL, USA

RE: AutoCAD BOM Conversion

MikeHalloran, that seems to be our number one option right now. Thanks.

Kadant Carmanah Design
Vancouver, BC

RE: AutoCAD BOM Conversion

If you're very familiar with the components in the BOM, (which I am assuming you are) you might also be able to look into DataExtraction (full release vanilla, not in LT).

You could extract the text, along with the file name, to an excel file, but that would get all the text in the drawing, which is where familiarity comes into play, as you'd sort and dump info not related. Much better would be if it was on a unique layer, you could extract text, layer, and file name, export to Excel, dump the layers that you don't need, then sort as required and manipulate from there.

(DataExtraction is something that we use all the time, that a lot of folks don't seem to be aware is built into Acad)

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! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close