Here 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.
I have created a sample drawing, to illustrate to the design manager at work that we can use AutoCAD to assist us with the scheduling of materials, but I am unsure of all the ins and outs of it myself!
See attached drawing to make sense of the following:
Ordinarily we would use a panel reference number for all 50mm panels of identical length, i.e., all 1200mm panels (our standard width) will be assigned a panel code, often P01... etc etc. From the data extraction (EATTEXT) command, as you can see, all 50mm cleanroom panels under the 'name' column are according the block name, in this case, I've called it "Cleanroom Panel 50mm". Is there any way to assign an individual tag to all panels of equal length, yet maintain the same block - or is this simply asking too much?
The reason for this is that although the autocad generated table is ideal for quantifying and placing orders for materials, we are a design and build firm, all our construction workers will need to be able to identify where on a plan an individual panel is, i.e., all well and good to say one panel is 332mm long, and one is 350mm long, but he will need to know what panel is to be installed where...
how to extract geometrical data (lenght, width, height) from 3d object to a tab or an external file?
View 0 Replies View RelatedI have been asked to write utility that will open a DWG file, retrieve layer data from the file and put it into a spreadsheet.
I know nothing about AutoCAD but I have been reading on this forum and gathering information. I have found that I have to write a dll that will be used inside of AutoCAD. Here is what I have so far:
1. I have AutoCAD 2008 (will convert to 2011 or 2012 later)
2. I have .NET Framework 4.0
3. I have Visual Studio 2010 Express
4. Needs to be done using VB.NET.
I need to do this using .NET.
Do I need the 2008 API?
Could this be done easier using VBA?
Once I create the dll how do I use it inside AutoCAD?
How do I grab the layer data for studs and braces?
I am trying to import a Shape file and extract the attribute data associated with the 'lines' (sewer pipes) into text format.
for example a pipe has an attribute showing the pipe diameter and intead of having to manually type it out I would like a way to extract that information.
Is there a way to do it? Whether using a specific method during the importing of the Shape file or another process?
*I use AutoCAD Map 3D 2011.
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.
I have been through all of the system variable field sources but cannot find one that stores the scale of a viewport. I want to add a field to my drawings that prints the viewport scale and updates it automatically if and when I change the scale.
View 3 Replies View RelatedIs it possible to add data to a feature data table? Example: The shape file data downloaded from NRCS only has the Soil number for the State. As I check out features I would like to add data for the soil name, soil group, etc. as additional columns in the data table and have it available in the future by checking the feature back in to my local information.
View 2 Replies View RelatedWe have a custom LISP program (Written, upadated in 2003) that takes a keyed in item number, opens and searches a .txt file with four coulmns, for the keyed in item number (column 1) and returns a part number (column 2), description (column 3) and any information in column 4.
Here is the Part of the cod in question:
(setq recx (open "H:/ACAD2012/alcocustm/LISP/hardware.txt" "r"))
(setq d "?")
(setq rec (read-line recx))
[Code]....
A quetsion was asked if the data in the .txt file could be put in an Excel file. I tried looking at other post, but I can't seem to find a clear cut way to open and extract the data. Or this old dog overlooked a boand. Is there a easy way to do this, similar to the above?
I'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] .........
what is the easiest wqy to extract information from an attrbuted block into a spreadsheet (excel)?
View 1 Replies View RelatedWe use a number of blocks with block tables for data extraction here, and whenever one of the blocks is modified and updated, all of the block tables reset to the default value. This happens for any block reference change, not just changes to the block table (which makes sense that it would reset).
How can we update these blocks without having to manually change all of the block tables afterwards?
My boss gave me a copy of Autocad 2012. I've messed around with architecture 2010 before so the ribbons are no surprise. One thing I have noticed that's really different is the dynamic block constraints & block table actionblock properties table? I looks very similar to the lookup property table
View 0 Replies View RelatedI was wondering if there was a way to extract data from Excel to be used in Illustrator. I know there is an option of variables and xml, and I don't want that. I've seen and tried out how to read illustrator and write to excel, and I get that. What I would like to do is pretty much the opposite:
1.Pre-fill in an Excel file(.xls,.csv, doesn't matter) with data such as a filename in column 1 and (Replacement Text) in column 2 and close manually.
2. Run script(VBSCRIPT,Javascript, doesn't matter)
3.For each column in Excel file where cell in first column is not empty, open Illustrator Template with placeholder of "DWG" textframe and replace the frame titled "DWG" with Replacement text from Excel in Column2.
4, Save each to a PDF file and name file with text from Excel Column1(Filename)
In a nutshell, there will be a single illustrator template with a premade textFrame with a name of "DWG". Excel will contain two columns, one for the filename to be named and one for the relative text to replace with the placeholder in AI.
It's about "Block Properties Table",I want to use a Block Properties Table to manage a Dynamic Block.
I have defined a Dynamic Block a and its Block Properties Table in Autocad2010,this is the screenshot of the Block Properties Table(a1:d1=100,d2=200;a2:d1=100,d2=400;a3:d1=100,d2=600.) Now I want to insert the Dynamic Block using .NET API.after I input a command,the block of a2(d1=100,d2=400) is inserted. I have the code about it, but the code is not complete. this is the Dynamic Block
this is the the screenshot of the Block Properties Table .
the result:
the code about it:
[CommandMethod("readBlockTable")]
static public void CmdReadBlockTable()
{
Editor ed = Application.DocumentManager.
MdiActiveDocument.Editor;
// select a block reference
[Code].......
So I'm creating a block with a block table and constraints. The constraints such as Geometric Constraints work just as assumed. When adding in dimensional constraints we start to have more fun. So I have dimensional constraints that use other dimensional constraints to manipulate itself.
EX. dimconC = (dimconB-dimconA)
dimconA is 12
dimconB is 14
dimconC would be 2
Now when ever dimconA or dimconB change dimconC would populate accordingly.
With this I wanted to make an attribute that could be placed in instead of a dimensional constant.
EX dimconC = ((Att1*dimconB)-dimconA)
Att1 is 02
dimconA is 12
dimconB is 14
dimconC would be 16
However when trying to place in formula that references a attribute I keep getting an error "A DEPENDENT EXPRESSION CANNOT BE EVALUATED" So I assumed it was missing an expression from the attribute, however once entering an expression in for it I still get the same error.
(full error message attached)Constraint_Error.JPG
Is this something that is not allowed at all or have I over looked something?
What are all the block table records?
I've got Model Space & Paper Space(Or Layout Space) under control.
I've got two block reference instances of the same block on a drawing.
If I purge the Drawing the older duplicate block reference disappears.
7867 is the older reference that disappears when I use the purge command.
78A7 is the newer reference, I only want to see this one on my extraction of attributes.
What property of the block reference will tell me that it would be purged if I used the purge command?
As I want to detect what's the old block and which one is the current block reference.
The problem is I only want to extract the attributes from the newer block reference.
The old block reference is coming up... how can I filter that out of my loop results?
I know I could just purge the drawing and my problem would be done with.But I need to do this in a manner that only accesses the drawing from a read-only manner.
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.
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.
Is that possible to read the Autocad Table data , without opening the Autocad from VB.NET. I tried with opening one autocad then loading the source dll. it was working perfectly.
But i need to without opening a application its possible or not?
How can I Get table name of the object data of a selected layer, with C#.
View 4 Replies View RelatedI am working on a co-ordinate utility that utilises data extractions. I am able to extract the data that I want to an XML file, but how do I create a dxe file and link it to a table? I have found the WizardSettings has a table style, but that is as far as I have reached.My code is below.
using Autodesk.AutoCAD.ApplicationServices;using Autodesk.AutoCAD.DatabaseServices;using Autodesk.AutoCAD.DataExtraction;using System.Collections.Generic;using System.Data;using System.IO;using AcApp = Autodesk.AutoCAD.ApplicationServices.Application;namespace acmCoordinates { public class DataExtraction { const string outputXmlFile = @"c:empdata-extract.xml"; public static void.
[code]....
Most people that I work with don't use autocad map, they use the regular Autocad. So they can not access the table data of my vectors. Is it possible to transform the table data that I choose and place it as text in the appropriate place ?
View 2 Replies View RelatedI have a table in excel and I'd like to have text in cells link to nodes on a map.
i.e. I have the traffic volume of a road section in a table. I'd like to show that volume on a map beside a circle where the count was taken. I'd like to be able to update the table value and have it also update on ythe map.
If it is possible to plot points (or a PLine, or a mesh) in AutoCAD from a table of values in EXCEL (columns of x,y,z coordinates).
View 8 Replies View RelatedI am using data extraction and data linking to an excel file to count blocks and list details. I need to be able to update automatically and the most trouble I have been having is that I need the images of the blocks to come out in the table as well. so far only have been able to get the text data to come out in the table.
View 3 Replies View RelatedI am having problems regarding Data Table Types.
I utilize Excel to build BOM's. I import them through data connection, I than will tell it which cells are Headers / Data / Titles. At which point text sizes / styles ... are applied.
Problem,
I have a cell that is enlarged with small text in the middle. I can orientate the boxes to increase in the Vertical or Horizontal directions larger than the original Excel Data File but i cannot get them to shrink?
I want .05" on the left / right of the widest data, and .02" on the top and bottom. If i change Vertical to .02 it puts the text at the top of the cell.. but if i put it at 1, it enlarges the cell and places it in the middle.
Horizontal i want .02 from the left, but if i align left it goes all the way to the left line.
Can a table format re-define an external excel spreadsheets cell lengths? Obviously taking into account if Wrap text is Enabled it takes the width and defines only the height?
How can I display the object data in a grid with vb.net and also add new features to the same layer along with the object data.
View 3 Replies View RelatedI want to export my slope - table - legend to an excel or txt file.
(Of course only the values)
Civil 3D (2013)
Is there any way to do this in Autocad? Split a table so it is in 2 sections side by side, rather than one verrrrrry long one? Similar to what you can do in Inventor?
[URL]
I am trying to insert a table using a data link. I set up the Link through the DataLink manager and then insert the table using a range. I click OK to insert the table and after a few seconds of thinking ACAD sits there with no table on the screen. When I look in XREFs, the DL is there but says it is unrefrenced. Tried multiple ways of entering or setting up information to no avail.
View 6 Replies View Related
