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 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 RelatedWhen 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.
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.
I can't link parameters properly with xlsx/xls files. At the beginning it works well, but if I change files the parameters can't get updated- all fields get yellow instead. It works only when I relink the file.
View 9 Replies View RelatedMy goal is to open have people go into a central assembly file, type in their specific parameters and the various part files update within the assembly. I wish to do this without the need for an excel sheet, but when I try to link the parameters from the assembly file to the part files, it will not allow me to insert these parts. I get an error about an "assembly can not be placed into itself."
Iparts will not work as this has an infinite amount of sizes.
I made an assembly that adjusted to sized based on some key parameters. These key parameters are controlled by a form in the main assembly. The keys parameters actually adjust the skeleton file, which then drives the frame, then all the parts are adjusted.
after changing these parameters all necessary parts would adjust to size and keep the location constraints. Worked quite well.
The issue now is that, we adopted a new naming convention and this assembly requires all the part files to be renamed. I meticulously saved each part as their new name and then replaced each component in the main assembly. This worked to an extent. The problem that I am facing is that when I saved each part as there new name, the new part retained the linked parameters to the old part. Is there a way to change this link to the newly name skeleton file?
I looked into design assistant for this process as well, but the only changes I think available were to add a prefix or suffix. If worse comes to worse, I can remodel this project but, I am sure there has to be a way to alter this.
attached is a single part with those parameters in the image above.
I link an excel spreadsheet of text into my .idw files and I constantly have this issue where the text is crowded (see attached). I've tried changing the font, etc. but nothing seems to work. Every once in a while if I move the linked sheet within the .idw it corrects itself.
I'm using Inventor 2012.
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
I have a excel sheet linked to my inventor file and I cant delete it. I really only need to change the starting cell, but I can't do that either. It works on some parts to right click on the folder in the parameters window and then select delete or change start cell, but on others it doesn't work.
View 5 Replies View RelatedI 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?
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 Replies View RelatedI'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]....
where to find a tutorial that explains the usage of Design Assistant? Particularly the practice of renaming assemblies and linked parts?
View 4 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'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
So i have a box with a left side, right side, top, bottom and a door in an assembly.I've linked all the parameters to the 'right side component' so that when i change it, it updates all the other parts in the assembly.
What I want to accomplish is to be able to use my BASE SIZED BOX ( say 500 x 500 ) to create many different sized boxes.The problem I have is when I save the assembly as a new one and save and replace all the components for the bigger box, all the components still reference the old part ( 500 x 500 right side component) instead of the bigger ( 600 x 600 right side component.
how to link parameters, don't know ilogic, and just know the basics of assemblies and part modeling.
I have several parts which I wish to modify, but, those modifications are only being done to get some prototypes made. I do not want the changed (non-approved part) to be used in current issue drawings, assemblies etc. until I have proven the modifications and am happy with them.
I can do this by doing a save as on the part and could just replace the previous design, but then I lose the history of changes/revisions shown in Vault which is critical to me and part of using vault in the first place.
I 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.
As a recent convert from ProEngineer to Inventor, if it is possible to vary the parameters exported from the source model in the derived part. The following article (see link below) explains the functionality in ProE - note the ability to see the model tree of the source part and also the ability to have varied items (dimensions, suppress features etc.) URL.....
View 3 Replies View RelatedHow can I drive parts from an assembly level without using Excel spreadsheets. I know it is possible using iLogic to do it, but I can't figure out how to do it "automatically".
For example, we would like to drive a conveyor roller without the use of a spreadsheet. I figured out I could simply insert user-driven parameters in the top-level assembly and drive the parts with the parameters in the assembly, but it is telling me it would cause a cyclic redundancy, so I cannot do it this way, then I thought about iLogic.
It is currently working OK, but I have to enter in the iLogic rule to manually change the filenames in the rule for it to work.
Why? Mainly because we use a prefix to our parts and we sometimes use Autodesk Vault, sometimes not (depending on the project).
Here is my example;
I have a part named "Tube.ipt", "Bearing.ipt", "Spring.ipt" and "Tige Hexagonale.ipt" along with this code in the assembly level (Rouleau.iam):
Parameter("Spring:1", "GAGE") = WIRE_SPRING
Parameter("Spring:1", "DE") = OD_SPRING
Parameter("Spring:1", "LONGUEUR") = LENGHT_SPRING
Parameter("Tube:1", "LONGUEUR_TUBE") = RL-Parameter("Bearing:1", "EPAULEMENT")-Parameter("Bearing:1", "EPAULEMENT")
Parameter("Tige hexagonale:1", "LONGUEUR_HEXA") = RL+B+B
Parameter("Tige hexagonale:1", "BOSSE_SPRING") = B+0.010 in+Parameter("Bearing:1", "EPAULEMENT_SPRING")+LENGHT_SPRING+WIRE_SPRING
Parameter("Tige hexagonale:1", "BOSSE_BEARING") = B+0.010 in+Parameter("Bearing:1", "EPAULEMENT_SPRING")
As you may see, I would have to change "Tige hexagonale:1" every time we use this assembly on different project for it to update properly. I would like to automate it a little bit more.
How to make it work in iLogic:Search for something that has "Tube" in it's filename in this assembly, then store it into a variable called "Tube" Repeat this step for "Spring" and "Tige" Then replace "tige hexagonale:1" by the variable or something like this...
I am attempting to reverse engineer a Slap Chop for a school project. Being only an amatuer at Inventor, I have made several parts that need to fit together but don't due to erronious measurements. Attached are three of the parts I have so far, and I will make a few replies with the remaining parts. I am trying to make an excel sheet or some table where I can manage all my parameters and have them update in the parts. The table is simply to make it easier for me to quickly check my dimensions.
View 6 Replies View RelatedIf I have parts in an assembly that would like to use the same parameter, what is the best way to do this? I am using AI 2013. Currently I know how to create a base part and using it to derive other parts from it, but this seems there should be a easier way, is there?
View 1 Replies View RelatedI would like my parameters to show in Description tab in BOM. Although I marked the for export I only see them in iprop.
How can use them in the create expression in BOM and add them to the part list later.Right now I dontsee them if I want to creat an expressin in the BOM
I have a large collection of parts that are controlled from an exteranl rule. I need to make slight changes to the external rule, but for the changes to be successful I need two extra user parameters to be added to each of the parts. There are hundreds of parts, so going in and adding the two parameters to each would take days.
Is there a simple way of getting the external rule to add the two parameters?
P.s. My VB skills are pretty limited, but my understanding of iLogic is pretty good.
How do you select parameters for export in parts that have already been published?
I have a part that I have published. There are some parameters that Ii would like to have available to the Parts List upon creation. I don't see a way to do this after the part has been published. I have been able to select the parameters for export before publishing and they will be marked for export when the part is placed form the content Center.2010 Suite-SP4 64bit
I have drawn a cylinder, with inside diameter 1028mm, wall thickness 5mm. We usually have calculated unfolded part length like this: outside dim. 1038mm - 5mm (wall thickness) = 1032 x 3,14 = 3240mm. Now when i unfold in inventor I get for the length 3215,35mm. It is quite far from the result we usually would have received.
Unfolded part will be rolled to cylinder. What parameters should be overlooked when making unfolded parts for plate rolling?
I am finally getting time to do some organizational cleanup and management with our templates and vault settings. Many of the things are items that I am altering for each drawing/model I make and I would like to make them "stick" for the company standards. Things like altering font size in the styles library, adding part dimensions to the parameters for the parts list, and creating a new content central library where our part numbers are already populated for the parts list and the structural shapes have datum planes in the middle rather than just at beginning and end.
Inventor Premium 2013 SP1.1
Vault 2013- plain vanilla version
HP G71 notebook
celeron cpu w 4gb RAM and 64 bit system
Win 7 home premium