AutoCAD Inventor :: Simple Excel Parameter
Dec 5, 2011
I have an assembly that I have created a sketch on and applied some dimensions. I would like to send those properties to an excel file that can then be inserted into an idw. What is the best way to get the parameter values into an excel file that would update as the model changes? I found were more focused on changing the model with the excel sheet which is not what I'm trying to do. I did try them however, but whether I clicked link or embed nothing appeared in the excel file at all.
View 2 Replies
ADVERTISEMENT
Jan 17, 2011
in inventor 2009: i linked parameter of 3D design from excel file. If i change the value on excel file --> dimension of 3D design will change. It work fine.
So, in inventor 2011, i can not do it: when change the value on excel file, 3D model does not change dimension.
View 3 Replies
View Related
Nov 20, 2013
I have a Multi-Value Parameter "MV" that I want to populate using a Named Range from an Excel file that is already populating other parameters for the same file.
I currently have the file working by populating "MV" by using the snippet from iLogic below...
MultiValue.List("MV") = GoExcel.CellValues("filename.xls", "Sheet1", "A2", "A10")
The reason I don't like this method is because if ever that range changes... all the iLogic code will have to be updated as well. How to set a Multi-Value Parameter using a Named Range from an Excel file? I assumed the below snippet would work but I am receiving
"Array was not a one-dimensional array." as an error.
MultiValue.List("MV")=GoExcel.NamedRangeValue("Named_Range_Value")
View 4 Replies
View Related
Jan 9, 2013
I have a MultiValue Parameter that I want to populate using a named range from an embedded excel spreadsheet. I would like an iLogic solution if possible because I need other people to be able to understand the code without too much difficulty.
One of the sample snippets given allows access but not if the excel file is embedded.
'GoExcel.NamedRangeValue("Part_Width")
The code below works but not when using a named range.
' Load bearing housing typesMultiValue.List("parameter1") = GoExcel.CellValues("A1","A20")
Is there something I'm missing? I was hoping to use something like below
' Populate MultiValue Parameter from excelMultiValue.List("parameter1") = GoExcel.CellValues("3rd Party:Embedding 4", "Sheet", "myNamedRange")
View 2 Replies
View Related
Apr 9, 2012
I have a set of sheet metal parts modeled in inventor that are produced in a wide range of sizes and several different sheet metal types.
The dimensions (length, width, flange size, etc) are driven from a spreadsheet. I would like to be able to have the user update the K Factor from the same spreadsheet by selecting a sheet metal type.
The sheet metal type and K factor are not listed in the parameters list with the other model dimensional data, so I'm not sure how to proceed.
View 1 Replies
View Related
Dec 23, 2011
I have user parameters that are no longer needed and are not being used anywhere. They each takes 4-5 seconds to delete, prior to 2012 this would happen instantly.
IV2014 SP1 64bit
Dell Precision T7500, Geforce GTX 480, DirectX11 306.97
SpaceExplorer 4.04, 3DxWare 3.12.2
Twin Intel Xeon E5506 2.13GHz, 12GB RAM, Win7 Pro SP1 64bit
View 6 Replies
View Related
Oct 2, 2012
I need to convert a model parameter to a reference parameter thru the API.
I saw this item discussed in the group before, but I cant find the thread.
View 4 Replies
View Related
Dec 19, 2011
I got a deadline for my project, but I got a big problem:
"I cannot set the "parameter" for the End Value in Parameter Animate dialog"
For easy understand, let's see a example:
1. I got a part which has two parameters named: "A" and "MaxA"
2. I animate Favorited parameter A.
3. The End Value is MaxA_ (Everything is ok)
4. I finish Studio environment, then I change parameter MaxA_ from 200 mm to 400 mm
5. I turn back to Studio environment, the End Value now is "200 mm" (I want this will be MaxA_, so I can animate the flexible parameter).
show me how to keep the end value will be "MaxA_" after I change parameter?
View 3 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
Jan 3, 2013
I am trying to publish to the CC a guide rail. The vendor of the rail gives me the option of entering the desired length of the rail. After that he gives me the option to choose between the length that I entered and a shorter and longer standard length witch can be delivered faster.
I want to do the same thing with my published part, but I cannot make a key parameter to change depending on the entered custom parameter. I want the user to make the next steps when inserting from the CC: 1- select the size of the rail; 2-select the type of the rail; 3- enter the desired length of the rail; 4- choose between the desired length and the 2 recommended lengths (I need these 3 lengths to be shown)
Is this possible?
View 9 Replies
View Related
Dec 1, 2013
I need to use the dimension created by an action-parameter as a variable in a user defined function but AutoCAD will not allow me (see attached).
How may I access the action-parameter's dimension ?
View 1 Replies
View Related
Feb 7, 2012
it is possible to use a user defined parameter to drive a action parameter.
I have several polar and linear stretch actions i would like to drive from one parameter.
View 3 Replies
View Related
Jun 27, 2013
I have a beam that is simply supported and I am needing to do FEA analysis on it. Simply supported on the ends with a load in the middle. Hand calculations show deflection is 2.256in. FEA shows delfection as 1.247in.
I think the problem is the constraints that I have placed on it. I have one fixed constraints at each end. One of these needs to be fixed and the other needs to be able to move horizontally. How do I set this up to get the correct results?
View 6 Replies
View Related
Oct 10, 2013
I have downloaded Inventor 14, and the program appears to start up without problems. However, when i create a simple sketch, it first says "Choose a plane". In my textbook, it shows a picture of the three planes to choose from. However, my computer screen shows a blank gray screen. It appears some tool bars are missing as well.
However, if i click in the space where I imagine the axis should be, it takes me into sketch mode. Similarly, when I draw a line, the information bar reads like I am drawing a line, but no line shows up on the screen.
Is there a specific requirement on my computer I could be missing? I have downloaded Inventor twice, and both times had the same problem with the program. Perhaps a video card I need to have, or a certain RAM requirement?
View 4 Replies
View Related
Jun 25, 2012
Illustrator keeps freezing when applying an effect such as texture-grain to a simple gradient, or even rasterizing a simple black circle. My system is about a 6month old macbook pro with 16gb ram, i7 and AMD Radeon HD 6770M 1024 MB. What could be causing this? It wasn't like this when i first started using the laptop but has started to do it everytime i try and do any of those simple tasks recently.
View 5 Replies
View Related
Oct 20, 2012
Crashes on a simple extrusion... VERY basic spline...
(When I click extrude... I doubt it's even a complete closed shape yet)
View 4 Replies
View Related
Apr 12, 2013
I am creating a Carbon Fiber glider. I have drawn the entire file and assembled it in autodesk inventor. How can I take each individual part and create a mold that I can CNC out? I just need a mold CAD file and then can run it through mastercam to get the G&M Code.
View 9 Replies
View Related
Jun 26, 2011
i need to build about 8 versions of this simple box (see pic). base size, top size height... easy!
i have been using simple extruded boxes for most of my work to create the "path" of the frame, but with the tops being smaller than the base i need a new trick. also i know i will make more and more versions and would like to make new sizes a quick and simple job.
View 4 Replies
View Related
May 27, 2012
in Inventor 2010 we can save and load iLogic Paremeter with *.xml and just in my opinion we can control parameter using *xml or html. It's right or false?
how to control Inventor parameter with *.xml?
View 2 Replies
View Related
Oct 26, 2012
I need to extrude a simple shape between two planes and then get the length as a parameter. Is there anyway of generating this? All I can find is a parameter for the angle of the extrusion.
View 3 Replies
View Related
Aug 24, 2013
I have generated frame that has 100 members in it. Is there a quicker way of changing G_L unit to a mm so that I don't have to go into all 100 parts to change the custom properties?
Also I do not need unit string to be appear in my BOM.
View 9 Replies
View Related
Apr 14, 2009
I set a dimension to a 2dline. The dimension is automatically added to Model Parameters. How can I find , by code, the line which length is driven by the parameter ? Or, starting from the line find the parameter which indicate its length ?
::GetDependents(), nor ::GetDrivenBy(), nor ::GetParent() gives me the answer.
View 7 Replies
View Related
Aug 6, 2012
I'm trying to get a parameter value from an Inventor .dwg file, but I keep getting an error saying the file is not found. I use this same code all over the place between different parts but its the first time I'm tried it using a dwg. Can you not access an Inventor .dwg parameters using iLogic .
MsgBox(Parameter(ThisDoc.Path & "MyDrawing.dwg", "Customer"))
View 1 Replies
View Related
Jan 6, 2014
Sometimes I change the dimensions of a material I use but then I have to open Iproperties and change the description by hand. This can create problems as you can understand especially when I forget to update the Iproperties.
Then I had the thought to automate it. Lets take a steel bar as example. I have thickness and width as parameter, both are exported and available under IProperties/Custom. But they show as 200 mm and 10 mm. I would like to loose the units. I tried also UL but then it reads 200 ul and 10 ul.
What I like to get are just the numbers, no units. I like to use it to create this "steel bar 200x10" where the 200 and the 10 are linked to the Parameter and will change when I change the dimensions av the steel bar.
View 9 Replies
View Related
Aug 8, 2012
I created a *.iam file. And from this asembly file, I need run some rules in *.ipt file.
I use
Parameter("PartA:1", "d12") = d12
to give d12 parameter in my assembly to d12 parameter in *.ipt. It works.
But I need get parameter in the *.ipt file after running the rules in *.ipt.
so, I put
d13 = Parameter("PartA:1", "d13")
following above line.
But everytime, I just be able to get the result before *.ipt run the rules, not after.
I noticed the rules in assembly were compeletely run, then run the rules in *.ipt. So, the result is not correct.
I am using Inventor 2009 with ilogic. XP OS.
Autodesk Inventor Professional 2013 (64 Bit) SP2
Windows 7 Professional Service Pack 1
Intel(R) Xeon(R) CPU E5645
12.0 GB Memory
View 9 Replies
View Related
Jan 31, 2012
I would like to have the material, color etc. as parameter so i can change it with an ilogic form.
In this video you can see what i mean:
[URL]
When I make a ilogic form i can only select parameters and iproperties.
View 4 Replies
View Related
Nov 8, 2006
Is there a way to use the filename to drive the parameters of the file?
Example: I have a cube that is called 4x4x4.ipt its dimensions d0,d1,d2 are 4,4,4 respectively. I want to rename it to 4x4x6.ipt and have the dimensions d0,d1,d2 resize to 4,4,6.
View 9 Replies
View Related
Dec 1, 2011
I'm trying to programmatically toggle a hole between tapped and simple. I found the Tapped property in the object browser but when I try to use it I get a "Method 'Tapped' of object 'HoleFeature' failed" error.
Public Sub setThd(tap As Boolean, doc As PartDocument)Dim hole As HoleFeatureDim holes As HoleFeaturesSet holes = doc.ComponentDefinition.Features.HoleFeaturesFor Each hole In holes If hole.HealthStatus <> kSuppressedHealth Then hole.tapped = tap End IfNextEnd Sub
View 2 Replies
View Related
Apr 5, 2013
I created a seemingly simple contour flange, and cut away a 890" radius. However, when I try to create the flat pattern, it gives me the message:
440-006.ipt: Errors occurred during update
440-006.ipt (Flat Pattern): Errors occurred during update
Definition1: Could not build this FlatPattern
The attempted operation did not produce a meaningful result. Try with different inputs.
View 9 Replies
View Related
Jan 31, 2013
I've got a custom VBA function that works perfectly when called from a parameter in my part.
However, when in the context of my assembly, there is no error, but the function no longer runs, and the parameter text is red.
Apparently, the function is no longer in context?
I've heard of external rules, but have never implemented one.
Is there a way to declare my function and keep it in context regardless?
Public Function BumpHeight(dblHeight As Double, dblMember As Double) As Double Dim X As Integer X = 2 If dblHeight > dblMember * 2 Then BumpHeight = dblHeight Else BumpHeight = dblMember * X End If BumpHeight = BumpHeight / 2.54 End Function
Here is the Parameter:
VBA:BumpHeight(ValanceBackBumpoutHeight;ValanceMemberSize) * 1 in
Update: (problem better defined)
What seems to be happening is that once I insert the part into an assembly, it creates a new blank copy of the parts' modules in VBA and the functions no longer work.
If I go to the VBA editor,
There are now two copies of my part listed in the browser tree, but the new one is blank.
If I paste in my function to the new one, it will work until I return to the parent assembly.
Next time I come back to the part, it will have a new blank set of modules.
This appears to continue indefinitely...
see the attached screenshot.
At this point there are only 2 copies of the DocumentProject. The original still contains my functions, but the new one is blank.
I need these functions to work in order to build my model.
View 1 Replies
View Related
