AutoCAD Inventor :: Update K Factor / Sheet Metal Type From Excel Parameter Spreadsheet
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
ADVERTISEMENT
Aug 7, 2013
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.
View 3 Replies
View Related
Dec 12, 2012
When our VAR initally setup our system for us he made it so the material selected in with the sheet metal rule would appear as the stock number in the ipropertys. I then set the sheet metal rule so the sheet metal rule material also had our material stock number for each different thickness. This gave me a value that was automatically loaded for drawings.
Now we have migrated to 2013 and in the migration things got mixed up so this no longer happens. I am assuming that when the SM Rule is set it creates a named parameter somewhere. What that parameter is? I am thinking if I go into the parameters of the template and set stock number = to SM Rule parameter I will regain this functionallity.
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
View 2 Replies
View Related
Aug 14, 2009
What is the name of a value that might hold the total number of bends in a part?
Or at least how those feature are managed?
Simply put, I'd like to pull the total number of bends into a parameter so it can be exported later.
View 3 Replies
View Related
Apr 18, 2012
A local search of my HD and a search on the subject here returned with zero results...
Where does one find the Inventor Sheet Metal Rules excel table for 2012 on a Windows 7 system?
All the documentation says it's located in the Documents and Settings directory, but Windows Vista eliminated that folder and thus it is not in Win7 either.
I can find the SheetMetalRules.xml file, but I need the excel table for modification.
View 3 Replies
View Related
Sep 7, 2012
How do you embed (not link) an excel spread sheet into my sheet metal template.
The excel file is simple, 2 rows listing the A1=gauge and B1= decimal equivalent.
What I want to do with this is to get the gauge to show up in the iProperties description along with length and width of part. The thing is I need column A to show up in the iProperties (12GA) but column B to be used for the sheet metal default thickness.
I keep getting this error when I run my code.
Error in rule: Gauge, in document: Part1
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
Code so far..
i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "Gauge", "<=", iProperties.Value("Custom", "Gauge"))MultiValue.List("Thickness") = GoExcel.CellValues("3rd Party:Embedding 1", "Sheet1", "B2", "B35")
View 9 Replies
View Related
Oct 18, 2013
i made a sheet metal part.ipt but that file is not updating immediately, i have added
iLogicVb.UpdateWhenDone = True
InventorVb.DocumentUpdate()
also tick marked in parameters for IMMEDIATe update
View 3 Replies
View Related
Oct 15, 2012
I have a basic floor plan in AutoCAD 2012 that has blocks in specific locations which contain personel data....name, phone, computer tag, desk key numbers, etc. I extracted the data to an Excel spreadsheet and I thought set up a "data link". But I don't know how to make the data update.
My problem...moves of staff, phone, computers are often made, but no one lets me know about it until they want a new floor plan printed and the computer and key tags get so messed up from the moves that it can take me hours to fix.
My goal is to be able to have our secretarial staff update the spreadsheet and in turn update the blocks in my AutoCAD drawing when it is opened and/or "updated".
View 3 Replies
View Related
May 27, 2011
I am extracting attributes from an AutoCAD 2011 drawing into an Excel sheet using EATTEXT. I am then manually adding columns to the Excel sheet. How can I update the Excel sheet with new attributes values later on without overwriting the modified sheet and losing the added columns?
View 2 Replies
View Related
Feb 15, 2012
Trying to figure out the best method to insert an IDW into an Excel spreadsheet without sacrificing quality. I have tried several methods to go straight from Inventor(2012) to Excel(2010) using print PDF at press quality, export JPEG, and even the snipping tool as a last ditch effort all of which inevitably loose all line quality when inserted to Excel.
I have only had success bringing a PDF from Inventor into Adobe InDesign where I am able to mimic the design of my Excel spreadsheet and create an additional PDF to include with the Excel document. It seems like there would be an easier way for Inventor and Excel to work together without sacrificing quality or adding additional steps.
View 1 Replies
View Related
Nov 21, 2012
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
View 4 Replies
View Related
Apr 17, 2013
Im struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
View 4 Replies
View Related
Nov 15, 2012
I am working on a gearbox design that requires multiple iterations on the shaft dimensins and other parts, so linking the dimiensinos to a spreadsheet would make this easier. However, I'm using the design accelerator for the shaft and other components and I cannot find any information on how to connect the dimensions I enter in that design accelerator to a speadsheet.
I know how to link to a spreadsheet for a regular component, but haven't used that much.
View 3 Replies
View Related
Sep 13, 2013
Is there a way of inserting points from an excel spreadsheet that come into the part file already fixed, instead of manually selecting the points and selecting the fix constraint?
View 2 Replies
View Related
Jul 26, 2012
My "parameter names" and "value" columns fill in under the Inventor Parameter chart, but for some reason I can't get the comment section to fill in.
Inventor 2011
07 Excel
Inventor 2011
Intel Core 2 Duo 2.93GHz
8GB RAM
Windows 7 Pro
View 1 Replies
View Related
May 12, 2012
I created a spreadsheet of about 40 rows to be used to create different parts. I then created a part "we'll call it Board_A". I linked to the spreadsheet and used 3 of the fields for my dimensions. Lets say I named the length (which was the extrusion number) as "Len_1". I saved it and all is well!! I then created other parts and used the spreadsheet for the dims. I then went back and opened "Board_A" and saved a copy as "Board_B". I closed Board_A and opened Board_B. I then rt clicked on "Extrusion" so I could change the length from "Len_1" to "Len_1_A" which is another row (field) on that same spreadsheet which is still linked. When I tried I received a message that said I couldn't do that (I forgot the actual message!) I clicked the Parameter icon and the only fields showing on the popup spreadsheet box were the ones I had previously used for those parts that I made from scratch. I thought I figured this out once but if I did I forgot. I deleted the spreadsheet link and then re-added it but nothing I have tried has worked. Is there a way to get these fields to be usable with a Copy of an existing part or do I just have to start from scratch and make the similar part?
View 1 Replies
View Related
Sep 20, 2013
For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
View 1 Replies
View Related
Apr 30, 2013
I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
View 4 Replies
View Related
Sep 12, 2013
A collegue asked me about this as he has been given a part to model and the details are for the flat sheet not the finished model. Is this possible in 'sheet metal'? I had a quick play but couldn't work it out. Im used to creating the finished part and 'un-folding' to get the flat pattern.Detail supplied below.
View 4 Replies
View Related
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
View Related
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
Dec 28, 2013
Is it possible to update an existing User Parameter. While I can only delete-create a new. In this case the connection is lost with BOMQuantity.
View 5 Replies
View Related
Aug 4, 2013
The rule iterates through an assembly looking for parameters. If it finds them it 'pushes' the value down from the top level Assembly into the sub-components.
It works well, but each component updates dynamically as the parameter value is changed. This looks a bit jerky and weird.Is there any way to write the script so the the updates all happen at once at the end?
' set a reference to the assembly component definintion.' This assumes an assembly document is open.Dim oAsmCompDef As AssemblyComponentDefinitionoAsmCompDef = ThisApplication.ActiveDocument.ComponentDefinition'Iterate through all of the occurrencesDim oOccurrence As ComponentOccurrenceFor Each oOccurrence In oAsmCompDef.Occurrences'check for and skip virtual components'(in case a virtual.
[code]...
View 7 Replies
View Related
Jul 14, 2012
I just what to cut a sheet metal,
and I don't know how (see in Capture.JPG where i what to cut, and test.iam what I what to cut).
Where is the icon "project the geometry" ?
View 6 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
Sep 10, 2013
The neww line expressions for Grid distance are phenominal. My problem is getting them into curves. All I want to do is apply the grid scale factor to the curve length and radius, but I can't narrow down the parameter. The Drawing Scale conversion links to the annotation scale. I've also noticed people just scripting in the value, but that doesn't work when the majority of the office doesn't operate at that level.
Also, I work in grid and need to convert to ground. I noticed that the system only does ground to grid, so I'm inputting an inverted scale factor to get the results in need in my distances.
View 1 Replies
View Related
Jan 6, 2012
I need a flat pattern for this part but it seems impossible. STEP 2 illustrate the desirable result.
View 7 Replies
View Related
Aug 21, 2013
Working with sheet metal and laying out a pattern for the cnc and was wondering if there is a way to imprint an extrusion onto the surface instead of cutting it. Mainly this will be used for a marking tool so the line type or layer would need to be different.
View 5 Replies
View Related
Aug 8, 2013
I am working on a bin type unit, and am having trouble creating a flange, I am creating the bin in the final product stage, then I will separate into manufacturer components. I am having trouble adding this flange around the top 4 edges of the bin. I need the four corners to meet on a miter 45. I will then rip down each seam and have 4 separate panels.
Is this a bad workflow? Is there a better route? I attached the part in Inventor 2013 format,
View 8 Replies
View Related
Dec 18, 2013
Attached are two sheet metal parts that we need to unfold and make them flat for a drawing. We cannot seem to capture the reference A or reference B planes asked for by the unfold command.
View 3 Replies
View Related
