topic Data extraction-Format of data in AutoCAD Forum

Data extraction-Format of data

Anonymous — Mon, 11 Jul 2016 05:29:08 GMT

Hello everyone,

I was wondering if it is possible to extract data from CAD drawings, including some data in it. For example, if I draw a rectangle with a specific Length and Width, and then I extract data from it into Excel spreadsheet, is it possible to have 'Length' and 'Width' in that spreadsheet in the columns? I'm not sure what is it required in the CAD model in order to see the column data in a specific format and with the specific terms in it.

I'd really appreciate if someone could help me in this case.

Thank you so much in advance.

Regards,

Behrouz

Re: Data extraction-Format of data

imadHabash — Mon, 11 Jul 2016 07:00:36 GMT

Hi,

usually EATTEXT command line is used for a such purpose.but for your case i think AutoCAD will not serve you to get width and length for rectangles geometry.it will only give you (see attached image) Area,global width and Length for polylines shape.

i think it's too hard to achieve this because there will be a big problem on how to know and link the data in schedule with the rectangles itself ...

i try a lot BUT nothing get your need .

Good Luck...

Re: Data extraction-Format of data

Anonymous — Mon, 11 Jul 2016 07:33:30 GMT

Hello Imad,

Thanks for the time and effort. I appreciate it.

May I ask if there is a chance to achieve this by defining a Block with attributes? The reason I'm asking is that thus way, I would be able to provide a designer with a Template, including a Block or a Dynamic Block, so he/she can design according to that, and I can get the required information.

Thanks again.

Regards,

Behrouz

Re: Data extraction-Format of data

imadHabash — Mon, 11 Jul 2016 07:45:48 GMT

Hi,

you can do that by using attributes and get numbers of rectangles.

i try this for you..

Re: Data extraction-Format of data

Anonymous — Tue, 12 Jul 2016 00:57:21 GMT

Hello Imad,

Thanks for that. Yes, you're right. I believe attributes should be used.

Thanks again.

Regards,

Behrouz

Re: Data extraction-Format of data

Anonymous — Thu, 14 Jul 2016 20:03:46 GMT

Hello,

Another method to do this would be to create a dynamic block with a lookup table and then once everything is done do a data pull. this should allow you to pull the size of the box.

The reason for this is to reduce the work for the end user. They only have to use one block and just pick the size they need and keep on going.

you can also put in attributes to sort the blocks even more.

Re: Data extraction-Format of data

parkr4st — Fri, 15 Jul 2016 11:21:58 GMT

formulas

see two rightmost columns

http://www.had2know.com/academics/rectangle-sides-area-perimeter-quadratic-equation.html

dave