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 RepliesWhen 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.
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.
I have a configurator assembly, which is controlled with an iLogic rule.
one of the parts is being changed in a lot of ways according to the different configurations. But in one of the Configurations the part must be suppressed, which works fine, however next time i run the rule i get an error message from all the other instances where it would change a parameter if the part was active.
I have tried adding if [the configuration that makes the part suppressed] = False then, in the beginning of the the code that fails, to simply prevent it from running, but it still makes an error.
and as you can see i have a lot of lines where the part normally would be configurated.
Error on Line 628 : Method arguments must be enclosed in parentheses.
Error on Line 629 : Method arguments must be enclosed in parentheses.
Error on Line 633 : Method arguments must be enclosed in parentheses.
Error on Line 634 : Method arguments must be enclosed in parentheses.
[code]........
I don't understand how to enclose the argument in parentheses.
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?
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]....
I 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.
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.
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 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
We are trying to switch to a new parts list format, and the goal is to have all of our parts list imported from excel spreadsheets. The problem we are having is that we cannot import from excel and maintain the format from excel. The problem seems to be with merged cells. I have tried it both by: 1) Annotate > General > Table and 2) Manage > Insert > Insert Object with no success. I have a non-ideal work-around for this by inserting the "QTY PER ASSY" separately as a sketch symbol.
Attached is a sample of what we would like our parts list to look like. The red rectangle outline is what would be imported from excel.
You can't export parts list to Excel file but you can export CSV file without any problems.
View 3 Replies View RelatedI have a drawing with multiple sheets (spool drawings) all with there own parts list and I need to export them all to excel. This takes a long time when you have 100 sheets. So my question is how can I do this, how should the code look like?
View 2 Replies View RelatedIs there a specific reason that you can only export a parts list from a .IDW to a MS Excel 5.0/95 format? Is there a conflict with the newer formats of Excel?
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 can publish a part containing a user text parameter to the content centre for use in frame generator however when I go to insert that part an error as per the attached screen shot.
To re-create the error you have to follow the below steps.
Create a part with a text user parameterPublish for use in frame generator.Create frame with the part and an error will be created as per the attached screenshot.
Is there a way to work around this error being created and use parts with text user parameters in Frame Generator?
it is possible to make a constraint that utilized a parameter of a part within the assembly.
For example, if I wanted to use the thickness of a plate, which I defined in the part, could I call that parameter in a constraint?
A user can change a text parameter by clicking on an associated tag, at which point parameters values in the tag turn blue and allow the user to change the text value. Is there a way to disable this? I want the 'properties worksheet' to be the only place to edit the tag values.
View 1 Replies View RelatedBut 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.