AutoCAD Map 3D :: Create Blocks With Attributes From Attached MDB?
May 7, 2013
I have an access database attached to a blank drawing. The database is a list of existing oil wells. I want to have civil3d (or map) create a custom block (I already have the blocks created) inserted at a coordinate in the database and propagate the other fields in the database into attributes in the blocks. For instance, the first two fields in the database are the x and y. Some of the other fields in the database are the well status and company name. Is it possible for Map to read the first two fields to know where to put the block, then select the block to insert based on wells status and company name, and then complete attributes from the other fields (section, township, range, county, etc) into the block? I'm having a hard time getting my head wrapped around the map3d user's guide talking about topologies, link templates, object classifications, etc. Using Civil3D 2013 infrastructure design suite, Win 7 64-bit, office 64-bit.
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
I have an access database attached to a blank drawing. The database is a list of existing oil wells. I want to have civil3d (or map) create a custom block (I already have the blocks created) inserted at a coordinate in the database and propagate the other fields in the database into attributes in the blocks. For instance, the first two fields in the database are the x and y. Some of the other fields in the database are the well status and company name. Is it possible for Map to read the first two fields to know where to put the block, then select the block to insert based on wells status and company name, and then complete attributes from the other fields (section, township, range, county, etc) into the block? I'm having a hard time getting my head wrapped around the map3d user's guide talking about topologies, link templates, object classifications, etc.
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
I have a site plan with underground water lines on it. We had a surveyor go out and GPS where all the water valves are. I brought in all the survey points and put a block of a valve in all the areas that were surveyed. I created the block with two attributes.
1) Valve ID # (ex: 001) 2) Valve Size (ex: 8")
I would like to know if I can do the following:
1 - Highlight all the blocks and have AutoCAD create a table with the valve ID# and Size that I can export/copy/paste into excel.
2 - If I have accidentally number an abandoned valve can I remove that valve and then make all the blocks update themselves automatically. Basically they renumber themselves.
I have the AutoCAD 2013 Master Suite of Software's so I have every AutoDesk product there is. However I use AutoCAD 2010 and not 2013 (for production purposes)
have a question on if its possible to have blocks automatically renumbering themselves using block attributes.
For example I have 12 blocks numbered 1 through 12, I delete number 4 and I want the remaining 5 through 12 to shift down in value. Would it be possible to use block attributes to do this?
i am trying to restrict users from modifying certain attributes in a block,i can create the blocks with some of the attributes on locked layers, but then autocad pops up an annoying alert box, is there a way to disable this? the other option i can think of is to redefine the commands *ddedit, *attedit, *ddatte,*attipedit,
I am looking for a way to create a master list of construction notes then use blocks attributes with fields to link to that master list. That way if the master list changed the note bubbles would change as well.
Sheet sets are being used with this project but I can't think of a way to make it work with the existing sheet set technology.
I'm trying to get a dynamic block to rotate the attached attributes from a left justification in the vertical position to a center justification in the horizontal position. I managed to do this with 2 Visibility States, but anyway to do this with only the one set of attributes. I'm using AutoCAD 2012.
I have this Dynamic Block which has a few distance parameters on it and an attribute at beginning of each parameter which are attached to a stretch action. If manually bring the block in. And set a value to attribute and then stretch the it , attribute move along with action. But when I do it pragmatically it doesn't . Basically attribute stays at original location of original block before stretch. What is wrong with my code. Or Shall I do something to Attributes when I change the distance parameters in Program? I don't know .
I have a function which bring the block in and set attribute first and then another call which change the distance . So I don't show the first function which to me works fine . The problem is this part.
For Each myBRP As DynamicBlockReferenceProperty In myBRC For I = 1 To NumbderOfDistanceParamsinDynBlk If myBRP.PropertyName = "Distance" & Trim(i.ToString) Then myBRP.Value = DynDistancevalue(i) End If Next Next
I have a square with a solid hatch as a point, with a visibility on it, and a text attribute with a leader from the square to the atrabute. This is the part i understand. the part that is confusing is when I try to rotate the attributes arount the square, how to i keep the leader attached to the square, and still look like a correct leader?
I'm looking for a map tool that can convert feature data from an SDF file or SHP to autocad block's with attributes data. My client just want blocks with attributes and dont work with sdf or similares, they extract the attributes and then work them in other software, so, i wonder if there is a autocad map tool that make the conversion from feature data SDF to blocks with attributes, that will make the work mutch more easier and fast.
Other question relational with blocks. How can we link block attributes and excell in real time, where i could change cells data in excell and the update happens in the open drawing and vice-versa?
And would like to know if there is a way to make this happen without vba tools or lisp's...just with map tools.
some attributes you can double click and edit within the dialogue box, others you have to double click and they are greyed out in the box, you have to click the little button with ... on and edit in place on screen... why?
whats the difference between the block atributes? attached is an example...
I'm working on creating some blocks for our office. Basically it is a simple block with a few lines that remain and then a couple attributes you can click on and change. I have added the attribute and all is working well.
My only issue is I would like to make the text in the attributes to be bold. For some reason I can't see to do this. Is it not possible.
Basically I want to try and get some of the attributes to stand out more than others. I tried changing the color and the lineweight of the attibute (which worked the color is different) but when it prints it doesn't change at all.
I am looping over a set of 40000 entities converting them to blocks and adding 35 attributes to each block. Till here its fine my .net program converts to block and write atributes to each one of them in 2 hours. But after the program finishes and I try to save the file autocad takes ages to save the file and also it stops responding. Is autocad not able to handle 40000 blocks with attributes. I am using autocad 2013. The dll has been developed using visual studio 2010.
I am trying to create a dynamic block with two attributes, a double grid head, when I add a stretch parameter to the head it only affects the first assigned attribute.
I have added a stretch parameter to each attribute and only the firt attribute will move. What are the rules with attributes in dynamic blocks, the only thing I found was I have to lock posistion for attributes to be affected by the paramter assigned by the dynamic block.
I want to create a structure using the attached part geometry, what would be the best way to make the crosses coincident with the two long columns? (just like the 2 at the top but without having to manually trim each line, if it could be constrained to variable parameters even better)
The structure has the same geometry on all four sides so i intend to circular patern the frame generator components around the Z axis, any better workflows?
I have a large amount of P&ID drawings that have blocks with attributes. One of the blocks is missing an attribute field that I need so I recreated the block using the same name and added the missing attribute. When I reinsert the block and say "yes" to updating the block's definition within one of my P&ID drawings everything seems fine except when I try to edit the block to fill in that field.
The newly added attribute doesn't show up but when I right click one of these blocks and select Block Editor the new attribute field does shows up so the redefine did work I just can't use that attribute. Is this a bug in AutoCAD? How I can use this attribute?
Every time I try to update blocks with attributes of a given layout, this only updates the last active layout. example:
I have three layouts: Layout1, Layout2 and Layout3
layout of the three blocks I would need to update the reference but I can Layout1 default that always takes the last active layout. In the following paper space specific code, but as it would to tell a particular layout.
Private Sub UpdateAttributesInDatabase(ByVal db As Database, ByVal blockName As String, ByVal attbName As String, ByVal attbValue As String) Dim psId As ObjectId Dim tr As Transaction = db.TransactionManager.StartTransaction() Using tr Dim bt As BlockTable = DirectCast(tr.GetObject(db.BlockTableId, OpenMode.ForRead), BlockTable) psId = bt(BlockTableRecord.PaperSpace) tr.Commit() End Using UpdateAttributesInBlock(db, psId, blockName, attbName, attbValue) End Sub
I'm trying to set up a dynamic block with an attribute/field within it that the user(s) edit using a lookup table.
I understand basically that a field must be created as the attribute that then references a lookup table with the inputs listed. However, I really do not know how to create a lookup that has custom information such as below:
Site: Unit Code Site X 100 Site Y 200 Site Z 300
All I have seen explains how to create a lookup from an existing parameter (liner etc) and I don't seem able to create something specific to my requirements. I forgot add that I want the user to see "Site X", "Site Y" etc in the dropdown - but the attribute to reflect only the Unit Code.
I need to know if there is a way to link an attributed F-N bubble with qty's to the BOM. This is for electrical wiring diagrams for aircraft. So I have serveral part numbers to a BOM, but no real accurate way of finding total quantities other than manually going though the drawing.
I am trying to create an attribute that displays the product of an Area of an object in the block and the value of a different attribute. For instance, here is what makes up the dynamic block:
1 rectangle (with width and height parameters and stretch actions) 1 Attribute called "ForcePerSQIN" - the value of this is entered separately for every instance of the block by the user 1 Attribute called "Total Force"
In the "Total Force" attribute, I want to create a field that contains a formula to multiply the area of the rectangle (which I am able to obtain with no problems using the Area property of the rectangle object type) by the value of the "ForcePerSQIN" attribute, which is user-defined. The problem I have is that it appears as if the value of this attribute is treated as text and thus cannot be used in the calculation; I get ######.
Is there a way to make the "ForcePerSQIN" parameter treat the user-defined value as a number instead of text so that it can be used in the calculation? Or is there a better way to accomplish my ultimate goal?
I have been making blocks Annotative by using block Editor. I would open block Editor and change the block property to annotative. When I do that I notice that the block's attributes become unreadable. The block's attribute appears to become so squished up the I can't read it. I have tried to change the attributes width to make it readable but that does not work.
At each projects, i need to copy and paste the values of attributes of all instances of a type of block in my drawings, paste them in a excel sheet, it take so much time and is possible to make errors.
Is there hints to read a DWG as a text file and retrieve the attributes values of all these blocks ? I would give special names to these blocks, and also specific quantity of attributes, to work.
I meant Excel VBA, not AutoCAD VBA, cause i will manipulate excel sheets depending on the results.
I am looking for a macro that can edit the default value off the attriburte for each block in the drawing. The new value must be empty.
But there is one exception. When the length of the current value is equal to 8 then the macro's has to do nothing and the macro must continue to the next block.
Just wondering how I would return attributes of blocks in my drawing's XRefs?
I've come across one example that is in VB but no luck.
I currently have a list in a form that consists of all the XRefs in my drawing and I wish to return all blocks and attributes that are linked to the selected XRef.
I'll try to import a text file with a string: pointnumber, easting, northing, elevation, discription, but I get very big blocks and attributes in my drawing. I use Autocad 2011 Map 3D, on a windows XP OS. I'll importing the text string with the import command. Easting and Northing are for the position. The Elevation, pointnumber and discription are attributes from a block. I can only choose a block: "Map_Survey_point" This is the only block I can choose. When I import the text, the scale from the importing blocks are too big. How can I change the size of the block and attributes?
I just have a quick question (hopefully) about an activity I want a Dynamic block to perform.
I have a simple electric switch block (a line with an S over it), that in some cases is enclosed by a simple rectangle. When the switch is enclosed, I'd like the attribute to move further, to keep the spacing the same.
Is there a way to make the attribute move automatically with the display of the rectangle, maybe through some combination of Linear Move parameters, Visibility parameters, and a formula?
Is it possible to increment text or attributes in a dynamic block? I'm want to create elevation text for grids that can start at a certain value and increment up or down from there.
I have a drawing with a bunch of blocks. the blocks repeat themselves, but I need to define different attributes to each one of them and then being able to extraxt a list that I can read in excel.
I'm working on a dynamic door block, which allows me to add some height and width values to the door. everything works fine when I put in the attributes right away when I insert the block. Only if I want to mirror and stretch the block before I enter the values they want move to the correct position. After I run "attsync" it moves to it's correct place.
