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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Feb 28, 2012
Is it possible to create a text block attribute in part sketch mode?
View 2 Replies
View Related
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
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
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
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
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
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
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
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