AutoCAD 2013 :: Exporting Attribute Data From Blocks
Feb 14, 2013
I wanted to get a few opinions regarding exporting data.
We are working with AutoCAD 2013 Vanilla.
We have dynamic blocks with attributes that contain the block Name, Size, Color, material etc...
What is the best way to export the information?
Schedule and linked to a spreadsheet?
(I have experience with schedules but not so much with linking to spreadsheets)
DbConnect? (I know very little on this)
Another way to ask the question;
What is the best way to export the data that I can successfully train 20 designers on how to do it correctly.
So part one is determining the best method,
part two is training a group of designers to use it correctly.
I worked on getting a schedule out and linking to a spreadsheet but even after talking to my reseller support I feel that is too cumbersome. I would like a more streamlined process, you know the one, click here and presto!
View 3 Replies
ADVERTISEMENT
Nov 19, 2013
I need to create a small table to ID the User, Computer name, Door Key, etc for a floor plan drawing of our office. I'd like to get this done in Excel and link it all so the bldg manager can make changes to the drawing without me. I have created the excel file and created a "name set" in excel for each room. In Autocad 2013 I have inserted a table from a data link and pointed that link to the named range of the room (the named range in excel is an 8 cel block with al the info I need repeated and uniquely named for each room.
This works great...so my next step is to create a block out of the table and make the DATA LINK a variable attribute...that's where I'm stuck. i cannot figure out how to do this. I would love to be able to INSERT BLOCK and have one attribute question...ROOM NUMBER?. That should look to the excel NAMED SET the corresponds and populate the table.
View 1 Replies
View Related
Mar 26, 2011
Seems like Multi-View Blocks are like that hot red-head in high school that you really want to get to know until you get to know them.
I made a bunch of blocks for my electrical plans. Annotative symbols for plan view, 3D blocks for model view, and elevation blocks for elevations. I then started creating the MVBs.
Upon insertion the annotative blocks appear super small and the model view blocks scale way up. The model view blocks are not annotative and are not supposed to scale at all. It seems MVBs see any block inside that is annotative as an indication that the entire MVB shall be annotative. Fustrated, I finally found a work-around that is a bit half-arsed:
I made another block as a sort of holder for the annotative symbols that was set to not be annotative and inserted that into the MVB. VOILA! the MVB itself doesn't scale, but the annotative symbol inside the non-annotative block does. This works fine except for one caveat: I can't edit attributes that are in blocks inside of blocks. If I made another block to use in the MVB for the attributes, it would work, so long as I don't make it annotative, which isn't what I want.
So, A) is there a better work-around than the block-in-a-block-in-a-multi-view-block method, or B) Is there a way to access and edit attribute data of sub-blocks inside a MVB?
Maybe my next thread will be about red-headed Multi-View Blocks with carpets that match the drapes.
Edit: Running ACA 2009
View 5 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
Feb 27, 2013
I've got a block that I want to scale in pspace, but I would like the attrib height to remain constant even at different scales. I have used annotative blocks in vports with much success, but I would like to do the same thing only in pspace.
View 8 Replies
View Related
Aug 8, 2013
When exporting from AutoCad to pdf, from paper space, my blocks come out looking strange. I was having the same problem with text but fixed that by converting to Arial. I am exporting to an Arch E size. I have found that when I am zoomed out to show my entire campus, this is when I my problem occurs. When I am zoomed in to show a specific area, export is fine.
Using AutoCad 2014. Files saved back to version 2010.
View 3 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
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
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
Jan 24, 2012
I have the same block repeated multiple times in a drawing, and I want to delete the last attribute in all of the specific blocks. When I edit the block in block editor, the attributes do not show up. After I explode the block, there is no text. The attached image shows the properties of the block.
View 9 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
Jan 26, 2012
knows a lisp to extract each attribute value from multi-entity single layer blocks to respective different user-named layers? Say tag1 value to layer1, tag2 value to layer2,entity1 to layer-entity1 .The source blocks are all in one layer containing texts and symbols/entities.
[URL]
View 0 Replies
View Related
Sep 14, 2011
I want to make a block with an attribute. But over the attribute I want to make a hatch. So at the place of the hatch the attribute shouldnt be visible. When I make the block AutoCAD puts the attribute on top. Is there a way that the hatch will be on top?
View 2 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 25, 2011
I have an attribute definition and I need to add its value to an mtext. I added it in mtext insert field it is ok, every thinks work fine it is only needs a regen but it is not a problem.
The problem is when my mtext and att in a block regen does not work in model space, I had to enter block and regen. Is there any way to do it without entrance in block editor?
I attached a simple example.
View 1 Replies
View Related
Nov 4, 2011
How do you edit attribute tags (only) and retain the values of the attributes? When I try to redefine a block the attribute values change with ATTSYNC.
View 1 Replies
View Related
Nov 7, 2013
Using Enhanced Attribute Editor one can set attribute text rotation to 0 when the block is rotated. But it must be done for each block individually. Is there a way to do this for several blocks at the same time or globally?
I know making block or text annotative does it but it requires redefining block, something I do not want to do.
View 7 Replies
View Related
Nov 10, 2011
I need a rectangle block which on insertion prompts me for some data (name/tag/item number) and then displays it (this I can do). This is al pretty straightforward. But I also want to be able to fill in width and height and then have the block stretch to the correct size. So basically what I think I need is to have the value of a parameter refer to the value of an attribute. I've gotten it to work the other way around, where the attribute displays the size of one side of the rectangle (after stretching and regenerating), but I'd really like to have it working the other way.
View 4 Replies
View Related
Mar 6, 2007
I've created a dynamic block with two visibility states. The second state is a copy of the first state, but some of the attribute definitions have been moved, along with some of the geometry.
When I insert the block, then toggle between the two visibility states, the geometry changes as I would expect, but the attributes stay in the position dictated on the first state.
How can I make sure that the attributes move for the second state, as I need them to.
View 9 Replies
View Related
Oct 17, 2011
ACAD LT 2006
I have various blocks with a letter assigned to them as a type. Problem is that some blocks are the same one but have a different letter as an attribute.
Is there a way to extract the number of blocks by a different attribute?
View 0 Replies
View Related
Sep 24, 2012
making dynamics blocks and more over utilizing the attribute feature but I have discovered some chnages tat i need to make.
My question right now is, once an attribute is created and put into the block editor is that it? Ifi need to edit it can i edit it? I don't really see an option or command right off that would allow me to do this ?
View 1 Replies
View Related
Sep 26, 2012
I have imported a shp to dwg. it has the object data attributes.
Suppose I have a point for cities shp imported to dwg. The attribute has name of the city. How can I display the name of the city to each point on the layer of dwg file.
View 9 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
Oct 24, 2013
Is it possible to embedd data in a table so that a user can select from a group of data within one cell?
I use this technique quite often in Excel. One cell in a table can have various values: A, B, C, or D. While another cell can have a different set of values to choose from: BLUE, RED, ORANGE, or PURPLE. The user can pull down an arrow (similar to a dynamic block) and choose from a set list of values.
View 2 Replies
View Related
Aug 27, 2013
I am trying to set constraints to this block and having some issues. I want to constrain the attribute text so when I stretch the block from the grips the text centers itself automatically within itself. The constraints will not let me pick the grip on the attribute text as a point.
View 2 Replies
View Related
Jan 27, 2009
I've built this nifty block for holdowns, but the attributes get all goofy on me when I use the flip command. The problem is that the justification of the attributes does not change when they are flipped - so if I modify the text in the attribute while the block is in the FLIPPED state, how to modify the justification?Check out the attached file to see what I'm talking about. The block instances are numbered so you can follow along:
1. block is inserted
2. attribute text is modified in NOT FLIPPED state - everything is dandy
3. block is flipped
4. attribute text is modified in FLIPPED state - text justification is jacked up
5. block is flipped again, in order to demonstrate the continued jacked-uppedness of the attribute
View 9 Replies
View Related
Dec 17, 2012
What I'm trying to do is have a graphic scale with a set list of scales the user can pick from. This was easy using the Visibility Parameter.
However, I want to add a "custom" vis state where, once they select this option, the attributed definition box will pop up and give them the option to input whatever scale they are using.Check out the attached .dwg to see what I've done so far (I just have the attributes on the "custom" vis state).
View 7 Replies
View Related
Jan 4, 2011
I have stored a few blocks in our library in 2D. They contain attributes such as detail numbers, elevation/sheet numbers, and side attributes for keynotes. But whenever I drag the blocks in now, instead of prompting for the information to be filled out for the attributes it only asks for insertion point and scale and that's it. it inserts the block but no text shows up, not even a default text. There has to be a setting to turn off or on.
View 4 Replies
View Related
Jul 2, 2013
Fairly versed with Dynamic blocks here, so the first thing I checked was to make sure that my FIELDEVAL was set to 31 to ensure updates but this one isn't working for me and may be a limitation of the software?
I'm making a dynamic block for my users who aren't familiar with electrical wiring so I am developing a series of blocks for our typical wiring configurations. In this instance, I've setup a pair of attributes to allow the changing of wire color codes and I want to use that single attribute entry to used in multiple other locations that are also connected to that conductor in certain situations. I have setup a field within this block to be the "VALUE" of the object (the attribute) in order to accomplish this. Unfortunately it is only displaying the default value I have for the attribute and will not update either upon insertion of the block or after an edit. Is this beyond the capabilities of Dynamic blocks or do I need to take a different approach?
Find file attached.
View 5 Replies
View Related
Mar 23, 2012
I have a attributed block with multiple attributes (called pkey). In some cases these block attributes will the same values save for one, "Total".
example:
pkey #1
Value AA, Value BB, Value CC, Total 20
pkey #2
Value AA, Value BB, Value CC, Total 30
Is there a way by which I can have AutoCad group these blocks together (when extracted into a table for example) and have the SUM of those "Totals" added together to produce a result such as:
Value AA, Value BB, Value CC, Total 50.
I've explored using fields, but I don't think they work in this case, unless I'm using them wrong.
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
