Making table with MText quantities

[MARIUSKDT4G]

Hello,

I have a small problem which I am trying to solve. I have a project with various concrete elements which has a name. And there are different quantities of every element. I have tried to select elements and then make a table with quantities, but I have failed to make it. So now I am thinking maybe its possible to make a table which will sort quantities by element names, because every single of them has a tag name. Or maybe it is possible to make it with elements, just I don't know how? Anyway, I would appreciate if anyone could come out with a solution. Bellow you'll find a dwg file with my project.

Thank you in advance!

[natasha.l · Accepted solution]

Hello @MARIUSKDT4G, 

You can use Block Attributes & have the attribute data extracted to create a table to accomplish this, here is an explanation on how to.

Please "Accept Solution" if a reply or replies have helped resolve the issue or answered your question, to help others in the community.

[davinatkins · Accepted solution]

There are a couple of steps to make this happen - so bear with me!

I started the EATTEXT command.

In that dialog - Create new Data Extraction and click next.  Telling AutoCAD where you want the extraction to be placed (don't worry we are going to make a table here - this is just the process)

Click next on page 2.

Select only Mtext on page 3.

Select only Contents on page 4

On page 5 you can see that right now we are getting every MText object in the drawing. Not what we want. So right click and choose filter options.

In filter options we are going to uncheck all the contents that we don't actually want. (This is actually easier than it looks - but be sure to scroll through the whole list. Took me about 20 seconds).    I got an error when I tried to uncheck a couple of these. So I just didn't uncheck them.It was the 2 {\fArial|b1|i0...etc} that caused a problem...

On page 6 you can decide if you want a table or if you want to output to an external file.

Page 7 sets the table format, blah, blah, blah...

You end up with a table like this... (actually a REALLY long table - I cut off 2/3'rds of it)

An improvement with this workflow would be to use MLeaders instead of MText for your callouts. You could then probably skip the filter part of this - at least for this drawing.

[alexpromd]

Use data extraction from Autocad and Excel Power Query - https://bit.ly/2TftsFq