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
ADVERTISEMENT
Jul 19, 2012
way I can link my AutoCAD title block attributes to excel and make changes in either excel or AutoCAD and then be able to run an update? The attributes would be “REV” “DWG_NO” “TITLE” “LOCATION” “DRAWING_SIZE” and “FILE NAME”.
View 4 Replies
View Related
Oct 15, 2012
I have a basic floor plan in AutoCAD 2012 that has blocks in specific locations which contain personel data....name, phone, computer tag, desk key numbers, etc. I extracted the data to an Excel spreadsheet and I thought set up a "data link". But I don't know how to make the data update.
My problem...moves of staff, phone, computers are often made, but no one lets me know about it until they want a new floor plan printed and the computer and key tags get so messed up from the moves that it can take me hours to fix.
My goal is to be able to have our secretarial staff update the spreadsheet and in turn update the blocks in my AutoCAD drawing when it is opened and/or "updated".
View 3 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
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
Jul 7, 2011
I've got a block with multiple attributes. This is not a problem to redefine the blocks attributes.
Some of the attributes contains dynamic fields (blockplace holder x y z parameters) When i insert a block with such atributes that includes the blockplaceholder dynamic fields i get
X: InsertionPoint => It is recognized as an Dynamic field but displays InsertionPoint. and does not update the value.
How can i update the fielddata from vb.net?
Part of the code I use (where i think the problem is)
For Each attid As ObjectId In refbtr attent = tr.GetObject(attid, OpenMode.ForRead) If TypeOf attent Is AttributeDefinition Then Dim attdef As AttributeDefinition = attent Dim attref As New AttributeReference() attref.SetAttributeFromBlock(attdef, myBlockRef.BlockTransform) Dim attrefid As ObjectId = myBlockRef.AttributeCollection.AppendAttribute(attref) tr.AddNewlyCreatedDBObject(attref, True) End IfNext
View 6 Replies
View Related
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
View Related
Jan 31, 2012
Running a Query that inserts a block with attributes filled with text derived from a file that has a large set of polylines with object data (text)? Is it easier just to insert this object data as text with a query. Or can I place this object data (text) into a block that inserts?
Example:
- You have land locations defined within the object data assigned to a set of closed polylines. (Large subdivision)
- Field name for object data on each closed polyline is "LAND_LOC"
- Now, I'd like to label these locations with a block that inserts to a central point within the closed polyline.
- Block Attributes with "get" the information from the polyline / object data and place this value in the block attribute.
- I have 1 drawing file that has closed polylines with object data assigned to them.
- What is the best method for this? I'd like a block with attributes to insert and pull the object data / field and place it into the block with a defined attribute, that is central to each of the closed polylines. (LAND_LOC)
View 2 Replies
View Related
Jan 23, 2012
From the attached image you can see what I'm talking about.
(left=original, middle=ROTATE, right=PROPERTIES)
When I rotate blocks using ROTATE command everything is fine, but when I rotate blocks using PROPERTIES my attributes get messed.
I need to rotate several blocks at once with PROPERTIES, because I don't have time to rotate each one separately.
The same thing happens when scaling blocks, but this was resolved using the command BSCALE in the command line.
View 5 Replies
View Related
Mar 1, 2014
Without using scripts, is there any way to have rectangles or textboxes act on values coming from a data file? For examplle if the value in a textbox was greater than 10 coming from a data record, could the textbox change color, or any other attribute to make it change from record to recortd as it is being viewed or printed?
View 9 Replies
View Related
May 9, 2013
I have a program that I used years ago to extract attributes from AutoCAD into excel. The VBA program is in excel. It is Attribute extraction Utility for AutoCAD Release 14. I want to use it again for 2014 but when I run it I get a compile error can't find project or library and it highlights the the following code "set doc = ACAD.ActiveDocument". Below is the entire VBA sub routine.
' THIS EXTRACTS THE ATTRIBUTE VALUES FROM AUTOCAD TO EXCEL
Sub Extract()
Dim sheet As Object
Dim shapes As Object
Dim elem As Object
Dim Excel As Object
Dim Max As Integer
[Code]...
View 2 Replies
View Related
Nov 30, 2006
I work for a company who's trying to automate the production of their mechanical and electrical cad drawings. We eventually want to integrate this into our website, so that a customer can select a few options, and a detailed drawing is generated based on what they pick.
To begin with, I'm trying to integrate AutoCAD with MS Excel. I've managed to automate in excel the options a customer can choose from. Now, the tricky part is, how can I transmit information to AutoCAD to perhaps pick blocks and strategically place them in specific locations of the drawing.
For example, if I have the option of Cats, Dogs, Elephants and Monkeys, and I have the option of quantities... 1, 2, 3, 4, 5, and I pick 3 Monkeys and 2 Cats, I want CAD to be able to place 3 monkeys and 2 cats side by side in a row.
View 9 Replies
View Related
Feb 14, 2013
Is there a way to create a block with attributtes that automatically complete x, y, z, lat, long for the insertion point of the block?
I am trying to complete text in paperspace that will automatically fill in the lat long of a point in model space without using a table. I have tried field insertion with reference to a cogo point, but it doesn't give options for position on a cogo point. If I pick a block with attributes, it will let me pick any attributes, and x,y position for the block.
Cogo points show all the information I need to propagate in the properties....but how do I get that to translate into the text using fields or some other method?
Dell Precision T3600 - Windows 7 64-bit
NVIDIA Quadro 600
Intel(R) Xenon(R) CPU E5-1607 0 @ 3.00GHz 3.00GHz
8 GB ram - Two 1TB raid
View 9 Replies
View Related
Oct 26, 2012
When the block is in a drawing and I click it, it takes me to block editor.
However if I go to it in block editor and test block it allows me to change the attributes.
Why does clicking the block go to block editor and not allow me to change its attributes as it does when I test block.
View 9 Replies
View Related
Oct 31, 2013
I would like to change sub block from a visibility after setting it. Here an example of code to get the right visibility, I don't really know how to update a sub block by name or by handle(seems to change inside dynamic block).
Dim Block As AcadBlock
Dim BlockRef As AcadBlockReference
Dim DynEntBlock As AcadEntity
Dim DynObjRefH As IAcadBlockReference
[Code]........
View 9 Replies
View Related
Aug 25, 2011
I'm trying to figure out a way to do the following:
I have several drawing files in DWG. Each DWG has a block placed in a drawing sheet. The block contains attributes which would like to link to an Excel file.
Then if I update the attribute in the drawings this would change the linked attribute in the Excel file, and vice versa.
Note that there are several drawings which I would like to handle in a single Excel file.
View 3 Replies
View Related
May 27, 2011
I am extracting attributes from an AutoCAD 2011 drawing into an Excel sheet using EATTEXT. I am then manually adding columns to the Excel sheet. How can I update the Excel sheet with new attributes values later on without overwriting the modified sheet and losing the added columns?
View 2 Replies
View Related
Apr 8, 2013
I can insert a block with block attributes using the Inter op very easily:
Dim theBlock AsAcadBlockReference
Dim pickScreenVBA = myDoc.Utility.GetPoint(, "insert the hydrant")
theBlock = myDoc.ModelSpace.InsertBlock(pickScreenVBA, "Hydrant", 1.0#, 1.0#, 1.0#, 0)
Dim varAttributes AsObject
varAttributes = theBlock.GetAttributes
varAttributes(0).TextString ="3 Ports"
varAttributes(1).TextString ="Salt water"
Works great, but when I try using the non-inter op, all the example insert new Attributes and not add block with existing attribute (so I end up with duplicate attributes for each block - i.e "Salt water" attribute is added to the block each time I run the code),
Are they any examples that does the same as above using the non-interop code?
View 2 Replies
View Related
Dec 12, 2013
I'm trying to add some attributes to an existing block using the block editor, but after I save and close it I cannot see any 'placeholders' despite adding a default value and the attributes work fine when I double click the block.
I've tried using the ATTSYNC and BATTMAN commands but nothing works and there are no invisibility states applied to either the attribute or block and all layers are switched on.
I just tried making a quick block from scratch and it seems to have the same affect, except the default value will show, but no 'placeholder' shown if left blank.
I swear with previous version I could see the tag when a value hadn't been applied, so is it that the version I now use (2012) does not have this feature or it's disabled?
View 9 Replies
View Related
Sep 19, 2011
I'm trying to chnage the text of the sheet number and total sheet number attributes for each layout in my drawing. I have code that adds and deletes the specified pages, now I need to edit the attributes to reflect the correct page and correct total amount of pages. Here is my code, based on my old VBA version.
I know there is a problem with the line:
For Each item In myBTR.ObjectId
I've used a number of websites and books, but I would really like to find something that teaches about block tables, block table references, block table IDs so I can get a better understanding of breaking stuff down to get the info I need.
Public Sub updatePageNumbers()
Dim myDWG As Autodesk.AutoCAD.ApplicationServices.Document
Dim myDB As Autodesk.AutoCAD.DatabaseServices.Database
Dim myTransManForPageNumbers As Autodesk.AutoCAD.DatabaseServices.TransactionManager
Dim myTransForPageNumbers As Transaction
[Code]....
View 6 Replies
View Related
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
Dec 13, 2012
using AutoCAD 2009 (vanilla)
I got too smart for myself today in bringing an old drawing up to current standards...Everyone seems to want their block attributes to be zero - I have blocks where the attributes are best when they match the rotations of each blocks.
I have an old drawing that was rotated (as it should be) at approx 2deg.
I used a lisp routine to global edit all the blocks that needed to be at zero. BUT for some reason (and after hundreds of blocks were corrected), I noticed I now have two blocks that should NOT have been in the set have had their attributes rotated to zero....and the attributes should be at the same rotation as their block's rotation.
Because those two blocks have a fixed tic mark, I can click on the mark to see what the block rotation is, then rotate its attribute to that rotation, but I have hundreds of blocks! One-at-a-time sucks....
Any chance there is a GLOBAL way to edit an attribute rotation to match its own block's rotation?
View 2 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
May 18, 2013
this dwg file data reading with c#?
View 9 Replies
View Related
Sep 15, 2011
I have been asked to write a module that will export layer data from AutoCAD and put it in an Excel spreadsheet. The user wants to have this done through a macro. I am assuming that I need to create a dll that is called from inside AutoCAD but I am not sure.
They want to start with AutoCAD 2008 and once we get it working there we will convert it to 2011 or 2012.
First of all, I can not find the 2008 API and second of all I'm not sure where to start. I am very experienced at programming. We are going to use VB.NET.
View 9 Replies
View Related
Nov 1, 2012
When trying to insert a table linked to an Excel 2010 file, it works up until row 28, however, as soon as I add a 29th row to the table it no longer inserts the table. When I try and insert it, I press ok and nothing happens. I tried inserting it as a smaller table and changing the data link to a bigger range after it was inserted, it just didn't update to a larger range.
Is there a way of getting this to work without having to insert it as two different tables?
View 2 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
Jul 24, 2012
Can you take text from a drawing and export it out to excel? My thoughts are room numbers, employee names, department names, etc.
I need an excel spreadsheet showing this information to then upload to my CAFM Application? Is there an alternative to obtaining a report from a drawing?
View 4 Replies
View Related
