How to list all the layers that are used in a entire project?

[Anonymous]

Hi,

Can anyone tell me whether i can list all the layers that have been used in an AutoCAD Electrical project?

The layers used in a drawing will be listed in the layer manager, but is there a posiibility to list out the layers in the entire project?

If not by default in AutoCAD Electrical, is it possible with a third party application?

Regards

Prem Savio

[rhesusminus]

I'm not aware of any functionality in AcadE or any third party programs that will do this.

It would not take a lot of work to create av VBA macro that fixes this though...

Is it just a plain list with the used layer names you want? One layername per line or comma separated?

[ccad2509 · Accepted solution]

there is a way in plain autocad commands

which is data extraction

menubar>tools>data extraction

you can configue this to examine a single drawing or multiple drarings

follow the menus through and you should be able to produce a spreadsheet with all the infomation you require

it takes a little playing with to get exactly what you need

its a powerful function which i use all the time

[vladop · Accepted solution]

Extract files in attachment.

Copy layerData.scr to the folder C:\Users\{username}\AppData\Roaming\Autodesk\AutoCAD Electrical {version}\{release}\{country code}\Support.\User.

Save layerData.lsp file to your computer.
To avoid possible problems in Multiple Document Interface (System Variable SDI=0), add layerData.lsp to the Startup Suite:
- type APPLOAD in ACADE command line,
- click on Contents... button,
- click on Add.. button,
- browse and open layerData.lsp file you previously saved,
- select Close twice to close dialogs.
Restart ACADE.
Now you're ready, next time you don’t have to load files and restart ACADE.

Type layData in command line and select drawing from which to extract layers.
Wait until data is extracted and then type layData2XLS to write data to excel file.
File is saved in the active project folder with name layerData_{active project name}.xls.

[vladop]

Another, much faster lisp:

http://www.lee-mac.com/layerextract.html

[Anonymous]

Thanks ccad2509 & vladop. This is perfect.

Its hard to find one solution to a problem, let alone two. But apparently i did, for this problem.

Both the solutions help me do exactly what i want to do. vladop's solution is a litlle more extensive than ccad2509's though.

Anyway, thanks again for those wonderful solutions.

Regards

Prem Savio