AutoCAD 2010 :: Data / Properties Link With Oracle And SQL
Jan 5, 2011
I have been tasked with finding a way to link data from Oracle and SQL databases with CAD files of rooms in certain buildings. My goal is to be able to select an arbitrary room within a building and be able to access certain information. I don't actually have access to the databases yet, but I would like to know how to do this when I do. My data consists of "human" data such as: name, email, position, sex, etc; as wells as "physical" data such as: square footage of the room, who uses it, computer serial numbers, or what department is in charge of it. Using this data we will cross reference the tables to determine what our needs are.
My AutoCAD skills are good but I've never come across anything like this in the class room. Most of my knowledge is Civil based and more focused on design.
View 9 Replies
ADVERTISEMENT
Jun 14, 2013
ORacle spatial connected via FDO.
Oracle Table uses a user defined SRS.
Drawing entities (CAD) in DWG file.
command: mapexportfdo
If no CS is assigned in Map 3D, the export of the autocad entities works ok, the result geometries are written with the correct (table/metadata) SRID.
If a CS in MAP3D is assigned (for example as a result when using a WMS from a public server), the export fails.
It seems that MAP3D is trying to "translate" the CR to SRID somehow and it fails if these are different. As this is a "plain CAD" to GIS export, I expect MAP3D to behave like:
Either it just works as in the first step (write geometries) and pick the SRID from the metadata, without applying any transformation.
Or it applies a transformation if feasible ONLY when I the user checks the thick box: Convert Coordinate to (in the options tab on the Export dialog box.
In my case I do not want to transform, I just need the geomes being exported into the target table. So far I have only managed to do so when both drawing cr and oracle SRID are "MAP3D technically equal" (based on a similar EPSG code)
Specifically, because MAP3D does not recognize the user defined SRID in ORacle, obviously it is up to the user to know what to do with the data.
NOTE1: "export fails" is the only message as a user I get from the software, not knowing what is going on. I had to drill down this issue by trial and error, great error messaging (or better refusing message).
NOTE2: Export via another file format is NO option! I need a direct export (as it always worked, also when creating features from geometry). This time I need to exportway.
View 5 Replies
View Related
Nov 23, 2011
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.
View 6 Replies
View Related
Apr 11, 2012
I'm using the ribbon in 2012. I've got a drawing index sheet I want to update, and what I need to do to get to the Edit Data Link command is switch to the Classic interface and select the table in order to display the Table toolbar with Edit Data Link button.
I cannot find this anywhere on the ribbon, and the same button icon as Edit Data Link on the Table toolbar runs Data Link Manager from the Annotate tab, Tables panel on the ribbon, which is not what I want.
Where is this on the ribbon? And how come identical tool buttons run different commands in different workspaces?
View 5 Replies
View Related
Sep 7, 2012
Is there a way to turn off the Data Link Updates? I want it to be a maual process. Right now it tries to update the data links when I print. It asks if I want to skip but I have to do that everytime I print. Can I turn that off. If it updates it destroys the formatting of the table.
View 6 Replies
View Related
Mar 16, 2012
I have created a table style in ACAD 2012 with all of the cells formatted to what I need. The trouble begins when I bring in a BIAS excel data link to populate the table. I have tried every option in the insert table steps and have even tried all the different options under the modify excel link options. I have toggled the use excel formatting on and off, which does change the table size a small bit, but does not allow the table style to take affect.
I have attached a screen shot of the "good" and "bad" tables. The bad table is what the good table comes in as and it is also what happens everytime the table link updates. It always reverts back to the bad style and then I have to change the table back to the good one by hand - changing each column individually.
Is there a way to attach a data link to a table with the table style holding its shape and formatting?
This happens on all of my drawings and using all kinds of different excel links.
how to bring in the data link??
View 8 Replies
View Related
Feb 1, 2013
I'm inserting a data link from excel into my CAD drawing and every time I try to select the table it brings in, the corner "grips" the green plus signs, are so huge they are bigger than my sheet and I can't see anything in the table. Any way to shrink them to a rational size?
View 2 Replies
View Related
Dec 8, 2010
I've created a table (a door schedule for example).The data cell type properties is "general". The door # is "001". When I type this in, it switches to just "1" and the type is swiched to "whole number." Same for another cell with a number in it, it switches the cell type on me and I don't want what it switches to. Every time I try to switch it back it doesn't do anything.
How do I stop it from automatically switching, or at very least let me override?
View 4 Replies
View Related
Sep 18, 2012
I have an issue between XP 32 bit ACAD 2011 workstations and Windows 7 64 bit ACAD 2011 workstations...
1 - A Windows 7 user does a Paste Special>Paste Link>Microsoft Excel to insertembed a portion of an Excel worksheet into the DWG.
2 - various win7 and XP users make changes to the Excel worksheet directly in Excel
3 - Win7 users open the DWG to see the correct and updated Excel data in the DWG
4 - XP users open the same DWG to see OLD data from a previous save and not the correct updated data on the linked worksheet
5 - XP users directly open the Excel file in Excel and are able to view the correct updated data BUT NOT IN THE DWG
6 - XP users see old incorrect excel worksheet data in the DWG. Win7 users see the correct data in the DWG.
View 5 Replies
View Related
Dec 26, 2011
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.
View 5 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
Jul 10, 2012
When I select any object, my quick properties tab is blank and my properties tab doesn't register anything. Also, I get an error message when I go into my CUI to try to modify the quick properties tab. Pretty frustrating. I've attached a couple of images for reference. I've repaired, re-installed and unistalled and re-installed and still have the same probelm.
Dell Precision T3500
Intel(R) Xeon(R) CPU W3530 @2.8GHz
ATI FIrePRo V5800 (FireGL V)
12 GB Ram
64 BIt OS
View 3 Replies
View Related
Aug 29, 2013
I am looking for a way to link custom harness properties to equal i-properties for an electrical connector, My end result is I would like the Cable and Harness report generator gather "description" but I will not recognized the i-property " description" but if I create a custom harness property "description" it will report that. I would like the custom harness property to equal the i-property of the part, or am I going about this the wrong way?
View 1 Replies
View Related
May 13, 2013
Here in some IAM mine, i need to put a % more of some parts, so I decided to use virtual components for that. It worked great, but I'm with 2 doubts to get faster doing that.
1º - Is there a way to link the properties of a virtual component, to an existing part ? Like mass, part number and some Customs too. That would be easier in this case, when I need just put some more parts without change the modeling visual.
2º - Can I use a template to create a virtual component ? I did some searches, but I just found topics from 2005 that it wasn't possible, but with IV 2013 or even 2014 is that possible ? I have here many custom properties that I always have to create again in virtual components.
View 1 Replies
View Related
Nov 1, 2012
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?
View 2 Replies
View Related
Aug 19, 2009
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."
View 2 Replies
View Related
Dec 10, 2012
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?
[URL]
View 1 Replies
View Related
Jan 7, 2013
We recently tried to convert a RAW data file to FBK and the program aborted after running several setups. I have viewed the raw data on the data collector, but there appears to be no error. What other methods of conversion could I use to convert the RAW data file to a TXT file? I was hoping that our local AutoCad/Topcon dealer would be able to have a work-around, but they seemed stumped too. We have never encountered a problem usitlizing the Survey data Collection Link with any of our traverses prior to this time.
View 3 Replies
View Related
Sep 9, 2010
When I try to reference an object in the Data Shortcuts menu, when I right-click the a profile in Prospector under Data Shortcuts, the option to "Create Reference..." is grayed out, and I am unable to reference that profile into the drawing I am working on. It works fine on other profiles that are being referenced from the same drawing.
I have tried:
1. Re-creating the alignment and profile data shortcut in the drawing being referenced
2. Creating a reference in my drawing to the alignment, which actually works. However, it still does not allow me to "create reference" for the profile.
3. Refreshing the data shortcuts.
4. Synchronizing the alignment referenced in the drawing.
Nothing seems to work. My only other option is to move the C3D profiles from the referenced drawing to the drawing I am working in. Is there a way to do this?
View 8 Replies
View Related
Nov 19, 2013
I need to create a small table to ID the User, Computer name, Door Key, etc for a floor plan drawing of our office. I'd like to get this done in Excel and link it all so the bldg manager can make changes to the drawing without me. I have created the excel file and created a "name set" in excel for each room. In Autocad 2013 I have inserted a table from a data link and pointed that link to the named range of the room (the named range in excel is an 8 cel block with al the info I need repeated and uniquely named for each room.
This works great...so my next step is to create a block out of the table and make the DATA LINK a variable attribute...that's where I'm stuck. i cannot figure out how to do this. I would love to be able to INSERT BLOCK and have one attribute question...ROOM NUMBER?. That should look to the excel NAMED SET the corresponds and populate the table.
View 1 Replies
View Related
Jun 21, 2013
I cannot remove datalink was created by Insert Sheet List Table. Cannot see it in Datalink Manager.
View 6 Replies
View Related
Dec 23, 2013
I have made a data link to an excel file. Then I bring it in as a table. I then adjust the text height and remove all formatting from the table. Unfortunately, after closing and re-opening the file, the table changes. I lose formating/cell alignment/text height. It isn't even consistent across the table. The lost formatting is only on the 2nd split of the table, the first side retains the corrected formatting. I have selected the option to not update excel formatting. I don't even get a notification the table is updating. There haven't been any changes to the excel sheet either....
View 6 Replies
View Related
Jan 24, 2013
when i create a data link with excell, the data link contains pages of unused cells. how do i controll the data link and have it show only the cells desired.
View 6 Replies
View Related
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
Jun 2, 2010
Using AutoCAD 2010 LT with service pack 1 and 2
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?
View 9 Replies
View Related
Jul 24, 2013
I want to link Microsoft Excel data with AutoCAD drawing (like dimension or values). When I made some changes in Excel data, value in AutoCAD drawing can be changes automatically.
View 1 Replies
View Related
Aug 2, 2013
We use Survey Data Collection Link to convert our file formats, in this case it is a GPS job exported from a TSC2 using Trimble Survey Controller Version 12.46. I exported the job from the data collector as a .csv file then use SDCL to convert the .csv into a .fbk file. I am getting this error saying the file is invalid or in use. We ran into this problem a couple months ago and it disappeared after a couple days, and now it has resurfaced.
Running Autocad Civil 3d 2012 with Service Pack 2, Windows 7 64-bit OS.
View 1 Replies
View Related
Apr 26, 2011
we recently were trying to import an excel table via data link function. Initially this works fine and the table appears in the drawing however when we want to break the link by deleting it in the data link table autocad tells me that the link is in use. We routinely do this in autocad mechanical 2010. The reason we do this is to be able to bring in the table and preserve formatting. How can we easily delete the data link in 2010 LT?
View 9 Replies
View Related
Mar 24, 2011
As title says, I create a new Excel Data Link using "Data Link Manager" but it takes forever! If so, how can I get rid of waiting long time when creating/editing a Data Link?
View 0 Replies
View Related
Mar 20, 2012
Possible to add custom fields to an AutoCAD object and be able to view those fields and contens in the extended data tab on the properties palette?
If it's not possible with VBA is it possible with .NET?
View 1 Replies
View Related
