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.
say you make some parcels in your project with custom data fields like: id_no, permit_no, acres_served etc. you attach an agency provided shape file via an fdo connection that has many fields of information like above.
when you right click on your parcel and do parcel properties you get a tab that lets you input the custom parcel data.
lets say you print an fdo map label showing, say, the id_no, provided in the shape file. Then in your custom parcel properties for id_no you type that in.
is there a way to make an expression to put in the other custom parcel properties that will read, say, the permit_no(id_no) from the fdo like and put that information in the custom parcel property field?
I'm messing around with tables and data links, practicing. I copied a range of cells in Excel, and did paste special to create a linked table.
Now I can delete the table object, but I cannot delete the link, cannot detach it.
When in Data Manager if I right click on the data link and click delete I get the error message "The data link is being used and cannot be deleted".
I have tried detaching, and the detach does not seem to take.
Now also, the table will not update from the source xls.
Win XP, AcadLT 2011, Office 2010. Using compatible setting for saving spreadsheet, for Office 2007 (not xlsx).
If I create a linked table by starting with the Table icon, choose "from a data link", choose the excel spreadsheet, etc., then I am able to later update the table from the spreadsheet, detach, delete the link, etc. But I can only delete the link if the table is not selected when I open the Data Link Manager.
But the one that was created following the directions from the Autocad video, with the copy, paste special, that link will not detach nor delete.
Any way to create a parcel from an object (closed polyline) and populate the parcel with Object Data from the polyline?
I have imported a .shp file into a drawing and the result is many closed polylines with properties similar to the attached image. I would like to bring this data into a parcel object for labeling purposes.
I have been working on some drawings when I linked up to a database that I had recently generated. I wanted to link some polylines to an external MS Access database so that I would have the additional object data available in the drawing. I attached the Access database, then created a link template on the key field (key field is called PipeID). I then used the "mapod2ase" command to generate the links based on the link template. However, when I went into the object properties to check on the data, the only field that came up under the link was the key field (PipeID). I have tried re-linking a number of times, but each time I only get the key field in the object data. I can open the table itself from the task pane, and it shows all of the fields, and the links work because the highlighting feature works as normal, but the data is not showing up in the properties.
I was thinking that I may have reset some sort of system variable on accident, so I made the same sort of link to an older table that I have used before. When I link to this table, all of the linked data shows up in the object properties. The only real difference between the two access databases is that the one that works was made in Access 2000, and the one that is not working was made in Access 2007. Is there some sort of problem when linking to the newer versions of Access? (see this post:[URL]
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.
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.
I am looking into using the Survey Database for the first time and noticed it linked back to the imported file from which the points came. However, my question is when the points are adjusted within the AutoCAD file is there a way for this adjustment to link back into the imported point file. I am trying not to have a situation where the data is different between the imported file and the autocad file.
I have a table in an Access 2010 database which has 130 rows of records. Each row is assigned a drawing file name field and then the 6 attributes for the title block of each drawing. I am wanting a routine that will open a set of drawings, the set matching each drawing file name field record and populate the attributes in the drawing title block with the corresponding records in that row from the database table.
I have seen where multiple blocks in one drawing can be populated with an attached database but I want to populate several drawings with a single database that has several records. One row of records for each drawing.
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.
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.
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.
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.
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.
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..
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.
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.
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!
A client wants to modify vector drawings automatically via database, preferably Microsoft Sharepoint Server running SQL. The modifications could be as simple as changing the color of a flag or overlay or as complicated as changing object dimensions and appearance.
I'm thinking SVG, but is there a more efficient method, something that can modify Illustrator files directly?
I am using AutoCAD Mechanical 2013. (Full version).If there is SLD with different HP rating, tag names and different cable ferrule numbers, and if there is any small change in HP rating of motor or small change in tag name, then it is time consuming work for me to go to AutoCAD and change the text by referring Excel sheet.
Is there any way to link excel sheet to AutoCAD drawings? So i can take updated excel sheet and link it with AutoCAD and if there is any change in excel sheet then it will be updated in CAD file as well.If there is any setting or grid referencing to be made. I am ready to do the required changes to meet my requirement.
We are copying our original files to a sub folder to make revisions that have only happened after bidding. We want to keep our original bid documents intact. I have created a sub folder called 'Conformed Documents' and added Constructs, Sheets, Elements, ect.
I copied the files over and used the Reference Manager to repath the files. However, all of my schedules and room tags now use the 'NA' prefix because it is not reading the project information. How can i reconnect this folder to the project folder?
When trying to insert a table linked to an Excel 2010 file, it works up until row 28, however, as soon as I add a 29th row to the table it no longer inserts the table. When I try and insert it, I press ok and nothing happens. I tried inserting it as a smaller table and changing the data link to a bigger range after it was inserted, it just didn't update to a larger range.
Is there a way of getting this to work without having to insert it as two different tables?
how to remove this link from my template. I don't see the table in MS or PS. When I right-click on the link I get the message: "The data link is being used and cannot be deleted."
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?
