AutoCad :: Way To Access Information From Excel
May 20, 2011
I've found a number of articles outlining the process of extracting data from AutoCAD to an Excel file, but I'm wondering if it's possible to do the reverse. For my work I have a number of databased already established in Excel and am able to create information tables rather quickly that access these databases. Currently, after creating a table in Excel I then copy, paste, scale to the right size in AutoCAD.
There's gotta be a way to create a table in AutoCAD that simply accesses this information in Excel and just updates automatically. I produce a number of CAD drawings off of a template daily so this process has become quite the bottleneck.
View 4 Replies
ADVERTISEMENT
Jun 23, 2012
- when modelling a part file in Inventor, only the dimensions we set (dimensions we give a name and a value), are listed in the parameters table. This way, its possible to export the information listed in that table.
- the information listed in the parameters table is based on sketches and features dimensions, as obvious.
So , my question is: is it possible to access the information (dimension values) contained in a feature (or a sketch) without setting a specific name or value to it?
For example, in the attached pictures, if a rectangular form is drawn and the dimensions are sett, these will be listed in the parameters table (see attached "pic1" and "pic1 - params").
But, in the other hand, if the same rectangular form is drawn, but this time without setting any dimension, the parameters table will be empty, obviously (see attached "pic2").
After this, i can surely presume that Inventor saves or keeps this information somehow, somewhere, without having to set dimensions or values.
So, my question is: is it possible to access sketches and/or features information without setting this values?
View 6 Replies
View Related
Oct 22, 2013
I want to present additional information on my drawings, whether in notes or some other form depending on whether it is a part or assembly drawing. The information I want to get access to is included in the material library and comes from the material Physical tab > Information section > Source, Subclass, Type, & Name.
Is the material library information accessible this way?
View 1 Replies
View Related
Dec 29, 2011
I'm having an issue plotting or exporting a dwg to pdf. When I have a dwg with a linked excel table and want to plot a layout, everything plots except the excel table. I'm running LT 2012, windows 7 pro (64-bit). I send the same file over to a friend running LT 2011 an he adjust the viewport boundaries slightly and he encounters no problem either plotting or exporting to pdf. I've tried the same with no success. My Adobe Reader is up to date as well.
View 7 Replies
View Related
May 18, 2012
I have 200 files listed in Excel. The file name in excel is an attribute being document number in title block.
How I can import this directly into eac .dwg file?
View 1 Replies
View Related
Nov 9, 2012
I am currently trying to retrieve data from a MS Access Database, we currently have iProperties with number values in them. An outside programmer created a code which takes these values and exports them to an MS Access Database, where they are then translated to mean something.
Instead of exporting those numbers, I want to use them to find what they ACTUALLY mean within the database and bring that information back into iLogic. (ie. 123456 actually means "1/4 Flat Bar Steel")
In short, I wish to access the MS Access database through iLogic in order to read information from it.
I have searched for the better part of 3 hours but have not found a good answer or example code of this situation. I am not that experienced in programming, but have worked with the API before for developing Automated Drawings and have an understanding how to navigate through. If there were to be some example code, I can begin to understand the process quite well through this method as well by seeing how to go about coding this.
View 2 Replies
View Related
May 10, 2012
I am programming an Illustrator plug-in for flexible modifying the width of stroked lines created by the Paintbrush Tool or Pencil Tool. The way of width modification should be similar to the "Width Tool".
Now I would like to have access to the painted area of the stroke lines, which I want to modify. With the Width Tool it is possible to modify the borders of the painted area very flexible. That is the same I want to do in the first step, but I do not know how to access these borders of the painted areas of stroke lines. I would like to know which Suites/functions are responsible for dealing with the painted area of stroke lines.
View 1 Replies
View Related
Feb 17, 2014
I have 26,000 images on an external drive (currently designated drive M), almost all tagged and/or rated and indexed in two PSE 11 catalogs on the main PC hard drive. I am just about to replace my PC. I assume that when I connect my external drive to the new PC, it is unlikely to be Drive M. How do I maintain access through the catalogs with all the stored information?
View 2 Replies
View Related
Jun 7, 2011
I know how to access the EXIF information inside PSP software OR from within WINDOWS but how to access it in terms of a text/DOC file so that it could be printed or used in other software?
View 4 Replies
View Related
Dec 27, 2011
I'm fairly new to Map 3D and I'm trying to attach either an Excel or Access file as a data source. I started out with a simple test case and created both Excel and Access files following the steps outlined in the first reply in post:
[URL].......
When I get to the drag & drop step to attach the data I get the following error messages:
Invalid Wordspace file format: My DocumentsTEST.xlsx
Invalid Wordspace file format: My DocumentsTEST.accdb
Not to be deterred, I saved the source files back to earlier xls and mdb file versions and was successful at attaching the data in both cases, but Map reported that there were no tables when I tried to define a link template.
View 5 Replies
View Related
Apr 19, 2012
Is there a faster way to create figure prefix i.e form excel spreadsheet or access.
I have one tip also. When you modify the figure database "C:ProgramDataAutodeskC3D 2013enuSurvey" by using notepad and you add "*" after each figure it will connect during linework codes that much the prefix code and will exclude the integer, EPN1 and EPN2 will be treated as EPN
The aterisks can not be added from the civil3d .
View 9 Replies
View Related
Jun 3, 2011
I am looking for a way to use the .dwg file properties of a drawing to generate an updateable drawing list/register. One that will update automatically as the file properties are updated. I have already created a title block that uses text fields to display custom properties of the file on my title block, such as the job no., drawing no. etc.
I have searched the web for answers, came across this site, joined and searched through it... There are a number of threads that 'sorta' deal with my needs but alway tend to digress more towards the "poster's" needs and away from mine. I noticed that they all talk about Lisp Routines and I have no knowledge of using them. Is that the only way to go or can I use another route? Another one was the Sheet Set Manager but I don't think that this is exactly what I am looking for...
View 1 Replies
View Related
Apr 25, 2013
I have create an excel file with a description and a hyperlink.With this way the user is able to open all the file that was able to open in only one excel.So far everything is OK.My problem is this. Have added 3 new lines for 3 different adobe illustrator files.When the user makes a click in the hyperlink open the adobe illustrator but is empty.They don't opening the file that has added in the hyperlink. (It happens only in the .ai files all the other files .pdf - .doc - .jpg opening without any problem)
I use windows XP with SP3 and adobe illustrator CS4
View 5 Replies
View Related
Aug 26, 2011
I am a AutoCad drafter for telecommunications and I have utility pole points (long/lats)
I can insert the poles via long/lat and all is great, my issue is I would like more information in those points.
For example, pole number, class, HOA, Make Ready. Currently I create a survey data store and import ASCII Points using PNE(comma delimited)
So with my Excel file (this is where I get my pole information from) I get a point/northing/easting to enter into the formatting section.
I would like to add more information to these individual points, like ploe number, class, HOA...
If I view the point table I see that there are a lot of other columns, can I use them or customize them? is there a quick tutorial on this issue?
View 4 Replies
View Related
Oct 30, 2008
When I link in an excel document to my model all parameters in that excel gets the unit (mm).
How can I change this? For instance I want some of the parameters to be an angle.
View 8 Replies
View Related
Apr 26, 2012
Just loaded 2013. Of course right away I get an error. "Internet access is required to access the Help" Well as you can see I have internet access.
View 4 Replies
View Related
Sep 4, 2013
Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.
View 6 Replies
View Related
May 29, 2013
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
View 8 Replies
View Related
Feb 13, 2012
We have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.
We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?
View 3 Replies
View Related
Oct 18, 2011
How to link some additional information to objects (3d solids, shapes, etc) in Autocad Civil 3D 2011. It would be perfect if it would work like this: i click on the object and information pops out that was hidden before.
View 2 Replies
View Related
Oct 9, 2012
Client is using straight up AutoCAD.
Wants to bring ESRI information into a DWG (actual data not just linework).
I know MAP and C3D does this with no problems and you can go open the file in AutoCAD. Problem is the data is not visible when you open it in AutoCAD. Switch back to C3D or MAP and you can see it again.
Just want to make sure I cover all resources before I tell them it can't be done without scripting something for AutoCAD.
2012 C3D
2012 MEP
View 4 Replies
View Related
Jun 27, 2011
I want to create an application that intensively uses dynamic blocks, cross checking any new or changed block entity with existing ones.
It needs to be almost instantaneous but the only way I know will be impractical.
Looping through the property collection of each block reference, searching for each parameter then checking for a match.
Is there some sort of database functionality I can use to quickly compare block information?
View 1 Replies
View Related
Aug 16, 2012
I have a problem importing text information from shp file to dwg. Using a command “Add to Map” I can see that shape file consists of Map Feature(s) objects and under Feature Properties there is an information that I need to move to Autocad environment (IGDS_TXT_;TEXTSTRING; TEXT_ANGLE). I’ve tried “mapimport” command but in result I’ve got only acad point objects with no information in it.
View 3 Replies
View Related
May 10, 2012
When I create a sketch block, there is a description area. After the block is saved, how can I see this information again? If I right click on the block in the browser, I cant find it anywhere.
View 1 Replies
View Related
Feb 23, 2012
Since we switched to AutoCAD 2010 we have been having trouble with things disappearing when we plot to PDF. I can not find a pattern with the things that are missing (i.e., area on page, layer, linetype, etc.). When I do a plot preview everything appears the way it should and then after the PDF is made items are missing. Typically after a couple of trys of rePDFing the drawing everything appears and works fine. I am using Vanilla AutoCAD 2010 and Adobe Acrobat 9 Pro.
View 3 Replies
View Related
Mar 16, 2012
I want to add a sort of legend / information box to my drawings, in a manner where it can remain constant and in the same place every time I print but I can edit the information therein. I guess that means making up a template, but I'm stuck beyond that.
Having robbed this picture from the Google image search:
I want to make that table at the top. Maybe add a company logo, the title, scale, author, etc. I'm sure you know the score. But I was hoping I could do it in such a way where I've only got to draw it once and all future drawings I can simply edit the specifics and add it to all drawings, regardless of size or scale.
I normally draw things with a pencil and drawing board and believe me during this learning process there have already been too many times where I'm tempted to go back!
View 6 Replies
View Related
Apr 26, 2011
once I've set an origin, how do you get the geometry info in the properties to show the coordinates from that origin? what I want to do is set an origin and then find relative points from that origin. What are the ways to do this? On ProgeCad I would just set an origin and then if I viewed the properties of say a circle, it would tell me the x,y,z coordinates from that origin but I can't seem to do it in AutoCad.
As you can see from the picture, what I did was set an origin at the on point. Then I selected the arc for which I want to know the coordinates. But as you can see in the properties it says the x,y are like 566,567mm, but clearly if I draw lines to that point and measure the lines it is only like 1.00,0.70mm.
View 9 Replies
View Related
Nov 19, 2013
When I export an .las file, I loose the contents from the description column. Is there a way to retain this information? I periodically update a drawing prepared by a different department that includes up to +500 layers. I would like to include descriptive information as part of the layer state that includes directions how to change/modify individual layers. Can this information/tags be saved directly in the .las file? Is there a different method to do this, short of preparing a separate spreadsheet?
View 0 Replies
View Related
Jan 25, 2013
I want to block the information of plotting in the editor see example (french version) :
***Zone effective du tracé: 290.70 de large par 400.97 de haut
Fenêtre de tracé 2.
The information is showing when i plot. How i can do that ?
View 2 Replies
View Related
Jan 6, 2014
I tried to get the XML-Information of a weld. But the string that should contain this information is empty. Did I make a mistake?, or is this feature not supported by Inventor 2014 anymore. Even the helping page "More XML Weld Info..." doesn't exist anymore and leads to an error.
This is my VBA-Code to show the XML-Info string for each weld within the assembly in a message box:
Sub WeldInfo()
'is the active document an assembly?
If ThisApplication.ActiveDocument.DocumentType <> DocumentTypeEnum.kAssemblyDocumentObject Then
Return
End If
[code]........
View 1 Replies
View Related
Sep 24, 2013
if there is a way to get detailed file information. I'm teaching a course this quarter and need to review about 300 dwg files/week for homework and labs. Obviously, cheating is a major issue (copying other files). Students are getting a bit more clever and can get around windows data (accessed/modified/created stamps). I think AutoCAD has more detailed information related to the dwg file that I can extract to compare files.
View 8 Replies
View Related
