AutoCAD Inventor :: Edit / Extract 3D Coordinate After Excel XYZ Upload
May 9, 2013
I'm doing some work with routed tubing at the moment using the Excel XYZ upload facility with auto-bend enabled and it works great. What I would like to know is if there is a way to edit an individual intersect point after the 3D line has been created? I've tried myself but can only movethe complete line, (all coordinates).
I would also like to know if it is possible to extract all XYZ intersect points back to excel or a table within Inventor so I could use the data with a CNC bending machine? Even displaying all coodrinates on the screen at once would be useful.
A working example would be as follows..., I will upload the customers XYZ data to create a 3D line, modifiy specific intersect points to simplify manufacturing and then extract the new co-ordinates to be used for prototyping purposes.
View 1 Replies
ADVERTISEMENT
Sep 9, 2012
I'd like to drive the position of workpoints by coordinate values defined in Excel. Inventor allows me to initially create them using values from a linked spreadsheet, however the positions do not change when the spreadsheet is updated. Is there another technique that could do this?
View 1 Replies
View Related
Apr 1, 2003
How are we suppose to do a simple rotation around the y axis ( like a mirror of the sketch ). I think that I have pick every single line in my ipt but inventor can't show me what I want.
View 8 Replies
View Related
Jan 27, 2012
I have had several sheet metal parts return error messages to edit the sketch coordinate system after the part has been modified. This usually pertains to a dimensioning drawing made to the flat pattern. I have found how to edit the coordinate system, but I don't know what to edit it to. If I select the center point I can drag it from where it sits to an existing corner and select done but that seldom resolves the issue. What is Inventor looking for? I sometimes get a message asking if I want to edit the axis as well but what to do there.
Why can't these sketches orient off the center point that is already in the model? If it would stay put I could dimension to it and be done but it has to twist and turn the model and then put the point on some corner, not usually where I would like it and then I get these errors if I alter the model later.
View 1 Replies
View Related
Jan 23, 2013
I work in a manufacturing facility and we are trying to come up with a way to extract data from an AutoCAD file in to a .KML or .CSV file which gives coordinate points, etc.
This will be used in a mapping-type software to display/highlight areas of the plant with zooming capabilities and information shown on the left-side. We are trying to make it look something like Google Maps, so it can used to determine areas of the plant undergoing work, lighting zones, etc.
In a nutshell, I want to be able to extract coordinate data from our layout(s) which can used to pinpoint locations on the map and highlight regions, etc. Perhaps it could export data in to Excel with attributes assigned to the coordinates which give Area, Bay Location, etc. The initial thought was to somehow export this to a .KML file and use that as a starting point.
View 2 Replies
View Related
Nov 16, 2011
See attached.
I no longer have the option to edit iparts or iassemblies via speadsheet (excel). I'm using Excel 2007. (INV 2012 Sp1)
Is excel functionality part of an addin that I might have turned off accidentally?
I believe it was working in 2012 but haven't really noticed it not working till after Sp1 install till now..
Running 2014 Product Design Suite Ultimate
Windows 7 64 bit
90G OCZ SATA 3 SSD
Core I7 920 processor, ATI HD6970 graphics card, 12G Corsair RAM
View 5 Replies
View Related
Mar 5, 2011
suppose i make one file in excel i put N:5200000.000 E:5210426.00 in excel now i want to convert it in auto cad same orignal cordinate then i make one CAD Drawing.
View 9 Replies
View Related
May 9, 2013
I have a program that I used years ago to extract attributes from AutoCAD into excel. The VBA program is in excel. It is Attribute extraction Utility for AutoCAD Release 14. I want to use it again for 2014 but when I run it I get a compile error can't find project or library and it highlights the the following code "set doc = ACAD.ActiveDocument". Below is the entire VBA sub routine.
' THIS EXTRACTS THE ATTRIBUTE VALUES FROM AUTOCAD TO EXCEL
Sub Extract()
Dim sheet As Object
Dim shapes As Object
Dim elem As Object
Dim Excel As Object
Dim Max As Integer
[Code]...
View 2 Replies
View Related
Feb 2, 2013
I enter data into an Excel job setup worksheet. I then want to be able to extract data from given cells in the Excel worksheet, and have this become fields in AutoCAD. I do not want to use a table in AutoCAD - I want (ideally) to have the Excel data come in to AutoCAD as a field. I can see that Data Links tends to come in only to a table in AutoCAD.
View 1 Replies
View Related
Mar 2, 2007
how to extract pile coordinates to excel or spreadsheets, or anything that works and is quicker than just individual pile coordinates. i have about 446 piles.
View 9 Replies
View Related
Jan 28, 2012
At center line I want to place a small perpendicular line in specific length and put their coordinate to excel sheet(export coordinates).
I have already two programs for this, one for placing objects on curve with specific length and 2nd for pick & export coordinates to excel or other type of file. but this is very lengthy process & need too big time. but I think it cab be done in a single command written in lisp.
View 1 Replies
View Related
May 17, 2013
I have an excel document with a document header reserving rows 1-12. When i use "extract data" in autocad, i don't want the excel header to disappear. Can i set another cell than A1 to be the starting cell in Excel? Or how do i keep the header in the document?
View 5 Replies
View Related
Aug 16, 2012
I'm dimensioning an old drawing with the real (measured) dimensions and with the drawing dimensions in brackets (using ' 1500 (<>)' to give '1500 (1505)' for example.
What I'd like is to also be able to put on the difference between the length I type in and the length in brackets - as this would let me see any really glaring errors that can't be attributed to user-error on the laser measure.So I could type in '1500 (<>) (X)' where X is the formula, and get ' 1500 (1505) (5)' back?
How to be able to run a script that could highlight any dimensions where the number is brackets and the typed number have a a difference of, say, 50.Or failing that, any way to extract all the dimension text at the end into excel so I can see the differences myself?
View 1 Replies
View Related
Jun 15, 2013
I've spent the last 4 hours searching for an answer to this question, but I simply can't find one.
As a start I think you have to know that I'm currently using AutoCAD 2012.
Here's the problem: I need to extract some info from an AutoCAD table to a reference file that can be opened in Microsoft Excel. Everything I find on the subject is actually an answer to the question "How does <DATAEXTRACTION> work?" or "How to do an extraction of DATA in AutoCAD?"....
In this particular case I have a set of production drawings (cut tickets) for manufacturing of stone. And in every single sheet I have this material schedule or a table, if you wish, that is made with an AutoCAD table. In this schedule I have the height, width and thickness of the stone plate and with a function it measures it's area and volume. What I want to do is to extract those values into a reference file that I can open with Microsoft Excel, as I already said.
How exactly?
View 3 Replies
View Related
May 8, 2013
I want to extract the metadata I have added to my images and export it into an Excel spreadsheet. Can this be done within LR4.4? If the software doesn't have a function for this is there another way to do it?
View 2 Replies
View Related
Feb 6, 2011
How do i upload pictures a want to edit for my prop editor .
View 1 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
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
Feb 25, 2014
I edited my picture in LR then I choose > Edit in Photoshop. All well. PS opens and I edit in PS. Then I save my image on my PC as a JPG. Then I want to upload it to a site certain site. And once the photo is uploaded the colors are all different. Not slightly but let's say I selected Old Polar as a preset . It will be like that in PS but on the web it looks like for example blue became closer to dark grey. Or other colors changed.
When I edit first in LR . Save it to my computer . Then open it in PS it works fine. But I don't want to do that.
View 3 Replies
View Related
Jul 6, 2012
I have a drawing which has hundreds of levels on and i'm trying to establish what the MEAN level is and the AVERAGE level. I thought the best way might be to extract the text to excel and perform it there but at the moment the only way i can do it is to copy and paste the text and its taking me forever. Is there a way to either a) extract text to excel or b) calculate a MEAN value based on texted selected?
View 2 Replies
View Related
Aug 31, 2013
i am trying to edit a photo from an image we took at a shoot and want to upload our faces to the body.
View 3 Replies
View Related
Dec 31, 2013
I have load schedule drawing with OLE object (as excel image with out any link) . I want to make some changes in this load schedules. so what should I do to make the changes as I want.
View 7 Replies
View Related
Nov 1, 2005
I want to be able to edit text by editing a cell in excel. I am not sure if there is any way to do it with AutoCAD LT 2004 and Microsoft Office Excel 2003.
View 2 Replies
View Related
Apr 10, 2013
im having an issue with my site Headphone Styles, I'm trying to extract the logo at the top left hand corner and edit in photoshop. if this image file extension is compatible with photoshop?
View 4 Replies
View Related
Jun 25, 2010
I have created some reference points on a part. I have a need to include a table on the drawing of this part that shows the x,y,z coordinate positions of each of those points relative to the coordinate system origin. I have been trying to figure out a way to extract this information from the part to create source data to place into a table on the drawing.
View 3 Replies
View Related
Feb 25, 2013
Is there anyway to report a coordinate of a part in a sketched symbol.
I have a plan view and would like to be able to point to specific part and among other things, report its elevation.
View 7 Replies
View Related
Sep 30, 2013
I try to reposition the origin of the coordinate system of a sketch with the pop up menu, on the RMB.
I position it correctly, then press enter-nothing happens. i RMB and select OK, and when i check again-the coordinate system remained in it's previous state. I did it a few times with 2 sketches and gave up
View 2 Replies
View Related
Aug 6, 2012
When ever I want to change the sketch plane for a already finished sketch, I use rmb, redefine and choose new plane/ planar face.
Why does the sketch position change from the original coordinate point when redefined to new plane?
Inventor Professional 2013
Vault Collaboration 2013
View 1 Replies
View Related
Dec 25, 2011
I made a complex assembly from Solidworks few years ago. I imported it to Inventor 2012. How can I find the coordinate of the center point of the: a) parts/sub-assemblies, b) the complex assembly as a whole? Under Application Options, I have already checked: Sketch->Display->Coordinate system indicator. Under the assembly tree, I can go to the Origin of each sub-assembly/part and make the corresponding Center Point visible. However, I want the x,y,z values.
I copied and pasted a sub-assembly/part to a new assumbly file and then used VRMLout to export. When I imported the .wrl files to another application, the location of the parts/subassembies are not correct. I think they all became (0,0,0).
View 3 Replies
View Related
Jan 30, 2012
Is there a way to set Inventor so that the sketch origin defaults to the part origin? I find it very frustrating that it always defaults to some random corner of the part's body. It can screw up a part if you decide later on to modify the part such that you eliminate the point to which a coordinate system was defined. Also, when copying and pasting a sketch to new work planes it can be a pain to figure out which point is the origin of the orignal sketch if the pasted sketch is misaligned.
I know you can edit the coordinate system after a sketch is created, but I'd prefer not to have to rememember to do that with every sketch.
This was brought up about 6 years ago and there was no formal resolution
[URL]
In the second-to-last post John-IV8SP1mentions an option under 'Application Options' for an older version of AI, but I cannot find it in the 2012 applicaton options.
View 9 Replies
View Related
Mar 14, 2012
Using Inventor 2012
I have parts inported from stp-files, now the coordinate system is different in all these parts.
How do I re-define the coordinate system to my needs in these imported parts.
View 6 Replies
View Related
