AutoCAD Map 3D :: Exporting Headings From Feature Data Table?
Nov 5, 2013
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?
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.
I have been working with some GIS data in the form of SHP files in autocad map 3D 2011. On one of my layers I have started getting "Feature was not saved in the target feature source" when I try to check in my data. In total there are 308 errors in the data table, all of which were features I deleted. They all have a featID of null and I cannot remove them from the data table. I need to fix these errors without going back and starting over.
I have a master shape file that contains parcel ID, owner, tax info., etc. I have another file ( access 2003 -open to better file format suggestions-) which contains parcel ID and a "yes" or " no" entry for whether or not the parcel needs a new water meter. All I want to do is add the water meter information into the other shape file. This would create one shape file with one table with all the information that I need.
Ultimately I will use the information to do a map query and find out spatially where i need new water meters.
Right now i have the master shape file connected though the “Connect to Data” feature. I also have the new data added to the drawing though the Data sources------>attach under the “Map Explorer” Task pane. I attached access file (ver. 2003 .mdb) which has two columns “Parcel ID” and “Meter”.
I right click on the shape file under the display manager and select”Create a Join;” however my water meter table is not listed as an option. Will this not work?
Plan B - I tried to Create and connect to the access file as an ODBC connection. Followed this guy’s directions to a T [URL]. But when i populate my table under the fdo connection the column headings exist ( “parcel ID” and “Meter”) but the actual data is missing. Am I missing something important?
Note: I am running c3d 2012 on a Win 7 64 Bit machine. I also removed office 32 bit apps and installed 64 bit apps to see if that would solve the problem. No go.
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 would like to add elevation values of start and end of feature line segments within a table. I can set up start and end co-ords but can't seem to find where I can add the levels?
I can add lables to the plan with levels but really would like to have a table as well as some of the segments are too small to lable on the layout.
I have created an iPart which uses the Hole Feature (counterbore hole). The hole is not threaded. Is there a way to put the Hole Feature into the iPart table so when a user enters specific values, he/she could type in or select a bolt size and the counter bore hole feature will use the correct dimensions for said bolt size (ie. I would like the counterbore holes for an M6 Socket Head Cap Screw. So instead of typing in the counterbore hole diameter, depth, and bolt diameter, etc... it would automatically enter the default values.) Or is this something that must use iLogic?
Yesterday I tried to make a table-driven I-feature of a few drilling paterns.
I want to use this for drawing steel manifolds. The I-feature is used to insert standard drilling paterns, for example a patern to fit a standard flange.
The only problem is, for the thread I used the thread feature, otherwise it doesn't show up in the I-feature.
But when I make a drawing of a part were this I-feature is used, the specification of the thread doesn't show up when I create a hole table, because in the I-feature, the thread is a separate feature.
I need elevation data from a surface. I need an elevation every 15' along an alignment or feature line. I would like the information as a table. I am not sure how to do this.
I'm currently using the Autocad Civil 3D 2014 on daily basis for urban infrastructure design. When using Autocad Civil 3D 2013, I always would create feature lines from corridors and then export this file to a ACAD 2007 version, which would read the feature lines as 3D polys. The company's topographer could then use this file to make his markings on the field very easily.
Now, when I do the same process using Autocad Civil 3D 2014, the ACAD 2007 file won't present the feature lines as 3D polys, but as 2D polys. This presents a major inconvenient, because I now have to export the file to ACAD 2007, open it in Autocad Civil 3D 2013, rebuild the surface from the design contours and create a feature line from the design surface; export the surface AGAIN to ACAD 2007 and FINALLY I'll get the 3D poly my topographer can read.
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?
I 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]....
I have a series of curved feature lines in Civil 3D where the elevation varies along the length of the curve. When I export the file in AutoCAD the feature line elevations are 0. In my previous version of 2010 civil 3D this did not happen but now I am running 2012 version and I can't find a way around it.
Why does 2012 Civil 3D not export feature lines the way it did in previous versions and retain the elevations?
We often have to create dxf files for surveyors to use in Trimble survey controllers. Usually, the linework has to be 3D polylines so that they can stake out the lines on the ground in 3D.
When compiling our design we often have to use arcs which do not function as 3D polylines. To get around this, we convert them to feature lines. This works for creating surfaces but we are unable to export these feature lines in our dxf files.
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 ?
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.
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.
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?
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?
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.
How 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 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?
In autocad 2013 is the best way still to convert data you have connected to, for example a shape file, as feature data in order to convert that into polylines and text is the best method saving it all as a seperate drawing using the "save as autocad drawing command"? Is there way to do it individually in the current drawing so that I do not always have to be saving things out as seperate drawings and then copy and pasting them back into my working drawing?
I have centerline data from SHP file that I can either import or attach to. Has a few lines of object data with it including a centerline of road name. Each one unique. When I attach to the data, I can then "join" with it additional data from a database. When I select a line and look at the properties, it contains both the original object data AND the additional data from the database. SO far So good.
When I edit the style and try to add feature labels only part of the labels come in. I end up with a lot of them with only the letters "text" or just not there. If I right-click on the line and select "Show Data Table" I can confirm that there is data for that label. I find nothing in common with the map features that have labels, or don't have labels. Kind of random.
Question: If I import the SHP file and create object data I need to know if there is a way to "ADD" the rest of my data that is in the database to this object data. If so then I think I could define a Template and label each piece with the block with attributes. Is this possible? OR
Is it possible for me to export to a new SHP file after I have connected to the data (both shp file and database).