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
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.
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.
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.
My 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 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 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 have created a iLogic form for my skeletal part file that drives my assembly. The issues is that it is a few steps to get the assembly to update.
Current Steps: open skeletal part fileuse form to change size parameterssave new skeletal size changesopen assemblypress the update button if changes haven't already been applied...I have tried to link these parameters directly to the assembly and tried to create the form using those linked parameters from the skeletal part file. It looks like it would work, but I am unable to edit the parameters once the form is created.
I am hoping that the I can skip opening and editing the skeletal part file.open assembly fileuse form to change size and dimensions, and all part files and drawings are updated to that new shape and size.
I have tried to create a global Form in the skeletal part file, and tried to update the size changes in the assembly file.I was able to changes the inputs this way, but once I pressed the apply I get an error with no changes. what I want but I am not very up to date on iLogic or these forms. I will be searching Google for now.
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
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 RelatedI 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 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]....
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 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 Relatedwhat is the procedure for linking ILOGIC rules? There has to be some way, either they are both called from a VBA or VB.NET program.
i want to update parameters in an assembly, then write out the updated IDW to a DWG and/or PDF, then update the parameters, write out etc.
I have both the Rule working in the IAM and the Rule working in the IAM, i just want to call them sequentially.
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'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
I have some manufacturing dimensions that are an end result of my design so they are driven dimensions at the end of my modeling history and pulled into the ipart table. If I make some design changes I need these dimensions to update too. The problem is they do not automatically update and require a manual activation of each child memeber for the dimension to update.
The dreaded "The Values in the active row don't match the document's current values. do you wish to update the table before continuing" Click, enter, Click, enter, Click, enter.
Autodesk Inventor 2012 Certified Assosicate
Autodesk Inventor 2012 Certified Professional
how to dump the counter of parameters of model:
d0, d1, d10, d12
became
d0, d1, d2, d3
I am working in one assembly. in that assembly i created all the part with using i part & same part i called in to the assembly & created i assembly. while creating drawing i have facing problem to show the model parameters in to the assembly drawing table. How to link the model parameters in assembly parameters with using i assembly.
View 1 Replies View RelatedIs there a standard command or command sequence that allows for the changing of a parameter, say length, of a component from within an assembly. I'm looking to compile a code that allows for a template to be created, then that template will do changes based on text box input and then save out the modified parts with new part numbers.
View 2 Replies View RelatedCurrently, when adding a parameter in the text dialog box, the parameter displays as a decimal (0.50). Is there a way to change this to display as fractional (1/2).
View 3 Replies View RelatedI want a ilogic rule syntax for following process:
I have one excel sheet it consists around 5 sheets for Plate, Flats, Rounds, etc. When i am run the rule then it will ask and do the following:
Ask the thickness value.It will search thickness value in “D:LINUS KOTTEstock numbers.xlsx” in sheet 1If thickness value found then fill the stock number in iproperty(project tab-stock number)
Here i am using different rules for plate, flat, round, etc.,
Is it possible to search & find where a dimension listed in the parameters dialog occurs in a part model ( in which sketch for example)?
Inventor Suite 2013 Ultimate
I would like to be able to use iLogic to get the value of the Comment field of a model's parameters. I have some text there that I would like to display in a sketched symbol. The attached image illustrates what I am seeking.
View 2 Replies View Related
