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.
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?
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.
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 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 created a data band in profile view that should show a created profiles elevation, but some of the the data fields are missing irregulary. Also in the data band that shoud show the diferenece betven the tow profiles - EG and the new profile the data is missing. The EG profiles data and the surface are ok all is shown.
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.
example [CommandMethod("Test")]public static void TestMethod(){ Document doc = Application.DocumentManager.MdiActiveDocument; Editor ed = doc.Editor; Database db = doc.Database; using (Transaction Tx = db.TransactionManager.StartTransaction()) {
[Code]...
1-autocad program will be closed 2-be selected within the file path c sharp example: csharp.jpg 3-I want to read data from a DWG excel file using C#. examples: dwgfile.jpg and drawing1.dwg 4-I want to list here DataGridView data 5-c sharp winform .net 4.0
I have several students working in 2012 or 2013 PC & Mac education edition who set the line type properties correctly but the line does not "read" correctly. Checked global scale factor, listed the content to confirm layer and line type as hidden, etc., checked the properties, made sure the line type and color were set to "by layer". It doesn't matter between model or paper space - the lines will not read.
Automated AI so much so that it can read instructions from an external source like xml or txt and automatically creates files and folders.
For example we have something like this: File1 Hello Font: Myriad Size: 22 Colour: Pantone 254C Image 1.jpg (link) Source: Image1.png (link) clipart1.eps (link) ---------- File2
and so on.
I want AI CS5 to: 1. create an eps File1, create a folder named File1, put File1.eps in it 2. type the text Hello, apply Myriad 22pt and PMS 254 to it, centre it to the artboard 3. Place all jpegs, pngs, eps source files on the artboard and embed them. 4. Save the file as eps legacy version 10, close the file and move to the next file.
Cannot read data on socket: Software caused connection to abort
I imported an AAF linking to R3D and Sony footage. When I tried scrubbing the timeline, I got that message. Smoke is REALLY slow now. And when I try to look at footage in my gateway, I get READ ERROR.
Also, the proxies don't start rendering in the backburner...
Smoke 2012 SAP2 SP4 and Smoke 2013 SP2 (Smoke Classic Keyboard Shortcuts) Mac Pro 4,1 OS X 10.6.7 12 GB RAM NVIDIA Quadro 4000 14 TB RAID (Areca)
I am doing a generic annotation with several rows of text, but I need to read the view scale in the project to set the spacing between the rows of text. My idea is to create a parameter that will be multiplied by the scale factor in the view.
How to read real number data from selected columns in an Excel spreadsheet into an illustrator javascript array variable, so that then I can use this information to construct an illustrator polygon.
Further information:
I am new to javascript (and not much of a programmer in the best case, but do have some basic knowledge using ancient languages like FORTRAN 88). I am sure I am just missing an important step here despite all morning browsing with Google for answers (something to do with variable definition I assume?). I have some survey data defining the outline of features in map view listed in a string of point (x,y) values in adjacent columns in excel (these x,y point values calculated from GPS data using a commercial program to converted 3D position to a 2D x,y by geoid projection, and then in excel to re-scale point locations to illustrator’s artboard). What I am trying to do is select columns of x,y value pairs in an excel spreadsheet, copy these values to the clipboard, and then develop an IA JavaScript to draw a polygon through the specified set of x,y points. It seems easy enough to script illustrator to draw the polygon once I get the values from the clipboard are in a javascript array (lots a good tips here [URL] ....), but pulling in the clipboard data seems to be beyond me. I have tried populating a defined array with various combinations of array declarations and app.paste(); or windows.clipboardData.getData('text/plain'); with no satisfaction. I then had the idea to try to pull in the clipboard to one long continuous string, place that in a text box (see see its structure), andthen read and split up the text in a loop to populate the JavaScript array…but that deposited a complex illustrator table object into my text box, and several attempts to force the clipboard to paste text did not work (again probably having problems understanding variable type declaration).
I would be happy to find any method of scripting the pull of the selected on an excel spreadsheet for use in an Illustrator script…so if I am making this all harder than it needs, be I would be grateful to know that also!
This is an AutoCAD 2011 related question about being unable to see under properties objects that I have attached to polylines in AutoCAD Map3D.
I have created an map3d .dwg that the polylines and points have attributes attached (objects). However, when I access the same file in plain AutoCAD nothing appears under properties.
Is is a format, import settings tweak or simply it can not be done?
I found super elevation labeling for profile, but not for alignment in plan view. Is there a way to label alignment, f.x. in critical points of super elevation automatically?
