AutoCAD 2010 :: Identifying Block From Data Extraction Table

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


ADVERTISEMENT

AutoCAD 2010 :: Rearrange Horizontal Order Of Table Columns Made By (Extraction Data)

Mar 14, 2012

How can I rearrange the horizontale order of the table columns  which made by (Extraction data).

I know how to rearrange it vertically, But horizontally that what I want to know. Example ( colomns order is : number, X, Y. How to change it to :X, Y , number )

View 1 Replies View Related

AutoCAD .NET :: Data Extraction To Table

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

AutoCad :: Price List - Using Attributes In Block / Data Extraction

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

AutoCAD 2010 :: Data Extraction DXE File

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

AutoCad :: 2010 / Data Extraction To Excel?

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

AutoCAD 2010 :: Data Extraction From Multiple Drawings

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

AutoCAD 2010 :: Create Or Edit BLK File To Use With Data Extraction Command

May 24, 2013

I want to add an attribute to a BLK file I have from a past release.  Using this .BLK file, I can create a table from attributes in my drawing using a LISP routine.

It seems there is no way to create or edit a .BLK file that I can use for this in ACAD 2011, it only creates .DXE files. 

The problem with the .DXE file is that is saves the drawing that the original extraction is performed on.  When I use the .DXE in another drawing, it uses the original drawing data unless I manually "delete" the old drawing reference using the dialog box in the extraction wizard.

The .BLK file works perfectly, but I want to add an attribute.  How can I create a new, or edit my old .BLK file?

Will I have to reinstall an older version of AutoCAd to accomplish this?

View 2 Replies View Related

AutoCad :: Extracting Data From Block To Table

Jun 8, 2012

Here is what i would like autocad to do

I work in architecture, and every time i create an opening (door, window) i add a block next to it with an attribute to the reference number

I was wondering if it would be possible when creating that little block to give it more information and later on extract the information from it to a table
Ex: door 106-02, steel finish, 3'x7' , isolated, steel frame, 2" thick etc.

View 0 Replies View Related

AutoCad :: Performing Data Extraction And Linking To External Data With Formulas

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

AutoCAD 2010 :: Inserting New Block And Entering Attribute Data By Selecting Another Block?

Aug 13, 2012

Is it possible, via whatever methods (lisp?) to be able to have a premade block with an attribute and insert it into a drawing then assign a value to it by selecting another existing block in the drawing and using one of its own attribute’s values?

For example, say I have a block representing a telephone and it had an attribute called "PhoneNo" and I inserted it into a drawing showing an office floor plan that had blocks in each office space that are telephone junction boxes with attributes "PhoneExtension".  I would like to be able to autocomplete the entering of the “PhoneNo” data by selecting one of the telephone junction boxes in the drawing and using its attribute’s value.

View 5 Replies View Related

AutoCAD 2010 :: Data Link Table Does Not Insert Into DWG

Nov 23, 2011

I am trying to insert a table using a data link.  I set up the Link through the DataLink manager and then insert the table using a range. I click OK to insert the table and after a few seconds of thinking ACAD sits there with no table on the screen.  When I look in XREFs, the DL is there but says it is unrefrenced. Tried multiple ways of entering or setting up information to no avail.

View 6 Replies View Related

AutoCAD 2010 :: Table Automatically Changes Data Type Properties?

Dec 8, 2010

I've created a table (a door schedule for example).The data cell type properties is "general". The door # is "001". When I type this in, it switches to just "1" and the type is swiched to "whole number." Same for another cell with a number in it, it switches the cell type on me and I don't want what it switches to. Every time I try to switch it back it doesn't do anything.

How do I stop it from automatically switching, or at very least let me override?

View 4 Replies View Related

AutoCAD 2010 :: Data Linked Excel Table Formatting?

Sep 9, 2011

I recently decided to see how the AutoCAD tables work. I was very happy to learn you could link your Excel spreadsheets with CAD. But now I have a problem.

After inserting the table it refuses to use the table style I have set up. The fonts do not want to change at all. I can change the colour of the text, but not the font.

PS: Using AutoCAD 2011

View 7 Replies View Related

AutoCAD 2010 :: Data Link Is Changing Table Style?

