AutoCAD 2010 :: Data Link Is Changing Table Style?
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.
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.
I am looking for a way to change the text style used by a table style with Visual LISP. So far I have been able to get the IAcadTableStyle object from the acad_tablestyle dictionary, but there is no property for text style. Is this even possible? Code and results are below.
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?
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?
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?
I have a situation where I just created brand new drawing templates and they have the revision block inthem already. The revision block that comes with Inventor. The vault is driving the revision in the titleblock and when the revision is placed in the revision block it too is linked to the vault. When the drawing is checked into the vault and the lifecycle is changed to "Released" and then back to "WIP" the revision updates. Both in the titleblock (which I want) and in the revision block which I don't want. Not only is it change the revision block, but the last revision posted as per the image below.
how do I change the property in the settings of the title block to not get it's revision from the vault or allow it to be manually driven?
I struggled for a while this morning with trying to data link to a large door schedule in Excel. After several failures, I searched online for answers, and read in another forum that AutoCAD won't data link to more than 2000 cells.
My door schedule is about 2050 cells now, and will be about 4000 when done. I defined a set of about 1,000 cells in the Excel spreadsheet, and AutoCAD linked to it no problem. So, I tend to believe the poster who stated the 2000 cell limit, but I can't find this.
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?
I 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 have a table linked to an Excel spreadsheet, I unlock the cells and then right click but the Data Link sub-menu is greyed out and not available. Cannot delete the link in the data link manager becasue it is in use. Had to open the drawing in 2011 and detach the data link. 2008 also detached the link no problem.
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?
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.
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.
Here's my problem: I have a customized plot style table "SK.ctb". I have it saved both in the appropriate folders on my computer and in a shared folder on the network. Usually when I am working in a file and open the plot window, my plot table is available in the list at the upper right "Plot style table (pen assignments)".
Right now I am working in a drawing that was sent to me by another firm. They of course didn't send me their pen assignment tables, not that I really care as I would rather edit the layer colors if necessary, but use my own. The problem is that in the plot window it is only showing their plot styles - none of mine! Theirs are all listed as missing, but I can't get it to even look for the plot tables I usually use.
Using Civil 3D release 2102 on a 64bit Win7 capable Dell Precision, everything up to date.
I have a table created from a datalink using TABLE command. I want to have it use a fill color of 255 in order to mask the objects behind it. I cannot seem to modify the table style, and using fill in Excel doesn't seem to the affect Autocad table.
As you know, when I create a table from a datalink I am not allowed to choose which style.
I don't like using wipeouts to provide a background mask, because they never seem to work when plotting from paper space.
How I can apply fill to the table, or otherwise mask the pbjects behind the table?
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
Our office has recently moved the folder containing our ctb files. The Plot Style Table Search Path has been correctly set on each computer, however when attempting to plot, Autocad cannot find the ctb files.
Having problem moving and repathing the location of the plot style tables?
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?
We have a person in the office that would like to create their own .ctb file that we would like to have them to access but they will also need to access our .ctb files (Standard). We currently restrict access to the .ctb files as they can be alterered leading to problems for everyone printing. Is there a way to create another path so they we can have a locked folder of .ctb files and an unlocked folder for .ctb files.
For some reason, my plot style is applied to my viewports. So for example, when I choose a monochrome plot style for the layout, the view ports in that layout display in black and white. I want to disable this. Is there a system command to turn this off?
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?
I recently decided to see how the AutoCAD tables work. I was very happy to learn you could link your Excel spreadsheets with CAD. But now I have a problem.
After inserting the table it refuses to use the table style I have set up. The fonts do not want to change at all. I can change the colour of the text, but not the font.
I have created a sample drawing, to illustrate to the design manager at work that we can use AutoCAD to assist us with the scheduling of materials, but I am unsure of all the ins and outs of it myself!
See attached drawing to make sense of the following:
Ordinarily we would use a panel reference number for all 50mm panels of identical length, i.e., all 1200mm panels (our standard width) will be assigned a panel code, often P01... etc etc. From the data extraction (EATTEXT) command, as you can see, all 50mm cleanroom panels under the 'name' column are according the block name, in this case, I've called it "Cleanroom Panel 50mm". Is there any way to assign an individual tag to all panels of equal length, yet maintain the same block - or is this simply asking too much?
The reason for this is that although the autocad generated table is ideal for quantifying and placing orders for materials, we are a design and build firm, all our construction workers will need to be able to identify where on a plan an individual panel is, i.e., all well and good to say one panel is 332mm long, and one is 350mm long, but he will need to know what panel is to be installed where...
I have data in an Excel spreadsheet that I want to insert into the drawing in a table format that replicates my spreadsheet formatting and creates AutoCAD entities as opposed to a bitmap image or the mess the TABLE command generates - I'm looking to keep my text consistent within the drawing and I still use the old SIMPLEX font.
I have this table that's reading my table style. All cell formatting is set to General and middle center justification.
When I type in a number the formatting automatically changes from General to Whole Number and upper right justification. When I type in letters everything it fine.
Why using numbers changes the formatting? In the textstyle I have changed the cell formatting to Text but that doesn't work. If I select the table, right click and choose Remove Overrides it moves the numbers to Middle Center as set in the style.
How can I rearrange the horizontale order of the table columns which made by (Extraction data).
I know how to rearrange it vertically, But horizontally that what I want to know. Example ( colomns order is : number, X, Y. How to change it to :X, Y , number )
I just got a new job with AutoCAD 2011. In the previous version (was using 2008 beore), I could select all lines, dimensions hatches, and then change the dimension style. But with this new version, as soon as I select anything that is not a dimension, like a hatch pattern or a regular line, I can't change the dimension style anymore. Is there anyway to change this back to how it was?
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?
