Data extraction-Format of data

[Anonymous]

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

[imadHabash]

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...

[Anonymous]

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

[imadHabash]

Hi,

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

i try this for you..

[Anonymous]

Hello Imad,

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

Thanks again.

Regards,

Behrouz

[Anonymous]

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.  

[parkr4st]

formulas

see two rightmost columns

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

dave