Mar 16, 2012

I have created a table style in ACAD 2012 with all of the cells formatted to what I need.  The trouble begins when I bring in a BIAS excel data link to populate the table.  I have tried every option in the insert table steps and have even tried all the different options under the modify excel link options.  I have toggled the use excel formatting on and off, which does change the table size a small bit, but does not allow the table style to take affect.

I have attached a screen shot of the "good" and "bad" tables.  The bad table is what the good table comes in as and it is also what happens everytime the table link updates.  It always reverts back to the bad style and then I have to change the table back to the good one by hand - changing each column individually.

Is there a way to attach a data link to a table with the table style holding its shape and formatting?

This happens on all of my drawings and using all kinds of different excel links.

how to bring in the data link??

View 8 Replies View Related

AutoCAD 2010 :: Insert Data Into Drawing In Table Format

May 30, 2013

I have data in an Excel spreadsheet that I want to insert into the drawing in a table format that replicates my spreadsheet formatting and creates AutoCAD entities as opposed to a bitmap image or the mess the TABLE command generates - I'm looking to keep my text consistent within the drawing and I still use the old SIMPLEX font.

View 5 Replies View Related

AutoCAD 2010 :: Dynamic Block - Lookup Table

Oct 22, 2012

I have created a dynamic block and have applied some lookup tables to it but its not working just the way I want it. I think its to do with the custom entry on the lookup tables. If I delete the custom entry when i select the block in model space the drop down select box to allow me choose a selection is no longer available. How can I remove the custom entry and still have the block working normally. I've attached the block.

View 9 Replies View Related

AutoCAD 2010 :: Adding Table Of Information To A Block

Jul 25, 2012

I am trying to add a table that I can edit like an attribute but have it in a block, Basically I am trying to put information for all the poles in an electrical panel, but im not using MV parts just a block is there anything that can be recommended in this instance.

Just another note I need to reference 72 poles and 5 colums for each of these.

View 1 Replies View Related

AutoCAD 2010 :: Lost Block Property Table Window?

Apr 26, 2012

I am having some troubles whit my dynamic blocks.

Whenever I add a block property table the window that should be opent doesn't open. The strange thing is that I think it actualy is open but i just don't see it on my screen. The same thing gous for the screen that allows you to ad a parameter to a lookup set. by folowing this link you can see what i mean, it gets interesting after 30 seconds.

[URL]

Is there a variable that decides where on your screen you see these screens?

View 2 Replies View Related

AutoCAD 2010 :: Identifying Objects That Use Enablers?

Dec 21, 2012

I have a personal block library, that somehow has gotten "infected" with AEC.  I'm not using any AEC objects on purpose - but loading my library file now loads the various AEC object enablers. How can I find the mysterious entity that is using these?

View 1 Replies View Related

AutoCAD 2010 :: Dynamic Block Visibility States In Table Of Contents

Aug 29, 2011

I am creating some table of contents. The first column contains symbols that are inserted blocks. Now, when I've created dynamic blocks I've made them to have more visibility states. If I insert the block that has such states, only the saved state is visible. Is there any way that I can use more visibility states when inserting some block into table.

At the moment the only solution is to insert another simplified block that I've created just for this insertion. That way my blocks library is getting bigger and bigger only because of this. I don't use simplified blocks in my drawings, except for the thingy mentioned above.

View 6 Replies View Related

AutoCad :: Using BL:NAME During Data Extraction

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

AutoCad :: Dimension Value (data Extraction)?

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

AutoCad :: Use Of Data Extraction Tool

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

AutoCad :: Data Extraction Tables

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

AutoCAD 2010 :: Add Set Of Attribute Data To A Block That Already Exists Within Drawing?

Mar 22, 2012

I am trying to add a set of attribute data to a block that already exists within a drawing.

View 1 Replies View Related

AutoCad 2D :: Data Extraction Not Sorting Properly?

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

AutoCAD 2013 :: Data Extraction To Create A BOM

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

AutoCad :: Spline Data Extraction Using Lisp?

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

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 View Related

AutoCad :: Palettes / Blocks And Data Extraction

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







Copyrights 2005-15 www.BigResource.com, All rights reserved