AutoCAD LT :: Extracting Info From Attributed Block Into Spreadsheet
Dec 29, 2011what is the easiest wqy to extract information from an attrbuted block into a spreadsheet (excel)?
View 1 Replies
ADVERTISEMENT
AutoCAD Inventor :: Add Helicoil Tap Info To Thread Size Spreadsheet
May 11, 2007Is there a way that I can add helicoil tap info to the thread size spreadsheet so that I can use the data within the hole command and place helicoil-tapped holes into my models? I need some way to automatically flow the helicoil tap info into the drawing via a hole note.
View 8 Replies View RelatedAutoCAD Dynamic Blocks :: Send Info From Excel Spreadsheet Back And Forth Between A Drawing
Jan 12, 2012why I can't export the "Distance 1" attribute out of thsi drawing using the ATTOUT command. I need to build a series of constrained drawings using Dynamic blocks so I can send info from an Excel spreadsheet back and forth bewteen a drawing. I think I'll have to buy a 3rd party utility for that but for now, how to simply get the info out of ACAD and into Excel thsat would be a great start.
View 2 Replies View RelatedAutoCAD Architecture :: Attributed Block Insertion
Aug 11, 2011I am using ACA 2009 and am experiencing something new with attributed blocks. When I insert the block, a copy of the block is placed at what seems to be an arbitrary distance away. As I fill in the boxes for each attribute, it appears in the image away from the insertion point. After I am done, the completed block appears filled out where it was inserted. I have never seen this before. Is there a setting affecting this?
View 2 Replies View RelatedAutoCad :: Attributed Definitions Within Dynamic Block?
Aug 5, 2011Basically I have a rectangle and want to change the dimensions of it. There are a couple of attributed definitions that I want to stretch the and change it length but I alsowant the attributed definitions to move with the right hand side of the rectangle and the stay a constant distance from the right hand side. Unfortunately when I use the stretch action it filters out the attributed from the object that I can stretch, any way to include these AD’s with the stretch action
View 3 Replies View RelatedAutoCAD 2010 :: Dynamic Block With Attributed Text
Jan 17, 2012I have a dynamic block with attributed text that I want to remain horizontal right reading even when the block is rotated. I have set up the parameters and the actions how I was taught and even revisited one of AU's downloadable lessons to try to get it correct. my settings are the same as in the lesson. I have the rotate parameter / action set to only the geometry and did not select the attributed text. I also have the attribute locked. Nothing I do gets the text to rotate with the block and stay horizontal and right reading. It will either rotate the text along with the block or just leave the text stationary. I have tried adding a point parameter to the text but that doesn't seem to work either. I am using Base ACAD 2010 I have also attached the block for troubleshooting.
View 2 Replies View RelatedAutoCAD Civil 3D :: How To Get Point Marker With Attributed Block
Jan 24, 2013How do you get a point marker that uses a block with attributes to show the attributed text?
We are using tree symbols that have the size of the tree as an attribute, but when the points that use that block come in...the block shows up w/out any attributed text. Tried to edit the "block" or point marker with attedit command, but C3D tells me it is not a block. Understand that it is a "marker" for the point. But, what is stopping the text size of tree from showing up?
AutoCad :: How To Make A Pull Down Inside Of Attributed Block
Jun 11, 2013Is it possible to make a pull down inside of a attributed block?
For example: if I a have engineering code section of a title block and I want to be able to choose from a list of codes:
ASME A17.1-2004
ASME A17.1-2007
ASME A17.1-2010
ASME A17.1-2012
Can I set up the block to let me do that?
AutoCad 2D :: Number Of Viewports And Editing Attributed Block?
Apr 21, 20111) Problem about viewports :
I am using 2011, I have created 17 viewports in one paper space, there are 2 viewports not showing anything. I deleted 2 viewports with content, then the 2 viewports which were not showing is now showing images.
I started a new drawing, drew something very simple for testing, I could create 63 viewports the 64th is not showing.
I would like to ask what it is to control/affect the number of viewports I can create in one paper space.
2) To Edit an Attributed Block
When double click an attributed block (command = eattedit), the dialog box "Enhanced Attribute Editor" disappeared !
AutoCad 2D :: Scaling Attributed Block - Imperial / Metric Conversion
Nov 11, 2013I have the drawing I'm working on, who's scale is set to "unitless". I'm attempting to insert a series of attributed blocks (containing titleblock information) into the paperspace of my drawing. The attributed block is also set to unitless.
Two of these blocks require editing to suite the drawing, the other two are to be edited at a later date by a third party.
Everything HAD been working fine, however, it appears the wheels have fallen off ~ I'm now experiencing a periodic error where, I insert a block to the 0,0 at a scale of 1 (as per procedure) but the block comes in at a fraction of the correct scale. I have to scale the block up by 25.4. (The imperial / metric conversion.) (Note, I'm working in Metric)
Even stranger - its not happening on all blocks. Just the two that have to be edited "in house".
I've checked measureinit within the blocks and it is set to metric. I'm limited in my ability to purge / audit the drawings as they don't want template information deleted from the drawing - but I don't know what other system variables i should be looking at.
I'm using CivilCad 2012 with Windows 7,
AutoCAD LT :: All Text Including Information On Attributed Title Block
Dec 21, 2011This is the command line responce I get when i attempt to enter text. All teh numeric expressions of all my dimensions have been replaced with a backslash. Along with all text including infomation on the attributed title block.
I have exhausted my options for figuring it out, do I need to reload the program? is there a restore default option? ( I haven't found one yet) I am running 2011 LT
AutoCAD Civil 3D :: Marker Style Or Note With Attributed Block Text
Oct 2, 2013Is is possible to have an attributed block in a marker style or note style? I would like to have editable text upon insertion of the marker or text? I have tried unsuccessfully to get it to work. Does the fact that C3D displays the marker and note as objects prevent it from being editable? Is there a workaround?
View 1 Replies View RelatedAutoCAD Visual LISP / AutoLISP :: Changing Text In Attributed Block
Dec 21, 2012I am trying to speed up some basic drafting of text revisions. In the P (plumbing) we call out the fixture units for a water pipe, along with the fixture units, the pipe size changes.
Is there any way to add numbers in an attributed block? (I have a lisp that works on text & mtext, but not attributes)
1.1. Example: Like if you have a block with two attributed text fields, the 1st field {x} is a number (fixture unit), and the 2nd field {y} is a number (pipe size). I would want it to only add the 1st text fields. [If possible then change the 2nd text field according to a changeable chart. (see #2)]
1.1.1. This is how the block looks like: x (y")
1.1.1.1. x could be any number from 0.5 – 10,000 (only using 1 decimal place, and only as needed)
1.1.1.2. y could be any number from the following list: ½, ¾, 1, 1¼, 1½, 2, 2½, 3, 3½, 4, 5, 6
Is there a way like in excel that you can set up a formula that will give a numerical result depending on other input? Like pipe size that change depending on the number of fixtures. There would need to be two different formula, one for hot and one for cold values (The value would be set at the beginning of the job; typically these values would not change later in the job). This could be separate text or if possible using the attributed block as described in #1.
2.1. Example: Like if you have a block with two attributed text fields, the 1st field {x} is a number (fixture unit), and the 2nd field {y} is a number (pipe size). I would want it to change the 2nd text fields according to the value in the 1st text field. If the value in {x} is 0.5 – 1.0, it would result in ½; 1.5 – 7.0 = ¾; 7.5 - 17 = 1; 17.5 – 36 = 1¼; ect.
2.2. In excel it would be =IF(x)<1,"1/2",IF(x)<7,"3/4”,IF(x)<17,"1",…{all #’s in between} …IF(x)>5000,"6")))))
AutoCAD Visual LISP / AutoLISP :: Link Attributed Block With Polyline To Get Area
Sep 13, 2013I'd like to set up a blockwith different attributes like Roomname, Floor, Area,...
Therefore I'd like to link a polyline of the drawing with the block and it shows me its area. I know how it works with fields, but not how to connect it when the field is within a block.
Is there a LISP for that?
AutoCAD Visual LISP / AutoLISP :: Attributed Multi Block Insert From Custom DCL
Dec 27, 2011I have been working on an AutoLISP routine which is intended to:
1) collect input from the user via a DCl dialog box
a) Create a List of the non-null "GROUP_CODE..." variable values collected from the dialog's settings
b) Create a List of the "ESN***#_Part" variable values collected from the dialog's settings (does the List elements' order need to be reversed after collecting them?)
2) Prompt the user to select an insertion point
3) Insert a Block named "ESN-CONTROL-WIRED" which has multiple attributes
a) Apply the first List element collected at step 1.a above to the attribute tag "INPUT_ADD" in the block
b) Apply the first List element collected at step 1.b above to the Attribute Tag "PART_NUMBER" in the block
4) Insert a second instance of the Block named "ESN-CONTROL-WIRED" below the first instance
a) Apply the second List element collected at step 1.a above to the attribute tag "INPUT_ADD" in the block
b) Apply the second List element collected at step 1.b above to the Attribute Tag "PART_NUMBER" in the block etc. .... keep inserting the block "ESN-CONTROL-WIRED" below the previous on until all the input from the dialog has been displayed in the attributes.
Notes:
The Dialog's pop-up lists are populated from external .TXT files which reside on our network (or alternate local C: drive folder if no network drive is found)
Inside the file "ESN_SENSORS_NUMBER.LSP", it is the function "ESN_APPLY_TAG" which I am struggling with how to write...
find inside the .ZIP file:
- (2) example screenshot .BMPs showing dialog box settings and what the resulting output in AutoCAD should look like
- (1) ESN_SENSORS_NUMBER.LSP
- (1) ESN_SENSORS_NUMBER.DCL
- (1) ESN_SENSORS_NUMBER.DWG with a sample output - and the definition of the block ESN-CONTROL-WIRED
- (1) ESN-OCC.txt which populates the PopUp List Boxes
- (1) ESN-DAYLT.txt which populates the PopUp List Boxes
- (1) ESN-IR.txt which populates the PopUp List Boxes
AutoCAD Visual LISP / AutoLISP :: Inserting An Attributed Block Using Data From An External Source?
Aug 9, 2013I am reasonably experienced in coding in VBA but cannot find any references as to how to achieve the above within VBA so am now turning to LISP to see if I can achieve it in that language.
Basically I want to be able to create multiple instances of an attributed block using an external source, e.g. a spreadsheet to provide data for the attributes.
I'm not even sure if this is possible.
I can find lots of references for extracting attribute date to a spreadsheet but I want to go the other way!
AutoCad :: Title Block To Excel Spreadsheet?
Dec 3, 2013How do i create a spreadsheet for title blocks. i want to be able to fill in a spreadsheet and automatically fill in the title block....
View 1 Replies View RelatedAutoCAD VB :: Extracting Certain Block Attributes
Aug 21, 2013I'm trying to loop through all the blocks on a drawing and if the block contains a group of tagstrings (B,C,D and H) I want to then extract the textstring from all 4 attributes and place them in a ListView. I got it to work but it is not consistant. Sometimes it doesnt get all of the attributes. Basically just want to grab all of the blocks that the 4 attribute tagstrings (B,C,D and H) and extract their textstrings to a ListView. Here is the code I have so far.
For Each objEntity In objModelSpace
With objEntity
If StrComp(.EntityName, "AcDbBlockReference", 1) = 0 Then
If .HasAttributes Then
TableData = .GetAttributes
[Code] .........
AutoCAD 2010 :: Update Block Attributes In Drawing From Excel Spreadsheet
Oct 15, 2012I 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".
AutoCad :: Extracting Data From Block To Table
Jun 8, 2012Here is what i would like autocad to do
I work in architecture, and every time i create an opening (door, window) i add a block next to it with an attribute to the reference number
I was wondering if it would be possible when creating that little block to give it more information and later on extract the information from it to a table
Ex: door 106-02, steel finish, 3'x7' , isolated, steel frame, 2" thick etc.
AutoCAD .NET :: Have ObjectID Of Block Need To Retrieve Info
Sep 3, 2013I have stored within an external database a handle of an entity within a drawing. If I have that drawing open and I retrieve that handle and then get the ObjectID from that Handle how do I convert that to a BlockReference so that I can then get position and attrribute values. I can get the position and attributes if I can just get the blockreference from the Object ID.
I am using the following code to get the ObjectID from the Handle:
Public Function ObjectIdFromHandle(db As Database, strHandle As String) As ObjectId Dim nHandle As Int32 = Int32.Parse(strHandle, Globalization.NumberStyles.AllowHexSpecifier) Dim handle As New Handle(nHandle) Dim ids(0) As ObjectId Try ids(0) = db.GetObjectId(False, handle, 0) Catch ex As Exception MsgBox(ex.Message.ToString, MsgBoxStyle.Exclamation, "Error in ObjectIDfromHandle") End Try Return ids(0) 'Return db.GetObjectId(False, handle, 0) End Function
I then want to use this ObjectID to get the BlockReference.
AutoCAD Inventor :: Title Block Info From Excel Sheet
Dec 21, 2005I've created a custom title block. I'd like to use VB to fill in this title block using info obtained from an Excel Spreadsheet; Company Name, Location, Drawing Title, etc.
View 5 Replies View RelatedAutoCAD Civil 3D :: Adding Framework Info To Title Block?
Jul 12, 2012Is there a way to display the projection (FL-W83) or Datum (NAD83) of a DWG file in the titleblock? Maybe using fields, or a diesel expression of some sort? I belive the information resides in the .NET framework, how can I get that into my titleblock?
HP Z400 Workstation
Intel Xeon W3550 -Cores 4
12GB Triple-Channel DDR3 @ 533MHz
2-HP LE2201w @ 1680x1050
ATI FirePro V3800 (FireGL) (HP)
MS Windows 7 64-bit
AutoCad :: Using Xrefs To Fill In Title Block Info Throughout A Set Of Plans
Apr 15, 2011Our professor provided us with 3 dwg files that we are supposed to use for our title blocks on all construction documents. One is the title block file, one is a file with preloaded client info text and the other is preloaded with project info text. This includes dates(drawing, revisions, etc.), page numbers, sheet names, etc.
He explained how it's easier to xref all of these files into the paper space of our working files, but I don't understand how this is easier when every page has different information on it - in the very least a different page number and sheet/drawing name.
Is this a matter of creating a unique file for each page of our set of plans? This seems much more confusing that just inputting the text manually on each drawing.
AutoCad :: Attributed Text Shifting
Apr 3, 2012I am currently using AutoCAD 2011 but there is a couple in our office using 2012. When they open a drawing with attributed text it shifts the text, usually to the right. The text height stays the same as well as the vertical position. It appears the text letter spacing (kerning I think it is called) is adjusted to be closer and it shifts to the right. If I click on the text and then click on the grip for the text twice it puts it back to what it is suppose to be or was. This doesn't happen in any logical order it is random through out the drawings, making it harder to find and fix them all. I can save the file close it, re-open it and the text shift happens again, randomly.
We have only noticed this on drawings that have been opened with 2012. Is that a problem with 2012? Is there a fix for it? I found while GTS that someone clicked on the annotate>annotation scaling>sync scale positions so I tried that and it didn't adjust the text/attributes back to where they are suppose to be/where. The shift happens as stated while re-opening a drawing, also when doing a regen, I also noticed it happening while doing a simple copy/paste of a part that isn't shifting. I hope this makes sense as to what is happening, I would post a drawing but they REALLY frown on us "sharing" our drawings.
AutoCad 2D :: Attributed Text Updating When Reinserting DB?
Sep 6, 2013issue regarding attributed text updating when reinserting a DB. I have text override in a dimension, inserted a field into the text override but whenever I reinsert the block and change the values, the text does not update.
View 5 Replies View RelatedAutoCAD 2010 :: Attributed Text Style Change?
Oct 25, 2013Is there a way to change the text styles, lets say from "Standard" to "Romans", all at once within an attributed block, or do you have to update each tag attribute individually?
View 2 Replies View RelatedAutoCAD Inventor :: Update Attributed Blocks In Drawings
Nov 15, 2011I have recently been forced more to use customer supplied drawings in inventor that contain attributed AutoCAD blocks, I have been looking for a way to automate filling out these and add some consistency since they sometime ask for the same thing to be updated in several places. I have been using the "dwgblk.GetPromptTextValues(sTags, sAttr)" to get the values of these attributes but I don't know how to update the value from a property back into the attribute.
I have even thought about doing this in iLogic so that it would be easy to change from customer to customer.
AutoCad :: Extract Furniture Schedule By Using Attributed Blocks
Nov 16, 2012I would like to extract a furniture schedule by using attributed blocks. I would like attributes like Item #, Color, Size, Location, Description, Manufacturer, etc…. The problem with the data extraction system that I am having is that in order for a chair with a tag to be considered the same chair and be counted correctly all the block attributes have to be exactly the same/ match.
For example, if I have the same chair (CH-01) but the location of the chair changes, cad treats it as 2 different chairs.
AutoCAD 2013 :: Editing Attributed Blocks Causes To Disappear From Screen
May 3, 2013Editing attributed blocks causes them to disappear from the screen. Edits include changing attribute values, moving attributes, or moving the entire block. The block is not gone, so saving and re-opening the drawing will display it again, but this is a terrible workaround when moving and editing many blocks in a large drawing.
We do not use annotative or dynamic blocks, so these are just good old-fashioned attributed blocks.This behaviour is being seen on both Windows 7 and older Windows XP systems with various hardware specs, and it is only in the 2013 product. We still have some stations running Map 2012 that do not experience this issue even when working in the same drawings.
AutoCad :: Creating Border And Making It Attributed - Linking Text
May 1, 2012I am creating a border and making it attributed. I have the drawing number showing up in the title block and in the opposite corner of the page. I want to link the two somehow so that when one is edited the other automatically changes to match. Is this possible to do?
View 6 Replies View Related