search and count blocks and export to excel files

[half235]

hello and pleasure to meet you.

I wanted some tips about a problem to solve.

use autocad 2008 version lt. I basically have a dwg file that inside has many different blocks between them. I need to make the calculation of the total number per single block, and then report block name and total of that specific block, of course this multiplied by all blocks, I could have even more than 100 blocks, and on completion I should create a sheet excel with these two columns "block name" and "total blocks block", I ask for help on how to automate all this procedure.
Thank you.

 

[MassiVonWeizen]

I did a quick search so I don't know if there's any better:http://www.cad3d.it/forum1/showthre...ome-e-la-geometria-dei-blocchi-in-una-regionehttp://www.cad3d.it/forum1/showthre...d-esportare-i-dati-in-excel&highlight=contare

 

[paolomath]

why don't you just use the extract attributes by setting the name as property?

then expose on external file.

 

[PlannerRoad]

I did a quick search so I don't know if there's any better:http://www.cad3d.it/forum1/showthre...ome-e-la-geometria-dei-blocchi-in-una-regionehttp://www.cad3d.it/forum1/showthre...d-esportare-i-dati-in-excel&highlight=contare

it is not possible, has the version lt:

...us autocad 2008 versione lt....

why don't you just use the extract attributes by setting the name as property?

then expose on external file.

I think he doesn't have that command.

 

[half235]

it is not possible, has the version lt:





I think he doesn't have that command.

Thank you for responding to me and for the attention you dedicate to me, at the moment I use filter to do it, but obviously I have to do it by hand for single block. I saw there's a command that uses attributes. but I didn't understand how to use it because I always have one

 

[paolomath]

I think he doesn't have that command.

you can always use _attext after creating a template file. for creating the template file controls on the help.

 

[paolomath]

you can always use _attext after creating a template file. for creating the template file controls on the help.[/quot

p.s. being an abstracting attributes so only the blocks cone attributes. the output file is a text file that you can then open with excel and do whatever you want.

 

[half235]

you can always use _attext after creating a template file. for creating the template file controls on the help.

p.s. being an abstracting attributes so only the blocks cone attributes. the output file is a text file that you can then open with excel and do whatever you want.

thanks again for availability, if I understood correctly I should give name to the blocks(how?) and build the template file with all the names of the blocks and then export right?

Thank you.

 

[half235]

Here are some news about it

through attributes I can extract the number of blocks within the design in a txt file

I would like to simplify operations for the "estratt" command
i.e. is it possible by script to let the user load the script and in the car take both the file of the model and enter the output name without the user interacting?

is it possible to make the attribute invisible in the drawing?

Thank you.

 

[paolomath]

creates a script like this:

filed
0
_-attext
C
"model name"
"data destination name"
filed
1

Don't forget to run after the final "1."

the visibility or not of the attributes depends on how the blocks are built. if you have to create it invisible.