AutoCAD .NET :: VB / Map 3D - Reading Object Data Tables From DWG Inside Database

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


ADVERTISEMENT

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 View Related

AutoCAD Map 3D :: Object Data Linked To External Database

Jul 14, 2011

For some reason, I can't seem to find all the right steps in the right order to accomplish this.  Maybe what I'm trying to do isn't possible.

Using either Map3D 2011 or Map3D 2007:

I have a database (SQL Server) and a drawing (.DWG) with object data fields.  For simplicity, lets say the database field names match the object data field names.  The key field in the object data is already filled in.  I would like to link to the database so the rest of the object data fields are filled from the database.  Is this possible?  If so, how?  The closest I have gotten so far is creating a link template and using mapod2ase, but that creates a separate set of Link Template fields instead of filling in the Object Data fields. 

View 5 Replies View Related

AutoCAD Map 3D :: Convert Linked Database Info Into Object Data

Jul 7, 2011

I have 200,000 lines with some object data. LINKED to these lines is a database with some more information. Basically I want to export all of these lines to shape files, converting the information in the linked database to be the new object data. (This is for the client to view the lines on ArcGIS).

I have done this a few times in the past, but working with this volume of lines and data, Its taking an extremely long time.

My question is, could i use autolisp to quickly transfer the database data to object data before i export to shape files? or if there are any other options.

View 3 Replies View Related

AutoCAD .NET :: Accessing Database Tables

Sep 21, 2011

I'm having a problem accessing data manager tables in the 2011 version.  My C# .NET code worked fine with 2010.  Here is a sample of the 2010 code that works, but returns zero length tables in 2011.

C#

