As my Inventor endeavors continue, I would like to take a template of a part I made and use Excel to change the parts dimensions. Essentially make it so if we need a 20 Tonne Lift Lug, I just punch in the necessary values in Excel and have the part update.
View 1 RepliesWhen 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.
From iLogic i got a lot of information. And i want to configure or display this in a form.
But without having to make parameters for everything.
Example:
Display the stocknumber of an ipart/iassembly.
Configure the parameters from a part in the main assembly.
I have a part made where various parameters in it.
Now I place the part in a assy and from there i want the parameters to control the part.
I do this now by the same parameters from the part to add in the assy by typing the parameters manually in the assy.
Is there a way that you can define parameters retrieved from the part about the assy without retyping and therefore can make mistakes?
I created an assembly, so far with one part in it. I created an Excel spreadsheet with several dimensions in it that would be used in the assembly parts. I went to Manage>Parameters and linked the spreadsheet. The Excel file appeared in the Parameter Dialog Box with the parameters included in it. However, when I create a part in the assembly and attempt to dimension a sketch in it, the parameters option in the dimension box is not present.
I have done this in the past in IV2009, has anything changed that I cannot do so in 2010?
I'm trying to export parameters for my parts to an excel sheet, this way to be able easily to edit any of these. So far :
1. exported parameters as xml.file and opened it in my excel sheet.
2. saved this sheet as xls.file on my desktop and linked (embed) parameters to this file.
- value column is formatted as text.
- any update to value column should immediatly change (after save and close worksheet?) parameters in inventor ?
Inventor 2012 Professional
Excel 2010 [URL]....
I would like to insert 2 or more of the same subassemblies into an assembly, yet have each subassembly a different size.
When I do this currently when I change the parameter for one of the subassemblies all the subassemblies are changed.
I am trying to control the parameters contained in a part that is not in my assembly. May sound odd, but I am using the multi body part modeling feature to create all of my bodies in a single part file, then making these components/sub assemblies, and pulling them into my assembly. However, I do not want to have the "control part" in my assembly, I just want it to drive the parts. I cannot figure out how to access these parameters without having the part included in the assembly...
View 7 Replies View RelatedI have entered in all the available sizes and have the outer frame of the louver adjusting nicely.Now where I am running into trouble is setting up the louvers and the louver spacing. I have been playing around with the parameters for awhile now and I just can't wrap my head around some things.
Example one:
in the picture below,
HEIGHT is selected on 18 in
I have created an user parameter called LOUVER_QTY which is set to subtract 1.6 in off HEIGHT = 16.4, then I divide that by 2.05 and the result is supposed to equal 8 but it is showing 3.149606. But when I assign LOUVER = LOUVER_QTY it is showing 8
For the most part this file works fine, but when the Height is changed to 56 in, the last bottom louver runs through the bottom of the frame.
I know that I have to change the spacing from a direct input (2.05) to a equation based on height to fix the spacing, but I can't grasp how these parameters are working, why are they red(errors)
Also I don't know how to set up the parameters to set the correct number of occurrences in the rectangular pattern to control the amount of louvers. Something related to to the spacing of the pattern and the selected height.
Inventor Professional 2014-Update 2 - AutoCAD Electrical 2014
Win7-x64 | ASUS P8Z77-V | i7 3770 -3.4 GHz | 32GB RAM |
240GB SSD | nVidia GTX 670 4GB - 320.49
I have linked my inventor drawing to excel to adjust some parameters. Is it also possible to have a enable/disable function in excel so a part in an assembly can be disabled at will?
View 3 Replies View RelatedI want to export reference parameters to an excel table using i-Logic
I found the function GoExcel.CellValues("filename.xls", "Sheet1", "A2", "A10") = MultiValue.List("d0")
It looks like the syntax calls for the file location and name if the xls file is not open and if open is not supposed to be required.
I have entered it both ways and with and with out the target file open and with the function GoExcel.Open("pathFilename.xls","sheet1") and continue to get the error:
we couldn't find C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls. Is it possible it was moved, renamed or deleted?
Also, I was expecting that to fill in the sheet cell's would be MultiValue.List("d0","d1","d2")
but the system give me an error that says
Error on Line 3 : Overload resolution failed because no accessible 'List' accepts this number of arguments.
See below
GoExcel.Open("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST")GoExcel.CellValues("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST", "A2", "A10") = MultiValue.List("d194_A")GoExcel.Save
I am making an assembly where I wanted to use an excel sheet to link common paramters between the parts. I know how to do it for just my single system, but I am wanting to have all the parts and the excel sheet stored in my vault server. Is there anyway to link the parameter list to the excel file stored in the vault or how can I go about having a common file that everybody can access.
What I am worried about is if the excel file is located on my computer and someone tries to open a part on another machine, it will not find the excel parameters and everything crash.
I linked an excel (2010) file with an inventor (2011) .ipt and none of the parameters are showing inside inventor. I was leaving the file external but I embed it also as a trouble shooting step and nothing still. I have no spaces in excel sheet. Is there something special i need to be doing inside excel or inventor?
View 5 Replies View RelatedI tried to match the dimensions of the already existing product with new dimension through fx parameters(using link excel sheet), while conversion all the dimensions are changed except taper value (By default it comes with inch instead of degrees) It can be changed by adding user parameter but i want it to consider from excel sheet data itself. Is it possible? For reference i have attached the snap shots
View 1 Replies View RelatedI am currently using iparts/assemblies to model a resistor bank. We have dozens of different configurations and currently each time we need a new one its is re modeled from scratch.
I have created an assembly with all my relevant parts and controlled it through parameters to auto update when key values are changed.
What I would ideally like to do is to either link my two iparts to the iassembly though the excel sheets they use. Currently I have to added each variation to the parts first and then added the parameters to the assembly.
Would it be possible to have a master sheet were all control values are inputted and then each excel sheet for the different parts are linked to this?
As the excel sheets are saved in the temp file and are deleted once you have finished editing I have found it hard to do this so far. Can I change where they are saved? I tried save copy as which created the file but inventor did not link to it.
If this is not possible can I utilize iLogic to input the key values and then write them to a new row in the table. I have created a rule already to limit the number of elements and also the length of the by's (the space between each supporting rod). I have included a zip file with all my parts in it.
I'm trying to link an Excel sheet to a new assembly but it is only listing half of the sheet parameters. I have done this before with no issues. I've also imported another sheet and it works fine. I copied and renamed a sheet I know that works deleting the data from it and coping the data I want and I get the same results. This lead me to believe there is something wrong with the sheet. See attached file.
Excel 2010
Windows 7
Inventor 2012 64 bit
When I add parameters to Excel, the new parameters do not show up in the linked parts. Even when starting
a new part and linking to the same excel file, the original parameters are all that are shown; not the new ones.
linked Excel file to Inventor 12 file parameters. Windows 7, Excel MS office professional '10. Linked excel file, here dimensions are driven by parameters which are driven by excel. toggled 'immediate update' Still - i have to open the sketch - it shows the updated number from Excel, but only on opening the sketch will it change the model to use the new dimension value.
View 3 Replies View RelatedI have a problem with using the excel spreadsheet to hold my parameters and then making them auto update in the model.
I have the excel 2003 spreadsheet saved in the same folder in the projects directory as the model. When I create the spreadsheet and enter the parameters and values etc I save and close the file.
When I am in inventor 2013 64 bit with SP1 installed, I open the model and can link the spreadsheet to the model and the model reflects the values in the spreadsheet. I also click update on the parameters dialog box.
I then open the spreadsheet and make some changes to the values, save the file and even go to the extreme of closing the file. When I go back into Inventor it recognises there has been some changes in the underlying spreadsheet. The update button is active in the tool bar. However trying to update the models by what ever means does not update the model parameters to those in the spreadsheet. Even closing the model and reopening it does not make a difference.
The only way I can get this to work is disconnecting the file and then reconnecting the file through the links option in the parameters dialog box. Then the model reflects the correct values and updates the model accordingly.
My concern is there is quite a bit of stuff on the net about 2013 not working with 2014 inventor anyway.
Is there a way to setup Field entry text in a Table that will control Dimensional Constraint Parameters in a model?
I basically want the control of the Parameters Manager to be in table form on the drawing that is usable and printable.
But I was wondering if it is possible to contol the insertion of dynamic blocks and it user definerable parameters from a excel-text file.
I am surveying a section of pipework and I need to display the brackets that are supporting the pipes. As there are numerous pipes on top of each other I have decided to show the brackets in plan and isometric view.
I think I have made the dynamic block ok and have numerous stretch/move and scale parameters working correctly.
But the only way that I can see of chaging these parameters at the momment is by manually typing them in the properties tool pallete for each individual block.
So I was thinking that if I can store the correct values that I need for each parameter in the dynamic block on our data logger along with the correct E,N,Z insertion point is it possible for this file to change the parameters in the dynamic block for example, If I have the correct insertion point stored and then have 10 parameters stored with that point for simplicity I store as A=5.00,B=8.00,C=0.100 etc and these correspond with the parameters in the dynamic block will this file be able to alter the dynamic block as the values in the excel/Text file are displayed.
I would like to be able to control the fire rating a door must have through a yes / no parameters. I have created a shared parameter for all the different codes and then I have loaded them into the family, now I just want it to work so that when a rating is checked the name will be in "Fire Rating".
EI0 selected when the door is not fire rated.
As can be seen in the picture, I found out how it can be doneif there are 3 checkboxes.
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 RelatedHow can you access user-defined parameters/function defined in the Parameters Manager dialog?
View 1 Replies View RelatedIm wondering if its possible to link either a constraint dimension to an action parameter or vice versa. Or using a linear parameter's value in an user parameter formula.
Its a 2D cylinder, for winding purposes we just have a rectangle, with a distance from the Y axis for radial.
Parametric dimensions: B=thickness, C=Lenght, R=radius
User parameter: A=Diameter (R*2), Mass in kg ((((pi*(c*b))*(A+B))*1.25)/1000)/1000
For the BOM, i need A, B, C & mass
For drawing references for peoples on the floor, to distinquish a cylinder from a stick, we put lines at the top and bottom of the cylinder, 1mm distance inbetween them.
I figured that making a linear parameter + stretch on the thickness to replace the B parametric dimension, allowed me to make an array of that line, with increments of 1mm as i stretch the cylinder. The thing is that the mass formula cant take the value of action parameters....
Other alternative is to keep the B parametric dimension, and add a linear parameter as above for the array. But then i have 2 places to adjust, and from a test i made, if i change the R dimension, the linear one does not follow. Its very frustrating.
What i was hoping autocad would be able to do is distance1 for array to be same as B dimension, but it does not allow me to do that, unless im missing something.
How can we get the parameters of a inventoer object using vb.net.?
I have 3 parameters named d1,d2,d3 .I want to get these three parameters name and value using API programing using vb.net.
Using AutoCAD 2013 and TOL command to generate feature control frames. We set our lineweights based on layer assignments.
Problem is that when printing, AutoCAD seems to randomly assign a lineweight to the feature control frames. It can vary from what it's supposed to be (such as lineweight set for the dimension layer) or thicker than even what the object lines are set at. Seems to pick a random linewieght at time of printing for these elements (just the boxes, not the symbols/text itself).
Is there a setting we should be defining somewhere to force it to follow the lineweight of the layer that it has been assigned to? Known bug?
I was wondering if it would be possible to do the following:
Parameters who can vary for lets say a rectangular profile with:
80x50x2
80x50x3
100x50x2
That these data sets/parameters are grouped/linked to eachother in the Parametric Table.
So when I'm doing my analyses with the profile of 100 and I change the wall thicknes from 2 to 3mm the 100 changes to the 80 variant automaticly, or asks me which version I want.
It would be handy to avoid mistakes with non excisting combinations of profiles.
Is there a custom app for Inventor that allows you to manage parameters easier? (Grouping wise to keep a better overvieuw.)
Creating User Parameters, can we use trigonometric functions? and can we add these to linear (mm) parameters?
Can we add the Values irrespective of Units i.e. Inch/ Deg/ Unitless
Example: d0 (In) = d1 (In) +d3[ul] + (sin(Variable_Angle))
In value = In Value + ul Value + deg Value
I'm having some difficulties with iLogic and reference parameters.
I have made a tube with a weird shape and I want to measure the longest length. So I have to cut the tube in a certain angle in relation with the center to measure the length.
The problem is that this angle is really hard to calculate.
So I tried making a rule where I can make my angle shift x degree and then measure the longest length. If the measurement is larger the previous measurement the angle will shift x degree again until the measurement is smaller than the previous.
So I made my starting angle 0 degree, I know this is for a fact not the longest length. And then I tried this rule. (before making a While rule).
And I noticed that on screen the measurement changes. But the reference - parameter stays the same. So it gives me the measurement on the starting angle & after rotating it again gives me the starting angle.
How can I get the parameter to update itself in between?
Dim measurement_length As DoubleDim measurement_length2 As DoubleMessageBox.Show("Start angle ", "My iLogic Dialog", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)angle_measurement_spec = 0RuleParametersOutput()InventorVb.DocumentUpdate()measurement_length = [code].....
I have lots of files that are linked either by length, height, etc.. Is there an option to delete all linked parameters. I would also like to keep the part history (cuts and extrudes).
I wonder if there is an option to delete all at once like iLogic option-"delete all rules" or should be deleted individually.