topic Re: Room wise Data extraction of objects in AutoCAD Forum

Room wise Data extraction of objects

Anonymous — Fri, 20 Dec 2019 11:16:04 GMT

This is my sample file in which i want to extract data in the form of excel.

I want to extract it in particular format like

Column A Column B Column C Column D (optional)

Room Name Room Number Layer Name of object Count of objects

Example

Office L1-5471 Bulb 5

Office L1-5471 Light 1

Office L1-5474 Bulb 3

Is it possible to do in cad?

Re: Room wise Data extraction of objects

pendean — Fri, 20 Dec 2019 13:19:09 GMT

Are you actually using AutoCAD ARCHITECTURE? you are in the plain AutoCAD forum.

Re: Room wise Data extraction of objects

JTBWorld — Fri, 20 Dec 2019 15:34:26 GMT

If using regular vanilla AutoCAD take a look at this https://knowledge.autodesk.com/support/autocad/learn-explore/caas/sfdcarticles/sfdcarticles/Creating-area-Room-Tags-linked-to-polylines.html

Re: Room wise Data extraction of objects

R_Tweed — Fri, 20 Dec 2019 18:06:15 GMT

Provide something in common between the symbols to sort and filter, the more in common the more filter options. You could use layering but then your dwg might get bloated. I would think an attribute would work best in my opinion. I've attached a screen cast to explain. Please,Still working out how to use screencast

Re: Room wise Data extraction of objects

Anonymous — Fri, 20 Dec 2019 21:04:39 GMT

This is a sample I worked up using (invisible) attributes in blocks, and the data extraction wizard built into AutoCAD.

Without having your geometry, I just whipped these blocks together sorta close, but they should get the point across.

The dwg and dxe files must both be extracted from the zip file (apparently a dxe file extension is too close to a .exe for a direct upload, thus the zip file) for it to work. See >link< for further info on data extraction. It's a great tool, I use it all the time. I won't say you are limited only by your imagination, but close. (slight exaggeration)

Hope this helps

Re: Room wise Data extraction of objects

R_Tweed — Fri, 20 Dec 2019 21:23:48 GMT

Screencast attempt #2