AutoCad :: How To Convert Geometrical Data And Attribute Of Block To Excel

Oct 3, 2012

I am currently trying to make my AutoCad more powerful as a tool of Engineer but not Draftmen (My boss never thing about it, I could only get a standard AutoCAD, not AutoCAD-EMP).

I want to make it a tool for myself to analysis the building system, with excel (and VBA)

The first tool I wanted to create is an underground drainage capacity analysis tool. But I meet the first difficulty, how can I automatically transfer the information inside CAD drawing to the excel?

Say, There is a drainage system with 2 manhole and 1 pipe,
the Manhole have 3 attribute : Name, Model, Level, (and the X-Y coordination),
I Create a Block with attribute "Name ; Model ; Level".
and then I insert the Blocks and place it in correct location inside the Layout Plan.

How can I create some script to "Scan" all Block inside the drawing and make an excel file with data like:

Block-Serial, X-Coor, Y-Coor, Rotated Angle, Name, Model, Level.

View 3 Replies


ADVERTISEMENT

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 2013 :: Importing Attribute Data From A Block Into Another Block?

May 30, 2013

I have 2 drawings with the following content :

Drawing 1 : Contains tree blocks that have a specific scale dependant on the tree size

Drawing 2 : Contains a block with just a point and attribute data about the tree (name, size etc.)

This block is approximatly at the same location as the tree block (0,1 m precision)

Problem I want to join these two items together. In other words, in the tree block that is scaled correctly i want the attribute data with the name, size etc. These blocks don't have a corresponding unique number or something like that.

View 2 Replies View Related

AutoCad :: Import Excel Information Into Title Block Attribute

May 18, 2012

I have 200 files listed in Excel. The file name in excel is an attribute being document number in title block.

How I can import this directly into eac .dwg file?

View 1 Replies View Related

AutoCAD 2013 :: Geometrical Data Extraction From 3D Object

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

AutoCad 2D :: Convert A Block To Attribute

Jul 18, 2011

It is possible to convert a block like below straight into an attribute without actually creating the attribute manually?

View 7 Replies View Related

AutoCad :: Creating Block From Excel Data

Oct 24, 2012

Is there a way to create block out of excel data?

I am trying to create multiple block missing in our database, actually i have all the measurement of the fitting inside excel this is mostly elbow and T fitting.

I was thinking of a dynamic block with editable lenght (strech parameter with a mix of constraint). but before digging too deep in a wrong direction i want to ask community if something similar already exist?

View 2 Replies View Related

AutoCad :: Data From Excel To Block Attributes

Jun 19, 2012

I have some soil boring data captured, in the field, to an Excel spreadsheet; basically, a bore site ID and coordinates.

I'd like to be able to have the coordinate attributes of blocks inserted into my bore site plans populate automatically, perhaps based off of the value of a bore site ID attribute which is manually entered for each bore site.

Alternatively, if there were a way to insert the bore site blocks based off the actual Excel records, populating all attributes and locating the block by the actual X,Y,Z coordinate, that might be even better.

View 3 Replies View Related

AutoCAD LT :: ZTag Data To Existing Attribute In Block

Oct 19, 2011

we have a block that we use to identify rooms. that block has 3 attributes: rooms name, rooms number and surface area.

A former colleague once showed me how to do this but I can't reach him... How can I inquire the data from an area and tag-it right to the surface area attribute of my block? I don't mean pick a pline, list and edit the block... it's something like pick the closed pline and the "area" data is displayed in the right tag of my block?

View 8 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 Visual LISP / AutoLISP :: Convert Text To Attribute Inside Block

May 3, 2013

Looking for routine for converting text to attributes inside the block?

In my drawing I hv some attribute blocks having some Text in it. I need to change the Texts inside the blocks as Attribute Texts. I am attaching sample Blocks drawing..

View 9 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Copy Block Attribute Data To A Selection / Group Of Blocks

Apr 15, 2011

I found a lisp to get block attribute data to a other block. See attachment. I can only apply it to one block. I like to apply it to selected blocks or blocks in a group. Is this possible?

View 9 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Check Block Attribute Then Change Different Attribute In Block

Aug 31, 2012

select all blocks on certain layers in a drawing, check attribute CIRCUIT in each block if it starts with MS then attribute CONTROL = switched. I hope thats clear enough the way