ProjectPartCollection oPP = PlantApplication.CurrentProject.ProjectParts;
PlantProject oPProj = PlantApplication.CurrentProject;
Project oProj = oPP["PnId"];
try
{
//get ACAD data table
[code].......               

The last two lines fail to object any meaningful data in 2011.  In 2010, I would have all the table rows and could access tags and asset information. 

View 2 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Search Database / Tables To Determine If New Layers Present In Drawing

Dec 6, 2013

Is there a way to search the database/tables/whatever to determine if new layers are present in a drawing?

I want to run a script to reconcile new layers in the sheet drawings after having cleaned the xref drawings, and the script bombs if there are no new layers present in the parent drawing.

If I could determine what triggers the layereval/layernotify sequence (tblsearch?) I could include an if or while lisp routine that would invoke the layer command and then reconcile the new layers.

View 9 Replies View Related

Revit :: MS Access Database That Can Export Family Tables?

Sep 15, 2011

MS Access database that can export Family Tables? Or knows of a 3rd party application that all the type information can be houses in a database, and the family table's TXT is just an export. The family tables we create are nemorus, and lengthly family tabels, and Excel just is not cutting the mustard.
 
Or would Autodesk ever include this in Revit?

View 5 Replies View Related

Corel Ventura :: Publishing Tables With DBP Database Publisher - Additional Empty Rows

Nov 13, 2011

i'm using DBP to fill a 48 page catalog in ventura 10 with 500 product descriptions (up to 600 characters) and small .jpg photos in tables (six columns). the data is .dbf format (dbaseIV from access2000) including a memo-field and .jpg links. depending on the sort order and/or filtering (selection of ) the items it either:

1. works like a dream or

2. most commonly,  the tables (including the headers) have additional empty rows around each item

with exactly the same data just sorted differently the results can be different (with or without empty rows). the result is 100% repeatable using the same recipe/sorting.i can't see any difference in the .txt files apart from the sort order of the table contents.the .jpgs are all 600 x 600px and the frame preset to 2.1cm x 2.1 cm..default page fonts all set to 7pt to avoid row height > page size

View 3 Replies View Related

AutoCad :: Data Extraction Tables

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

AutoCad :: Managing Data Between Tables?

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

AutoCAD Map 3D :: Read Only Data View Tables

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

AutoCad :: Data Extraction Tables And Fields

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

AutoCAD Architecture :: Tables With Linked Excel Data

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

AutoCad :: Data Tables Linked To Excel Spreadsheets

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

AutoCad :: Merged Cells In Data Linked Tables

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

AutoCAD .NET :: Reading Data From Table

Oct 6, 2011

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?

View 6 Replies View Related

AutoCAD Civil 3D :: Get Data To Excel / Get Tables Of Can't Tabular Editor

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

AutoCAD Civil 3D :: Deleting Data From Pipe / Structure Tables

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

AutoCAD Map 3D :: Messages - Conflict Between Data Tables In Open Drawings

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

AutoCad :: Data Link Tables Compress And Change Text Size When Updated

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

AutoCAD Civil 3D :: Survey Database Point Data

Apr 16, 2012

Is there a way to "data shortcut" information imported from a data file into multiple drawings?  If so, is there a way to lock the data points "in place" and not be able to adjust the point location/elevation, but allow the movement the text information around within the drawing.

The goal is to have multiple drawings with these data points and be able to move the text information from the style, but not (in a million years) be able to move the data point itself.  There may be multiple drawings with these points located within them.

View 4 Replies View Related

AutoCAD Inventor :: Getting Data From Access Database Using ILogic

Aug 2, 2010

I have a program that populates an access database with part parameters. Each Inventor part can look up its own parameter values from the database when supplied with a single parameter, the ID number of the database record. The ID number is derived from a blank part that the program also updates. So in a nut shell, the program populates the blank part's parameters with all database ID numbers that would make up entire assembly. Those parameter values are derived to all the parts in an assembly. This is by far the fastest most efficient way I've found to rapidly generate an entire assembly. In a matter of seconds I can have a new 1000+ part assembly.

 The rumor that Inventor will eventually sever ties with VBA has put this whole process in jeopardy. So I have been looking into using iLogic to perform the same task of looking up the data from Access. I know that iLogic has Excel functions built into it, but because the original program is Access based (changes this is not an option) any way to use iLogic to retrieve data from Access.

View 4 Replies View Related

AutoCad :: Link To Database And Populate Drawings With Data

May 16, 2013

I have some files (OK, 11,000 of them) and they have drawings on the bottom and text on the top. I want to erase this text and replace it with data that comes from a database. I don't know where to start.

I need to:
1. preferably find a way to erase the old data on the top, but I could do it manually
2. Insert data from specific fields into specific spots on the drawings.
3. Each drawing would have the same fields but different data corresponding to an account number. The account number is included in the name of the drawing and is a field in the database.

How to get started? I have Map3D as well, which I was told would work better than regular AutoCAD on this, but I also have regular AutoCAD. I can't even figure out how to make the database connection work.

View 9 Replies View Related

AutoCAD Civil 3D :: Survey Database And Data Shortcut Path

Feb 15, 2013

How do you move a survey database and data shortcuts?  Without going into details, sometimes it is necessary to copy portion of projects as new projects.  The survey database along with the drawings our surface, points, linework, etc. need to reference the new directory.  I can set the survey database folder location to the new path but am not certain the information in the dwg is point to the correct location.

The same essentially applies to the data shortcuts.  I'm having trouble getting this to work.  With LD we were able to copy the project and resuscitate the drawing(s).  I tried to use Data Shortcut Editor with the Saveas.  I then attempted to rename the dwg's and path the new location and name but receive an error of Invalid source file. Correct the path or press Esc..

View 1 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Export Data To Any Database Application?

Apr 19, 2013

I would like to save the data generated by LISP program at command prompt area to any data base app or any simillar app from where I can retrieve the stored data again in autocad for further usage. 

For example, A LISP program generate the result as shown in above Fig. I would like to save the data of step 5, "Shear force in tonnage is : 50.868" to any database application or any simillar one from where I can retrieve the stores data for further usage.

View 9 Replies View Related

Lightroom :: Creating Tables (or Other Persistent Data Structures)

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

AutoCAD Visual LISP / AutoLISP :: Data Extraction And Database Visibility Counts

Jul 30, 2013

My goal is to have a quantity count of a specific dynamic blocks visibility state and for it to be updated when changes are made, without having to recreate the Table. I want the total amount to be where I have the Fields.

My test drawing is the perfect example, assuming I have all the items that I need in the drawing. I don't want to recreate the Table and re-link each Field to the appropriate cells of the table. Which no one wants to do. In this test drawing the objects in Blue will be used in the final production drawing.

I noticed if I add a new item or remove an item entirely I'll have to redo the Table and fields. Which defeats the time I'm trying to save.

View 1 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Importing Data From Database / Spreadsheet Into Polyline

Jun 29, 2012

I have a database with the polyline reference/handle (i.e. '13EE6A') and each polyline has a 'door number' associated with it.

I can easily create a query that produces a table of polyline ref and associated door number.

I need to somehow import that door number into the middle of each polyline on the drawing - i.e. if there is a polyline with that handle, put the associated door number in the middle of the polyline on a certain layer. I do NOT need an active link between the database and drawing - it's just to initially populate several thousand rooms numbers!

View 9 Replies View Related

Photoshop :: CC - Reading Layer Data?

Nov 27, 2013

I can't open my psd with properly in Photoshop, it keeps showing :There was a problem reading the layer data. Read the composite data instead? 
 
Photoshop cc

View 1 Replies View Related

Revit :: Pickup Data Tables Of Families Of Elements Of Details

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

AutoCAD Map 3D :: Add Database As Source For Object

Dec 18, 2012

I'm trying to add a database (excel ) as source for object in Map3D.

I start but when i select the excel file that i've created and stored in my pc map3d says that the cration of the data source doesn't work.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved