AutoCAD 2013/2014/2015

AutoCAD 2013/2014/2015

Reply
Contributor
CPEProjE
Posts: 19
Registered: ‎09-09-2013
Message 1 of 5 (999 Views)
Accepted Solution

Orderly / Neatly exporting AutoCAD BOM into Excel 2013

999 Views, 4 Replies
03-12-2014 09:53 AM

Inventor Forum,

 

I have been tasked with generating a Bill of Materials from multiple PDF copies of piping spools similar to below:

 

SampleSpool.png

 

So my question, "Is there a way to export the Bill of Materials of an AutoCAD 2014 drawing ORDERLY/NEATLY into Microsoft Excel?"  I do have access to the *.dwg files but ACAD 2014 doesn't seem to have the features needed for me to export out to Excel 2013.

 

Because having to do this manually over 80+ pages is just not a good use of time and our designer's haven't figured out how to do this for us.

 

I am not trained in AutoCAD beyond R14 so this is new territory for me.

 

Thank you,

... generating a Bill of Materials from multiple PDF ...

 

While I can't see what appears as a table of text very clearly in your capture, I'm speculating that it's actually a collection of vectors that gives the appearance of text.  Post one of your your PDF files for verification, but my recommendation at this point is to hire some minimum wage people and have them start typing (and proofreading).

*Expert Elite*
braudpat
Posts: 2,404
Registered: ‎12-15-2006
Message 2 of 5 (989 Views)

Re: Orderly / Neatly exporting AutoCAD BOM into Excel 2013

03-12-2014 10:15 AM in reply to: CPEProjE

 

Hello

 

Do you know _DATAEXTRACTION ?

 

It is mainly used to Export Blocks+Attributes Infos to CSV, XLS, MDB and produces in the same time (if you need it) a beautiful ACAD Quantity Table ...

So If you have the Info you need in Blocks+Attributes, a few seconds later you are happy !

 

Please ask on Youtube with the key words :  autocad dataextraction

and you will find many examples ...

 

Bye, Pat ( Supporting Troops )
If you are happy with my answer please mark "Accept as Solution" and if very happy please give me a Kudos (Compliment) - Thanks
Mentor
cadwomen
Posts: 154
Registered: ‎08-31-2003
Message 3 of 5 (968 Views)

Re: Orderly / Neatly exporting AutoCAD BOM into Excel 2013

03-13-2014 07:36 AM in reply to: braudpat

so didn´t

AutoCAD Plant 3D Report Creator

 

http://www.pdoteam.com/2011/09/autocad-plant-3d-report-creator-2012/

 

work for you ?

 

cu cw

 

 

If my post answers your question, please mark it as an Accepted Solution, so that others can find answers quickly!
Distinguished Mentor
TerryDotson
Posts: 515
Registered: ‎06-06-2010
Message 4 of 5 (965 Views)

Re: Orderly / Neatly exporting AutoCAD BOM into Excel 2013

03-13-2014 08:07 AM in reply to: CPEProjE

... generating a Bill of Materials from multiple PDF ...

 

While I can't see what appears as a table of text very clearly in your capture, I'm speculating that it's actually a collection of vectors that gives the appearance of text.  Post one of your your PDF files for verification, but my recommendation at this point is to hire some minimum wage people and have them start typing (and proofreading).

Contributor
CPEProjE
Posts: 19
Registered: ‎09-09-2013
Message 5 of 5 (934 Views)

Re: Orderly / Neatly exporting AutoCAD BOM into Excel 2013

03-20-2014 05:32 AM in reply to: CPEProjE

To all respondents, thank you for the guidance.  I wound up having to personally go the route of the last suggestion which was to get started typing - I learned through asking very pointed questions our drafting designers were using drawings (many wrong at the outset) a few years old, that have been imported/exported across previous versions of AutoCAD and CadWorx... in so doing, caused some data links to pipe spools to break or become faulty.

 

In any case, after about four days of manually parsing and entering into Excel to sort and compile, it's done so I'm off to engineer some more stuff.

 

Thank you again!!!

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.