Having an issue trying to join an access table to a shp file attribute table. I want to use the access table to cross reference the shp file for matching parcel numbers. I have attached the access table in the ODBC using a data source name however it seems to not give me the option to view any records.
View 2 RepliesHow to join atributes from xls/xlsx to table in shp file?
I attache some sample files.
I have shp with 3 poligones. Each has two atributes in the table. I prepared some table in excel. Now I want to join this file to shp's table.
Should I connect this file though FDO? (ODBC)
I tried to bring in a shapefile to AutoCad Map 3D 2013 and I realized the attributes in the table were incorrect. There should be no negatives for the column CLN_NUM_ID.
And it appeared that the CLN_NUM_ID is totally incorrect. Then I realized the data type of CLN_NUM_ID is Long integer so I changed the datatype to DOUBLE in ArcMap. When I brought in the shape file, the program crashed.
How can i access and get details of ipart Table. Even if i want to modify are there any chances of doing them
View 2 Replies View RelatedThe angle or radius are outside the table boundaries. I have used bend tables before and have not run into this. See screenshot. What I don't understand is that in the error dialog box the Thickness is correct the Radii are correct and the Angle is correct except it is showing a -90 degrees. Is that the problem? The negetive? Why is it showing a negative number. I can't change the way the part is formed. The problem seems to be with the lower left hand curl. It does go ahead and flatten it, but I don't trust the results when I have the three errors.
View 1 Replies View RelatedIn our company, we put Excel tables in our drawings. The reason we've chosen for Excel-tables is that we can adjust the layout of the table quite easily. These tables consist of grouped cells in a particular company-specific layout. We select the range of the desired cells, copy and paste them in our AutoCAD drawing. This drawing is sent to our customers. The disadvantage of this method is, that when our customers (who use CAD-software of other brands) open the dwg, they don't see the table, but some kind of picture of the table.
Is there a way to 'explode' the excel-table, but keep the specific layout of the table? For attributes in blocks there's the 'Explode Attributes'-command in the Express-tools, but is there something similar for Excel-tables?
Product Design Suite 2014
Inventor 2012 SP2, Vault 2014
HP Workstation Z220
Intel Xeon 3.4GHz
16GB RAM
Nvidia Quadro 4000
Windows 7 Professional (64bit)
Is 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.
I have a part where I have placed a number of table driven iFeatures. These features generate parameters in the model that I can see in the parameter table. I am trying to find a way to have these iFeature parameters show up in the hole table in my drawing.
By 'exporting' the parameters, I have been able to get the values to show in notes and drawing view labels but I can't find a way to add them as a 'New Property' in my hole table.
I want to know if you can link AutoCad tables to other Autocad tables on different layouts. Say I have ten sheets, each with a table for quantities of pipe length, and one sheet with a total of all quantities. Can I link cells from each separate layout sheet to the main table sheet, so that I can add them all for project totals?
View 3 Replies View RelatedI am wanting to use an Autocad table object to display fields from an Access database table that is linked to symbols in my drawing.
My objective is create a database table that has detailed notes for call outs in my drawings and then link my call out blocks to the database table and display the blocks and linked descriptions in an Autocad table. If the notes in the database table are edited the Autocad table updates with the new the description from the database.
How can I export a excel table to Autocad not as an OLE object but as a Audocad table?
View 7 Replies View RelatedI have a simple block that consists of a point and an attribute that contains the point number. I want to generate a table with point number from the attribute, and x, y and z of the block's insertion point. I want a routine that sets out the blocks and then create the table. The first part of the routine I have (in LISP), I need it to generate the table. I was intended to use the -DATA EXTRACTION but unfortunately it does not allow me to select objects (blocks). Are there other ways to do this? I'm using AutoCAD 2011.
View 5 Replies View RelatedSay I had two tables located within AutoCAD, can I make it to where if I put data in one cell of one of the tables that it could automatically populate in a different cell in the other table? Also if this can be done, could it be done linking the data in-between separate layouts?
View 9 Replies View RelatedIs 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 RelatedWe have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.
We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?
I want to export my slope - table - legend to an excel or txt file.
(Of course only the values)
Civil 3D (2013)
how to add more fields to the dbf file of a shp (using AutoCAD Map 2010), other than calculation fields? I am often working on a shp and get asked to add more fileds to hold more data but cannot find a way to do in in AutoCAD (have to resort back to Arcview: but then that causes issues when I go back to the original CAD file that has the data connected to it).
View 7 Replies View RelatedI have an Excel file linked to a Table which has 3,400 lines. When the Table is unbroken a File Save takes 30 seconds. When the Table is broken it takes 30 Minutes to save. Makes the breaking feature for large table unusable.
View 3 Replies View RelatedI have a general table in my engineered print. It consists of basic columns with text. How can i have Inventor refresh the data if i change the Excel without having to delete and re insert a table ?
Autodesk Inventor Professional 2011
We are using Inventor and Vault pro 2013.
I have an iPart in which I want to change the File Name Column from "Member" to "Part Number". These columns are not the same and makes the filenames for the members different when generated.
The challenge is that I already have about 100 members generated and used in different assemblies. I want these to be replaced by the new files and be deleted.
If I change the File Name Column I will get 100 new files (ipart members) that is not used anywhere. The only way I know of to replace the 100 "old" members is to do this in Vault - one by one..
I 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.
What is the best way to get a hole table on a converted SW file. Our Engineers use Solid works and I can easily import the file but when I try to create the hole table in the IDW file it comes up blank.
Do I need to recreate all the holes so they are native to Inventor? or I am missing a conversion setting.
Autodesk Inventor 2014 64 Bit Edition Build 170
Dell XPS 8300
Processor: Intel Core i7-2600 CPU 3.40 GHZ
16GM Memory
64 Bit Operating
Windows 7
I've spent the last 4 hours searching for an answer to this question, but I simply can't find one.
As a start I think you have to know that I'm currently using AutoCAD 2012.
Here's the problem: I need to extract some info from an AutoCAD table to a reference file that can be opened in Microsoft Excel. Everything I find on the subject is actually an answer to the question "How does <DATAEXTRACTION> work?" or "How to do an extraction of DATA in AutoCAD?"....
In this particular case I have a set of production drawings (cut tickets) for manufacturing of stone. And in every single sheet I have this material schedule or a table, if you wish, that is made with an AutoCAD table. In this schedule I have the height, width and thickness of the stone plate and with a function it measures it's area and volume. What I want to do is to extract those values into a reference file that I can open with Microsoft Excel, as I already said.
How exactly?
So I just upgraded to MEP 2013 last week and am in a bad situation where when I keep making my data link tables to a range on an excel table the file name's full address is not staying when I go to insert the table.
(ex. D:/Documents/JB Plans/NK.xlsm is just NK.xlsm when I try to insert the table)
Does some defaulting or setting that I haven't found involving this issue?
Generic lisp file that summaries areas of hatches in a table,
I’m wondering if there is a lisp file that can read the boundary of the study area and the hatches and stick there areas in a table as shown in the attached screenshot
The areas of the roads are derived by subtraction the total area of hatches from the area of the study area.
The dwg file is attached
This is very frequent sort of work and takes a lot of time to be constructed. I’m already using fields to perform this kind of work.
Software: AutoCAD 2014, AutoCAD C3D, AutoCAD M3D, Revit
Windows 7 (Ultimate 64 bits),
Firefox 20.0,
Kaspersky 2013.
I want to convert a table from .doc to an image file.
If I screen print it and edit in paint.net the quality deteriorates.
I copied the table from the doc file and directly pasted in paint.net
This is what i get after pasting it,
My question:
How do I get a white background for this table? I want the quality same as you can find in the word doc. I used paint bucket but again the quality doesn't look the same.
OK...so when I copy the desired cells form the excell worksheet and paste to paintnet, it works fine...the entire range of cells copied show up in the paste, but...if you first eliminate the gridlines in excell before copying the range of cells, the paste into Painnet only shows one section/quadrant of the excel range of cells which I copied. I don't want the gridlines showing in the final .png file...I know this must be possible...
View 3 Replies View RelatedI am repeatedly running into the same problem of a data linked table losing its formatting upon closing and opening the file.
Each time this happens, I am forced to enter the properties tab and return the height of the text and the height of the cell to the size that it had originally been. Is there an option that I have not seen? What is continuously causing this error?
I've been using the ado_lisp method to create a table and populate it from an access database with mixed results. Any VBA routine to create a table to share or a good source of information?
View 3 Replies View Relatedi try to copy one table from dwg to current dwg which is opened. I have a little success - my table is copied to current dwg. But when i click text in cell or try to activate table, AutoCAD hangs.
I think that my code does not copy the table. And these table that i see in the current dwg this is table from source dwg.
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