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.
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?
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.
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.
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.
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.
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?
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!
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.
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.
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?
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.
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.
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.
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.
I use simple set of iLogic rules to manage product configuration through the assembly LOD. Assembly is really simple not more then 30-50 parts. Still I manage to crush Inventor fairly often. Some days 5 and more crashes! Several times sent crash report to AutoDesk for no joy. Never got any feedback.
I am just getting an impression that Inventor does not like LOD manipulated with iLogic for some or the other reason.
I am having trouble managing a PDF underlay once I have inserted it into my drawing. If I move either the underlay file or the dwg file, it loses the reference cannot find a way to update the path. A co-worker with 2011 LT can manage his underlays using the external reference manager. My Xref manager does not display the PDF underlays in the list of references, so I can't use that tool to update the file path. I have also tried manually changing the file path in the properties box, but that doesn't work either. It is a locked value and I cannot select it to edit.
I have tried inserting a pdf underlay with all three (Full Path, Relative Path, and No Path) path types, and still nothing shows up in the Xref manager.Is there some setting turned off somewhere? I cannot find an Xref Manager options, display options, etc.
I draw using different colors for the different layers I use & I am trying to print drawings using a plot file that I can manage my line weights and shades. In my plot dialog box I used to get a drop down w/ the different choices of plot files (for different clients) but that drop down no longer shows up in my plot dialog box.
I also checked the plot style table search paths in the options window and those paths show do not exist. I created the path as shown but to no avail.
I just started using 2012 and have few problems. I do MEP drafting and usually use multiple states within a dwg. we create bases and xref them into the various disciplines. When I toggle between the different saved states within a dwg, the layers in the dwg appear, but the xref layers turn off every time. is the a glitch?
Also i don't know how I turned this on, but there is a blue box that appears on my crosshairs and shows me the different lines that I select.
We use simple line drawings of parts. Some of these parts are used in multiple products, however if a change is made to a drawing it has to be replaced in all the other locations
I have tried to get them to go to 3d modeling and xref in the parts but apparently that is not acceptable , since there is no master assembly, but instead folders of dwgs is there an easier way of managing this?
I created two PDF's from identical files in Illustrator CS6 using spot colors but the colors came out different when printed although I couldn't find any apparent differences in the settings of the two documents.
I also noticed that when importing an eps file that contains spot colors in Indesign CS6, and export as PDF the colors in the PDF are sensibly different to the eps. It never happened with CS4.
I've been using LR for 18 months or so now, and do pretty well with it. But my organization, I think, is lacking. I'm not sure when I would want to start a new catalog, or why. It seems to be a pain to go from one catalog to another, just to access different folders of pics that I've worked on in LR. I now have dozens of folders that I can access in my current catalog, and I'm wondering if it's getting to be too many. I shoot lots of events, from weddings to dance performances, so many of my folders might have 1,000 images or more.
Are there any links to information or instructional videos that really explain the organizational process of LR? What I've seen so far gets me started in LR. It hasn't really explained how long you can stay in one catalog, or how many pictures can be in there, before LR's performance starts tailing off. I am a member of Kelby Training, NAPP, and I use a Mac Pro on a SSD, 32 gigs of RAM, so I should have plenty of comp power. Not really facing doggish problems right now, but just curious about LR's optimal organization.
Not sure if this is a LR or CS6 issue. When CS6 finishes editing, it sends a virtual copy back to LR4 - I now have 2 copies of the photo. How do I then get the newly edited version to be the main photo in all collections etc - does this have to be done manually i.e. remove the original and replace with the copy
Recently I was working on an A1 size sheet and exported it from Indesign as a jpg file. The settings were as follows
Output as CMYK Resolution - 300dpi
The final image was huge! - a staggering 73 mb file.
On the other hand if I would have done the same work on photoshop with same resolution, then the image would have come at maximum of 20mb filesize.
I know settings for pdf exports, but for jpg exports, the settings are too less [as far as I have observed]. So, what is the solution to keep filesize minimum with best quality [in my case 300dpi]
I need to save from Illustrator in .dwg format, for laser cutting. However the scale shown in Illustrator is not the same scale in the .dwg when they look at it at the laser cutting firm.
btw when I export in .dwg format the setting for scale is set at 1 centimeter = 1 unit. I don't know what they mean by unit however.
Currently using Capture NX and looking for somthing little more featured. LR3 and Capture NX2 are on my list. I like Capture NX becuase I am one who likes to be in fulll control of my picture management. I download my NEFS to a folder, convert to JPEG and save them in another folder and then transfer the jpegs to manually created folders on a NAS. Will LR3 control me by creating and maaging it's own picture database or do I have the ability to manage pictures like I'm currently doing?
What is the most efficient way to manage and migrate my Photoshop workspace and other preferences while working on different computers in the Cloud?
My home computer has Photoshop CS6 installed and I’m about to customize my preferences and workspace in the app. If I use my Cloud subscription at my workplace, how do access those same preferences at my workplace? Do I have to manually transfer my user prefs from my library,
