AutoCad :: Data Extraction Nested Blocks?
Dec 13, 2011
Here is the problem with the process put simply:
Start with a new drawing Drawn a rectangle. Place a block which has an attribute with a number at each corner. ie. 1-4. Convert all objects into one single block. (the attributes become nested). If you use data extraction and retrieve the attribute number, position X and position Y, and output to a table the information displayed is correct. HOWEVER, if you rotate the block and update the link the coordinates become incorrect? This seems to be an issue with nested blocks?
View 4 Replies
ADVERTISEMENT
Jun 5, 2012
I am new to this company, we manufacture and build panelised buildings. We are 3 users in the drawing office, we all have Pallettes set up in ACAD and our pallettes all reference the same block files on the server.
We do Data extraction when we move into the production phase of any project and we extract all block information into Excel.
The problem is that when these blocks were made very little thought went into the naming of them. So now when ACAD produces a list of the blocks on the drawing I have electrical, plumbing, fittings etc all mixed together, making it time consuming to sort through them and put them together in their separate spreadsheets.
What I am hoping to do is go through our library of blocks and rename them all, simply giving them a single letter prefix at the start of the file name IE E - Single plug, P - Tap, D - 826 Door etc. The problem is obviously if I rename them then all 3 users have to reassign each individual block again to their palettes.
View 9 Replies
View Related
Jun 4, 2011
I design all of the architectural metal used on most project homes being built in Sydney at the moment.
I draw up balustrade and screening etc.
Basically what I have is a huge collection of complex dynamic blocks that I insert into my drawings, I then change all the variables to suit.
These drawings are then dimensioned, and a parts list manually written out based on the lengths etc of each type of material.
All of these drawings are exact reproductions of what is produced on the factory floor, so it is quite easy to identify the parts, but rather painfull to manually write out a cutting list.
I'd like to add attributes and/or fields for material type and length to each of these dynamic blocks, which update as the blocks are manipulated to the required sizes.
where I get stuck is that there are multiple drawing methods used to create these blocks, and I cannot seem to figure out exactly what I should be naming, and assigning length fields too, or even how to extract or what to extract!
When I extract the data, I get a mess of conflicting and confusing information that is impossible to sort correctly, as I can use the dynamic parameter field for some, but not others, and on others it is a simple line, but on others again they are polylines and the length is useless to me.
I have tried to creat a block with an attribute for each and every individual part, but when I combine these into a complex part and try to assign dynamic parameters as a single dynamic block, the previously blocked and named parts wont behave correctly.
Im not sure if im making much sense here, but in my mind it all seems simple enough, I just cant get it to actually work with my exsiting blocks...
All im really after is a simple BOM, for example, I have a dynamic block with the Style code A0-1, when this is inserted I change 3 different lengths depending on the job. This style code is made up of several components such as a 40 mm square post (coded 40SQ), an 80 sq baseplate (coded PF2) and a 50 x 25 mm handrail (coded HR5025).
I need to extract a length for the 40 sq post, a length for the 50 X 25 handrail and an item count for the baseplate.
There may be 25 of these in a drawing, all at different sizes.
The dynamic block works perfectly for drafting, but not so well for data extraction.
There are over 1100 of these dynamic blocks, created over the last 2 years, and the only missing piece in the drafting puzzle is the extracted cut-list to save a large amount of time, and I just cant get it working.
Is there a methodology I need to learn here? will I need to re-create these blocks to allow for extraction?
I have explained to my boss the theory behind all of this and he is keen for some working examples that the monkeys on the shop floor can read and understand, and Im stuck creating an extraction template that can work, even if just for proof of concept that I can refine over the next few months.
I know ACAD can do this, I know my brain has all the data, I'm just not getting the ACAD>BRAIN interface working here.
View 4 Replies
View Related
Jul 25, 2013
i am searching for a lisp for data extractiion from selected blocks. Here Iam attaching sample blocks drawing for reference. These blocks containing visability features. I need output excel in the below snap shot format.
View 8 Replies
View Related
Apr 19, 2012
I am trying to link my extracted data from blocks with attributes to an extenal source so that the table I create and place into the drawing already has the formulas I need to due the required calculations. But every time I create and place the table the formulas are not in the table. I include the columes that contain the data but it doesn't seem to be working.
View 2 Replies
View Related
Mar 19, 2013
Ive setup some blocks which have attributes and have been successfully using a template to extract the data for a while. I just created a new block and tried extracting the data. All works fine except for BL:NAME returns '*U' instead of the block name. The block is called 'SM'. Is '*U' a code for something?
The old blocks still export fine.
View 4 Replies
View Related
Jul 22, 2011
what should i Select in data Extr wizard to get the readings of series dimension on one layer preferably
View 0 Replies
View Related
Apr 7, 2013
I am working on a co-ordinate utility that utilises data extractions. I am able to extract the data that I want to an XML file, but how do I create a dxe file and link it to a table? I have found the WizardSettings has a table style, but that is as far as I have reached.My code is below.
using Autodesk.AutoCAD.ApplicationServices;using Autodesk.AutoCAD.DatabaseServices;using Autodesk.AutoCAD.DataExtraction;using System.Collections.Generic;using System.Data;using System.IO;using AcApp = Autodesk.AutoCAD.ApplicationServices.Application;namespace acmCoordinates { public class DataExtraction { const string outputXmlFile = @"c:empdata-extract.xml"; public static void.
[code]....
View 2 Replies
View Related
Oct 16, 2012
If I use the data extraction tool in Express tools or go down the path of ATTEXT I can get an extraction result that includes block handle data. If I use the data extraction wizard I can't recover this handle data.
Is there a reason for this and can the data extraction (.DXE) template file be tweaked to accomplish this?
View 0 Replies
View Related
Sep 18, 2013
Here at the office we use a template I created using Data Extraction. After creating the table and inserting it, it works just fine. Then, if you make changes to the door or window you can click the "Download Changes From Source File" and it will update the table ... However, after saving it and trying to work on it the next day, it somehow unlinks the table I have in my drawing and I cannot "Download Changes From Source File" to update the table ... I checked under XREF and it shows it is loaded and I have it reading from the same path I saved it. I would like to know if there is a way to re-link the table to the .dxe file or how to prevent from it un-linking new tables?
View 0 Replies
View Related
Feb 3, 2010
I am creating a schedule with a .dxe file, which extracts data from attributes into a schedule. Is there a way to link this file so it is a "relative path" instead of a full path. IE: The .dxe file is liked to the same folder that contains the current drawing, not linked to my C:/AutoCad drawings/Job Name/folder2... I really want to be able to move the drawing and .dxe to a different folder and not have the link broken.
View 4 Replies
View Related
Sep 21, 2011
Seems like i export the data of thickness, diameter, lenght and mass to excel via dataextraction, but if i change something in the drawing, its not updated in the excel file..
I also wanted to export the data to an already existing part list template, but this seems impossible...
View 2 Replies
View Related
Nov 21, 2013
I'm doing a data extraction with a block with attributes. When I extract the data, it sort like the image below. I want it to sort 1,2,3,4,5,etc...
View 4 Replies
View Related
Dec 26, 2012
Here is what I would like to accomplish:
1. Construct a blank "template" drawing that already has a pre-determined data extraction table set up with every piece of valueable data that may or may not be used in the drawing showing values of zero (because there is nothing drawn yet of course)
2. The data extraction table is linked to an excel file. This excel sheet will recieve data from the linked CAD data extraction table and use the data in the pre-determined 'destination' cells to execute cost economics equations
3. I would like the data extraction table to be set up with all possible entities that may potentially get drawn into the drawing - I don't know if this is possible because in any data extraction table I have ever drawn, as soon as the entity the data table is accounting for is deleted from the drawing, the whole line from the table dissappears - in my case I would love for it to just show "zero" or null
4. The reason for all of this is to not have to create a new data extraction table and excel sheet every time - The two templates would already be linked, and all the drafter would do is draw the drawing, the appropriate data would show up in the data extraction table (eg. X amount of feet of poly line, X number of Y block), be pushed to the excel sheet in predetermined locations, cells would be linked on the sheet to execute costing equations.
I hope i have been clear enough that the project represented in the drawing does not have many possible components and that is why having them all listed in a pre-designed data extraction table would not take up much space, the benifit of having everything linked before hand is the goal.
View 5 Replies
View Related
Mar 23, 2006
Using autocad 2002, how to extract the control points of a spline drawn and writing into a file using autolisp?
View 4 Replies
View Related
Jun 10, 2011
I have created a data extraction table based on attributes placed on blocks. The data table is in my layout and it includes part number, dimensions, and cost. What I need to do is total the cost of all the items at the bottom of my table. I added in a row for the total cost which is not linked to the table but when I try to add a field in that cell to sum the cells above it (the costs), I get ###. I already tried unlocking the cells, but that didn't do anything.
How can I add a field summing these costs?
View 1 Replies
View Related
Aug 13, 2013
I need to EnableFrameText to all MLeaders in a drawing, I also want to get the MLeaders who are nested in Blocks automatically...
I started this way but It just works fine with the Mleaders in Modelspace or if I open the Blockeditor to edit Mleaders nested in a Block...
I know I'm not going to "deep", maybe I need an other Transaction, or thirst open each Block to edit... not right sure...
my example:
//Ändert leider nur die MLeader die nicht in einem Block sind....
[CommandMethod("MLeaderIterator")]
public static void MLeaderIterator_Method()
[Code]....
View 2 Replies
View Related
Apr 13, 2012
Is there a quick/easy way to know if a DWG contains nested blocks?
View 6 Replies
View Related
May 28, 2013
I wish to extract geometrical data from autocad 3d object (mostly poligons), like length, height and width. I can see them in the property of a single object, but when I want to extract them into a table or into an external file, I can't find them.
View 5 Replies
View Related
Jan 14, 2013
I am working on Data compliation and trying to extract data from multiple AutoCAD drawings. The data extraction wizard works well and extracts all the data from the drawing. I wish to segregate the data and want some certain set of data e.g. in P&ID drawing, I need only instrument Tags which are connected to DCS and likewise...
Is there any way to filter such kind of data and get the required results?
View 3 Replies
View Related
Nov 28, 2012
Can the Data Extraction Wizard be added to 2013LT?
View 2 Replies
View Related
Sep 27, 2013
I continue to suffer project downtime and setbacks due to a variety of defects in the software. Here formula columns are not working. I created a Formula Column for simply computing ItemQTY *Item Cost in a Data Extraction table for a current project.
QTO is defective, and now Data Extraction is not working. What does the product leadership expect us to do for quantity analysis?How can Quality Control of this software significantly improve?
View 5 Replies
View Related
Jul 17, 2013
I have some 17500 points that I need to get the co-ordinates of but I need to have them in the order they were drawn. I have been through the wizard for data extraction and cant find any option for displaying the data in this order.
View 0 Replies
View Related
Sep 27, 2013
I'm attempting to have the user select mText from a nested block within a block and then copy the nested block to model space out of the block. I'm able to change the mText successfully, but when I attempt to get the nested block it is not in the list of GetContainers() it only contains the block in model space and the model space block. The nested block is missing in the list. I'm using AutoCAD Civil 3D 2013.
Here is the code to select the mText object which works correctly.
Sub GetNestedMtext() ' Have the user select an object. Using the prompt provided. Dim ed As Editor = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor Dim entopts As New PromptNestedEntityOptions(Environment.NewLine & "Select a mText in block to replace: ") entopts.Message = Environment.NewLine & "Select a mText in block to replace: " Dim ent As PromptNestedEntityResult = Nothing Try ent = ed.GetNestedEntity(entopts) Catch ed.WriteMessage("You did not select a valid entity") End Try If ent.Status = PromptStatus.OK Then CreateDuplicateBlockInModelSpace(ent) End If End Sub
Here is the code that attempts to get the nested block which is missing the nested block.
Private Shared Sub CreateDuplicateBlockInModelSpace(ByVal ent As PromptNestedEntityResult) Try Dim containerObjIds As ObjectId() = ent.GetContainers() Dim blkToExtract As BlockReference = DirectCast(containerObjIds(1).GetObject(OpenMode.ForRead), BlockReference) Dim blkToPlace As BlockReference = blkToExtract.Clone() Dim doc As Document = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument Dim db As Database = doc.Database Using tr As Transaction = db.TransactionManager.StartTransaction Dim acBlkTbl As BlockTable acBlkTbl = tr.GetObject(db.BlockTableId, OpenMode.ForRead) Dim acBlkTblRec As BlockTableRecord acBlkTblRec = tr.GetObject(acBlkTbl(BlockTableRecord.ModelSpace), OpenMode.ForWrite) acBlkTblRec.AppendEntity(blkToPlace) tr.AddNewlyCreatedDBObject(blkToPlace, True) tr.Commit() End Using Catch ex As System.Exception End Try End Sub
Is there another way I can get the parent block object for the nested object?
View 5 Replies
View Related
Jan 14, 2013
I have a need to run a data extraction every night at lets say 2am and have it save to a .csv file.
View 3 Replies
View Related
Dec 5, 2012
I was trying to use data extraction to create a table that can list the blocks in the drawing and descriptions in AutoCad 2012 windows version. the software didn't recognize my blocks. When I starts trying at my mac version of 2013, I am even more confused on how the create a table that can list the blocks in my drawing.
View 2 Replies
View Related
Mar 21, 2013
I have created a sample drawing, to illustrate to the design manager at work that we can use AutoCAD to assist us with the scheduling of materials, but I am unsure of all the ins and outs of it myself!
See attached drawing to make sense of the following:
Ordinarily we would use a panel reference number for all 50mm panels of identical length, i.e., all 1200mm panels (our standard width) will be assigned a panel code, often P01... etc etc. From the data extraction (EATTEXT) command, as you can see, all 50mm cleanroom panels under the 'name' column are according the block name, in this case, I've called it "Cleanroom Panel 50mm". Is there any way to assign an individual tag to all panels of equal length, yet maintain the same block - or is this simply asking too much?
The reason for this is that although the autocad generated table is ideal for quantifying and placing orders for materials, we are a design and build firm, all our construction workers will need to be able to identify where on a plan an individual panel is, i.e., all well and good to say one panel is 332mm long, and one is 350mm long, but he will need to know what panel is to be installed where...
View 2 Replies
View Related
Aug 1, 2013
Can I run the dataextraction command via a command line and respond to the prompts via lisp or script. In other words is there a commandline version of dataextraction - setting cmddia to 0 doesn't work.
View 8 Replies
View Related
Jul 15, 2011
I want to make a price list, using attributes in block and then extracting them to cell matching some cells with excel
While in data extr wizard for some reason I cant get the size column to set in ascending order.. Why does size 10 brake the logic?
Can I edit the extracted data without launching data extr wizard?
Data extr wizard brings a data in one table what if I want the table to display other types of attribute ( example see pic for instance instead of EL i have SS no problem until now, but my matched data link in excel is for EL and not for SS)
Its hard to explain Basicly i selected the column in excel for one type of attribute "EL" and I want fo a different name of same attribute different cell matching.
See pic: text.data.dwgsQ1.jpg
View 2 Replies
View Related
Oct 13, 2011
I've just started working with Autocad 2012 and am using the Data Extraction Wizard to extract information into excel. Some of my drawings have upwards of 150+ layers and I don't necessarily need the information from every layer. Is there a way to have the data extraction wizard ignore layers of my choosing?
View 4 Replies
View Related
Apr 15, 2012
how I can export the nested data of Cogo Points. I need to get them into a spreadsheet.
I have tried exporting a .shp file and opening the .dbf file in excel, however, it only seems to export the data field of the table and not the value.
View 9 Replies
View Related