(defun c:control()
(graphscr)
(Setq sc (ssget "X" '((0 . "INSERT")

[Code].....

View 1 Replies View Related

AutoCAD VB :: 2011 Batch Convert Field Attribute To Text Attribute In Blocks Using VBA

Jun 3, 2011

I've got hundreds of files to convert. 

In VBA, how can I batch convert field attributes in blocks to text attributes while retaining the blocks?  Is there a simple way to univerally convert them all at onceusing VBA?  The plotted values for the fields must be retained, too.

Explode will not retain the value of the field.

Burst will not work as it explodes the blocks as well.

You can right-click on the field and slelct "Convert to text" from the RCM.  So I know that the process exists within CAD, just need to batch the process for a quantity of DWGs at a time - in VBA.

View 1 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Convert Attribute Tag Into Attribute Value?

Dec 8, 2011

Background: Someone exploded an attribute block and copied it hundreds of times throughout a project, each time changing the Attribute Tag to match the Value they expected to appear in their drawing.  The drawing must be xrefed, so the attribute definitions do not appear.

(There is only 1 attribute in the block.) 

Proposed Solutions:

1:AutoLISP routine which copies Tag data from Attribute Definition into Value of Attribute Block:

Prompt-Select Attribute Definition

Copy Tag data

Prompt-Select Attribute Block

Paste data into Value

(Allow repeat to speed workflow)(*PREFERRED*)

2:AutoLISP routine which copies Tag data from Attribute Definition into Default Value and creates a new Block:

Prompt-Select Attribute Definition

Copy Tag data

Paste data into Default Value

Create New Block

(Select Multiple Objects)(Creates tons of new blocks which are messy)

View 3 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Transfer Attribute Block Values To Another Attribute Blocks

Jul 3, 2012

I wanna transfer my attribute block values to another attribute text blocks , is there any lisp for that?

Is there a possibility for sum tag values of choice attribute blocks to inside of another attribute text block ?

View 2 Replies View Related

AutoCad :: Object Data To Attribute Data To Perfection?

Oct 15, 2010

I'm working in AutoCAD Map 3D 2008 and Autocad Civil 3D 2009.

The General Task:I want to convert the object data to attribute data so that I can export it to an Excel file, add another column of data, and then import that new data as attribute data.

The Specific Task:I have thousands of campus water meter locations (a block with a small icon, attribute data, and object data) that belong to two different systems, domestic water and lake water. Each of these blocks has object data item (a barcode tag) that I want to show as a label next to the block.

However, before I do that, I want to export that barcode data to an excel file so I add a column (eventually a new piece of attribute data) that says whether or not that specific water meter is radio read or manually read. I want to then import that radio read/manual read excel file back into autocad and have an X appear on the block icon if it is radio read. I also want the barcode information to show up as a label.

My problem:I can't get the barcode object data to export with the locations in one easy excel sheet that I can simply import after I have made my changes.

Find some person on here who knows how to convert object data to attribute data.

View 9 Replies View Related

AutoCAD 2010 :: Change An Attribute From A Value From Another Attribute In The Same Block

Oct 5, 2012

What I really want to do is on our fire alarm blocks we have 3 different attributes one for the address, the candela and one for misc info. I want to make an attribute that takes the number from the candela (15,30,75or 110) and change a different attribute to a value depending on which candela we use (such as 15=.078, 30=.113, 75=.195 or 110=.259). But I don't want the .078,.113,.195,.259 to print out on paper, I want to export block information excel file so I can add up all values.

View 2 Replies View Related

AutoCAD VB :: Attribute Export To Excel

Aug 5, 2013

I am currently working on a project where I am taking a lot of Autocad Attributes and Exporting them to an excel file so they can be referenced in a table of contents type of manner. My question is if there is a way to have excel automatically update the tables after changes are made to the autocad file. This file is an ever changing thing so going back and running through the entire "Eattext" command and re exporting and overwriting the existing file is very tiresome, especially when I am adding and deleting attributes daily. Is there a VBA program I can run to accomplish this task, I have fairly limited VBA skills and haven't written in VBA for years. I am fairly new to exporting autocad attributes to excel . I attached a very simplistic example of the general Idea of what I am trying to accomplish.

View 3 Replies View Related

AutoCad :: Attribute In Title Block Exists In Block Editor But Not In Project

Sep 6, 2012

Autocad 2011, Electrical package,

I have an existing title block a few text attributes, to which I wish to add a watermark. I have added it in the block editor as a normal attribute, with the same details as the other attributes that work, only a different tag name. It has a default value, "DRAFT" and is tagged "WMARK". It works fine in the Block Editor, and If I test the block I can edit it to display whatever I want, but if I save the block and open it from Autocad proper, the attribute is not in existence, either as a default value, or editable from block properties, attribute editor or title block editor, whereas all of the other attributes are there. I have used BattMan to verify the settings of the attribute, and the only difference is that the others all have "L" in the "Modes" column, but I think that means that their position is "locked" whereas my new attribute is justified "aligned" therefore cannot be "locked" (This is some assumption on my part, as the documentation on the "Modes" column is almost non-existent). I cannot afford to waste much more time on this issue, as the boss is breathing down my neck, but editing watermarks on every drawing after every revision is frustrating, when it could be an attribute that is editable from the title block editor.

View 9 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Match Multiple Attribute Values From One Block To Another Block

Feb 12, 2012

I need to match few attribute values from one block to different block. I download a lisp file called; ca.lsp which can match the single attribute value. I modified it for more than one attribute value matching. It is ok but still wish to overcome two issues for batch prcess

1. picking up the blocks by selection

2. click the alternative block numbers of times to match the numbers of attribute values I needed.

How to modify this lisp I can run it by block name selections instead of picking selection which enable me to run batch process for numbers of drawing? That will be good...

Lisp & Demo file attached (Match attribute value, A, B & C to Attribute 1, 2 & 3).

View 3 Replies View Related

AutoCAD Civil 3D :: Transferring One Block Text Attribute To Another Block?

Nov 8, 2013

Is there a way that I can create a block with text ('A') and when I insert the block and populate the block another block block will update also? I am wanting to create a block for x-sec flags, and detail callouts that update their detail titles.

AutoCAD Civil 3D 2012 SP4
Windows 7 (64)

View 6 Replies View Related

AutoCAD Inventor :: Block Attribute In Part Sketch Block

Feb 28, 2012

Is it possible to create a text block attribute in part sketch mode?

View 2 Replies View Related

AutoCad :: Insert Blocks From Excel With Attribute Info?

Jul 19, 2011

I have found a few things on here, but not exactly what I want. We have a excel spreadsheet with borehole references and coordinates. I need to be able to insert a block according to these coordinates and the borehole reference as the attribute.

View 5 Replies View Related

AutoCad :: Creating A Block With Block Attribute?

Jun 10, 2013

I'm creating a block with a block attribute.

In the blockeditor I can change the draworder so the attribute is partly under some lines. But the draworder in the blockeditor of the attribute doesn't work in the normal modelspace; the blockattribute is allways on top.

View 9 Replies View Related

AutoCad :: How To Transfer Data From Excel

Nov 8, 2011

I saw a youtube video "Cross Section in AutoCAD".But i could not understand how to transfer the data from excel to AutoCAD.There is a file TMaker.exe to make template of excel data.I could not find that elsewhere on net. Making earthwork x-sections with AutoCAD.

View 9 Replies View Related

AutoCad :: How To Import Excel Xyz Data

May 29, 2007

I have an excel file containing xyz co-ordinates that i wish to import to AutoCAD (2005).

I realise you can probably do this using the lisp function, but i don't know how they work, and wanted to know if there is an easier way.

View 9 Replies View Related

AutoCad :: Importing Excel Data

Apr 6, 2010

I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.

View 9 Replies View Related

AutoCAD Architecture :: Attribute Data To Schedule

Mar 4, 2013

Possible to send attribute data that is in our title block to a schedule that is populated with property set definitions? We are not using the Project Navigator at this time.

View 2 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Extracting Attribute Values From Multiple Dwg Files To An Excel File

May 11, 2013

how to extract the attribute value of a  particular block in multiple drawings to an excel file.

Eg... there are nearly 800 drawings where I need to list down the description and Drawing number which is mentioned in the title block name "Title". The Drawing Number and the description is done in same attribute block. extract the data into an excel file or txt file. All the drawings are saved in one location.

View 7 Replies View Related

AutoCAD 2010 :: Convert Block Back To Title Block Or Border

Feb 15, 2012

We have a title block and border which is used in MS.  If this is referenced using AMTITLE then it acts as expected.  We issue these to some external people to create our drawings but they have been using CTRL-C and V to place them in a new drawing.  ACAD does now not see them as a Title block or border but as blocks.  We have a process to bring DWG's into SAP and this will check for a title block and border. 

The issue is we need to fix these drawings and currently this means removing the borders and title blocks and placing new ones then adding all the attributes again.  Is there a way to convert the blocks back to how they should be?
 
AutoCADM 2011 SP2
XP 32-Bit SP3

View 4 Replies View Related







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