I 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 RepliesIs 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.
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]
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 want to edit some values in the data table of a shape file (*.shp) with AutoCAD Map 3d 2013. Every time I alter a value in data table it takes about 30 seconds until AutoCAD Map saves (?) the value. I have to wait 30 second until I can continue working. Why is this so slow?
The shape file has 7000 lines and is stored on a local drive.
We do a lot of very large site plans with mulitple options and have to compare cost differences for Concrete, Asphalt, & Base Course. We hatch the areas and print in color so it is easy to see what is concrete, asphalt, grass, water, & Base course. Is there a way to create a table that would update the total areas that we have hatched? We make a lot of changes to these plans and it takes a long time to keep adding up the areas that are hatched everytime and typing the informaiton into a table. I have the table setup so once we type in the sq. ft. of area it calculates the totals but was hoping there was away so it would automatically update the ares in the table for us when we make changes.
View 4 Replies View RelatedI have a table which is linked to a datalink from Excel. The table and contents (text) show up in paperspace; however, only the table frame shows up within the plot preview, or when I try to plot it. The text does not show up.
View 4 Replies View RelatedI am editing an old file set up by another firm that is used by our clients to keep track of room sizes etc, which has a room data table and room tags tied to area polylines. It has worked just fine on our 2013 Acad Architecture, but when I sent them (saved down to 2010) back to our client, using 2012 Acad Architecture, the tags disappear and the table is unpopulated.It seems like it must have something to do with the file originally being created way back when, along with some quirk between 2012 and 2013.
View 2 Replies View RelatedIs there any command in autocad to LINK TEXT TO SCHEDULE TABLE. I have door & windows in my plan I have given attribute numbers to them as per sizes like for
800mm -w1
900mm-w2
1200mm-w3 etc...
I have made window opening schedule table , when ever i add or delete one window form schedule i have to change the order. like if i delete 900mm window schedule will be.
800mm- w1
1200mm- w2 etc....
so I am looking for a command when ever i change my schedule table my attribute numbers should also change.
Is 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 RelatedIs there a way to force the table and table text height to stay constant despite the scale? I can do it for Point Label Styles with an Expression. But in 2011 there is no way to build an expression for a table style.
I want to create tables in the drawing where the points are and then plot them from a drawing they're Xrefed in to. The tables are too small but zooming in doesn't make them any bigger because the scale of the viewport changes and they adjust.
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]....
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 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 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)
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 RelatedHow to insert a linked excel table into my drawing, however I have not figured out how to add rows to the table, the option is greyed out. I can insert rows above and below the (inserted) table but not anywhere in the middle.
I've tried everything I can think of, even removing all the formatting in the .xls spreadsheet to no avail. The cells are unlocked, I can manipulate the data, but not being able to insert rows is really hindering the efficiency of using a data linked table.
i get an error message telling (invalid thread data table. Please check Thread.xls file.i tried to reinstall the windows and the autodesk inventor but the error keep appearing.
1.my os is windows xp sv2 32 bit
2. inventor version is 2011 32 bit i also had the same problem with 2010
3. i tried to reinstall without any antivirus on my pc but i still have the same problem
4. what's a UAC?
5. yes i've office 2007 installed & i had tried with office 2003 but also the same problem.
1 the first time i used, i made the bolted connection once, but at the second time i kept having this issue.
2 my last trial was installing a freh copy of the windows then install office and the inventor only but nothing changed
3 i tried to install the inventor on another pc but i also had the same issue
4 i searched the c drive for the file THREAD.xls, and i found three of it and i guess they are fine.
I found out you can export the data table of feature properties from an SDF connection by choosing Options > Select All and then Options > Export and obtained a .csv file I was able to bring in Excel...but there are no headings for the data. How to export the column headings as well?
View 2 Replies View RelatedUsing AutoCAD 2010 LT with service pack 1 and 2
I created a link to an Excel file to create a table. Before I ETransmit the AutoCAD file (along with many other files) I want to remove the link so that the table is embedded with no need for the external file. When I have somebody who doesn't have the linked file on their machine open the file they get a "missing external file" message" despite the fact that I ran the detach data link command and have purge selected in the ETransmit setup. The table shows up with the data, but I want to eliminate the nag pop up about the missing file. I know you can click the ignore button, but I don't want our customer to have to bother with it.
Any way to save a list of files for ETransmit like you do in a .dsd file for batch plotting?
Is there a way to setup vertical alignment of text in a cell for the entire table, when using Table Tool? It is possible for a single cell, but when selecting a table (or multiple cells) this option is not available.
View 5 Replies View RelatedI create a sdf file and add a squema for non feature class, for association with an existing feature class squema property.
But the table is empty andlocked with no chance of adding values. Since it has no geometry, how can I put some rows on it.
I try to import using bulk copy, but then I cant remove or add rows.
How can I insert values in a sdf table?
I've created a table (a door schedule for example).The data cell type properties is "general". The door # is "001". When I type this in, it switches to just "1" and the type is swiched to "whole number." Same for another cell with a number in it, it switches the cell type on me and I don't want what it switches to. Every time I try to switch it back it doesn't do anything.
How do I stop it from automatically switching, or at very least let me override?
I am just wondering whether FIELD category can access the OBJECT DATA Table ?
I want to use a block to display its OD table's attributes as Annotation text , so that the Text will update when the OD table change.
Or do I need use the Data connection for this purpose ?
I recently decided to see how the AutoCAD tables work. I was very happy to learn you could link your Excel spreadsheets with CAD. But now I have a problem.
After inserting the table it refuses to use the table style I have set up. The fonts do not want to change at all. I can change the colour of the text, but not the font.
PS: Using AutoCAD 2011
I have created a table style in ACAD 2012 with all of the cells formatted to what I need. The trouble begins when I bring in a BIAS excel data link to populate the table. I have tried every option in the insert table steps and have even tried all the different options under the modify excel link options. I have toggled the use excel formatting on and off, which does change the table size a small bit, but does not allow the table style to take affect.
I have attached a screen shot of the "good" and "bad" tables. The bad table is what the good table comes in as and it is also what happens everytime the table link updates. It always reverts back to the bad style and then I have to change the table back to the good one by hand - changing each column individually.
Is there a way to attach a data link to a table with the table style holding its shape and formatting?
This happens on all of my drawings and using all kinds of different excel links.
how to bring in the data link??