[Search tip detail and code files using keywords, tip number, author name, etc ]
Check for Duplication During Data Extraction
Tip# 3949 By Danny Korem On 13-Aug-2012
Rated By 1 users
Categories : Export
Software type : AutoCAD 2013
Rename File To : No Files to download.
Determine whether you've extracted data from duplicates of attributed blocks.

Frequent tipster Danny Korem shares a technique he uses during AutoCAD data extraction to ensure that he doesn’t duplicate data.

"The latest versions of AutoCAD all have built-in data-extraction functionality — the ability to link between DWG components and their derivatives within electronic spreadsheets (in both directions, and more). At the end of the day, accuracy while counting objects within drawings is crucial and, in spite of great functionality, there are some possible failure points that must be considered before the real procedure starts its run: Is it possible that blocks with attributed data that is to be extracted have unnecessary duplicates? Is it possible that each duplicate resides in a different layer?

"If one of the blocks is on a locked layer or the Delete Duplicate Objects command (also known as Overkill) has the wrong set of parameters, it makes it difficult to clean up your file. Well, one of the critical phases in the procedure to help deal with this issue is to have an invisible attribute quoting the location (x,y coordinates), which can be extracted later. This way, you'll be able to easily determine if any duplicates exist in the data extraction source (DWG objects). If so, stop and relate to, and finally, resume the procedure."

Notes from Cadalyst Tip Reviewer Brian Benton:
This is a good tip that can help you check your data. If the x,y,z coordinates are duplicated, then the data is likely to have been duplicated as well. Making a unique field to hold the data also makes it easier to find the data.


Average Rating:

User comments
Comment by Shehata,Tawfik
Posted on 2012-08-14 00:25:19
You can also choose to include the Position X, Position Y, & Position Z from the “Geometry” category (on page 4 of 8 of the data extraction process), this will extract the block insertion point coordinates without the need to create an attribute for that.