Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Making table with MText quantities

MARIUSKDT4G
Enthusiast

Making table with MText quantities

MARIUSKDT4G
Enthusiast
Enthusiast

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!

0 Likes
Reply
Accepted solutions (2)
1,826 Views
3 Replies
Replies (3)

natasha.l
Alumni
Alumni
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.

0 Likes

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

Extractpg2.png

 

Select only Mtext on page 3.

Extractpg3.png

 

Select only Contents on page 4

Extractpg4.png

 

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.

Extractpg5.png

 

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

Filter.png

 

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)

Table.png

 

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

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

0 Likes