topic Re: Roundup a data extraction, how? in AutoCAD Forum

Roundup a data extraction, how?

hanslammerts — Thu, 05 Oct 2017 21:45:25 GMT

Hi all,

(This question comes from AutoCAD Architecture use, but because the routine is the same as in AutoCAD i will post it here.)

I can make dataextraction on mass objects (or some other property).
I notice that there are very, very little difference the values which make them unique. Which i don't want.

So, my question is this..
Is there a way for some kind of round off BEFORE dataextraction and couting it right in AutoCAD immediately?

Thanks upfront

Re: Roundup a data extraction, how?

john.vellek — Thu, 05 Oct 2017 22:45:28 GMT

Hi @hanslammerts,

I don't use MASSPROP very often but I wonder if changing units accuracy before running the command has any affect on the accuracy of the volume value being displayed.

I tried setting the length precision to 1 decimal place on my AutoCAD and it looks like that works. Can you check on your side too? If you can provide a sample drawing that would be helpful to do more testing.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Roundup a data extraction, how?

leeminardi — Fri, 06 Oct 2017 03:03:03 GMT

The UNITS command controls the displayed precision of MASSPROP and the precision of the results sent to a file.

Re: Roundup a data extraction, how?

hanslammerts — Fri, 06 Oct 2017 04:18:09 GMT

I' not using massprop here. Value Volume is a ACA AEC object property..

Re: Roundup a data extraction, how?

hanslammerts — Fri, 06 Oct 2017 07:31:35 GMT

Let me clarify further. I have a 3D solids come as exports come from ..<fill in some BIM software> .. REVIT..

I want to filter based on volume which is a 'failsave' way imo,

But as you can see, due to the precision issue in Revit and between these two. The numbers need to be rounded to 1 mm3

After doing further eximinations i come to believe i reached the of posibilities of Data extraction.

So, these further question pop up in my mind.

- Please prove me wrong that this can be done. 😉 most appriciated

- Where can i post any idea to put in a roundup function in between these columns. Did Autodesk really forget to put in Ideas for AutoCAD in this platform?

- Maybe Dynamo can jump in here and a script can be run putting rounded volumes to some custom field. Any examples of AutoCAD and Dynomo use, please share them !

https://youtu.be/sDOZKbUU4qw

test files attached

Re: Roundup a data extraction, how?

dbroad — Fri, 06 Oct 2017 19:12:53 GMT

Based on what I see, I don't see a need to tweak dataextraction regarding this. (See Image.) BTW. You can easily format and process using Excel (to which Data extraction can write to or by using the built-in features of tables themselves (if inserted as a table). While it is not clear, it seems like the process of arriving at a whole unit would involve some rounding operation.

Re: Roundup a data extraction, how?

hanslammerts — Fri, 06 Oct 2017 19:17:30 GMT

THe idea behind the *roundup* is that the counts are corrected with the results after the rounding. I don't think that is the same. Thanks anyway, i will try..

Re: Roundup a data extraction, how?

dbroad — Fri, 06 Oct 2017 19:25:41 GMT

You're talking about cubic millimeters. What kind of projects are you working on that require always rounding up values that small vs normal rounding? If you're working with gold or something costlier, process it in Excel using its roundup function and import the table back into CAD.

Re: Roundup a data extraction, how?

hanslammerts — Fri, 06 Oct 2017 19:58:00 GMT

These are bricks for a lock. All our work is done using mm. We don't need to round up less then 1 mm. I know Excel can make and manipulate the output, but it would be better if AutoCAD was able to make these good in the first place. The thing is that these solids come from Revit, exploded blocks (families). You would think they would have exaclty the same volume. Even if is behind 0.0. I am amazed Revit 3D dwg are that Unprecise. Can Revit do a round function in there scheme? I need this in AutoCAD.

Re: Roundup a data extraction, how?

dbroad — Fri, 06 Oct 2017 20:25:50 GMT

