AutoCAD Map 3D :: Combine Object Data Tables?
Jun 12, 2013
A large combined file in our GIS format corrupted. I dug out all the old files that were originally used to create it but they are too old and will not combine in the GIS.
I exported each one to SHP, and then imported all of them into civil 3d as shp files, creating object data. This meant that I could correct the corrupted sections, which I have done, but now I need to get it back into the GIS program with the object data intact.
The problem is that the object data, coming from several combined files, is in several tables. Each table contains the same identical fields. (eg every table has a field called drawing)
I need to combine those tables so that I can re-export the shape files. I need one table with all of the object data in it.
View 9 Replies
ADVERTISEMENT
May 23, 2013
Would you have a solution to accessing ODTables for a dwg object only loaded into memory? I have 1000+ dwgs that I want to return a string with the names of the various ODTable names for auding purposes that I would prefer to just side load rather than full load for performance reasons.
I'm attempting to use something like this (which works fine on an open drawing):
Public Function ReturnOBJData(acObjIDIn As ObjectId, intOffset As Integer) As String
'Don't forget that table is 0 based offset so....plan accordingly Dim strRet As String = ""
Dim acDoc As Document = Application.DocumentManager.MdiActiveDocument
Dim acDb As Database = acDoc.Database Dim acEd As Editor = acDoc.Editor
[Code] .......
In a fashion along the lines of
Public Function GetTables(strFileIn As String) As List(Of String)
Dim lstReturn As New List(Of String)
Dim acMapApp As MapApplication = HostMapApplicationServices.Application
Dim acActiveProject As Project.ProjectModel = acMapApp.ActiveProject
Dim acTableList As Tables = acActiveProject.ODTables Dim acTable As ObjectData.Table
[Code] ....
The problem is that I can't seem to link the ODTables object off of the memory database object. In this sample, the msgbox always returns a count of 0 where I would expect it to be in the range of 1-4.
View 6 Replies
View Related
Sep 18, 2013
Here at the office we use a template I created using Data Extraction. After creating the table and inserting it, it works just fine. Then, if you make changes to the door or window you can click the "Download Changes From Source File" and it will update the table ... However, after saving it and trying to work on it the next day, it somehow unlinks the table I have in my drawing and I cannot "Download Changes From Source File" to update the table ... I checked under XREF and it shows it is loaded and I have it reading from the same path I saved it. I would like to know if there is a way to re-link the table to the .dxe file or how to prevent from it un-linking new tables?
View 0 Replies
View Related
Aug 13, 2013
I have Acad 2011 and Excel 2010 on my computer. What I would like to do is to create a list of materials in my autocad that will update from an excel table. The only problem is my Acad Table needs only some materials from that large spread sheet. For example when I write in my Acad table a piece number(col A) I would like to have a description coming automatic from excel (in col.b).
There will be hundreds of drawings with tables taking data from the same excel table.
View 8 Replies
View Related
Oct 17, 2011
I have an Excel spreadsheet I am testing to see how to edit table data in Map 3D and see the changes back in Excel. I have created the .udl file from my Excel file, which AutoCAD stores way down in the Data Links folder. I attach the .udl file as a Data Source. It shows the named range and I can view the table but it is always Read Only. I checked the Access permissions under Properties and none of the boxes were checked. So I checked ReadWrite but I still can't edit the table.
Then I tried just attaching it as an FDO provider. It links and displays the table just fine, but when I perform an edit (which it allows), the whole program crashes out without a single warning. Like I never had Map open.
This may be a Windows 7 permissions thing but since Map won't let me change the folder location where I save the .udl file, I can't test this out by putting it in a folder I know I have full access to.
View 3 Replies
View Related
Jun 10, 2011
I have created a data extraction table based on attributes placed on blocks. The data table is in my layout and it includes part number, dimensions, and cost. What I need to do is total the cost of all the items at the bottom of my table. I added in a row for the total cost which is not linked to the table but when I try to add a field in that cell to sum the cells above it (the costs), I get ###. I already tried unlocking the cells, but that didn't do anything.
How can I add a field summing these costs?
View 1 Replies
View Related
Sep 25, 2012
I have set up some autocad tables that are linked to excel data( using relative path) in an Autocad Architecture project template. In the xref dialog box, the data links are show as relative path e.g. ..Standards excel file
After creating a new project from this template and right-clicking in one of the cells which have linked data and selecting "data links" and "open data links file" it opens the template excel file, not the excel file within the project folder.
If I use the xref command, select and right click one of the excel data links and select "open" it does open the correct excel file located in the current project folder.
The xref dialog box does show all the data links as relative path e.g. ..Standardsexcel file.
View 1 Replies
View Related
Apr 19, 2012
I have a new issue that I am unsure what to do about.
This has never occurred with previous version of ACAD and this is the first time I created data links with Autocad 2012, and I am using the same procedure that I have successfully used in the past.
I have data tables linked to excel spreadsheets. I used the "TABLE" button on the ANNOTATE ribbon to place the table, and the layout of the cells assumes the layout of the excel spreadsheet, which is what I want.
As long as I don't Scale the table, I can Update the data table links just fine.
However when I scale the table and then update table links, the table layout changes drastically, and is undesirable.
I have tried locking the cells' but that will not fix the problem.
I want to keep the layout of the table that is assumed when I place the table originally. Is there any way to lock it as such?
View 0 Replies
View Related
May 17, 2011
Table styles / Data linked tables. In particular when re-syncing the table from excel, cells that should be merged become unmerged.
i have unchecked excel formatting, as i am using table styles used in autocad, i did try getting it to work starting with excel formatting, but couldn't get styles consistent, and text was much fainter.
As it is now the tables are working well except for the merged cells!
View 1 Replies
View Related
Mar 19, 2013
I want to export data from AC3D to Excel; I've tried to do it with copying directly the tables I made, but it isn't text or number format.For example, I want to get the data from this table:
I know that with previous versions of autocad it could be done.In addition, I also want to get value table of the calculated cant of the "Cant Tabular Editor":How can I get a table of this data? I need it because I have a lot of curves and I want to do some verifications of the standars of my country.
View 4 Replies
View Related
Jul 19, 2013
I am trying to delete a few rows in both my pipe table and my structure table but the 'remove items' button doesn't work.
View 2 Replies
View Related
Feb 6, 2009
Whenever I open a drawing in a certain project this error message always pops up.Some of the message details are:
-Parameter ERRCODE; Value 786433
-Error 786433 - Conflict between data tables in open drawings (57 consecutive occurrences)
-Parameter: APPLNAME Value: ad
-Parameter: CLASSNAME Value: airfield
this message box stops popping up when I open the drawings?
View 4 Replies
View Related
Apr 27, 2012
I decided to use Data Link Tables for my Excel sheet instead of OLELinks. The appearance is far sharper, and I am also pleased there is no background color transfered. What IS the problem is when I update the table, its goes from 12" Wide by 12" Tall table @ 7/16" Text W/O borders back to 3" Wide by 10" Tall with varying text size to fit and gains back all borders except diagonals (of which none are present on the Excel file).
So, any way to default the format when I refresh so that it holds each cell at the 6"X1" dimensions with no border.
With that, If there is a way to have a stencil for making the range links with Excel, that would be useful. I use the exact same 4 or 6 ranges (2 formats) in every dwg.
View 7 Replies
View Related
Aug 19, 2013
I have a complex data structure I want to be able to add to a Lightroom plugin. I know Lightroom uses a SQLite database. Can I add tables to that database from either inside a Lightroom plugin or externally? I see no documentation of any API capabilities granting direct queries of the SQLite database and as of now it's looking like the only technique I have at my disposal is to create my own homebrewed database system using the file system. I would like that not to be the case.
View 1 Replies
View Related
Dec 28, 2013
How do I combine 2 data catalogs into 1 in LR5? Both are LR5 catalogs.
View 2 Replies
View Related
Oct 2, 2012
I wonder if you can make a table of families picking "elements of details." Why? I mean, when I do a detail included screws, foams, sealants, etc ... all these elements I have done as families of "elements of detail."Now I want to collect these items on tables and include calculated values to determine the amounts thereof.
View 2 Replies
View Related
Dec 12, 2012
I am using x6 to create datasheets & need to insert tables to hold the data.Most of the time when doing anything to a table ...combining cells, splitting cells or almost anything, nothing actually works & x6 ends up crashing.
When starting a table, i click on the table icon, go up to the columns & rows box & type the numbers that i want ...but whatever i type, a 3 x 3 table appears.
View 4 Replies
View Related
Jan 20, 2011
how to import point data that has Map Object Data also attached to it? "import it by attaching to a data source".
Example: I have a bunch of manholes. Each MH has X,Y,Z, but also Type, Invert Elevs., Pipe Sizes, Pipe Materials, Pipe Directions, Structure Type/Material, etc. etc. etc. I may have point data representing MH's, airport runway ends, trees, anything you can imagine, with all kinds of data imaginable.
I want to import this data directly into Autocad/Civil 3D as either Autocad points, lines, or closed polylines (I also have utility lines, parking lots, etc.- all with data associated with it), all with the data attached as object data. I know that anything more complex than points might be hard to explain here, so I am hoping at least for a solution on how to import points - I have 99,999 MH's and obviously I don't want to have to type all that data in one by one.
I basically suck at using sql server. I can get around using the Map workspace and the different tabs. I have never used FDO, and I am not even sure what it is.
I fooled it today by creating 99,999 Autocad points at the correct XYZ, attaching the correct object data to them, then exporting as a shp file. I went into the shp_name.dbf file and edited it to add the data I wanted by cutting & pasting from Excel. then I re-imported the shp file. but, this is a workaround at best.
Surely Map can import objects and their associated data fields, all populated with valid data! all I need is to know how to do it. I mean, if this is not something I can do directly using Map commands should I take the money I earned by surveying 99,999 MH's with my GIS data collector that allows me to assign 101data fields to each object I survey, and buy something better?
C3D 2012 on 64bit Win 7 all up to date
Dell Precision 7core 8GB RAM
NVIDIA Quadro FX 1800M
LDT/C3D user since release 12
View 9 Replies
View Related
Mar 28, 2013
I have a drawing with Objects that have both Object Data and Linked data in an Access database. I need to get information from the linked table to a new linked table for each object.
I have thought that if I get the necessary information from the Linked table record to the object data for each object, I could then convert the Object data to a new link and am looking for a way to copy the data from a field in the Linked Table to the object data. There is at least one field common to both the OD and Linked Table record.
Is there any automated way to transfer this data?
View 5 Replies
View Related
Jun 25, 2013
In my company, they have just upgraded the old version of Autocad LT 2004 to the new 2013 and we have created menu to make our job easy. I have try to transfer the menu file .mnc to 2013 but it's not working or I don't do it the right way.
View 4 Replies
View Related
Oct 15, 2010
I'm working in AutoCAD Map 3D 2008 and Autocad Civil 3D 2009.
The General Task:I want to convert the object data to attribute data so that I can export it to an Excel file, add another column of data, and then import that new data as attribute data.
The Specific Task:I have thousands of campus water meter locations (a block with a small icon, attribute data, and object data) that belong to two different systems, domestic water and lake water. Each of these blocks has object data item (a barcode tag) that I want to show as a label next to the block.
However, before I do that, I want to export that barcode data to an excel file so I add a column (eventually a new piece of attribute data) that says whether or not that specific water meter is radio read or manually read. I want to then import that radio read/manual read excel file back into autocad and have an X appear on the block icon if it is radio read. I also want the barcode information to show up as a label.
My problem:I can't get the barcode object data to export with the locations in one easy excel sheet that I can simply import after I have made my changes.
Find some person on here who knows how to convert object data to attribute data.
View 9 Replies
View Related
Sep 7, 2012
I have problem when i duplicate polygon another side of model. The object is not smooth, it look like different model. I try to "combine" and "mesh" vertex from middle of object. but it still same. The polygon will smooth if i use "smooth tool". But i need low polygon for transfer map from high polygon to low polygon. but it not work, because low polygon look like different model.
I need smooth low polygon, but not to much smooth. I need only when i duplicate polygon, it not look like different model is okay.
View 6 Replies
View Related
Jan 20, 2013
I'm having problems getting what I want on Illustrator CS6. This is the shape that I'm working on: [URL]
I got two paths, one for the inner outline, one for the outer. I want this to be one object, looking just like that, where red is the fill, and black is the outline. Simple as that. [URL] - this is what i want.
So, the inner "circle" is not filled with anything, beacause my object is this "frame" outside. But since I have two seperate paths, I'm filling the outer path with colour, and I get:
[URL] the outer filling is red, the outside is transparent, which is good, but the inside is red because the inner path has no filling.
Right, so next I fill the inner path with white and it looks almost good: [URL]
But the inside is not transparent, it's an "illusion" and everything will be great on a white background, but that's not the case.
I want to convert these to paths into one object to behave exactly like I showed in the first image. Red is the fill, black is the outline. And I plan to use gradient mesh heavily on that shape, so that has to work to.
Bad quality, just doing some quick previews on Photoshop.
View 3 Replies
View Related
Feb 10, 2012
I have a shape created by three hexagons and they are abutted along edges. I would like to combine them into a single object and in doing so reduce the lines so that the abutted lines become one line. the reason is that currently they are processed twice along each abutted line by my laser.
I can use combine but this still leaves them as discrete editable shapes in node editor, so clearly the double lines are still there.
If I use weld I lose the lines.
View 13 Replies
View Related
Apr 3, 2013
There is problem with my CorelDRAW X6.
After I import different files in my working file, it's getting hard to work- RAM(16GB) is getting completely full and its almost unworkable!
I checked out Object Manager and found stack with "SVG data" and "Locked SVG data" object there under some basic shapes.
Stack is about from 10000 to 100000... Some times even more, but its not possible to select all them because Corel just stops. What is that- "SVG data" and "Locked SVG data" object and why they are so many there?
View 5 Replies
View Related
Aug 28, 2002
I have object data attached to some linework and I want to copy that data to some new entities.Is it possible to copy object data from one entity to another with out having to fill in the table again.
View 3 Replies
View Related
Jun 9, 2011
We need to take polylines from AutoCAD Map 3D to 3ds Max and rename each polyline to have a name of something like "Building Number-Room Number", both of which are defined in our properties for each polyline. Because none of this data is kept on import to Max, we need to do this all in Map 3D, which we are not experienced with. Is there a way to do this, and if so what? We are importing the .dwg files in Max with polylines as splines.
View 2 Replies
View Related
Jan 27, 2013
How can I Get table name of the object data of a selected layer, with C#.
View 4 Replies
View Related
Feb 1, 2011
I have an object with an Object Data Table attached filled in with information. Is it possible to copy the table and information from that object to another object? Tried the obvious, Match Properties, and it did nothing.
View 3 Replies
View Related
May 28, 2013
how to extract geometrical data (lenght, width, height) from 3d object to a tab or an external file?
View 0 Replies
View Related
May 27, 2011
is there any way to use data extraction and get the dimensions of the solid. Using dynamic blocks on 3d solid is not an option as far as i know. I tried using block with attributes and field which refer to a dimension line but it's too complicated and takes far more time than just check them by hand.
View 0 Replies
View Related