Yeah. I wouldn't use Revit if extreme precision is required. It doesn't even have a real coordinate system (IMO) but I will admit that for architectural work, it does pretty well. I'm not convinced however that mass elements are going to give you any more precision. 3D solids seem pretty precise. If I were working on locks, I would probably lean toward Inventor or Solid Works.

Good luck!

Re: Roundup a data extraction, how?

hanslammerts — Fri, 06 Oct 2017 21:07:45 GMT

Yeah i dont because precision is allways required, but its not extrme in any way and I am not going to rephrase myself 😉 about the seach for the need for rounding / countin to make it better work this work within data extraction. And I agree Revit has some work to do with its coordinare system, along with other aspects. Here are some screenshots from the excersice using FME. this works pretty good, however not direct in a DWG environment. Hope you get the picture. This script can read DWG, compare solids forms and deteminate if they are ROUNDED equal, assign a number and put it into a DWG file together with the volume written done in the centerpoint of the solid. Very cool, however... you need FME (knowlegde),.. I'm better in AutoCAD

And i think you misunderstood 'locks', what i mean is ship-locks. Don't know if that is the right word. My profile should say: civil 😉 i do bridges, tunnels, .. And .. locks..

Re: Roundup a data extraction, how?

dbroad — Sat, 07 Oct 2017 02:03:53 GMT

I assumed that you meant canal locks. 🙂 Sounds interesting.

Re: Roundup a data extraction, how?

hanslammerts — Sat, 07 Oct 2017 12:10:54 GMT

https://www.youtube.com/embed/sDOZKbUU4qw

Re: Roundup a data extraction, how?

dbroad — Sat, 07 Oct 2017 14:07:13 GMT

After doing some more testing, I apologize for completely missing the point of your complaint. First changing the column data format should affect whether rows or combined or not but doesn't. Second, the formula column should support more than just +-*/ functions. Third, the "whole number" format option is completely broken. This may be because of the volume property but that shouldn't matter.

I strongly agree that some additional function support should be added to the formula column or to the formatting features so that nearly identical rows can be combined and counted. There is also no easy way that I can find in Excel to combine nearly identical rows.

Re: Roundup a data extraction, how?

hanslammerts — Sat, 07 Oct 2017 14:54:49 GMT

Doug, kind of you to look at it again.

I agree, conversion rvt to dwg seems to lead to unpredictably volumes.

data extraction (manipulation) seems not to work, is broken, and can do better..

this is in core AutoCAD. So how, there is now way to get this message though to the Autodesk people.

Referring to my post (rant) IDEAS for AutoCAD?

to be continued

Re: Roundup a data extraction, how?

hanslammerts — Sat, 07 Oct 2017 15:05:31 GMT

In the meanwhile I will do some testing Revit exporting 3d to ACA masses to have a closer look what happens to these .001234 rounding..

Re: Roundup a data extraction, how?

dbroad — Sat, 07 Oct 2017 21:08:46 GMT

If you have time, join the beta program at https://beta.autodesk.com/welcome/

It may or may not matter.

Re: Roundup a data extraction, how?

hanslammerts — Sun, 08 Oct 2017 05:57:43 GMT

Great idea! I will post my idea and findings there.

Re: Roundup a data extraction, how?

Anonymous — Wed, 29 Jul 2020 07:50:51 GMT

Use system var called "LUPREC". replace the value with zero.

Enter new value for LUPREC <4>: 0

Re: Roundup a data extraction, how?

dbroad — Wed, 29 Jul 2020 14:15:28 GMT

This thread has been finished for 3 years. The test file provided by the OP already had the LUPREC set to 0. Are you saying that the current version of AutoCAD has fixed the error? Did you actually test it? This is a snippet of a data extraction done on the file after both the luprec is set to 0 and the volume units are set to millimeters and volume accuracy is set to 0. Note that there is some combination of similar elements but its not consistent. I would post a screenshot but many forum editing features are disabled this morning.